Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product Sort V1.3 Problem


steven_cong

Recommended Posts

Hi,I get the following errors when i enter my admin page,category

 

1054 - Unknown column 'p.products_sort_order' in 'field list'

 

select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_sort_order from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name

 

May I know what causes it?

 

and during the modification for admin/categories.php ,i cannot find the step 4 things in my categories.php :

 

4. Approximately at lines 357-372,

 

>>> FIND THIS:

 

if ($action == 'new_product') {

$parameters = array('products_name' => '',

'products_description' => '',

'products_url' => '',

'products_id' => '',

'products_quantity' => '',

'products_model' => '',

'products_image' => '',

'products_price' => '',

'products_weight' => '',

'products_date_added' => '',

'products_last_modified' => '',

'products_date_available' => '',

'products_status' => '',

'products_tax_class_id' => '',

'manufacturers_id' => '');

 

>>> REPLACE THE LAST LINE:

 

'manufacturers_id' => '');

 

>>> WITH THE FOLLOWING 2 LINES:

 

'manufacturers_id' => '',

'products_sort_order' => '' );

 

Where can i find it?

 

Thanks a million...really headache .... don't know how to settle...please help.Thanks

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...