Problem with local installation

[sapphal]

Hi

 

I installed XAMPP and copied my live stores catalog folder into xampp/htdocs folder, created a new database and imported the live shops database into it. The problem is that I get the error below when I drill down to a product or product listing. If there are subcategories they are displayed, also if I click on a product in the 'new products for ....' i can view the product details.

 

I have seen posts with a similar problem but not one with a solution. I've downloaded the site twice in case the FTP went corrupt. I've looked in the database and the column products_id is in the products table.

 

1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '79'

 

It's not a critical problem but it would be nice to solve it.

 

Any help would be greatly appreciated.

 

Thanks

 

Howard

[♥Vger]

Check the includes/database_tables.php and admin/includes/database_tables.php files.

 

Vger

[sapphal]

Check the includes/database_tables.php and admin/includes/database_tables.php files.

 

Vger

 

Both the database_tables.php files have the products table defined as below - just the few lines around the define.

 

  define('TABLE_ORDERS_STATUS', 'orders_status');
 define('TABLE_ORDERS_STATUS_HISTORY', 'orders_status_history');
 define('TABLE_ORDERS_TOTAL', 'orders_total');
 define('TABLE_PRODUCTS', 'products');
 define('TABLE_PRODUCTS_ATTRIBUTES', 'products_attributes');
 define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', 'products_attributes_download');

 

I'll delete the database and create a new one to see if that helps.

 

Thanks for your help.

[spax]

This is probably because you have an older version of osC, your host uses MySql 4.* but XAMPP has version 5.*

 

Read this about updating your osC files:

 

http://www.oscommerce.com/ext/update-20051113.html

 

The part about MySQL 5.0 Compatibility will apply to this problem.

 

Note: A new update is available here:

 

http://www.oscommerce.com/solutions/downloads

[sapphal]

This is probably because you have an older version of osC, your host uses MySql 4.* but XAMPP has version 5.*

 

Read this about updating your osC files:

 

http://www.oscommerce.com/ext/update-20051113.html

 

The part about MySQL 5.0 Compatibility will apply to this problem.

 

Note: A new update is available here:

 

http://www.oscommerce.com/solutions/downloads

 

Peter

 

You are spot on.

 

Problem solved

 

Thanks for your help.

 

Howard