mysql error 1064 ... near 'TYPE=MyISAM'

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.

Back Up First!!

Then in that code try and replace

TYPE=MyISAM

with

ENGINE=MyISAM

If this was working before and the error only appears now then it is most likely due to and update of the MySQL version on the server.

or just remove "TYPE=MyISAM" altogether.. Truthfully it's not needed..

But, the table is already there, it has been for a very long time. It just started not letting me edit permissions for the merchants just a few days ago and everything else works.

maybe if I reupload its files, could be something got corrupted in the move?

I did try to run the sql but it won't let me since the table is there.

DarkAngel:

But, the table is already there, it has been for a very long time. It just started not letting me edit permissions for the merchants just a few days ago and everything else works.

maybe if I reupload its files, could be something got corrupted in the move?

I did try to run the sql but it won't let me since the table is there.
That SQL comes from your custom module.. edit the part of the code which contains that piece of code to remove the offending part and see if that fixes it..

DivaVocals:

That SQL comes from your custom module.. edit the part of the code which contains that piece of code to remove the offending part and see if that fixes it..

I think I did it right but as you can see it doesn't look right and nope still get the error when trying to edit permissions.

[Attachment no longer available]

DarkAngel:

I think I did it right but as you can see it doesn't look right and nope still get the error when trying to edit permissions.

[Attachment no longer available]

Based on what you posted, your custom code appears to attempting to run a "create table" bit of SQL.. You need to use the developers tool kit to figure our what part of your code is attempting to execute this bit of SQL and remove the code that is causing the issue..

ok, will do that later when i get up...been up for 24 hours and now need to sleep before my head falls off...not a pretty sight...LOL