sql error on install

Installation and Setup Issues For Affiliate Manager Only
Post Reply
duchaine
Posts: 3
Joined: Mon Dec 04, 2017 7:29 pm

sql error on install

Post by duchaine » Wed Dec 06, 2017 7:54 am

Hi,

Problem uploading sql.

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

Thanks,
duchaine

User avatar
forumadmin
Site Admin
Posts: 400
Joined: Fri Nov 07, 2014 4:50 pm

Re: sql error on install

Post by forumadmin » Fri Apr 13, 2018 1:59 pm

what version of JAM are you trying to install?

Post Reply