[peterlaursen]

I am using Vista 95% of the time myself and cannot recognize this. But frustrating when it occurs of course!

Anyway:

If the program is busy it is not responding! So my best guess is that it takes that much time to finish what it is doing (saving).

Please first

1) Ensure that Vista is fully up-to-date

2) Try SQLyog 6.14

.. and see if problems persist!

If problems persist please tell:

* Is it a remote server?

* How do you connect (direct, SSH or HTTP)?

* What type of Internet connection do you have?

* Can you reproduce on a local server?

* If it is a local server please try some INSERT statement from command line client. Much faster or not?

* if it is a remote server and direct connection is possible, please try some other client (like command line, Query Browser)

* Is it same problem from DATA tab and RESULT tab?

* You are perfectly sure that it is not a coincidence that something happens on the server or with the connection at the same time as you change the OS? (you are welcome to try your copy from a XP and a Vista machine at the same time from the same location to test this!)

* You are sure it is not a firewall issue (try turn off all of that kind!)?

Vista has known issues with TCP implementation (that should mostly affect 'shared connections' and dial-up connections, as I understand), so this could be part of the explanation.

[peterlaursen]

Our upgrade and support concept lets you have free upgrades and lets you retrieve registration information from our webiste for a year after last purchase.

Users that do not want to upgrade at regular intervals are themselves responsible for keeping a safe copy of all details (installer and registration details). As a principle we do not support old versions, becasuse we hate to distribute code with known bugs!

Anyway:

We will not exchange registration details public! Please create a ticket here:

http://www.webyog.com/support/ttx.cgi

Please write any information that is required to identify you (order id, company name, to whom the program is registered, registration code or email address used for purchase)!

[peterlaursen]

Still not reproducable with 6.14 or 6.15 internal build. Every query I execute with “LIMIT 1” exports one row of data!

[attachment=795:limit1.gif]

Are you sure that you do not have an old versions (with this bug) and a recent version installed at the same time and by mistake execute the same old version as before? When program is open what version does 'help … about' tell?

[peterlaursen]

Would you expect this to work across different server versions or would the same version only be OK?

[peterlaursen]

For me it works fine!

I import the dump, execute “select lname,fname,fname2,sum(hours) as Total from fbi_hours

group by lname,fname,fname2 order by lname,fname;”

export as HTML, next switch to text-mode and copy from result tab into a text editor with line numbers (PSPAD).

See the display of the result

* as text in PSPAD

* as HTML is Dreamweaver 4

* as HTML is IE7

[attachment=792:htmexp.gif]

[attachment=793:ie.gif]

What am I missing?

[peterlaursen]

We solved such issue recently.

Please upgrade to latest version (6.14) and tell if problems persist!

And please also post SQLyog questions in the SQLyog – and not MONyog – category. I am moving you out of here 😉

[peterlaursen]

Just let me add that this build adds a single fix to 6.14 (in structure sync).

[peterlaursen]

Just let me add that this add a single fix to 6.14 (in structure sync)

[peterlaursen]

Once the registration information is stored in a system it is 'permanent ' there

We have an old FAQ here that describes:

http://www.webyog.com/faq/content/31/106/e…ter-sqlyog.html

If you have Windows 'Systems Restore' enabled and have a restore point available from before the 1st installation you can use it!

Now if you have purchased a valid license for yourself, then just don't worry about it! It will work and nobody will blame you!

[peterlaursen]

We consider an option in 'Structure Synchronistion' and exports to 'strip out' DEFINER and SQL_SECURITY clauses.

I do not think we will in ALTER …

Currently you can 'search and replace' with an empty string in the editor.

[peterlaursen]

This ALTER … was never considered a sync tool. Structure Sync will let you sync without touching thedatabase ..

You have experienced this as 'extemely dangerous'. The other way around (not specifying the database) may be equally dangerous – if you by mistake hit a database in the Object Browser the statements will execute where you hit. Other users may NOT be aware of that changing the database context changes where it executes!

You should understand the meaning of the SQL you are executing, basically!

We populate the TEMPLATE from the returns of 'show create procedure'. The server returns like that.

Maybe we can implement by querying from Information_Schema ..

Anyway we use database identifier with DROP and not with CREATE stmt. Looks like a mistake – or at least an inconsequence.

[peterlaursen]

I should have realized!

There never was a 4.14! There was a 4.1 and some 4.2 betas were released, but were finally released as 5.0!

[peterlaursen]

We will either

* provide a 6.14 or 6.15beta/RC in both versions

* or find a better ('smart') solution …

in short time. I think in less than 48 hours.

[peterlaursen]

OK .. 'url_encode' was the issue then!

We will try to get the time to build 5.14 accordingly for you very soon!

[peterlaursen]

An issue with version 4.14 is definitely not 'url_encode' related.

Can you connect to the tunneller from a browser?

Can you connect to other php scripts in the same folder?

[Author]

Posts