Back In Stock Notifications

[Sudakoma]

Great looking mod Conor, as usual, however im having trouble with it. Ive copied all the files over and ran the sql and it is showing up under 'configuration' and also 'catalogue' in Admin. The only problem is, the option to enable it is not there, so it doesn't work!

I have double checked to make sure all the files were uploaded and they are there. Any ideas?

[conor]

Hi,

Great looking mod Conor, as usual, however im having trouble with it.

Thanks... I'm sorry to hear that though - thought I'd got all problems covered now! ;)

Ive copied all the files over and ran the sql and it is showing up under 'configuration' and also 'catalogue' in Admin. The only problem is, the option to enable it is not there, so it doesn't work!

It sounds like the entire SQL file wasn't successfully run then. The option to enable the module is inserted by the SQL so if it's not there then the module won't work!

Do you just have a "Configuration Group" for Back In Stock Notifications but no options within that group? Or, if you do have any of the options, what do you have?

If you're missing options then something strange must have happened with the SQL file and it could possibly be run again to see if any errors come up:

Open the SQL file before you run it and uncomment the lines to delete the existing options/group, then run it again.. you shouldn't get any errors. If you do, that would cause the missing options you are talking about!

All the best...

Conor

[Sudakoma]

Hi,



Thanks... I'm sorry to hear that though - thought I'd got all problems covered now! ;)



It sounds like the entire SQL file wasn't successfully run then. The option to enable the module is inserted by the SQL so if it's not there then the module won't work!

Do you just have a "Configuration Group" for Back In Stock Notifications but no options within that group? Or, if you do have any of the options, what do you have?

If you're missing options then something strange must have happened with the SQL file and it could possibly be run again to see if any errors come up:

Open the SQL file before you run it and uncomment the lines to delete the existing options/group, then run it again.. you shouldn't get any errors. If you do, that would cause the missing options you are talking about!

All the best...

Conor

Thanks for the reply. When i open the configuration group for Back In Stock Notifications, there are no options at all, just 3 headings:
Title
Value
Action

I tried running the sql file again after uncommenting the lines to delete the existing options/groups and got the following errors:

14 statements processed.
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot insert configuration_key "" because it already exists
ERROR: Cannot create table back_in_stock_notification_subscriptions because it already exists
Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.

Hope this helps.

[conor]

Hi,

What version of MySQL are you using? It appears to be failing with the usage of the @t4 variable in the SQL.

All the best...

Conor

[Sudakoma]

MySQL 5.0.22

[Sudakoma]

Correction, MySQL client version: 4.1.7

Sorry about that!

[conor]

Hi,

Unfortunately I don't know why it won't work then, that seems like a recent enough version.

The SQL code that is failing was based on code from other modules in the download area.

I'm afraid I'm just going to have to post and ask if anyone has a clue what is going wrong.

In the meantime, you could remove the BISN configuration group from your database replace the @t4 variable with an unused configuration group ID and run the SQL again.

Using a hard-coded ID is guaranteed to work but obviously not the way I wanted to offer!

Sorry I can't be more help than that!

It'll have you working in no time, but that's not the nicest solution!

Here's the code, replace the ID in the five places marked with your ID:

INSERT INTO configuration_group VALUES ('YOURIDHERE', 'Back In Stock Notifications', 'Set Back In Stock Notifications Options', '1', '1');
UPDATE configuration_group SET sort_order = 'YOURIDHERE' WHERE configuration_group_id = 'YOURIDHERE';


INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` ,  `use_function` , `set_function`, `date_added`) 
VALUES ('', 'Enable/Disable Back In Stock Notification', 'BACK_IN_STOCK_NOTIFICATION_ENABLED', '1', 'If enabled, when a customer comes across a product that is out of stock, the customer will be offered the chance to be notified when it is back in stock<br /><br />0 = off <br />1 = on', 'YOURIDHERE', '1', NOW(), NULL, 'zen_cfg_select_option(array(''0'', ''1''), ', NOW());

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added`) 
VALUES ('', 'Send Copy of Back In Stock Notification Subscription E-mails To', 'SEND_EXTRA_BACK_IN_STOCK_NOTIFICATION_SUBSCRIPTION_EMAILS_TO', '', 'Send copy of Back In Stock Notification Subscription e-mails to the following email addresses, in this format: Name 1 <email@address1>, Name 2 <email@address2>', 'YOURIDHERE', '2', NOW(), NOW()
);

All the best...

Conor

[dscott1966]

Yes this is a great mod and it helps out a lot like to say first great job on the mod.

I did see one thing though. I noticed that in the mod when it reaches zero in stock the notification comes up under the out of stock button. but say if it goes backwards say your stock says there is -1 in stock it does not show it is looking at it as if you do have stock.

My question would be how would you go about fixing this so the negitives do not make it look like it is in stock?
If the notfication does not show then how can people know to use it.

Second question in the form the confirm email box has this inside of it {cofnospam} how do i go about getting rid of that or is that normal?

Once again great mod thank you for putting it together.

[conor]

Hi,

Yes this is a great mod and it helps out a lot like to say first great job on the mod.

Thanks, that's always good to hear! :)

I did see one thing though. I noticed that in the mod when it reaches zero in stock the notification comes up under the out of stock button. but say if it goes backwards say your stock says there is -1 in stock it does not show it is looking at it as if you do have stock.

You're right! I'll create a new version which checks for stock less than or equal to zero rather than just 0.

I can release that shortly but in the meantime, if you like, you can change:

$products_quantity == 0 

to

$products_quantity <= 0 

in

\includes\classes\observers\class.back_in_stock_notificationsProductInfo.php

Second question in the form the confirm email box has this inside of it {cofnospam} how do i go about getting rid of that or is that normal?

No, that was a bug in an earlier version. Download 2.2.2 at the following address to fix it:

http://dev.ceon.net/web/zen-cart/bac..._notifications

I guess I must have forgotten to update the download area!

I'll create a 2.2.3 and upload it, probably tomorrow.

All the best...

Conor
Ceon

[conor]

Hi,

Just checked and 2.2.2 is in the download area.

What version were/are you running?

The bug with cofnospam should be fixed in 2.2.1 and up!

All the best...

Conor