[Forum] Invalid SQL when upgrading to VB 4.1.2.

[Fungsten]

Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?><?xml version="1.0" encoding="windows-1252"?><errors> <error><![CDATA[<p>Database Error</p>Invalid SQL:SELECT c.contenttypeid FROM contenttype c INNER JOIN package AS p ON p.packageid = c.packageid WHERE c.class='Article' AND p.productid = 'vbcms' ;;Table 'xxxxxxxxx.contenttype' doesn't exist]]></error> <error_html><![CDATA[<p>Database error in vBulletin 4.1.1 Alpha 1</p><p>Invalid SQL:SELECT c.contenttypeid FROM contenttype c INNER JOIN package AS p ON p.packageid = c.packageid WHERE c.class='Article' AND p.productid = 'vbcms' ;;<p><p><strong>MySQL Error</strong> : Table 'xxxxxxxxxxx.contenttype' doesn't exist<br /><strong>Error Number</strong> : 1146<br /><strong>Request Date</strong> : Friday, February 11th 2011 @ 06:07:17 PM<br /><strong>Error Date</strong> : Friday, February 11th 2011 @ 06:07:17 PM<br /><strong>Script</strong> : http://www.XXXXXXXXXXX.net/test_vb/f...upgrade.php<br /><strong>Referrer</strong> : http://www.XXXXXXXXXXXXXX.net/test_v...upgrade.php<br /><strong>Classname</strong> : vB_Database<br /><strong>MySQL Version</strong> : 5.0.91-community<br /></p>]]></error_html></errors>

[Steve Machol]

Which version are you upgrading from?

[Fungsten]

Version 4.1.1 Alpha 1

[Steve Machol]

An Alpha to a Beta, and neither officially supported.

This may be a server time and/or memory limit. To increase your limits edit your includes/config.php file and add these lines right under the <?php line:

ini_set('memory_limit', -1);
ini_set("max_execution_time", "2880");

Then try again.

[Fungsten]

An Alpha to a Beta, and neither officially supported.

This may be a server time and/or memory limit. To increase your limits edit your includes/config.php file and add these lines right under the <?php line:

ini_set('memory_limit', -1);
ini_set("max_execution_time", "2880");

Then try again.

Thanks. I'll try it and get back to you.

On Edit:

It's just sitting there after a few minutes at Step 1.

On Edit:

Same error didn't work.

[Steve Machol]

Please report this in the vB4 Bug Tracker here:

http://tracker.vbulletin.com/secure/Dashboard.jspa

[Fungsten]

Please report this in the vB4 Bug Tracker here:

http://tracker.vbulletin.com/secure/Dashboard.jspa

I shall.

[Blindspot]

I had the same problem... Seems only the contenttype.frm existed in the MySql data directory. I deleted the table reference and recreated it from the sql in the install file.

Note: Dont forget to run the insert part on this table or you will get further errors.

[Fungsten]

I had the same problem... Seems only the contenttype.frm existed in the MySql data directory. I deleted the table reference and recreated it from the sql in the install file.

Note: Dont forget to run the insert part on this table or you will get further errors.

How do you delete the table? I don't know that much about sql. And does the installation automatically recreate it?