Forum Replies Created
-
AuthorPosts
-
vygi
MemberTGKnIght wrote on Sep 29 2006, 02:51 PM:Hi I have the same issue, it seems to be if you leave the program running for a long time that the window will close. (e.g after a few hours)Oh yes, I see!
Sorry for posting it again as separate thread; somehow I did not see this another topic!
It seems to be exactly same issue: SQLyog disappears when it runs for a long time and then the users switches to another Windows application.
Now I can recall it happened always some time in the morning, probably when SQLyog was in front of other programs “running” (or actually sleeping) over the night.
Now you must be a little happier as you are at least not alone!! 😉
And I will install Beta 5 to see if it helps (have beta 3 until now).
Memberpeterlaursen wrote on Sep 29 2006, 08:55 AM:OK .. we must then realixse that there is an issue.this is report no. 3 of its kind.
However please still try beta5 when avail!
Oh yes, surely I'll do!
One more remark: I am susing SQLyog a lot, almost permanently, and had quite often similar problems several months ago; then the issue was fixed… or almost fixed, and then I did not have such disappearing experiences for a quite long time.
MemberRohit wrote on Sep 12 2006, 02:02 PM:We will dedicate one developer full time on this starting from Monday.We are not going to use COM objects. We will use the Excel XML format to export data.
🙁
Unfortunately, many corporate customers – probably even most of them – are still using older Excel versions.
I.e. my prevouos company was still using Office 97 (!) and my current company uses mix of Office 2000 and Office XP but I have Office/Excel 2000 which does not support XML-based Excel format.
Nevertheless, this would be a welcomed update and a reason to upgrade my Office to 2003 or at least XP version!
Best regards,
Vygi
MemberHey Friends,
now, are there any news on this topic?
Maybe our company has very special and unusual needs but we really need this feature!
Currently, some of us are using Urban SQL (urSQL) client to export data to Excel. It is not really compatible with MySQL 5 and sometimes creates wrong data type in Excel (text instead of numbers) but still works better than SQLyog.
Unfortunately, I am not a Windows/C++ programmer (just web/php) and unable to implement data export to MS applications via COM (or whatever) in SQLyog, but I am sure that such possibility would be very useful for some customers.
Thanks in advance!
Vygi
MemberRitesh wrote on May 23 2006, 01:27 PM:Give us 2-3 more weeks and things will be more clear.I can give you even 2-3 months! 🙂
P.S. congratulations to your Open Source decision!
Member3: Kill this query from another client –> SQLyog reports lost connection
>> no — SQLyog creates a new connection/new thread!
strange… I am using v5.14 Beta 1 on WinXP Professional and MySQL 5 DBs.
When I kill a query from another client, SQLyog pops up an error dialog with message “Error No. 1028 Sort Aborted” or similar, and that's all. Reconnection only on next request. And it crashes when I try to copy a table from another server to this one with lost/killed connection.
MemberRitesh wrote on Jun 12 2006, 09:01 AM:Nope.We have not been reported any issue.
Can you give us a table dump and some idea of steps to follow to fix the issue?
Nope!
It only happened once yesterday and I cannot reproduce it.
SQLyog was running for 4-5 hours at that time, with 3 active connections, 3-5 query tabs each, etc…
BTW for table dump we would need a DL DVD-R (8+ GB of data) 😉
Nevertheless, I can reproduce another silent crash!
It happened to me when I tried to copy a table to another server which lost connection (time-out over the night).
Steps to reproduce:
1: Open two connections to two different MySQL servers
2: Start some heavy query like “SELECT * FROM large_table ORDER BY unindexed_field LIMIT 10;”
3: Kill this query from another client –> SQLyog reports lost connection
4: Now switch SQLyog to another server without doing anything on the 1st
5: Select some table and try to copy it to the 1st server via “Copy Table To Different Host/DB…” –> SQLyog reports “Error 1146: Table xxxxx doesn't Exist”
6: Confirm error popup with “OK” and try to do same operation (click on “Copy”) again –> SQLyog CRASHES WITH NO MESSAGES!
Hope it helps,
Vygi
MemberHey guys,
does anybody still have similar problems?
I have the latest 5.14 Beta since last Wednesday and it has unexpectedly disappeared (crashed without any messages) while I was browsing in the result tab.
It was a table with maybe 20 columns and approximately 2,100 rows, all of them visible in the data grid (limit set to 5,000). I have sorted the rows by date/time … and SQLyog was away when I've pressed “LEFT” key… 🙁
MemberHey here,
now one more (small one) problem:
when I have several open connections and they time out over the night — all works now fine when I try to access the servers directly by sending queries or selecting objects (THANKS for fixing) but is still doesn't work when I try to copy a table to another server:
I still get “Error No. 2006 Mysql Server Has Gone Away” error when I try to copy a table to a server with inactive (expired or killed) connection. I have to switch to that server (to re-initiate connection) and then retry.
MemberI am sorry to say that your “Plans for future versions of SQLyog” (http://webyog.com/faq/33_20_en.html) aren't up to date anymore:
Next release adding major new functionalities will be named Version 5.2. It is planned for release by the end of first quarter 2006/beginning of second quarter 2006.
[…]
With version 5.2 we also plan to implement some other requests, such as Better interoperability with spreadsheet programs – Microsoft Excel in particular
But I still hope that export to Excel will be not forgotten!
Our company has bought 5-License-Pack of SQLyog but my workmates must still use UrbanSQL because of this issue.
I clearly understand that it's not really a SQLyog problem
but in this case I recommend you to remove or rename “Fill Excel friendly values” option as it makes the process not much more friendly and is just confusing.
May 3, 2006 at 12:18 pm in reply to: Issue With Inserting A Row At The Bottom Of Table Data Grid #21547Memberpeterlaursen wrote on May 3 2006, 11:12 AM:Code:Will probably fix #6 in BETA 5To me it looks more like vygi's PC needs an OS repair or reinstall ?!
Why this?!…
[format c:] <-- execute this to get new OS
May 3, 2006 at 10:20 am in reply to: Issue With Inserting A Row At The Bottom Of Table Data Grid #21543Memberpeterlaursen wrote on May 3 2006, 10:09 AM:I have a scroll-bar and I used your table definition and filled data into it so that there were more rows than could be displayed.The asterix symbolizes non-saved rows, I think! I think this is part of a the windows API, but Ritesh must explain.
It is similar in Access and OpenOffice Base when you open a table. Don't you have it there either?
No, Access works fine, I can scroll as long as I want and Access does not save not finished rows.
BTW asterix in Access means new (empty) rows and it changes to “pen” (and another empty asterix row appears) when you start o edit, so empty (not existing) = asterix and not saved = pen in Access.
Memberpeterlaursen wrote on May 3 2006, 08:15 AM:You should shut down your computer when leaving your job in my opinion!What an irresponsible waste of energy 🙁
OK OK OK,
I know I know I know,
CO2 and rain forest and so on….
but seriuosly: sometimes I start some long taking scipts and processes when I left my office and I even CAN'T stop my PC, so I also left SQLyog up and running.
BTW did you see that SQLyog has scheduled tasks? They also require an (almost) permanently running client, isn't? And they may fail because of some timeout and unavility to reconnect automatically?
color=”red”]X[/color <-- nail here to get a new monitor
Memberpeterlaursen wrote on May 3 2006, 09:55 AM:🙂basically Excel is to blame I think! But it will take a few weeks before I'll buy Micorsoft, so we'd better find a solution in between.
Now can't you set the type for each column (avoid auto) when importing CSV?
no, it doesn't solve all issues as in some cases Excel still overwrites their own settings and still interpretes some values like it wants.
May 3, 2006 at 9:54 am in reply to: Issue With Inserting A Row At The Bottom Of Table Data Grid #21541Memberpeterlaursen wrote on May 3 2006, 09:48 AM:I tried to follow your instructions, but failed in doing so!5. Press TAB to switch to the next column (s2). The row you're editing disappears at all. Now it is actually not visible because it is somewhere below the data grid. NOPE it does not disappear!
6. try to move (with the mous) the scroller on the right side of the grid or clisk of their arrows.
You wil get a large number of “Suplicate entry” errors, at least 5 or 10 if you're quick enough to releas the mouse, or up to several hundreds of them! Not either, but as first step was not reproduced that could be why!
Here it looks a little bit different. See attached. What happend to that 'brick' with an asterix (*)
Did I miss something?
hmmmm… don't know…
do you have a scrollbar at the right?
and also do you already have a row with default primary key value? otherwise there will be no primary (or unique) kay conflict and therefore no error messages.
I also tried it in the Result row: when I clisk “add row” (green “+”), a new line appears and remains visible, so there is no issue at the 5th step. But when after them I try to scroll — SQLyog tries to insert the row being edited, and I again get those errors.
-
AuthorPosts
