Jump to content

sql error on install


Recommended Posts

Hi,


Got db error. I know html but not sql! Does the sql have to be zipped?


Thanks,

duchaine


code:

Error

SQL query:



{{{~~~}}}

CREATE TABLE IF NOT EXISTS `jam_action_commissions` (

`id` int(10) NOT NULL AUTO_INCREMENT,

`status` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',

`type` enum('flat','percent') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'flat',

`action_commission_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

`action_commission_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,

`amount` varchar(25) COLLATE utf8_unicode_ci NOT NULL,

`auto_approve` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

MySQL said: Documentation


#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 '{{{~~~}}}

CREATE TABLE IF NOT EXISTS `jam_action_commissions` (

`id` int(10)' at line 1

code:

Link to post
Share on other sites
  • 4 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...