Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
Reload this Page Major error with db_mysql.php. Help appreciated...
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Major error with db_mysql.php. Help appreciated... Details »»
Major error with db_mysql.php. Help appreciated...
Version: , by Mithan Mithan is offline
Developer Last Online: May 2012 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 09-07-2002 Last Update: Never Installs: 0
 
No support by the author.

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...

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 09-07-2002, 08:28 PM
Mithan Mithan is offline
 
Join Date: Apr 2002
Posts: 96
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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/
Reply With Quote
  #3  
Old 09-10-2002, 06:08 PM
Mithan Mithan is offline
 
Join Date: Apr 2002
Posts: 96
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
bump
Reply With Quote
  #4  
Old 09-10-2002, 06:17 PM
g-force2k2 g-force2k2 is offline
 
Join Date: Mar 2002
Location: Everywhere you wanna be..
Posts: 1,608
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
it seems to me there's a problem with the update sql... what exactly does the sql say? regards...

g-force2k2
Reply With Quote
  #5  
Old 09-10-2002, 06:25 PM
Mithan Mithan is offline
 
Join Date: Apr 2002
Posts: 96
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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?
Reply With Quote
  #6  
Old 09-10-2002, 06:32 PM
Mithan Mithan is offline
 
Join Date: Apr 2002
Posts: 96
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Actually, I re-enabled the code.

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


The strange thing is, even with these errors, the code all works fine.
Reply With Quote
  #7  
Old 09-11-2002, 01:56 PM
g-force2k2 g-force2k2 is offline
 
Join Date: Mar 2002
Location: Everywhere you wanna be..
Posts: 1,608
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
Reply With Quote
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 07:31 PM.

Contact Us - Archive - Top

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.04253 seconds
  • Memory Usage 2,257KB
  • Queries Executed 20 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (6)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete