Datastore problems.... did i screw up?

[BigJohnny]

I was testing out a hack lastnight, vBackup pro or something i think.

Anyway it was for vb 3.0, and i found instructions on making it work with vbulletin 3.5 (which maybe means it will work with 3.6)

anyway, first and foremost, like an idiot i didnt make my database backup BEFORE testing this hack out.


Well upon running the cronjob, i got an error...

REPLACE INTO datastore
(title, data, unserialize)
VALUES
..... Etc.... too many values to list here

MySQL Error  : Table 'datastore' was locked with a READ lock and can't be updated
Error Number : 1099

and this is the error i get when i try to load my site after inserting the data that the above query was trying to insert.



So the probolem is, after this little hitch, my site would no longer load, at all... i just kept getting the following error about something in class_core (was never modified)

Fatal error: Cannot create references to/from string offsets nor overloaded objects in /***/***/***/***/includes/class_core.php on line 1283

So i panicked a little, not sure what to do, i made a backup of my database, and began looking through some others trying to find a soloution.

Note: it seems as if ONLY the datastore tables was affected by this error.

So i came up with the idea to copy another sites datastore table, and see what happened.


Well it worked, my site loaded, but i had there forums and skins list, but had only my skins installed and modded.

Confused again, i tran just about all of the maintanence options and this seems to have now made everything right again.

I have all my forums, my skins to choose from and my posts/threads back.

To me it appears as if everything is working correctly, But i know nothing about the datastore, what it does, how it works etc.
so im kind of just wondering if everything really is ok based on what ive done and what i see now, or if i have possibly screwed something up by doing this, and if so is there anyway to fix it?

[sinisterpain]

you can use the following but I dont believe its the best way

$vbulletin->db->query_write("
REPLACE INTO " . TABLE_PREFIX . "datastore (title, data)
VALUES

[BigJohnny]

i fixed it.....

cant remember how but all is working fine now... no issues.