[tranzformation]

My host has sent me the following information

“Dec 5 04:23:19 “server name”: ALERT – configured request variable name length limit exceeded – dropped variable 'localhost“my username”“My password”3306

[tranzformation]

My hosting company has now managed to solve the problem.

I have included their resolution below, in the hope it may help other people.

“One of the variables in SQLyogTunnel.php was hitting the name_length limit in our security module. I have tweaked it to allow ridiculously long variable names. Please try it now.”

I didn't ask what variable it was.

Regards

Mark

[tranzformation]

I am having a similar problem using 6.14

I think the problem is with the hosting company, as I can connect to other hosts ok

I just wondered if anyone else has had a similar problem and found a resolution, as the hosting company seem to be scratching their heads.

The problem only happened around a week ago, the same time I upgraded to 6.14, although I don't think this is the fault.

When I try to connect to any of my databases I get the following message returned to me.

“

HTTP/1.1 406 Not Acceptable

Date: Wed, 05 Dec 2007 09:23:19 GMT

Server: Apache/1.3.37 (Unix) mod_jk/1.2.14 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.7 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a

X-Powered-By: PHP/4.4.7

Keep-Alive: timeout=15, max=99

Connection: Keep-Alive

Transfer-Encoding: chunked

Content-Type: text/html

“

Thank you in advance

Mark

[tranzformation]

peterlaursen wrote on Sep 20 2007, 12:15 PM:

OK .. I thougt I could 'steal/link' an attachment of another post, but seems not to work!

Find it attached here too.

We found out so much that we will need a piece of 'wrapper' code for the API call as the API will only support ANSI and UTF16 strings as file path – not UTF8. This code snippet has been written now, and we are integrating and testing.

I have run the exe file and it has created the 2 files

Chek.txt is an empty file

and the contents of Log.txt are

C:Documents and SettingsusernameApplication Data

Copying file to Appfolder Successful

Copying Contents Successfull

username is my username which contains an UPPERCASE first character and the rest are all lowercase, with no special characters.

[tranzformation]

tranzformation wrote on Sep 20 2007, 09:28 AM:

I tried to download the zip file twice, each time I opened it, I got a zip file corrupt message!!!

Winzip gave a corrupt error again

I have managed to open it with winrar, but it just shows a 17k file called CopyToLog with no extension.

I tried to add the .exe extension to it, but that didn't work.

I tried to attach the file to this reply, but I was told I don't have permission, so I changed the extension to .txt and I have uploaded it.

[tranzformation]

peterlaursen wrote on Sep 19 2007, 09:31 PM:

1)

Could I ask you to try this:

download http://www.webyog.com/forums//index.php?ac…post&id=746

It is a .zip file. just unzip.

A folder with an .exe inside is resulting.

Just doubleclick the .exe

It will build two files in that folder “check.txt” and “log.txt”, and it will attempt to copy “check.txt” to … {AppData}SQLyog folder.

Please attach “log.txt” Generated here.

(if your username is very secret you can create a ticket!).

2)

Also could you try with another user account?

I tried to download the zip file twice, each time I opened it, I got a zip file corrupt message!!!

[tranzformation]

peterlaursen wrote on Sep 19 2007, 08:04 PM:

And no accented letters (like ä, é, ñ, ø) in user name either?

Every non-ASCII letter will cause this problem!

No accented letters, no special characters, no numbers, just straight forward name, with first letter in Uppercase.

As I said earlier, this is the first time this has happened, I have been using SQLyog for about 17 months now.

Fantastic program, saved me hours of work.

[tranzformation]

peterlaursen wrote on Sep 18 2007, 08:23 PM:

@tranzformation

Please answer:

Does the string describing the path “documents and settingsuserapplication datasqlyog” contain anything unusual (accented and other special characers) due to a special user name or localized AppData folder name?

The path is “C:Documents and Settings*****Application DataSQLyog”

where ***** =username(made up of letters, no special characters)

[tranzformation]

I too had this problem moving from 6.05 to 6.07 and have never seen this problem in the past.

The suggested fix did not work, I overwrote the newly created ini file with the old ini file from version 6.05 and each time I start SQLyog the ini file is again copied to ini.bak and a new empty one is created.

The only way I could resolve this problem was to remove V6.07 and re-install V6.05

[Author]

Posts