I keep getting this error:
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 'TYPE=MyISAM' at line 1
in:
[CREATE TABLE zen_upgrade_exceptions ( upgrade_exception_id smallint(5) NOT NULL auto_increment, sql_file varchar(50) default NULL, reason varchar(200) default NULL, errordate datetime default '0001-01-01 00:00:00', sqlstatement text, PRIMARY KEY (upgrade_exception_id) ) TYPE=MyISAM;]
I am currently running FreeBSD 4.11-STABLE, PHP 5.1.2, and MySQL 5.1.7-beta .
I have tried installing 1.3.0.2, first, then I thought, perhaps, there could be a problem with the latest version, so I attempted to install 1.3.0 and it still created the same error.
Can anyone give me a little direction? :)
Thanks!
Results 1 to 3 of 3
-
28 Jul 2006, 02:14 AM #1
New Zenner
- Join Date
- Jul 2006
- Posts
- 1
- Plugin Contributions
- 0
Zen Cart install problems (MySQL errors)
-
29 Jul 2006, 07:23 AM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 58,459
- Blog Entries
- 3
- Plugin Contributions
- 111
Re: Zen Cart install problems (MySQL errors)
I suspect your problem is MySQL 5.1.x-beta.
It could be that your MySQL settings are set to disallow TYPE=MYISAM table definitions.
Zen Cart isn't fully tested nor certified for MySQL5 at the present time.
Downgrading to MySQL 4 should do away with the reported error..
Zen Cart - putting the dream of business ownership within reach of anyone!
Donations always welcome: www.zen-cart.com/donate
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
30 Jul 2006, 01:55 AM #3
Totally Zenned
- Join Date
- Nov 2004
- Location
- Norfolk, United Kingdom
- Posts
- 3,102
- Plugin Contributions
- 2
Re: Zen Cart install problems (MySQL errors)
I'm not 100% certain on this, but I don't think that it's necessary to speciify MYISAM in the sql file, so you could try doing a find and replace on all instances of TYPE=MYISAM in the installation sql file - and replace with nothing of course.
Downgrading to MySQL 4 would be safer option if it is open to you to do so - as MySQL 5 is not exactly stable (beta release or not).
Vger
Bookmarks