[Tarheel]

peterlaursen wrote on Aug 16 2007, 09:24 AM:

Can you tell if php_mysql() or php_mysqli() extension is available/used? There is no mysqli_pconnect().

If php_mysql is used, Is 'Allow_persistent = ON´ in php configuration ([mysqld] section of php.ini)? But even if it is it is not always sufficient. I have experienced on some servers that it is not and I think that also webserver configuration has influence. But I do not know details.

What is the phpMyAdmin version and can you attach phpMyAdmin configuration file here?

Also the returns of phpinfo() could be useful! I am a little surprised that phpMyAdmin seems to have no problem and would like to find out how it does!

I am not sure about whether php_mysql() or php_myhsqli() extension is available/used. The phpMyAdmin program is accessed via CPanel 11 at BlueHost.com so the only information I have is as follows:

phpMyAdmin – 2.10.0.2

MySQL client version: 4.1.21

Used PHP extensions: mysql

'Allow_persistent = ON' is in the php.ini file which I can access. Sorry, I cannot provide more info – perhaps, technical support at http://www.BlueHost.com can help.

[Tarheel]

peterlaursen wrote on Aug 16 2007, 03:58 AM:

Are you using HTTP tunnel? If so is PHP version the same? Was SQLyog/the tunneler upgraded recently?

User variables only live as long as the connection. With HTTP tunnel a new connection is created for every statement (unless persistent connection is ON in PHP configuration and supported by webserver configuration)

So when you execute “SELECT @N := @N +1” @N is NULL and NULL + 1 = NULL

As it works with phpMyAdmin it seems that pesrsistent connection is supported on the host. You can edit the tunneller file and replace mysql_connect() with mysql_pconnect.

This is the only reason I can see. If that is not the issue, I think we need more details

Yes, I am using HTTP tunnel on the new server (I did not have to use it on the old server). The PHP version is also an upgrade to 5.1.6. I used the SQLyogTunnel.php file from SQLyog version 6.05.

I made the following change to the tunneller file but it has not corrected the problem: $ret = mysql_pconnect ($host.':'.$port, $username, $password);

Is this correct? Is there anything else I can try?

Thanks for your help!

[Tarheel]

I upgraded to the 5.2 beta5 and as you predicted, it did not solve the problem.

I then changed the field from BLOB to LONGBLOB and that solved it. I just uploaded a ~600KB image file successfully. Thanks for your prompt response. I am very pleased the SQLyog program.

peterlaursen wrote on Oct 2 2006, 01:54 PM:

There is no such (known) issue with SQLyog. Attached a BLOB of almost 3 MB (SQLyog 5.2 beta5)

But please upgrade SQLyog and try again – though I am 99% sure that there was no such issue with 5.16 either.

Are you connecting with HTTP-tunneling? There could be some buffer or time-out issue on the network.

PHP/webserver(Apache)/releay server settings are my best guess. Neither SQLyog nor MySQL, I think.

SQLyog sends the data, it is all delivered to the remote network, but inside that netwok some of it gets lost.

If you create a ticket I can arrange access to a database on another server (tomorrow!).

Upgrades: http://www.webyog.com/en/download_latest_sqlyog.php

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

[Author]

Posts