upgrade errors - need a little help

[ClimberGirl]

I was using preview version 2.1 and decided it was update time... I tried using the update install for 2.2 and it updated my db seemingly without error. When it started to update the admin I got a TON of errors - they seemed location-related, and I tried relocating the files it was looking for with minimal success. I was getting nowhere and then made the decision to manually install the files. The admin is *almost* working... and I'm stuck. I've gotten it down to 1 error and I can't figure out what's wrong. The error is

 

Warning: mysql_connect(): Unknown MySQL Server Host 'http' (0) in /home/group9mo/.panel/web/ecommerce/os/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

My admin/includes/config.php file looks like this:

 

 
define('HTTP_SERVER', 'http://localhost'); 
 define('HTTP_CATALOG_SERVER', 'http://localhost');
 define('HTTPS_CATALOG_SERVER', 'http://localhost');
 define('ENABLE_SSL_CATALOG', 'false'); 
 define('DIR_FS_DOCUMENT_ROOT', '/.panel/ipw-web/ecommerce/os'); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs)
 define('DIR_WS_ADMIN', '/admin/');
 define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN);
 define('DIR_WS_CATALOG', '/catalog/');
 define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);
 define('DIR_WS_IMAGES', 'images/');
 define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
 define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
 define('DIR_WS_INCLUDES', 'includes/');
 define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
 define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');
 define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/');
 define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/');
 define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/');
 define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
 define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/');
 define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/');
 define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/');
 define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

// define our database connection
 define('DB_SERVER', 'http://localhost');
(servername, username, pwd listed next)

 

 

Is there a "map" of what files belong where? I'm certain I've put something in the wrong place.

 

Additionally, I noticed the following in the database:

 

The "products" table column "products_id" is auto_incremented, as expected. Also in the "products_descriptions" table, the column "products_id" is auto_incremented. This can't be since the "products_descriptions" table column "products_id" is a foreign key to the "products" table column "products_id". The diagram that came with the upgrade shows it correctly but the implementation seems incorrect. Am I missing something here?

 

 

TIA for any insight...

-jean :huh: <-- this upgrade is killing me!

[Guest]

Just use:

 

define('DB_SERVER', 'localhost');

 

The auto_increment is ok - it increments concurrently with the products table.

 

Matti

[ClimberGirl]

D'OH! Sometimes, you just have to step away from the forest to see the trees, eh!

 

:P

 

thanks, Matti!