datastore corruption

[LauraS]

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]

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]

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]

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]

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]

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