this is the 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 6
in:
[CREATE TABLE IF NOT EXISTS zen_custom_zen ( id int(11) NOT NULL auto_increment, module varchar(50) NOT NULL default '', version char(10) NOT NULL default '', UNIQUE KEY id (id) ) TYPE=MyISAM]
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.
It is for a paid for module called Private Area which is so my merchants can log into their own area of "admin" then enter the description/price and so forth to their own products while awaiting testing.
I get that error when trying to access the "Edit Permissions" button.
I see from searching that most likely it is due to the Type needing to be changed to Engine but it was functioning perfectly before our move..
If that is what is the problem with this portion of the controls not working anymore--- how does one go about editing only the tables from Type to Engine, this does not seem to affect anywhere that needs permissions changed, only this mod.
Bookmarks