16 replies to this topic

[ianhaney]

Hi

Can anyone please recommend a good shop by price add on for oscommerce 2.3.1 please

Thank you

Ian

[tmckee]

I am looking for the same thing.

[toyicebear]

Here is one for 2.2 , it can be modified to use with 2.3

[tikkoss]

can someone teach me how to use this addson on 2.3? i tried this http://addons.oscommerce.com/info/8297 but somehow it shows error.

What I did is, I added few lines in myphpadmin as per shop_by_price.sql
and copied all the files in catalog files and modified catalog/includes/filenames.php as well as per instruction

The error as below:

Fatal error: require() [function.require]: Failed opening required 'includes/languages/english/FILENAME_SHOP_BY_PRICE' (include_path='.:/usr/local/lib/php') in catalog/includes/modules/boxes/bm_shop_by_price.php on line 15

perhaps anyone have any clue how to modified the one that Nick suggest to use with 2.3?
I am a noob in php and html.. advice is very much appreciated..

TikkoSS
www.tikkoss.com

Edited by tikkoss, 08 January 2012, 12:00.

[germ]

The error indicates your catalog/includes/filenames.php hasn't beeb modified despite what you may think.

[linjong]

Hi TikoSS,

I'm not sure that you should have added anything to your database even though the SQL file was included in the download. The instructions did not mention that this needed to be done. That said, I tried to install the contribution without the database addition and get exactly the same errors you have. I think that there is an error in the downloaded files somewhere.

I hope that the author of the contribution will know what went wrong, but I will try and fix this and if I can I'll post the fix here.

[tikkoss]

Hi Jim, I have looked into the /filename.php and I have inputted as per the instructions. However, I still encounter the same problems.

Isa, thanks for trying out .. this time i did not try include the sql but still encountering the same problems. I am trying to rectify it at the moment. Will keep you posted if it works..

Thanks all..

TikkoSS
www.tikkoss.com

[RickyPoon]

Inside the admin boxes install page...i get this error

Warning: require(includes/languages/english/FILENAME_SHOP_BY_PRICE) [function.require]: failed to open stream: No such file or directory in /home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php on line 15

Warning: require(includes/languages/english/FILENAME_SHOP_BY_PRICE) [function.require]: failed to open stream: No such file or directory in /home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php on line 15

Fatal error: require() [function.require]: Failed opening required 'includes/languages/english/FILENAME_SHOP_BY_PRICE' (include_path='.:/usr/lib/php:/usr/local/lib/php') in/home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php on line 15

[RickyPoon]

Warning: include() [function.include]: Unable to access /home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php in /home/perpet19/public_html/savoircouture/moesc/modules.php on line 129

Warning: include(/home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php) [function.include]: failed to open stream: No such file or directory in /home/perpet19/public_html/savoircouture/moesc/modules.php on line 129

Warning: include() [function.include]: Unable to access /home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php in /home/perpet19/public_html/savoircouture/moesc/modules.php on line 129

Warning: include(/home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php) [function.include]: failed to open stream: No such file or directory in /home/perpet19/public_html/savoircouture/moesc/modules.php on line 129

Warning: include() [function.include]: Failed opening '/home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in/home/perpet19/public_html/savoircouture/moesc/modules.php on line 129

Warning: require(includes/languages/english/FILENAME_SHOP_BY_PRICE) [function.require]: failed to open stream: No such file or directory in /home/perpet19/public_html/savoircouture/includes/modules/boxes/bm_shop_by_price.php on line 15

Warning: require(includes/languages/english/FILENAME_SHOP_BY_PRICE) [function.require]: failed to open stream: No such file or directory in /home/perpet19/public_html/savoircouture/includes/modules/boxes/bm_shop_by_price.php on line 15

Fatal error: require() [function.require]: Failed opening required 'includes/languages/english/FILENAME_SHOP_BY_PRICE' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/perpet19/public_html/savoircouture/includes/modules/boxes/bm_shop_by_price.php on line 15

[DunWeb]

Ricky,

You have to upload the files to the correct directories.


Chris

[adgvast]

I guess this module is missing something in the installation pack,
I tried to follow the instruction, but some error as above,
i looked into the code, i found it is missing some language file which related when adding the module in the admin page.
i tried to remove the line 15 (which is point to load the language file), then i can install the module in the admin section.

but another problem came out.
After activitied the module, and return to the store, some error is displayed which is related to the database.
it forced me to deactivited the module to make the store work again.

btw, how to unistall the SQL staffs that goes to the database if i wanted to remove the module totally,

thanks
Alex

[chrish123]

The author has packaged it wrong and missed some language code, I have it working fine, I commented out in catalog/includes/modules/boxes/bm_shop_by_price.php:

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_SHOP_BY_PRICE);

to look like:

//require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_SHOP_BY_PRICE);

and then created another file of the same name in catalog/includes/languages/english/modules/boxes/bm_shop_by_price.php containing this code:

<?php
/*
  $Id$
  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com
  Copyright (c) 2010 osCommerce
  Released under the GNU General Public License
*/
  define('MODULE_BOXES_SHOP_BY_PRICE', 'Shop By Price');
  define('MODULE_BOXES_SHOP_BY_PRICE_DESCRIPTION', 'Shop By Price');
  define('MODULE_BOXES_SHOP_BY_PRICE_BOX_TITLE', 'Shop By Price');
  define('BOX_HEADING_SHOP_BY_PRICE', 'Shop By Price');
?>

Remember box modules within osC 2.3.1 generally have their language files like above with the same name in the corresponding modukles/boxes folder, not stored in the languages/english/ folder

Another pain in this addon that will eventually need rewriting is that you need to change the database price ranges via phpmyadmin and also the price ranges present in the catalog/includes/modules/boxes/bm_shop_by_price.php too! Bad.. bad!

