Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2008, 02:48 AM
crkgb crkgb is offline
 
Join Date: Oct 2007
Posts: 237
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Profile: Go Advanced issue

Hello. Please help to solve this thing which I have no explanation for. I have not changed anything in the DB.

To the problem.

In the user profile in the area where personal messages are left there is a button "Go Advanced". Well now istead of taking me to the full size editor it gives me an error

PHP Code:
Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT useridrelationidtype from userlist where userid=AND relationid=2;

MySQL Error   Table 'russianwavbdb.userlist' doesn't exist 
Please help
Reply With Quote
  #2  
Old 07-23-2008, 05:38 AM
PaulSonny PaulSonny is offline
 
Join Date: Dec 2006
Location: Middlesbrough, UK
Posts: 433
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Basically that error message means that there is no userlist table or it cannot find it.

I would suggest going into your database manager (most likely phpmyadmin) and check whether the userlist table still exists.

Thanks, Paul.
Reply With Quote
  #3  
Old 07-23-2008, 08:03 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can you please provide the URL so we can see the full error message?
Reply With Quote
  #4  
Old 07-24-2008, 01:53 AM
crkgb crkgb is offline
 
Join Date: Oct 2007
Posts: 237
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The table does exist
rwvb_userlist

PM sent to Marco Van Herwaarden due to the test site being password protected in accordance with vb instructions
Reply With Quote
  #5  
Old 07-24-2008, 09:24 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you can not post the URL here, then a copy of the full error message might also do.

PS If the table rwvb_userlist does exist, then i guess that you have installed a modification that does not work with table prefixes. Contact the author for a solution.
Reply With Quote
  #6  
Old 07-24-2008, 11:58 PM
crkgb crkgb is offline
 
Join Date: Oct 2007
Posts: 237
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank You,

Here is a complete error message:

Quote:
Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT userid, relationid, type from userlist where userid=1 AND relationid=2;

MySQL Error : Table 'russianwavbdb.userlist' doesn't exist
Error Number : 1146
Request Date : Wednesday, July 23rd 2008 @ 07:46:50 PM
Error Date : Wednesday, July 23rd 2008 @ 07:46:51 PM
Script : http://www.russianwa.com/testvb/visi...php?do=message
Referrer : http://www.russianwa.com/testvb/member.php?u=1
IP Address : 76.121.xxx.xx
Username : User1
Classname : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.2-log
Reply With Quote
  #7  
Old 07-25-2008, 12:50 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);
Reply With Quote
  #8  
Old 07-26-2008, 06:45 AM
crkgb crkgb is offline
 
Join Date: Oct 2007
Posts: 237
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

After putting this define('DISABLE_HOOKS', true); in config everything started to work again.

I guess gonna have to see which one of the plugins causes this weird issue.

Thank you very much.
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 02:49 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04087 seconds
  • Memory Usage 2,226KB
  • Queries Executed 13 (?)
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)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)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_postinfo_query
  • fetch_postinfo
  • 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