Yet Another 1064 error with MySQL

[Guest]

Hello,

 

I've been searching the forums but I can't find how to fix this problem...

I'm trying to install a payment module but, when I click on the "setup" button on the admin side, I'm getting this error:

 

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 '(14) NOT NULL, PRIMARY KEY (id) ' at line 32

CREATE TABLE `payment_logs` ( `id` int NOT NULL auto_increment, `orderID` varchar(30) NOT NULL default '', 
`amount` int(15) NOT NULL default '0', `currency` varchar(3) NOT NULL default '', `language` varchar(5) NOT NULL default '', 
`PM` varchar(25) NOT NULL default '', `BRAND` varchar(25) NOT NULL default '', `CARDNO` varchar(21) NOT NULL default '', 
`Alias` varchar(50) NOT NULL default '', `CN` varchar(35) NOT NULL default '', `ED` varchar(7) NOT NULL default '', 
`ACCEPTANCE` varchar(15) NOT NULL default '', `STATUS` int(2) NOT NULL default '0', `TRXDATE` varchar(32) NOT NULL default '', 
`NCERROR` int(8) NOT NULL default '0', `NCERRORPLUS` varchar(255) NOT NULL default '', `NCSTATUS` varchar(4) NOT NULL default '', 
`CVCCHECK` varchar(2) NOT NULL default '', `AAVCHECK` varchar(2) NOT NULL default '', `ECI` int(1) NOT NULL default '0', 
`VC` varchar(3) NOT NULL default '', `SCORING` varchar(4) NOT NULL default '', `SCO_CATEGORY` varchar(1) NOT NULL default '', 
`PAYID` int(9) NOT NULL default '0', `PAYIDSUB` int(3) NOT NULL default '0', `SHASIGN` varchar(40) NOT NULL default '',
`SESSION_ID` varchar(255) NOT NULL default '', `IP` varchar(32) NOT NULL default '', `IPCTY` varchar(2) NOT NULL default '', 
`CCCTY` varchar(2) NOT NULL default '', `date` timestamp(14) NOT NULL, PRIMARY KEY (id) ) TYPE=MyISAM;

[GemRock]

i did not see any problem with that sql script. what version of mysql are you using? i tried it on mysql v5.0.x and it ran OK - table created w/o error.

Ken

[Guest]

i did not see any problem with that sql script. what version of mysql are you using? i tried it on mysql v5.0.x and it ran OK - table created w/o error.

Ken

I'm using version 5.0.7.

It looks like it's the "timestamp" part that's causing the error...

Could it be that the script is OK but that I got a "corrupted" file? What does that timestamp thing refers to?

[GemRock]

timestamp refers to the data type of the 'date' field/column, which is normal and it shouldnt be a problem. i suggest you run the sql script in phpmyadmin to create the table, and then comment out the sql script in the php file responsible to set up the payment module. that should bypass the error.

Ken