View Single Post
Old February 3rd, 2011, 04:44 AM   #9 (permalink)
chapsrulez
Member
Verified Customer
 
Join Date: Feb 2004
Posts: 36
HI.

Im having the same problem, i tried to upgrade vbulletin from 3.8 to 4.1 but i recived an error stating that a table called "cache" existed on the server. I ignored the error, and when the vb installer tried to alter the "cache" table i recived the following error.

Quote:
<?xml version="1.0" encoding="windows-1252"?>
<?xml version="1.0" encoding="windows-1252"?>
<errors>
<error><![CDATA[<p>Database Error</p>

Invalid SQL:

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vb_types.types';

Unknown column 'expires' in 'field list']]></error>
<error_html><![CDATA[<p>Database error in vBulletin 3.8.6</p>
<p>Invalid SQL:

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vb_types.types';<p>
<p>
<strong>MySQL Error</strong> : Unknown column 'expires' in 'field list'<br />
<strong>Error Number</strong> : 1054<br />
<strong>Request Date</strong> : Thursday, February 3rd 2011 @ 04:39:29 AM<br />
<strong>Error Date</strong> : Thursday, February 3rd 2011 @ 04:39:29 AM<br />
<strong>Script</strong> : http://vb411.arquipruebas.com/install/upgrade.php<br />
<strong>Referrer</strong> : http://vb411.arquipruebas.com/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database_MySQLi<br />
<strong>MySQL Version</strong> : 5.0.91-community-log<br />
</p>]]></error_html>
</errors>
Im running Photopost 6.22 but when i did the firs installation i didn´t create any table prefix for the photopost tables.

I guess that by changing all photopost tables prefix to something like "photo_tablename" and then modifying my config file the problem will solve, is this correct?

And if so, could you please give the name of all the tables used in 6.22 I have 324 in my mysql database used for vbulletin.

Thanks.
/cas
chapsrulez is offline   Reply With Quote