Tweet
I'm having issues after a crash at my datacentre forced them to rebuild the box i had my forum on.
I can't begin an upgrade from 4.2.2pl2 to 4.2.2pl3 because of errors - example:
..nor does the board function anymore, beyone some of the Admin CP.
We have restored the last .sql dump i had, after all the tables in the DB mysteriously clearing, but checking the DB in cpanel gives plenty of this:
if i try to EMPTY that table (truncate it) in phpMYadmin i'm told it does not exist.
the datacentre has been playing with things for over a week now, and not alot has changed for us, same 'innoDB' nonsense at every turn.
OK, so, my question - let's assume for a moment here that InnoDB is present, that SQL was compiled with it in mind, could a simple corruption of my DB cause SQL to complain like this all the time?
The reason i ask is because i have been pointing out the InnoDB missing stuff for 7 days, and nothing is changing, and i remember about 10 days BEFORE the datacentre had their hardware issue that killed the box seeing some random DB errors on the board that i had never seen before. these were sporadic and uncommon, and i could not repeat them - but they all smacked heavily of damaged storage - i'm thinking my database could have been progressivley corrupting over a period of 14+ days before the box itself finally died.
TIA..
Springer.
I can't begin an upgrade from 4.2.2pl2 to 4.2.2pl3 because of errors - example:
Code:
<?xml version="1.0" encoding="windows-1252"?>
<?xml version="1.0" encoding="windows-1252"?>
<errors>
<error><![CDATA[<p>Database Error</p>
Invalid SQL:
SELECT stylevar.*,
INSTR(',-1,', CONCAT(',', stylevar.styleid, ',') ) AS ordercontrol
FROM stylevar AS stylevar
INNER JOIN stylevardfn AS stylevardfn ON (stylevardfn.stylevarid = stylevar.stylevarid AND product ='vbblog')
WHERE stylevar.styleid IN (-1)
ORDER BY ordercontrol DESC;
Unknown storage engine 'InnoDB']]></error>
<error_html><![CDATA[<p>Database error in vBulletin 4.2.2</p>
<p>Invalid SQL:
SELECT stylevar.*,
INSTR(',-1,', CONCAT(',', stylevar.styleid, ',') ) AS ordercontrol
FROM stylevar AS stylevar
INNER JOIN stylevardfn AS stylevardfn ON (stylevardfn.stylevarid = stylevar.stylevarid AND product ='vbblog')
WHERE stylevar.styleid IN (-1)
ORDER BY ordercontrol DESC;<p>
<p>
<strong>MySQL Error</strong> : Unknown storage engine 'InnoDB'<br />
<strong>Error Number</strong> : 1286<br />
<strong>Request Date</strong> : Saturday, December 20th 2014 @ 02:11:01 PM<br />
<strong>Error Date</strong> : Saturday, December 20th 2014 @ 02:11:01 PM<br />
<strong>Script</strong> : http://***/vbulletin/install/upgrade.php<br />
<strong>Referrer</strong> : http://***/vbulletin/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database<br />
<strong>MySQL Version</strong> : 5.5.40-cll<br />
</p>]]></error_html>
</errors>
We have restored the last .sql dump i had, after all the tables in the DB mysteriously clearing, but checking the DB in cpanel gives plenty of this:
Code:
[***_vb3forum.action] Error: Unknown storage engine 'InnoDB' [***_vb3forum.action] error: Corrupt
the datacentre has been playing with things for over a week now, and not alot has changed for us, same 'innoDB' nonsense at every turn.
OK, so, my question - let's assume for a moment here that InnoDB is present, that SQL was compiled with it in mind, could a simple corruption of my DB cause SQL to complain like this all the time?
The reason i ask is because i have been pointing out the InnoDB missing stuff for 7 days, and nothing is changing, and i remember about 10 days BEFORE the datacentre had their hardware issue that killed the box seeing some random DB errors on the board that i had never seen before. these were sporadic and uncommon, and i could not repeat them - but they all smacked heavily of damaged storage - i'm thinking my database could have been progressivley corrupting over a period of 14+ days before the box itself finally died.
TIA..
Springer.
Comment