Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Getting a strange error from my cp.. Details »»
Getting a strange error from my cp..
Version: , by Crazy Pete Crazy Pete is offline
Developer Last Online: Jun 2006 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 04-21-2003 Last Update: Never Installs: 0
 
No support by the author.

This just started happening last night, and I haven't installed any hacks in a while so I don't know what could be causing it. I tried installing filburt's "Self-Healing Database" beta hack to see if it would fix the problem, but it didn't. Here's the error...

To: pete@expectedmiracles.com
Subject: vBulletin (cp) Database error!


Database error in vBulletin Control Panel 2.2.9:


Invalid SQL: UPDATE session SET lastactivity=1050939142,location='' WHERE sessionhash='0a4d9ea9fae9dd38041e2bd3db7a1bc2'
mysql error:


mysql error number:


Date: Monday 21st of April 2003 11:32:22 AM
Script: http://www.expectedmiracles.com/foru...hp?action=home
Referer: http://www.expectedmiracles.com/forums/admin/index.php
Repair Report: This type of error cannot be automatically repaired.

Anyone have any ideas?

Show Your Support

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

Comments
  #2  
Old 04-21-2003, 04:52 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

erm, i don't see the errormsg itself...

try to upload an unhacked session.php
Reply With Quote
  #3  
Old 04-21-2003, 04:54 PM
amykhar's Avatar
amykhar amykhar is offline
 
Join Date: Oct 2001
Location: PA
Posts: 4,438
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am getting the same problem. It just started happening as well. I wonder if it could be a host issue?
Reply With Quote
  #4  
Old 04-21-2003, 04:57 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hmm, has your host upgraded to mysql4?

AFAIK there are some more problems with hosts upgrading to ChenQL4 ..
Reply With Quote
  #5  
Old 04-21-2003, 04:58 PM
Crazy Pete Crazy Pete is offline
 
Join Date: Nov 2002
Posts: 155
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That's why it's odd Xenon, there's no error number associated with it at all, that's just all it tells me.

Really Amy? Who do you go through if you don't mind my asking?
Reply With Quote
  #6  
Old 04-21-2003, 05:02 PM
amykhar's Avatar
amykhar amykhar is offline
 
Join Date: Oct 2001
Location: PA
Posts: 4,438
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I just found what's causing it on mine. I installed assassingod's database stats hack yesterday. Removing that hack fixed the problem. Are you sure you didn't hack something?

Amy
Reply With Quote
  #7  
Old 04-21-2003, 05:10 PM
Crazy Pete Crazy Pete is offline
 
Join Date: Nov 2002
Posts: 155
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well the only thing I added was trafix's jukebox hack but that had been working fine for a few weeks already. I did make one change to the user.php file the other day because I couldn't add any users manually (was getting that dreaded "column count doesn't match value count" error).

It is in the session.php file though? What should that line look like?
Reply With Quote
  #8  
Old 04-21-2003, 05:38 PM
amykhar's Avatar
amykhar amykhar is offline
 
Join Date: Oct 2001
Location: PA
Posts: 4,438
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The hack I mentioned was actually installed on admin/index.php

I haven't taken the time yet to figure out why it might be giving me grief.

It's just weird that we both started getting exactly the same error at the same time - especially since you don't remember installing any hacks recently.

Amy
Reply With Quote
  #9  
Old 05-06-2003, 03:11 PM
Crazy Pete Crazy Pete is offline
 
Join Date: Nov 2002
Posts: 155
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Found out what it was. It was the hack to find out how much space was being used by the SQL database. For some reason my index.php didn't like the code.

But now it's a moot point anyhow as my CPanel index page tells me that same info.
Reply With Quote
  #10  
Old 05-06-2003, 03:20 PM
assassingod's Avatar
assassingod assassingod is offline
 
Join Date: Jul 2002
Posts: 3,337
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmmmm, my hack seems to be casuing some trouble.
Maybe I should remove it for the time being.
Reply With Quote
Reply


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 10:51 PM.


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.05012 seconds
  • Memory Usage 2,282KB
  • Queries Executed 23 (?)
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
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)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