Hello Folks!
I have downloaded ecom_scripts_ex2.zip from http://www.larryullman.com and installed this on my Mac mini server.
The homepage and category page seem to be running fine, but the products page (myserver.local/browse/coffee/Kona/3) shows the error.html message.
According to the book this page is shown when the related db tables aren't populated or if the connecting mysql user does not have EXECUTE permissions.
This does not seem to be the case, because the mysql user is 'root' and has access to everything. Also the DB tables are filled with their regular demo content.
First I thought the problem was with the expired end_date of the sales products, but changing this didn't solve a thing.
By executing the query: CALL `select_products`('coffee', '3') in the mySQL admin I can retreive all the matching rows, so my PROCEDURE should be ok.
At the moment I'm clueless, so I hope someone can lend me a hand on this.
Thanks in advance!
Kind regards,
Jeroen