Jump to content
Latest News: (loading..)
DunWeb

[Contribution] Featured Products for v2.3.x

Recommended Posts

@@builder_bob,

 

It has most of the same features, but is coded to function with v2.2

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

Hi,

 

I would like to know if it is possible to make a SCROLLING FEATURED INFOBOX.

 

Roberto

 

@@hellboy084,

 

Anything is possible.

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

@@hellboy084,

 

You could use the Scrolling Specials contribution as a template to create one for the featured products box.

 

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

I like to install the featured products add-on. I've been browsing the forum for some clues on how to install add-ons, but can't seem to find a guide on how to install add-ons.

Can someone point me to the installation guide on how to install the featured products add-on.

Share this post


Link to post
Share on other sites

I like to install the featured products add-on. I've been browsing the forum for some clues on how to install add-ons, but can't seem to find a guide on how to install add-ons.

Can someone point me to the installation guide on how to install the featured products add-on.

 

Download it and follow the included installation instructions.

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

@@hellboy084,

 

if you are not familiar with coding, you can either just attempt it and ask questions or hire someone to create it for you.

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

@@Garrigue

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


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

@@hellboy084,

 

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

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites
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'.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

Hello

I have installed succesfully the Featured products 2x3x but I am getting a fatal error when I try to install the box module:

Fatal error: Cannot redeclare class bm_featured in /homez.520/fafimagi/www/catalog/includes/modules/boxes/bm_featured.php on line 17

I have installed the latest version of the bm_featured.php. I run the site in french language. Any idea of wht the pbm could be ?

Txs

Share this post


Link to post
Share on other sites

Click the "Cannot redeclare..." link in my signature.

 

It will show you how to find the error.


If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Share this post


Link to post
Share on other sites

Hi,

 

I have just started using specials and found that the specials price does not appear on the home page with featured products displayed but does appear in the featured products list page. Any idea's on how to fix this. From what I have worked out so far the featured_products.php displays ok but the featured.php does not.

 

Thanks

Colin

Edited by cbonnar

Thanks

Colin

Share this post


Link to post
Share on other sites

@@cbonnar

 

It works in every installation I have ever done. Check your code edits.

 

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

Hi, I do hope someone can assist me.

I am "taking over" the development of an OSCommerce 2.3.1 site.

The "home" page is already designed and apparently the intention was to use the "Features Products" contrib. and allow feature featured products on the home page.

Now, I downloaded Featured Products v1.6.5_1.zip. There are installation instructions in the zip file.

Then I found the update for OSC 2.3.1: featured_for_SPPC_fix.zip

Now, I am not certain how/what to install.

I would greatly appreciate help in what I need to add/replace etc to install this contrib on 2.3.1

Thank you greatly in advance.

Share this post


Link to post
Share on other sites

@@svella

 

If you don't have SPPC installed, use the original contribution.

 

 

 

Chris


:|: Was this post helpful ? Click the LIKE THIS button :|:

 

See my Profile to learn more about add ons, templates, support plans and custom coding (click here)

Share this post


Link to post
Share on other sites

Update: after I posted this, checked to insure includes/modules/featured.php *is* present. Where else to look? Please read below.

 

Hi, your assistance would be greatly appreciated:

I have followed all the instructions installed the database table, & run the query.

Now, I have errors on the home page of the site: vellatest.com/isistest;

 

Warning: include(includes/modules/FILENAME_FEATURED) [function.include]: failed to open stream: No such file or directory in /home/selenav/public_html/isistest/index.php on line 265

 

Warning: include(includes/modules/FILENAME_FEATURED) [function.include]: failed to open stream: No such file or directory in /home/selenav/public_html/isistest/index.php on line 265

 

Warning: include() [function.include]: Failed opening 'includes/modules/FILENAME_FEATURED' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/selenav/public_html/isistest/index.php on line 265

 

(It is repeated 3 times on the home page.)

 

I'm going to check this out, I am assuming that I should check index.php & includes/modules/FILENAME_FEATURED' -- but I would *really* appreciate some direction re *where to look* and *for what*. I would not be surprised if something is missing, as there were many files to update/upload. I am fairly new to OS Commerce, and this is one of more complex contribution I've attempted to use.

 

Now: one thing I was NOT able to do per instructions:

I was not able to able to upload include/boxes/featured.php, since in 2.3.1, the directory includes/boxes does not exist.

 

Your assistance is greatly appreciated.

 

Thank you!

Edited by svella

Share this post


Link to post
Share on other sites

Hello again: I am not able to edit my previous post; it seemed I may not have uploaded "includes/application.top"... so I uploaded it to the server.

Please disregard my previous error.

 

So now I have a DIFFERENT error:

 

1146 - Table 'selenav_osc1.TABLE_FEATURED' doesn't exist

 

select featured_id from TABLE_FEATURED where status = '1' and now() >= expires_date and expires_date > 0"

 

Of course, I can access the database, and osc1 DOES have a "featured" table. (I am assuming the table should be named "featured" & not "table_featured")

 

And yes, I did run the sql query script per instructions at the end, after importing the table.

 

If I am able to get some help, that would be fantastic! If can provide further information to allow you to help me, please let me know what that would be...

 

Thanks in advance!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×