Quote Originally Posted by Centec2b View Post
Good Evening Eric

Thank you for this guidance

I have made progress (some)

It would appear that the folks at MySQL are evolving the language and the term has been replaced by although from what I understand there should be backwards compatibility

However when I had tried several times copying and pasting into the install SQL patches with a copy of a new SQL file and it still failed, I used phpMyAdmin and I installed the SQL instructions with ENGINE substituting for TYPE and it installed ok

On looking at the database entries I noticed several errors where foreign language punctuation had been used and corrected by hand (eg French ç).

I found references to this MySQL language change at

http://www.zen-cart.com/forum/showpo...65&postcount=5

and

http://dev.mysql.com/doc/refman/5.0/...ge-engine.html

The system now shows up in Admin and the only remaining problem is the same as #1593 ie the main page is blank.

I checked the error log as suggested and it is saying


I have checked the file but I am blowed if I can see this error. I have uploaded the file and if anyone can put me right on this I would be grateful.

In conclusion thank you Eric and All for the help and assistance - I wouldn't have got this far by myself
A blank page typically means there is an error in your PHP somewhere. This is most often do to incorrectly copy and pasting the code required to run the module into the templates on your site. To resolve that issue you need to go back and make sure each and every element is copy and pasted exactly as shown and that you did not copy over any other code on your site (which may cause accidental removal of PHP tags that make other portions of your page run.

Another thing to keep in mind. If you tried to install this via PHPMyAdmin then you need to make sure you manually inserted your database prefix (if using any) to each of the commands. When you sue the built in Zen Cart patch tool it automatically does this for you, but with PHPMYAdmin you need to adjust the code to find your correct table prefix.

The file you uploaded looks ok. Make sure you take a look at the html header file as well and ensure you didn't accidentally remove anything there when copying code in.

What version of MySQL are you using? I'm running this (and tested installs on) many many machines with MySQL 5.+ and it goes without flaw each time (no alterations to SQL code etc..., no running through PHPMyAdmin, etc...)