Jump to content
Jack_mcs

Daily Specials

Recommended Posts

Hi there,
 
Need some help please.
 
My OSC: osCommerce 2.3.4 on xampp with MySQL 5.5.32  + PHP 5.5.6 
 
I have copied the daily_specials_install.php into my root shop directory. When I execute the file, I get this error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where customers_group_id in(1,1)' at line 24

CREATE TABLE daily_specials ( unique_id int NOT NULL auto_increment, special_name varchar (64) DEFAULT '' NOT NULL, page_type TINYINT (4) DEFAULT '0' NOT NULL, page_text TEXT NOT NULL default '', popup_text TEXT NOT NULL default '', alt_text varchar (128) NOT NULL default '', image varchar(64) NOT NULL default '', categories text NOT NULL default '', pages text NOT NULL default '', products_list text NOT NULL default '', condition1 varchar(32) NOT NULL default '0', condition2 varchar(32) NOT NULL default '0', condition3 varchar(32) NOT NULL default '0', coupon_amount varchar(16) NOT NULL default '', date_start datetime NOT NULL, date_stop datetime NOT NULL, recur_days varchar (3) DEFAULT '0' NOT NULL, recur_mode TINYINT (1) DEFAULT '0' NOT NULL, test_mode TINYINT (1) DEFAULT '0' NOT NULL, use_css TINYINT (1) DEFAULT '0' NOT NULL, language_id int(11) NOT NULL default '1', index idx_unique_id (unique_id) ) where customers_group_id in(1,1)

[TEP STOP]

Can anyone help?

 

Thanks Amigoo

Share this post


Link to post
Share on other sites

You have an invalid install file since it doesn't contain customers_group_id. Use the one from the addon and it should work.

Share this post


Link to post
Share on other sites

Hi Jack,

 

The addon download includes a directory "Database" where I found the daily_specials_install.php. File is last modified on 2014-06-15. There is anywhere a newer one?

 

Amigoo

Share this post


Link to post
Share on other sites

I just download that package and searched the database file for "customers_group_id" but it isn't in there so I don't know what to tell you. Something is corrupted on your end but I've no way to identify it from here. That field is usually part of the SPPC addon so maybe you've made some change for it. But if you search through the complete Daily Specials package, you won't find mention of that field so the problem isn't with his addon.

Share this post


Link to post
Share on other sites

Yes, you are right. I found the bug. I bought an addon specially fixed for my needs. This addon use customer groups to show/hide products. Sorry to bother you.

 

 

Cheers Amigoo

Share this post


Link to post
Share on other sites

Hello!

I installed this addon on my test site.

I have latest oscommerce installed - 2.3.4.

If I understand right, the problem is in header.php becouse if I follow daily special's installation instructions and add that code in header.php then in product pages doesnt work photo gallery and in product pages (product_info.php) and in other pages doesnt work UI buttons.

How I can resolve that problem. I see addon is great!

Share this post


Link to post
Share on other sites

@@gvv I have it installed in a 2.3.4 shop here and it works fine so I don't know what it might be. You can try using the included header.php file to see if that makes a difference. Or, if it can't be used due to other changes in your shop, use a compare program like WinMerge to compare yours to it.

Share this post


Link to post
Share on other sites

Been testing this for a while now.

 

I notice that if you do not go to your shopping cart, going straight to checkout the daily special will not add the discount.

Anyone same issue and got it resolved?


Getting the Phoenix off the ground

Share this post


Link to post
Share on other sites

I just tried it here and you are correct. I wasn't aware of that problem and don't have a fix for it off the top of my head. You can enable the show cart option to get around it for now. I'll get this fixed though it won't be anytime soon, most likely.

Share this post


Link to post
Share on other sites

Hi there, in instructions for before 2.3 it says make the database changes by uploading the included mysql file, named daily_specials.sql but that file doesn't come in, is correct to use the install document in the folder of Database?

Share this post


Link to post
Share on other sites

That's a mistake. The file existed prior to version 1.6 but was replaced with a php file to make applying the changes easier. Use the daily_specials_install.php in database directory as you mention.

Share this post


Link to post
Share on other sites

The author has reserved space. It is not recommended to install during business.

Share this post


Link to post
Share on other sites
3 hours ago, shore said:

The author has reserved space. It is not recommended to install during business.

Did you mean to ask a question?

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

×