PDA

View Full Version : Major error with db_mysql.php. Help appreciated...

Mithan
09-07-2002, 08:06 PM
Hello, if you go to my webstite (www.ac2hq.com) and scroll to the bottom, I am getting the following error:

Warning: 3 is not a valid MySQL-Link resource in /home/virtual/site92/fst/var/www/html/forum/admin/db_mysql.php on line 93

Database error in vBulletin 2.2.6:

Invalid SQL: UPDATE session SET lastactivity=1031432316,location='/' WHERE sessionhash='9a427a58e228aec13b5dee9ee11bf924'
mysql error:

mysql error number:

Date: Saturday 07th of September 2002 04:58:36 PM
Script: http://www.ac2hq.com/forum/
Referer: http://www.ac2hq.com/forum/index.php



The following code seems to cause the problems:
chdir("/home/virtual/site92/fst/var/www/html/forum/");
require('./global.php');
chdir("/home/virtual/site92/fst/var/www/html/");


I have this code in to make the Front page forum login work correctly. When I remove it, the error goes away (but my code breaks). When I put it back in, my code works fine, but I get the error code at the bottom.

Any help is appreciated...
Mithan
09-07-2002, 08:28 PM
Well I have seemed to be able to narrow it down to this:

chdir("/home/virtual/site92/fst/var/www/html/forum/");
require('./global.php');
chdir("/home/virtual/site92/fst/var/www/html/");


We turned off Pluhnews and the login script, and that is ALL that im calling on our front page that is forum related. The error message is slightly changed to this now:


Warning: 3 is not a valid MySQL-Link resource in /home/virtual/site92/fst/var/www/html/forum/admin/db_mysql.php on line 93




Database error in vBulletin 2.2.6:

Invalid SQL: UPDATE session SET lastactivity=1031433819,location='/index.php?vo=18' WHERE sessionhash='d53a8eb2b8318730c0ab2d0e03dd5809'
mysql error:

mysql error number:

Date: Saturday 07th of September 2002 05:23:39 PM
Script: http://www.ac2hq.com/forum/index.php?vo=18
Referer: http://www.ac2hq.com/
Mithan
09-10-2002, 06:08 PM
bump
g-force2k2
09-10-2002, 06:17 PM
it seems to me there's a problem with the update sql... what exactly does the sql say? regards...

g-force2k2
Mithan
09-10-2002, 06:25 PM
Thanks for the reply g-force.

All the errors the SQL gives us is displayed up top. If you want, I can turn it back on so it shows the errors on the front page, but I copy and pasted it exactly.

Or are you refering to something different?
Mithan
09-10-2002, 06:32 PM
Actually, I re-enabled the code.

You can see all MySQL errors at the bottom of the webpage in this picture:

http://www.ac2hq.com/mithan/trouble.jpg
The strange thing is, even with these errors, the code all works fine.
g-force2k2
09-11-2002, 01:56 PM
Mithan... show me that exact query as per the php file that it is in... the update sql... as for the headers already sent could be a problem with the code that you're using... if you want to pm me the codes / file that is fine... regards...

g-force2k2