64 replies to this topic

[DunWeb]

@Garrigue

Garrigue, on 01 February 2012, 15:06, said:

Hello !
Excuse for my bad english
I have two problems :
Next administration in the "Configuration" menu "new properties" I have menus that are repeated every 2 times:

Display Featured Products
Display Featured Products
Maximum Display of Featured
Maximum Display of Featured
Include Sub Categories When Displaying Featured Products
Include Sub Categories When Displaying Featured Products
Specials Featured Products Only When Displaying
Specials Featured Products Only When Displaying

Next catalog (my shop) I have this message on the homepage and boxes on the side is no longer displayed:

 1054 - Unknown column 's.customers_group_id' in 'field list'

SELECT p.products_id, p.products_image, p.products_tax_class_id, s.customers_group_id, IF (s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, p.products_price, pd.products_name FROM products p LEFT JOIN specials s ON p.products_id = s.products_id LEFT JOIN products_description pd ON p.products_id = pd.products_id AND pd.language_id = '4 'LEFT JOIN featured f ON p.products_id = f.products_id WHERE p.products_status = '1' AND f.status = '1 'AND s.customers_group_id = '0' order by rand (2346) DESC limit 6

Thank you for your help!

Oscommerce v.2.3.1
MySQL: mysqlnd 5.0.8

This is because you ran the SQL twice. You will need to use PHPMYADMIN and delete the duplicate database entries.



Chris

[DunWeb]

@hellboy084,

That is why I suggested a similar contribution that you can refer to.


Chris

[bassmaga]

Quote

Next catalog (my shop) I have this message on the homepage and boxes on the side is no longer displayed:

 1054 - Unknown column 's.customers_group_id' in 'field list'

SELECT p.products_id, p.products_image, p.products_tax_class_id, s.customers_group_id, IF (s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, p.products_price, pd.products_name FROM products p LEFT JOIN specials s ON p.products_id = s.products_id LEFT JOIN products_description pd ON p.products_id = pd.products_id AND pd.language_id = '4 'LEFT JOIN featured f ON p.products_id = f.products_id WHERE p.products_status = '1' AND f.status = '1 'AND s.customers_group_id = '0' order by rand (2346) DESC limit 6

Thank you for your help!

Oscommerce v.2.3.1
MySQL: mysqlnd 5.0.8

if you dont have SPPC module delete 'customers_group_id'.

[Garrigue]

Actually it works!

For duplicates not be found in the database. I searched all over the base! Nothing!
This does not preclude the operation.

Thank you for your help

[trogette]

Hi

I've installed this add-on (*double checks to make sure it's the right version*) and it's working fine, with the odd tweak or two of css and adding a short description, on my home server, but on uploading to the live site the admin page featured.php is giving me a 500 error. I've copied the files across and checked a load of times with Beyond Compare so I'm at a loss as to what the problem is, other than maybe a php or mysql version issue? Also I wondered if anyone had fixed the not displaying specials prices issue?