I'm trying to set up Aznknight's Snitz Link Manager 2 on my site using MySql and am running into the following error when running mod_dbsetup.asp:
CREATE TABLE LINKS( LINK_ID INT (11) DEFAULT '' NOT NULL auto_increment , NAME varchar (100) NULL , URL varchar (100) NULL , KEYWORD varchar (255) NULL , DESCRIPTION varchar (255) NULL , EMAIL varchar (100) NULL , POST_DATE varchar (50) NULL , BANNER_URL varchar (100) NULL , HIT int NULL DEFAULT 0, CATEGORY int NULL , PARENT_ID int NULL , SHOW int NULL , BADLINK int NULL ,KEY LINKS_LINK_ID(LINK_ID))
-2147217911 | [TCX][MyODBC]You have an error in your SQL syntax near 'SHOW int NULL , BADLINK int NULL ,KEY LINKS_LINK_ID(LINK_ID))' at line 1
I've looked thru these forums and mysql documentation, but can't seem to find a workaround.
Can anyone help? Thanks in advance if you can!
dv