I'm unable to upgrade due to a database error. The exact error is displayed below.
1. All plugins are globally off in config.php. They're also off manually.
2. I also added the following to my config.php file as per another thread suggestion.
ini_set('memory_limit', -1);
ini_set("max_execution_time", "2880");
Environment:
Web Server Apache v2.2.16
PHP 5.3.3
MySQL Version 5.0.45
I just noticed that in my admincp and in the footer of my forum the vBulletin version is displayed as 4.1.2. So I guess part of the upgrade has completed but not all of it. How do I figure out where the system failed?
There aren't any errors in my php_error.log or my general apache error log or mysql error log so I'm not sure how to track down this problem.
The status of the upgrade fails right after the dialog box says "processing XML step 2 of 6"
Then it says Status: Aborted
The "show details" button doesn't reveal any information, just a blank section.
The following error is displayed on page.
##############################
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 fieldname, varname, text
FROM phrase
WHERE languageid IN(-1,0) AND
fieldname IN ();
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4]]></error>
<error_html><![CDATA[<p>Database error in vBulletin 4.1.2</p>
<p>Invalid SQL:
SELECT fieldname, varname, text
FROM phrase
WHERE languageid IN(-1,0) AND
fieldname IN ();<p>
<p>
<strong>MySQL Error</strong> : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4<br />
<strong>Error Number</strong> : 1064<br />
<strong>Request Date</strong> : Sunday, February 20th 2011 @ 09:11:11 PM<br />
<strong>Error Date</strong> : Sunday, February 20th 2011 @ 09:11:13 PM<br />
<strong>Script</strong> : http://xxx.com/install/upgrade.php<br />
<strong>Referrer</strong> : http://xxx.com/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database<br />
<strong>MySQL Version</strong> : 5.0.45-log<br />
</p>]]></error_html>
</errors>
1. All plugins are globally off in config.php. They're also off manually.
2. I also added the following to my config.php file as per another thread suggestion.
ini_set('memory_limit', -1);
ini_set("max_execution_time", "2880");
Environment:
Web Server Apache v2.2.16
PHP 5.3.3
MySQL Version 5.0.45
I just noticed that in my admincp and in the footer of my forum the vBulletin version is displayed as 4.1.2. So I guess part of the upgrade has completed but not all of it. How do I figure out where the system failed?
There aren't any errors in my php_error.log or my general apache error log or mysql error log so I'm not sure how to track down this problem.
The status of the upgrade fails right after the dialog box says "processing XML step 2 of 6"
Then it says Status: Aborted
The "show details" button doesn't reveal any information, just a blank section.
The following error is displayed on page.
##############################
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 fieldname, varname, text
FROM phrase
WHERE languageid IN(-1,0) AND
fieldname IN ();
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4]]></error>
<error_html><![CDATA[<p>Database error in vBulletin 4.1.2</p>
<p>Invalid SQL:
SELECT fieldname, varname, text
FROM phrase
WHERE languageid IN(-1,0) AND
fieldname IN ();<p>
<p>
<strong>MySQL Error</strong> : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 4<br />
<strong>Error Number</strong> : 1064<br />
<strong>Request Date</strong> : Sunday, February 20th 2011 @ 09:11:11 PM<br />
<strong>Error Date</strong> : Sunday, February 20th 2011 @ 09:11:13 PM<br />
<strong>Script</strong> : http://xxx.com/install/upgrade.php<br />
<strong>Referrer</strong> : http://xxx.com/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database<br />
<strong>MySQL Version</strong> : 5.0.45-log<br />
</p>]]></error_html>
</errors>
Comment