Link Manager 3.0 Support Thread

[mutinyzoo]

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:

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

`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

  `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.

[mutinyzoo]

Okay seems to be working now. The MySQL statement that will not work under MySQL 5.5.x is the CREATE TABLE links statement which I beleve can be replaced with:

DROP TABLE IF EXISTS `links`;
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` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `links_last_modified` TIMESTAMP,
  `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`)
) ENGINE=MyISAM ;

Differences: updated the DATETIME statements to replace with TIMESTAMP and updated TYPE=MyISAM to ENGINE=MyISAM.

TIMESTAMP has some limitations, but they should not be a problem in this application (unless you are still trying to use it in the year 2030).