Request Restock Mod Thread

[yellow1912]

to change the text:
edit: includes/languages/english/your_template/request_restock.php

[boriZ]

thanks

[alanpace]

I installed Request Restock alpha 3.5 about two weeks ago. The drop down menu on the admin/request_restock.php page was and continues to be blank... none of the option values are displayed. It appears that my symptoms are the same as those reported above by 100asa, which appear to have been solved in his case. The screen shot that he posted shows the same problem I'm describing.

After installing the mod, I upgraded both PHP and MySQL from 4 to 5. I'm now running MySQL 5.0.45-community and PHP 5.2.4. After the upgrade, the drop down menu still didn't appear in the admin. I've completely re-installed this mod twice... uploading all the files and dropping/recreating the database tables. The "front end" works fine. The automatic emails are sent when customers request a restock, and their requests are saved in the database. I just don't have a functional admin page. I've tried every suggestion posted in this forum. Unlike asa100, my store is in English. I'd appreciate any suggestions.
Thanks,
Alan

[yellow1912]

For those having such problem, please try this file:
upload it to admin/request_restock.php, overwrite the old file when asked.

[alanpace]

Problem solved.
Thanks!
Alan

[alanpace]

Problem solved.
Thanks!
Alan

I spoke to soon. Using the file you attached, the options are now shown in my drop down menu, but I get this SQL error when I choose the "Send notices to customers" option:

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 '' at line 1
in:
[update products_restock_request_customers r set r.zen_customers_id = (SELECT customers_id from customers c where c.customers_email_address = r.email_address]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Do you know what might cause this?
Thanks,
Alan

[yellow1912]

Try this in your phpmyadmin, let me know if you get the same error:

update products_restock_request_customers r set r.zen_customers_id = (SELECT customers_id from customers c where c.customers_email_address = r.email_address)

PS: If you have prefix for your zen table, you may have to use this:


update zen_products_restock_request_customers r set r.zen_customers_id = (SELECT customers_id from zen_customers c where c.customers_email_address = r.email_address)

// Replace zen_ by your prefix name (if you use a different one)

[alanpace]

Try this in your phpmyadmin, let me know if you get the same error:

update products_restock_request_customers r set r.zen_customers_id = (SELECT customers_id from customers c where c.customers_email_address = r.email_address)

PS: If you have prefix for your zen table, you may have to use this:


update zen_products_restock_request_customers r set r.zen_customers_id = (SELECT customers_id from zen_customers c where c.customers_email_address = r.email_address)

// Replace zen_ by your prefix name (if you use a different one)

I used the first query you suggested since I don't have a table prefix, and got this error:

Unknown column 'r.zen_customers_id' in 'field list'

I then removed the zen_ prefix from zen_customers_id in the query, tried it again and got this error:

#1054 - Unknown column 'r.customers_id' in 'field list'

I checked my products_restock_request_customers table, and there's no customers_id field in the table, although it does have an ID field. I then changed r.customers_id to r.ID and ran the query without an error.

Should the products_restock_request_customers table have a customers_id field? Here's the code from the "new install" SQL packaged with alpha 3.5:

DROP TABLE IF EXISTS products_restock_request_customers;
CREATE TABLE products_restock_request_customers (
  ID int(10) NOT NULL auto_increment,
  name varchar (255) NOT NULL,
  email_address varchar (255) NOT NULL,
  PRIMARY KEY  (ID) 
) ENGINE=MyISAM;

Thanks,
Alan

[yellow1912]

Im looking at the sql query closely this time, there is something weird here:

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 '' at line 1
in:
[update products_restock_request_customers r set r.zen_customers_id = (SELECT customers_id from customers c where c.customers_email_address = r.email_address]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Where did you download this version? Did you download it from download section here?
Because I re-downloaded this version from download section and can not find this line of code anywhere.

[alanpace]

Im looking at the sql query closely this time, there is something weird here:


Where did you download this version? Did you download it from download section here?
Because I re-downloaded this version from download section and can not find this line of code anywhere.

Thank you for getting back to me so fast... I was already typing a message to tell you to ignore that last post. I re-uploaded all the files and I'm not getting the error anymore. Over the last week or so, I've tried every hot fix and code update posted in this forum, so I managed to revert some of the code back to where it was at the time the fix was posted... and then I forgot I'd made the changes. Hopefully I've got it working now...
Thanks,
Alan