[lblanks240]

after i installed this contrubution i got the error

1146 - Table 'divinefa_osc23.TABLE_PRICE_RANGES' doesn't exist

select price_range_id, price_range_values from TABLE_PRICE_RANGES order by price_range_values

[TEP STOP]

how do i fix this the table is in the data base

thanks
lenard

[germ]

Normally UPPERCASE_ERRORS_LIKE_THAT mean you are missing a define in a php file.

My guess is you didn't edit/upload your /includes/database_tables.php file to include the define for TABLE_PRICE_RANGES

[Sars]

yep followed instructions Exactly as stated in the readme and also getting :


Warning: include() [function.include]: Unable to access /home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php in /home/perpet19/public_html/savoircouture/moesc/modules.php on line 129

Warning: include(/home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php) [function.include]: failed to open stream: No such file or directory in /home/perpet19/public_html/savoircouture/moesc/modules.php on line 129

Warning: include() [function.include]: Unable to access /home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php in /home/perpet19/public_html/savoircouture/moesc/modules.php on line 129

Warning: include(/home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php) [function.include]: failed to open stream: No such file or directory in /home/perpet19/public_html/savoircouture/moesc/modules.php on line 129

Warning: include() [function.include]: Failed opening '/home/perpet19/public_html/savoircouture/includes/languages/english/modules/boxes/bm_shop_by_price.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in/home/perpet19/public_html/savoircouture/moesc/modules.php on line 129

Warning: require(includes/languages/english/FILENAME_SHOP_BY_PRICE) [function.require]: failed to open stream: No such file or directory in /home/perpet19/public_html/savoircouture/includes/modules/boxes/bm_shop_by_price.php on line 15

Warning: require(includes/languages/english/FILENAME_SHOP_BY_PRICE) [function.require]: failed to open stream: No such file or directory in /home/perpet19/public_html/savoircouture/includes/modules/boxes/bm_shop_by_price.php on line 15

Fatal error: require() [function.require]: Failed opening required 'includes/languages/english/FILENAME_SHOP_BY_PRICE' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/perpet19/public_html/savoircouture/includes/modules/boxes/bm_shop_by_price.php on line 15



would it be to much to ask for the author to repack and redocument this addon.

[veego]

Hi Everyone,

I just download and install this addon and get all the same error as you guys. But now I fixed them all. All solution are came from this support thread. And I just put everything together, Please follow below info to fixed your error and I hope I didn't miss anythings. 3 step to solve error from original Addon file.

1) On admin page, you install the modules and will get this error,

Fatal error: require() [function.require]: Failed opening required 'catalog/includes/languages/english/FILENAME_SHOP_BY_PRICE' (include_path='.:/usr/local/lib/php') in catalog/includes/modules/boxes/bm_shop_by_price.php on line 15

To fix it, open catalog/includes/modules/boxes/bm_shop_by_price.php and remove the following line

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_SHOP_BY_PRICE);

2) When you finish installed, and go to your online store, you will get the following error

1146 - Table 'mysql.table_price_ranges' doesn't exist

select price_range_id, price_range_values from TABLE_PRICE_RANGES order by price_range_values

To fix it, open catalog/includes/datebase_tables.php and add the following before the last ?>

//Start - Shop by price
define('TABLE_PRICE_RANGES', 'price_ranges');
//End - Shop by price

3) Finally, you will have another error something like this

Warning: include(includes/languages/english/modules/boxes/bm_shop_by_price.php) [function.include]: failed to open stream: No such file or directory inC:\xampp\htdocs\includes\classes\osc_template.php on line 86

Warning: include() [function.include]: Failed opening 'includes/languages/english/modules/boxes/bm_shop_by_price.php' for inclusion (include_path='.;C:\xampp\php\PEAR') inC:\xampp\htdocs\includes\classes\osc_template.php on line 86

This is because the author haven't attached one file called bm_shop_by_price.php

To fix it, please create a file called bm_shop_by_price.php by notepad or any editor you are using, and save it into

catalog/includes/languages/english/modules/boxes/

place the following line into your new created file bm_shop_by_price.php

<?php
/* $Id$ osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com Copyright © 2010 osCommerce
Released under the GNU General Public License
*/
define('MODULE_BOXES_SHOP_BY_PRICE', 'Shop By Price');
define('MODULE_BOXES_SHOP_BY_PRICE_DESCRIPTION', 'Shop By Price');
define('MODULE_BOXES_SHOP_BY_PRICE_BOX_TITLE', 'Shop By Price');
define('BOX_HEADING_SHOP_BY_PRICE', 'Shop By Price');
define('NAVBAR_TITLE', 'Shop by Price');
// the following $range references come from catalog/shop_by_price.php
?>

That is it, Enjoy!!

Edited by veego, 05 May 2012, 08:02.

[veego]

Hi All,

When playing this addon, i found that the shop_by_price page has a back button at the bottom left of the page, and will redirect you to Advance page when you click on it. It seem non-sense for me, so I just change the redirect location of the file and make the back bottom redirect you to the default page. which is https://www.yourdomain.com/

open catalog/shop_by_price.php

Search
<?php echo tep_draw_button(IMAGE_BUTTON_BACK, 'triangle-1-w', tep_href_link(FILENAME_ADVANCED_SEARCH, tep_get_all_get_params(array('sort', 'page')), 'NONSSL', true, false)); ?>

And replace by
<?php echo tep_draw_button(IMAGE_BUTTON_BACK, 'triangle-1-w', tep_href_link(FILENAME_DEFAULT, tep_get_all_get_params(array('sort', 'page')), 'NONSSL', true, false)); ?>

Enjoy.

Edited by veego, 05 May 2012, 08:54.