vb.org Archive - Mysql Error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Mysql Error (https://vborg.vbsupport.ru/showthread.php?t=238457)

goshalim

03-17-2010 05:32 AM

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

Speysider

03-17-2010 07:41 AM

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.

goshalim

03-17-2010 08:04 AM

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 ?

Marco van Herwaarden

03-17-2010 10:53 AM

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.

goshalim

03-17-2010 01:06 PM

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

Marco van Herwaarden

03-20-2010 12:37 PM

You will need to either re-install the modification or completly remove it.

goshalim

03-20-2010 05:46 PM

exellent , working now , thanks marco

All times are GMT. The time now is 02:01 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01034 seconds Memory Usage 1,720KB 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 (1)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
Messages: