Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberAre you behind a firewall?
Ritesh
MemberQuote:except where table names need to be cleaned up.Can you explain a little more?
In the last step of the wizard, SQLyog will show you the table name that is currently being imported. Can you find out the table that is giving error?
BTW, can you attach a copy of your database that is giving error, so that we can work on it and fix the bug ( if there are any ) in SQLyog 3.6?
Ritesh
MemberCan you attach a screenshot?
Ritesh
MemberYou cannot SORT column in the Insert/Update window. This feature is planned for SQLyog Max.
You can still get the same effect by executing a query for UPDATE.
e.g. write a query like
Code:select * from tablename order by col1and execute it by pressing F8 ( insert for update )
Ritesh
MemberQuote:You have areas in your application where it is impossible ย to scroll to the end of a (query) line for editing.Can you give us more details?
Quote:Another 'serious' problem along the same lines is the 'blob' viewer. An example. I have two 'longtext' fields in one of my clients databases. One of them can contain any number of characters, and some can become quite long. When I double-click to view the text, IT DOES NOT WRAP ย in the dialogue box. It should!!It is planned for 3.6 wherein you can specify whether you need to 'wrap' data or not.
Quote:In closing, I have a question which I would appreciate the answer to. If I install the retail 'demo' version to view the improvements you have made, will I be able to uninstall the demo and reinstall the 'freebie' version until you address any deficiencies I find.Yes ๐
Ritesh
MemberThere is an option in ODBC Import Wizard where you can import data by specifying a SELECT SQL stmt. Anyway, it seems that you are not using the feature.
Can you tell me the steps that you are following?
Better still if you can attach a screenshot when you are getting the error.
HTH
Ritesh
MemberAre you issuing a SQL query to fetch data?
Ritesh
MemberProbably this will help http://www.mysql.com/doc/en/Gone_away.html
Ritesh
MemberCan you tell me the exact steps which results in the anomaly?
Ritesh
MemberThanks for the suggestion ๐
Ritesh
MemberBTW, SQLyog puts ticks around all object names in the SQL it generates.
Ritesh
MemberAha…found the error !!!!
Your database name contains spaces, therefore you need to put ticks(`) around it.
Code:select info from peace beanies.properties where id='1'will not work. Try
Code:select info from `peace beanies`.`properties` where id='1'HTH
Ritesh
MemberI have forwarded it to my development team. Give me 1-2 days.
Ritesh
MemberAs I see, it is not the correct forum to post your question ๐ก
Ritesh
MemberSQLyog logs all its queries in the History window. Just paste the query out here.
If you are using SQLyog 2.51, we highly recommend you to upgrade to 3.52 as it has many new features and lot of big fixes.
-
AuthorPosts