Upgrade from 1.2.3-DEV to 1.2.8. => dbdown.php

ramchester · Post by **ramchester** » Sat 12. Aug 2006, 09:49

I have a site running version 1.2.3-DEV and tried to upgrade to version 1.2.8, but http://www.myshite.com/setup/upgrade.php jumps right to http://www.myshite.com/dbdown.php.

If I try the normal setup it starts normally, but I haven't tried running it through. According to phpMyAdmin the database is working normally.

Any ideas?

Post by **Oliver Georgi** » Sat 12. Aug 2006, 18:25

wrong db settings.

Oliver

ramchester · Post by **ramchester** » Sat 12. Aug 2006, 19:34

Even though the site runs normally on 1.2.3-DEV?

Post by **flip-flop** » Sat 12. Aug 2006, 19:44

How many tables do you have inside your db? 38?

Knut

ramchester · Post by **ramchester** » Sat 12. Aug 2006, 19:58

Looks like 35...

DeXXus · Post by **DeXXus** » Sat 12. Aug 2006, 22:19

These are the 38:
http://www.phpwcms.de/forum/viewtopic.php?p=68809#68809

You might want to enable all errors, notices and warnings in "php.ini" to see if anything is helpful.

There is a possibility that "upgrade.php" uses the new "dbcon.inc.php" which does a PHP require command of file "default.inc.php" to get the definition for PHPWCMS_ROOT (used as a path constant) and will error out if it is not defined:

"upgrade.php"

Code: Select all

require_once ('../include/inc_lib/default.inc.php');
require_once (PHPWCMS_ROOT.'/include/inc_lib/dbcon.inc.php')

"default.inc.php"

Code: Select all

define ("PHPWCMS_ROOT", 			$phpwcms['DOC_ROOT']);

"dbcon.inc.php"

Code: Select all

// obligate check for phpwcms constants
if (!defined('PHPWCMS_ROOT')) {
   die("You Cannot Access This Script Directly, Have a Nice Day.");
}
// ----------------------------------------------------------------

// build the database table prepend part
define ('DB_PREPEND', $phpwcms["db_prepend"] ? $phpwcms["db_prepend"].'_' : '');

// open the connection to MySQL database
$is_mysql_error = false;

if($phpwcms["db_pers"] == 1) {
	$db = @mysql_pconnect($phpwcms["db_host"], $phpwcms["db_user"], $phpwcms["db_pass"]) or ($is_mysql_error = true);
} else {
	$db = @mysql_connect($phpwcms["db_host"], $phpwcms["db_user"], $phpwcms["db_pass"]) or ($is_mysql_error = true);
}
@mysql_select_db($phpwcms["db_table"], $db) or ($is_mysql_error = true);

if($is_mysql_error) {
	header('Location: '.PHPWCMS_URL.'dbdown.php');
	exit();