1. Crescenzio Gallo
  2. Valentina Studio
  3. Saturday, October 27 2018, 07:53 AM
  4.  Subscribe via email
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
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
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?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Crescenzio Gallo Accepted Answer
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 :-(
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Crescenzio Gallo Accepted Answer
And yes, it worked in the old version on the same server/database/user. And the user is root.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Sergey Pashkov Accepted Answer
Please try to view the query logs using button on the main toolbar. Are there any errors?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
Crescenzio Gallo Accepted Answer
I can't see any error; however, here is in attachment the log obtained when starting Valentina Studio, hoping this could help.

Thanks,
Crescenzio
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 5
Crescenzio Gallo Accepted Answer
I forgot to specify that I am using an iMac 27" with macOS Mojave.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 6
Sergey Pashkov Accepted Answer
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?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 7
Crescenzio Gallo Accepted Answer
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"
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 8
Crescenzio Gallo Accepted Answer
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"
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 9
Sergey Pashkov Accepted Answer
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.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 10
Crescenzio Gallo Accepted Answer
Dear Sergey,

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

Thanks,
Crescenzio
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 11
Sergey Pashkov Accepted Answer
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.
References
  1. https://dev.mysql.com/doc/refman/5.5/en/server-side-help-support.html
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 12
Crescenzio Gallo Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 13
  • Page :
  • 1


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