duchaine 0 Posted December 4, 2017 Share Posted December 4, 2017 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: Quote Link to post Share on other sites
forumadmin 0 Posted April 13, 2018 Share Posted April 13, 2018 Hi the sql file should just be uploaded as it is, not zipped up. Quote Free Affiliate Marketing Software Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.