
Originally Posted by
Lopi
Hi,
I have 1.5.5e and if I put sql the error is below.
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 'IF NOT EXISTS TABLE ship2pay ( s2p_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , ' at line 1
in:
[CREATE IF NOT EXISTS TABLE ship2pay ( s2p_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , shipment VARCHAR( 100 ) NOT NULL , payments_allowed VARCHAR( 250 ) NOT NULL , status TINYINT NOT NULL );]
the code should be
Code:
CREATE TABLE IF NOT EXISTS
. I'll update the plugin. Thanks for reporting