Request Restock Mod Thread

[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

[yellow1912]

Glad we found the cause. Please let me know if there is still any error.

[alanpace]

Glad we found the cause. Please let me know if there is still any error.

Thank you very much for your help, yellow1912. I've tested all the functions and everything is working properly. :-)
Alan

[vivaraquel]

Hi and thank you for this mod, I am hoping it will be good for my business.

I have just installed it, made sure I changed the TEST folders to my custom template name.

The link to RESTOCK REQUESTS is available in my admin area under the CATALOG tab. When I clicked it I got this error message:
1146 Table 'easybead_zc1.zen_products_restock_request_records' doesn't exist
in:
[select count(*) as total from zen_products_restock_request_records r,zen_products_description d WHERE r.request_status = 0 and d.products_id = r.product_id]
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.

I then went to my PhP MyAdmin on my sever and there is no table named zen_products_restock_request_records. Do I have to create that myself?

Also, there is no REQUEST RESTOCK button visible at all in the product info page. See here: http://easybeading.com.au/index.php?...products_id=18

I'm not sure if that is supposed to be turned on somewehre in admin or if it not curretnly available due to the error.

Thank you again.

[vivaraquel]

Before anyone replies, and in case I am supposed to create my own table in PhP MyAdmin, what values do I enter for the table?

Thanks,
Raquel.

[yellow1912]

Did you run the sql patch that goes with the package?