Hi,
I have a db issue:
It’s for a affiliate program… Thanks!!
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