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 03-17-2010, 05:32 AM
goshalim goshalim is offline
 
Join Date: Oct 2007
Posts: 470
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Mysql Error

Hi,

Since yesterday when iam in the admincp and trying to delete a user this message is coming and i cant do anything .

Any ideas please what is this and how can be fixed



Quote:
Invalid SQL:

DELETE FROM fnewgroupread
WHERE userid = 3938;

MySQL Error : Table 'canarybr_canary.fnewgroupread' doesn't exist
Error Number : 1146
Request Date : Wednesday, March 17th 2010 @ 01:29:18 AM
Error Date : Wednesday, March 17th 2010 @ 01:29:18 AM
Script : http://canarybreeder.net/up/forum/ad...er.php?do=kill
Referrer : http://canarybreeder.net/up/forum/ad...=remove&u=3938
Reply With Quote
  #2  
Old 03-17-2010, 07:41 AM
Speysider's Avatar
Speysider Speysider is offline
 
Join Date: Apr 2009
Posts: 1,029
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

canarybr_canary.fnewgroupread
Clearly states that this table does not exist anywhere on your forum's database.

You will need to use phpMyAdmin to create the fnewgroupread table in your forum db.
Reply With Quote
  #3  
Old 03-17-2010, 08:04 AM
goshalim goshalim is offline
 
Join Date: Oct 2007
Posts: 470
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Its not the only one problem that i have.

Since last night when i have upload new clear original files of Vb ( beacuse my web site was hacked ) some function are not working showing that there is error in sql as above.

Why is that ?
Reply With Quote
  #4  
Old 03-17-2010, 10:53 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Most likely caused by an installed modification, and i guess you did not re-upload all the files needed for these modifications.

Turn off the plugin system until you find the culprit.
Reply With Quote
  #5  
Old 03-17-2010, 01:06 PM
goshalim goshalim is offline
 
Join Date: Oct 2007
Posts: 470
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi MArco

I havent uploaded any new modificaition . The only thing i did was to uploald all Vb files to public_html path.

Nothing else.

Exept from the above also the social groups are not working at all and also recieving hundreds of e-mail of databease error

Shall i try to re upload them all again !!!
Reply With Quote
  #6  
Old 03-20-2010, 12:37 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You will need to either re-install the modification or completly remove it.
Reply With Quote
  #7  
Old 03-20-2010, 05:46 PM
goshalim goshalim is offline
 
Join Date: Oct 2007
Posts: 470
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

exellent , working now , thanks marco
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 11:21 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.05879 seconds
  • Memory Usage 2,214KB
  • Queries Executed 11 (?)
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_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)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
  • (7)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