1. Crescenzio Gallo
  2. Valentina Studio
  3. Суббота, Октябрь 27 2018, 07:53 AM
  4.  Подписаться через 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
Комментарий
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