mysql error number: 0 ???

[LordB]

Ok this is a odd, setting up a new server and keep getting this problem with php

Database error in vBulletin 2.2.8:

Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,althash,location) VALUES ('1d4a69b3544ecf525a70ffa1a18fb67e','1','10.2.1.134','Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) ','1035227439','','/forum/index.php')
mysql error:

mysql error number: 0

0 should be succseed can some one help... I have tryed compileing php with the genaric support and pointing it to my mysql libs.

ist php 4.2.3 apache 1.3.27 mysql 3.23.49 on redhat 7.2

Thanks
LordB

[Steve Machol]

This often means there's a problem with the database but MySQL can't determine exactly what it is.

Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1

[Of course change the exact URL as appropriate for your forums.]

If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok. See if this fixes the problem.

[LordB]

I am just testing a new front end box the back end database is the same for the live forum that does not get any of these errors. I have also tryed installing on the local server and encoter the errors during install.


Database error in vBulletin Installer :

Invalid SQL: INSERT INTO style VALUES (1, 1, 1, 'Default', 1)
mysql error:

mysql error number: 0


LordB

[Steve Machol]

Originally posted by LordB
I am just testing a new front end box the back end database is the same for the live forum that does not get any of these errors. I have also tryed installing on the local server and encoter the errors during install.

I don't know what you mean. Sorry.

[LordB]

Ok lets start from scratch....

I am trying to install a dev site and as I run the install.php on step 4 I get this error.

Database error in vBulletin Installer :

Invalid SQL: INSERT INTO style VALUES (1, 1, 1, 'Default', 1)
mysql error:

mysql error number: 0


Is there any way to make things more verbose??

LordB

[LordB]

To ad on to this i am also getting the php error

[Mon Oct 21 16:49:34 2002] [error] PHP Warning: MySQL: Unable to save result set in /forum/admin/db_mysql.php on line 93

[Steve Machol]

Did you create the database first? What's the link to your phpinfo.php file?

[LordB]

ya it looks like this is a php problem I have posted to there bugtrac list I will post here when I have a resolution. It seems to have to do with compileing php with apxs

LordB

[LordB]

Well It seems to be a problem with php on linux when compiled --with-apxs I have submitted a bug on the php site and will post here if they every get back to me. To get around the problem I compled --with-apache=../apache_1.3.27 and then in apache --enable-shared=php4

LordB

[Steve Machol]

Originally posted by LordB
Well It seems to be a problem with php on linux when compiled --with-apxs

To tell you the truth I thought of that possibility. However I ckeched my server and it is compiled with this extension as well and I don't have this problem. Is this bug unique to PHP 4.2.3? Do you have a URL for this bug submission?

[LordB]

http://bugs.php.net/bug.php?id=20016
is the url to the bug. I have had the problem with many differnt versions of php. I know in this case I did try php4.1.2 with the same result.


LordB

[George L]

Originally posted by LordB
http://bugs.php.net/bug.php?id=20016
is the url to the bug. I have had the problem with many differnt versions of php. I know in this case I did try php4.1.2 with the same result.


LordB

strange i've used php 4.1.2 compiled with apxs for over a year without problems...