I'm having trouble installing the SQL file because my server is still using MySQL version 5.5, which does not allow the following statement:
Code:
CREATE TABLE links (
`links_id` int(11) NOT NULL auto_increment,
`links_url` varchar(255) default NULL,
`links_reciprocal_url` varchar(255) default NULL,
`links_image_url` varchar(255) default NULL,
`links_contact_name` varchar(64) default NULL,
`links_contact_email` varchar(96) default NULL,
`links_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`links_last_modified` datetime default NULL,
`links_status` tinyint(1) NOT NULL default '1',
`links_clicked` int(11) NOT NULL default '0',
PRIMARY KEY (`links_id`),
KEY `idx_links_date_added` (`links_date_added`)
) TYPE=MyISAM ;
and specifically
Code:
`links_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
.
The error being that the default value is invalid. Apparently in the latest version of MySQL the DATETIME is allowed.
Two recommended workaround are to use TIMESTAMP instead of DATETIME or to add TRIGGERS to the table.
I was able to use
Code:
`links_date_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
but then got errors trying to add a second TIMESTAM field (links_last_modified).
I installed the table WITHOUT the links_date_added field (might not be necessary), but am getting "WARNING: An Error occurred, please refresh the page and try again."
Insights welcome and I will post solution, of course.
Bookmarks