vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Invalid SQL Data Base error on Admincp and forum (https://vborg.vbsupport.ru/showthread.php?t=286061)

Naijasite 07-29-2012 02:32 PM

Current Error:

Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_global = 'a:1227:{s:9:\"1_day_ago\";s:9:\"1 Day Ago\";s:10:\"1_hour_ago\";s:10:\"1 Hour Ago\";s:12:\"1_minute_ago\";s:12:\"1 Minute Ago\";s:7:\"1_reply\";s:7:\"1 reply\";s:10:\"1_week_ago\";s:10:\"1 Week Ago\";s:20:\"CurrentlyActiveUsers\";s:40:\"Current ly Active Users Viewing this Page\";s:14:\"Edit_This_Page\";s:14:\"Edit This Page\";s:18:\"WT_EditWebtemplate\";s:16:\"Edit Webtemplate\";s:17:\"WT_Page_Visit_Log\";s:14:\"Pa ge Visit Log\";s:14:\"a_closed_forum\";s:14:\"A Closed Forum\";s:6:\"accept\";s:6:\"Accept\";s:6:\"action \";s:6:\"Action\";s:14:\"active_members\";s:14:\"A ctive Members\";s:20:\"active_subscriptions\";s:20:\"Act ive Subscriptions\";s:14:\"add_as_contact\";s:14:\"Add as Contact\";s:13:\"add_as_friend\";s:13:\"Add as Friend\";s:15:\"add_new_folders\";s:15:\"Add New Folders\";s:16:\"add_subscription\";s:16:\"Add Subscription\";s:17:\"add_x_to_contacts\";s:25:\"A dd %1$s to Your Contacts\";s:5:\"admin\";s:5:\"Admin\";s:19:\"admi n_control_panel\";s:19:\"Admin Control Panel\";s:11:\"admin_login\";s:8:\"Admin CP\";s:23:\"admin_required_register\";s:129:\"The administrator may have required you to <a href=\"register.php?%1$s\" rel=\"nofollow\">register</a> before you can view this page.\";s:14:\"administrative\";s:14:\"Administrat ive\";s:29:\"administrator_decided_x_quiet\";s:85: \"The administrator

The error are too long to be posted...am still getting same error above but little diff.

--------------- Added [DATE]1343576635[/DATE] at [TIME]1343576635[/TIME] ---------------

I have uploaded the Tools.php...admincp was change to ---------

--------------- Added [DATE]1343577074[/DATE] at [TIME]1343577074[/TIME] ---------------

Datebase error
Its same as the above code

BirdOPrey5 07-29-2012 02:53 PM

im working on it now, please dont do anything.

Naijasite 07-29-2012 02:53 PM

Ok thanks bro

BirdOPrey5 07-29-2012 02:56 PM

You're back online. :up:

There were about 15 more phrase groups to add... then I did have to finish the upgrade that was previously started- that seems to have rebuilt the laguage... All phrases appear to be working now.

BACKUP YOUR DATABASE BEFORE YOU DO ANYTHING ELSE.

ozzy47 07-29-2012 03:00 PM

Excellent Joe, thanks for sticking through this with me and figuring out the issue.

Naijasite 07-29-2012 03:01 PM

Thanks so much. You should be in Vbulletin Team.
You actually get my board working after spending hours working on it...

I do not know hot to say thanks to YOU.

God bless you you and BirdOpre5 and Ozzy47,

You guys are guru am going to do my backup now.
Thanks

BirdOPrey5 07-29-2012 03:02 PM

You are welcome.

Ozzy did most of the work with getting all the phrase groups back.

I am on the vBulletin Support Team :)

You can thank me by making regular backups. ;)

Naijasite 07-29-2012 03:10 PM

Thanks so much Ozzy for fixing the errors and Thanks to BirdOprey5 for responding so fast.
You both wonderfull people.

I just did my backup now

TheLastSuperman 07-29-2012 07:20 PM

Do we know which product caused such behavior? Which product did you uninstall just before this error presented itself?

Naijasite 07-29-2012 11:14 PM

The product that cause the error are Vbquiz and VbNotification they are the two last product that i uninstalled.

They just broke my board but my forum is working well now.

But Ozzy and BirdOprey5 are wonderful guys, they stayed up to 3-2 hours to help me resolve the issue.

Very big thanks to them.


Quote:

Originally Posted by TheLastSuperman (Post 2352534)
Do we know which product caused such behavior? Which product did you uninstall just before this error presented itself?



All times are GMT. The time now is 04:50 AM.

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.01155 seconds
  • Memory Usage 1,740KB
  • 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)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete