1. Crescenzio Gallo
  2. Valentina Studio
  3. 土, 10月 27 2018, 07:53 AM
  4.  メールで購読
I have just upgraded my old Valentina Studio Pro 7.0.4 to the new version 8.6.3. All works fine but I noted two disappointing differences:
1) In the SQL Editor window the option "fx Functions..." (located in the top right corner before "Client/NoLock";) is no more visible: how can I get it back? It is VERY useful for me when editing SQL queries.
2) Even if I select in Valentina Studio Preferences the "Default" option for "Color Scheme" in SQL Editing I get no such behavior, i.e. there is no automatic capitalization of SQL keywords and no syntax coloring (all is lowercase green :-( ).

Can anyone help me?
TIA,
Crescenzio
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Crescenzio,

What database do you use? The button is hidden if the list of functions can't be retrieved.
The same thing with capitalization, depending on the engine, we get the list of keywords differently, maybe the appropriate system table is not available for the current user.

And it worked in the old version on the same server/database/user, right?
コメント
There are no comments made yet.
Crescenzio Gallo 承諾済みの回答
In Valentina Studio Pro 8.6.3 I am using MySql Community Server 5.1.7 just as with the previous versions 7.0.4. And before it worked fine :-(
コメント
There are no comments made yet.
Crescenzio Gallo 承諾済みの回答
And yes, it worked in the old version on the same server/database/user. And the user is root.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Please try to view the query logs using button on the main toolbar. Are there any errors?
コメント
There are no comments made yet.
Crescenzio Gallo 承諾済みの回答
I can't see any error; however, here is in attachment the log obtained when starting Valentina Studio, hoping this could help.

Thanks,
Crescenzio
添付ファイル
コメント
There are no comments made yet.
Crescenzio Gallo 承諾済みの回答
I forgot to specify that I am using an iMac 27" with macOS Mojave.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Thank you, the following queries returned 0 records and columns so functions and keywords weren't retrieved


SELECT LOWER( name ) AS word FROM mysql.help_keyword ORDER BY word;



SELECT IF( category.name = 'Functions and Modifiers for Use with GROUP BY', 'Aggregate Functions', category.name ) AS fld_Category, topic.name AS fld_Procedure, topic.description AS fld_Description, topic.example AS fld_Example FROM mysql.help_topic topic JOIN mysql.help_category category ON category.help_category_id = topic.help_category_id WHERE category.help_category_id IN ( SELECT help_category_id FROM mysql.help_category WHERE `name` IN( 'Functions and Modifiers for Use with GROUP BY', 'Numeric Functions', 'Control flow functions', 'Encryption Functions', 'Logical operators', 'Miscellaneous Functions', 'Information Functions', 'Comparison operators', 'Bit Functions', 'Date and Time Functions', 'String Functions' ) ) ORDER BY 1;


What happens if you try to execute them in the SQL Editor?
コメント
There are no comments made yet.
Crescenzio Gallo 承諾済みの回答
When I try to execute the first query:
SELECT LOWER( name ) AS word FROM mysql.help_keyword ORDER BY word;

I get the following error:
18:45:50 Kernel error: Error( 1146 ) 42S02: "Table 'mysql.help_keyword' doesn't exist"
コメント
There are no comments made yet.
Crescenzio Gallo 承諾済みの回答
When I execute the second query I get a similar error message:
18:48:16 Kernel error: Error( 1146 ) 42S02: "Table 'mysql.help_topic' doesn't exist"
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
The Valentina Studio (including 7.0.4) relies on these mysql.help_* tables, so they must have been deleted or so.
If you download an old version (http://valentina-db.com/download/prev_releases/7.0.4/mac_64/) you'll see it, too.

Anyway, I think we can include some default help information - because the users may not have an access to the help tables, for example, in case if they use third-party hosting.
コメント
There are no comments made yet.
Crescenzio Gallo 承諾済みの回答
Dear Sergey,

I'll be waiting for your upgrade, if any ;-)

Thanks,
Crescenzio
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Crescenzio,

The fix for syntax highlighting will be available in the version 8.6.6.
But the function browser needs the MySQL help tables on the server.
Could you please check why did they disappear?

I attached the link to the article on how to recreate them if necessary.
参照
  1. https://dev.mysql.com/doc/refman/5.5/en/server-side-help-support.html
コメント
There are no comments made yet.
Crescenzio Gallo 承諾済みの回答
Dear Sergey,

you're right: the help tables disappeared after an incorrect upgrade of MySql on my Mac (instead on Linux it worked fine).
Thank you very much for the ink: I'll do as suggested!

Kind regards,
Crescenzio
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories