2008-08-22, 11:56 AM
During the upgrade of a board using pgsql you get the following error:
Possible fix: Replace
Quote:Fatal error: [SQL] [0] ERROR: invalid input syntax for integer: "yes"The query can be found in the file upgrade.php in the lines 717 and 723.
SELECT name,sid FROM mybb_settings WHERE isdefault='1' OR isdefault='yes' in /var/www/testforum.blubotter.org/htdocs/moepforum/inc/db_pgsql.php on line 552
Possible fix: Replace
$query = $db->simple_select("settings", "name,sid", "isdefault='1' OR isdefault='yes'");
while($setting = $db->fetch_array($query))
{
$settings[$setting['sid']] = $setting['name'];
}
$query = $db->simple_select("settinggroups", "name,title,gid", "isdefault='1' OR isdefault='yes'");
with: if($db->type == "mysql" || $db->type == "mysqli")
{
$wheresettings = "isdefault='1' OR isdefault='yes'";
}
else
{
$wheresettings = "isdefault='1'";
}
$query = $db->simple_select("settings", "name,sid", $wheresettings);
while($setting = $db->fetch_array($query))
{
$settings[$setting['sid']] = $setting['name'];
}
$query = $db->simple_select("settinggroups", "name,title,gid", $wheresettings);