vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   Major error with db_mysql.php. Help appreciated... (https://vborg.vbsupport.ru/showthread.php?t=43283)

Mithan 09-07-2002 08:06 PM

Major error with db_mysql.php. Help appreciated...
 
Hello, if you go to my webstite (www.ac2hq.com) and scroll to the bottom, I am getting the following error:

Quote:

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:
Quote:

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:

Quote:

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:


Quote:

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


All times are GMT. The time now is 07:14 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01125 seconds
  • Memory Usage 1,726KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete