[peterlaursen]

BTW: I do not understand this:

Quote:

we still have some MySQL 3.x and 4.0 servers and they do not support subselects,

SUBQUERIES ( = “SELECT … WHERE some_column = (SELECT … );” ) were introduced in 4.1

but SUBSELECTS (= “SELECT … WHERE some_column IN (SELECT ….)” ) were always functional I think.

“IN” is just a simple and common SET operator in this context

… just like this in PPPL:

{

IF orange IN fruits THEN eat_it() ELSE go_nuts()  /*   🙄   */

}

[peterlaursen]

We cannot reproduce (not with 5.21 or 5.22 RC3) and need more information.

1) Please let us see the

Code:

..
..

..part of the job/XML file (fake details that you don't want to make public, or create a ticket and attach there)

2) Is it a 'freshly generated' jobfile or an old one generated with an earlier version? Was it generated using the GUI?

3) Is it only Migration jobs that give this problem?  Try for instance a Notifications job with the same details (.. section).  Just try to execute the SQL “SELECT 'this is a test'” for instance!

The relation between the two is that it is (or should be) exactly the same code that establishes connection in either case.  Actually they are both compiled from the same soruce files, classes and functions. You are pefrectly sure that you use the same jobfile (use FULL path enclosed in “doublequotes” to be sure like

Code:

sja “c:the pathtomy_jobfile.xml”

 

[peterlaursen]

hmmm…

undoubtedly a OS issue.  

I tried to research into Windows clipboard/memory management.  Did not find much, but did find this discussion:

http://www.aqua-soft.org/board/showthread.php?t=34619

quote: “The clipboard size ~ free memory size (actually, the clipboard doesn't have a “size”).”

What is the memory situation of your system before/after copying to the clipboard?

This utility 

http://www.softpedia.com/get/Office-tools/…/ClipSize.shtml

gives information about clipboard memory

and more utilities here …

http://www.softpedia.com/catList/152,1,1,1.html

Could you save to a file?  Could be on some big and fast removable media …

Or does it make any difference to increase the virtual memory (Control Panel .. System .. advanced ….)

anything usable?

[peterlaursen]

yes .. just copy the sqlyog.ini file from the old to the new installation folder.

[peterlaursen]

No HTTP, reproducable on several computers etc. etc.

This looks like a data specific error.  

I think it is one particlar row of data causing this and not the amount of data.

Can you identify the row where it fails?

What was the last row that was succesfully inserted/updated?

[peterlaursen]

Quote:

Or is it more complicated than I like to think?

Could be done like that of course.   

However with details stored in a SQL database, we could do a lot of things (sort, filter are obvious but consider autocomplete, usage statistics, 'connection quality statistics' etc ) with little cost (except for the Query Builder that will come anyway!).

However nothing is planned in detail.  But we do realize that the Connections Manager can be pretty crowded.  

Up to around 20 connections is OK in my opinion. The design is not good for more.  But that I think is also more than enough for 95-98 % of users!

[peterlaursen]

2 say 🙂

1) the program does display a warning.

2) users should not have the DROP privilege unles they need it!

This is a server administration issue, I think.

[peterlaursen]

The idea is as good now as it was when I first heard it (1 1/2 years ago?)!

Basically we will then need to move the storage of those details from the sqlyog.ini file to somewhere else.  

Most likely a sqlite database.  And that would actually give a lot of more options (sorting, filtering, statistics …).

However this is 'mid priority' only.

[peterlaursen]

Please answer:

1) How do you connect?  direct, SSH or HTTP ??

2) Is a a shared server (ISP) or is the server configuration under you control?

[peterlaursen]

“but i still can not connect with that user”

If you can connect to MySQL as 'root' I can only see wrong password as the reason why you cannot with 'mangos'.

I have no experience of my own with bittorrent.

Did you try to UNINSTALL Zonealarm!  My experience (from when I used it myself) is that you cannot trust it when it says it is disabled!  If you do not have a router, enable the Windows firewall so that you are not totally unprotected.  

BTW: Windows Firewall .. enabled??

If so port 3306 must be opened here too!

[peterlaursen]

I saw this page earlier this day as our Server statistics stool told me that we had quite a lot of referrals from it.  You are referring to this description, I think:

Quote:

MySQL host address: localhost

Username: mangos

Password: mangos

Port: 3306

Database: mangos;realmd

While SQLyog is open, first connect (fig7, fig8, fig9, fig10) and then create two databases MANGOS and REALMD(fig11, fig12, fig13);

However how was the user 'mangos' created? The instruction tells you to create a VERY STRONG password for 'root' but nothing about creating the user 'mangos'. Actually now it looks to me that the instruction totally skips the creatio

 of user 'mangos' and his privileges.

Try to log on as 'root' (with the password you gave him), go to tools .. user management ..edit user.  Is 'mangos' there? If not go to tools .. user management … create user (mangos).  Give the password (twice).  Can you now log on as 'mangos'?

Also there is nothing told about what privileges 'mangos' will need for the game server to be functional.  I would start to give him ALL available privileges to the two databases “mangos” and “realmd”, but NO privileges anywhere else.  Do that from tools .. user management .

 management permissions.  Locate the two rows of the databases and check all boxes in the two rows only.

[peterlaursen]

MySQL documentation: http://dev.mysql.com/doc/

Also you may find somet articles on specific matters here:

http://dev.mysql.com/tech-resources/articles/

(actually I rememebr a good one on VIEWS about 1 1/2 year back)

Webyog FAQ: http://www.webyog.com/faq

[peterlaursen]

Two ideas:

1) wrong password ..

2) user does not have a password …

Actually we have had a lot of issues with ZoneAlarm over time.  I used it myself but stopped when i started running Server programs.  It had a tendency of blocking when it should not!  Try to disable it (or even uninstall) temporarily once you are sure that your details are correct.

[peterlaursen]

Yes you have to get up early …  😮

I do not think it is the time that matters!

We will need to know:

1) With what program was that dump generated? 'mysqldump' ?

2) From what MySQL version?

3) To what version do you try to import ?

4) SQLyog program version?

Pease try 5.22 RC1.  It should handle 'version dependent conditional comments'  (/*!40103 … */) correctly.

If you still have an issue, please post a (small) test case to reproduce with.

[peterlaursen]

“SQL yog has generated 2 insert operators for the table, which contains more than 10000 rows!?”

The BULK size is configurable.  Please understand and use the settings of the program!

http://webyog.com/faq/24_101_en.html?highlight=chunk

[Author]

Posts