vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   datastore corruption (https://vborg.vbsupport.ru/showthread.php?t=169190)

LauraS 01-30-2008 07:40 PM

datastore corruption
 
I'm getting errors saying that my datastore is corrupted and the MySQL client has run out of memory. I'd like to rebuild my datastore, and I've hard tools.php is the way to do it.

However, when I try and upload tools.php and run it from a browser, I get a blank white screen. I removed the /install directory from my web servers, and I changed the /admincp directory name, so I don't know where to put tools.php to make it accessible. Am I missing something, has anyone else run across this issue?

snakes1100 01-30-2008 07:43 PM

It goes in your renamed admincp dir.

Please post the full mysql error message before running tools.php though, that way we can trouble shoot the issue.

LauraS 01-30-2008 07:56 PM

Sure, I get this error message consistently:

Database error in vBulletin :
Invalid SQL:

SELECT *
FROM vb3_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','style cache','languagecache','products','pluginlist','cr on','profilefield');

MySQL Error : MySQL client run out of memory Error Number : 2008

snakes1100 01-30-2008 08:42 PM

The issue is a mysql issue and not a datastore issue, this can be resolved by your host as they have a small memory limit set for mysql.

If this is a dedicated server / vps, you can modify my.cnf and correct the issue yourself.

LauraS 01-30-2008 08:58 PM

Thanks for the help. What mysql value would it be, though? I've got access to the server itself, but there's numerous memory values I can edit, I'm not a mysql expert.

snakes1100 01-30-2008 10:11 PM

It should be a memory option listed under the [client] section.


All times are GMT. The time now is 01:09 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.01116 seconds
  • Memory Usage 1,709KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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