Link Manager 3.0 Support Thread

[mutinyzoo]

Page Parameters= gID=41 (your_domain.com/admin/configuration.php?gID=xx <-- type this address into your browser and keep changing the gID number until you find your Links Manager page)

Thank you very much, Moksha and Diva Vocals. A potentially faster way to achieve the above quoted step is to find the id number in the database either using phpAdmin or with the following SQL statement:

SELECT *
FROM `your_zc_database`.`configuration_group`
WHERE (`configuration_group_title` LIKE '%link%')
LIMIT 0 , 30

I wonder what it would take to update the plugin so that it would self-register.

[mutinyzoo]

Also in case it wasn't clear - data that needs to be inserted into the Configuration field includes gID=XX, not just the number.

[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).