Link Manager 3.0 Support Thread

**clydejones** · 25 Mar 2008, 01:15 AM

Originally Posted by milobloom

Thanks for helping

www.allforyourwedding.com/define_links.rar

Sorry, I don't recognize anything in the file that is remotely connected to Links Manager.

for instance:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>All For Your Wedding - Wedding Supplies & More <?=$_GET['ctl']?> Link Partners</TITLE>
<META NAME="Description" CONTENT="We are a wedding supply's Favors and Accessories company like no other. People ask us special requests all the time! We find the products for them and put them up. You wont believe what we found!

">
<STYLE type="text/css" media="screen">

.link { margin-bottom: 3px; margin-top: 3px;}

.cattable { width: 700px; border:1px solid black; }

.linktable { width: 700px; border:1px solid black; }

.catcell { border:1px solid black; text-align: center; }

.keywordsearch { font-size:9pt; font-family: arial, helvetica, sans-serif; }

.navlinks { color: blue; font-family: arial, helvetica, sans-serif;}

.topnavlinks { color: blue; font-family: arial, helvetica, sans-serif;}

.submitsearch { font-size:9pt; font-family:verdana, arial, helvetica, sans-serif; }

.url { font-weight: bold; font-family: arial, helvetica, sans-serif; font-size:10pt; color: blue;}

.catlink { font-weight: bold; color: blue; font-family:verdana, arial, helvetica, sans-serif; font-size:10pt; }

.description { font-size:10pt; color: black; margin-bottom: 5px; font-family: arial, helvetica, sans-serif; margin-top: 5px; }

.title { color: blue; margin-bottom: 5px; font-weight: bold; font-size:10pt; font-family:arial, helvetica, sans-serif; margin-top: 5px;}

.topnav { text-align: left; color: black; margin-top: 5px; font-family: arial, helvetica, sans-serif; margin-bottom: 5px; font-size:10pt;}

.navigationtext { font-size:10pt; margin-bottom: 5px; color: black; font-family: arial, helvetica, sans-serif; margin-top: 5px; text-align: center;}

</STYLE>
</HEAD>
<BODY>

Then there are the "GL" variables and the other php code.

None of this is related to Links Manager.

**milobloom** · 25 Mar 2008, 03:32 AM

I tried to re-install...

Some more errors...

From main page, View All Links ->

Warning: Division by zero in /home/noah/public_html/includes/templates/zencart_zen/templates/tpl_links_default.php on line 37

Warning: Division by zero in /home/noah/public_html/includes/templates/zencart_zen/templates/tpl_links_default.php on line 39

Warning: Division by zero in /home/noah/public_html/includes/templates/zencart_zen/templates/tpl_links_default.php on line 39

Then there is a box that I can click on for Zen cart development.

Then I get:

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 '' at line 1
in:
[select count(l.links_id) as total from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '1'order by ]

**clydejones** · 25 Mar 2008, 03:59 AM

Originally Posted by milobloom

I tried to re-install...

Some more errors...

From main page, View All Links ->

Then there is a box that I can click on for Zen cart development.

Then I get:

try this - just unzip the file and upload the entire includes folder to your server.

Attachment 3637

**milobloom** · 25 Mar 2008, 04:36 AM

Oh I was getting so hopefull...

No Change...

Part that puzzles me is the 2nd one

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 '' at line 1
in:
[select count(l.links_id) as total from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '1'order by ]

**clydejones** · 25 Mar 2008, 05:13 AM

Originally Posted by milobloom

Oh I was getting so hopefull...

No Change...

Part that puzzles me is the 2nd one

what are the settings you have in admin -> configuration -> links manager

Number of Link Categories Per Row - Default is 3

Select Links Sort Order

**milobloom** · 25 Mar 2008, 07:29 PM

Probably getting somewhere here.

I do not have any options in Link Manager

Just the heading

Title Value Action

With nothing listed underneath it.

**clydejones** · 25 Mar 2008, 07:43 PM

Originally Posted by milobloom

Probably getting somewhere here.

I do not have any options in Link Manager

Just the heading

Title Value Action

With nothing listed underneath it.

copy and paste the following sql statement into admin -> tools -> install sql patches and click the send button

Code:

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id)
FROM configuration_group
WHERE configuration_group_title= 'Links Manager'
LIMIT 1;

DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_LINKS_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration_group VALUES (NULL, 'Links Manager', 'Links Display Settings', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO `configuration` VALUES (NULL, 'Links Box - Display View All Links', 'BOX_DISPLAY_VIEW_ALL_LINKS', 'true', 'Display View All Links on Links Sidebox', @configuration_group_id, 1, NULL, now(), NULL, 'zen_cfg_select_option(array(NULL, ''true'', ''false''), '), (NULL, 'Links Box - Display Submit Link', 'BOX_DISPLAY_SUBMIT_LINK', 'true', 'Display Submit Link on Sidebox', @configuration_group_id, 2, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Display Description As Link', 'DISPLAY_LINK_DESCRIPTION_AS_LINK', 'false', 'Display the links description as a link', @configuration_group_id, 3, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Enable Click Count', 'ENABLE_LINKS_COUNT', 'true', 'Enable links click count.', @configuration_group_id, 4, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Submit Link - Require Reciprocal Page', 'SUBMIT_LINK_REQUIRE_RECIPROCAL', 'true', 'Require Reciprocal Page on Links Submit', @configuration_group_id, 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Display Link Banner Image', 'LINK_LIST_IMAGE', '1', 'Do you want to display the Link Banner Image?', @configuration_group_id, 6, NULL, now(), NULL, NULL), (NULL, 'Display Link Description', 'LINK_LIST_DESCRIPTION', '2', 'Do you want to display the Link Description?', @configuration_group_id, 7, NULL, now(), NULL, NULL), (NULL, 'Display Link Click Count', 'LINK_LIST_COUNT', '3', 'Do you want to display the Link Click Count?', @configuration_group_id, 8, NULL, now(), NULL, NULL), (NULL, 'Link Title Minimum Length', 'ENTRY_LINKS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @configuration_group_id, 9, NULL, now(), NULL, NULL), (NULL, 'Link URL Minimum Length', 'ENTRY_LINKS_URL_MIN_LENGTH', '10', 'Minimum length of link URL.', @configuration_group_id, 10, NULL, now(), NULL, NULL), (NULL, 'Link Description Minimum Length', 'ENTRY_LINKS_DESCRIPTION_MIN_LENGTH', '10', 'Minimum length of link description.', @configuration_group_id, 11, NULL, now(), NULL, NULL), (NULL, 'Link Contact Name Minimum Length', 'ENTRY_LINKS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', @configuration_group_id, 12, NULL, now(), NULL, NULL), (NULL, 'Links Check Phrase', 'LINKS_CHECK_PHRASE', 'yoursitename', 'Phrase to look for, when you perform a link check.', @configuration_group_id, 13, NULL, now(), NULL, NULL), (NULL, 'Links List - Scroll Box Size/Style', 'MAX_LINKS_LIST', '3', 'Number of link category names to be displayed in the scroll box window. Setting this to 1 or 0 will display a dropdown list', @configuration_group_id, 14, NULL, now(), NULL, NULL), (NULL, 'Length of Link Categories Name', 'MAX_DISPLAY_LINK_NAME_LEN', '20', 'Used in links box; maximum length of link category name to display. Longer names will be truncated.', @configuration_group_id, 15, NULL, now(), NULL, NULL), (NULL, 'Select Links Sort Order', 'DEFINE_SORT_ORDER', '1', 'Define the sort order of the links<br />1= Sort by Title<br />2= Sort by Date (Newest to Oldest)<br />3= Sort by number of clicks (highest to lowest)', @configuration_group_id, 16, NULL, now(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3''),'), (NULL, 'Number of Link Categories Per Row - Default is 3', 'MAX_LINK_CATEGORIES_ROW', '3', 'Used to display Link Categories per row.<br />Default is 3', @configuration_group_id, 17, NULL, now(), NULL, NULL),  (NULL, 'Link Category Image Directory', 'LINK_CATEGORY_IMAGE_DIRECTORY', 'link_category/', 'Set the Directory for the Category Image', @configuration_group_id, 18, NULL, now(), NULL, NULL), (NULL, 'Image - Link Category Height', 'LINK_CATEGORY_IMAGE_HEIGHT', '80', 'The pixel width of Link Category images', @configuration_group_id, 19, NULL, now(), NULL, NULL), (NULL, 'Image - Link Category Width', 'LINK_CATEGORY_IMAGE_WIDTH', '80', 'The pixel width of Link Category images', @configuration_group_id, 20, NULL, now(), NULL, NULL), (NULL, 'Link Image Directory', 'LINK_IMAGE_DIRECTORY', 'links_image/', 'Set the Directory for the Link Image', @configuration_group_id, 21, NULL, now(), NULL, NULL), (NULL, 'Image - Link Image Width', 'LINK_IMAGE_WIDTH', '150', 'The pixel width of Link images', @configuration_group_id, 22, NULL, now(), NULL, NULL), (NULL, 'Image - Link Image Height', 'LINK_IMAGE_HEIGHT', '30', 'The pixel height of Link images', @configuration_group_id, 23, NULL, now(), NULL, NULL), (NULL, 'Default Link Image', 'DEFAULT_LINK_IMAGE', 'links_default.jpg', 'Set the Default Link Image', @configuration_group_id, 24, NULL, now(), NULL, NULL), (NULL,'Only registered customers may submit a Link', 'REGISTERED_LINK', 'false', 'Only registered customers may submit a Link', @configuration_group_id, 25, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), ;

INSERT INTO `configuration` VALUES (NULL, 'Define Links Status', 'DEFINE_LINKS_STATUS', '1', 'Enable the Defined Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', 25, 999, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');

INSERT INTO `configuration` VALUES (NULL, 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, now(), NULL, 'zen_cfg_textarea_small(');

**milobloom** · 25 Mar 2008, 07:57 PM

Same thing... No Change anywhere...

As stated before... Is it something with my database prefix???

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 '' at line 1
in:
[select count(l.links_id) as total from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '1'order by ]

**clydejones** · 25 Mar 2008, 10:42 PM

Originally Posted by milobloom

Same thing... No Change anywhere...

As stated before... Is it something with my database prefix???

copy and paste the following sql statement into admin -> tools -> install sql patches and click the send button

Code:

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` 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',
  `links_rating` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`links_id`),
  KEY `idx_links_date_added` (`links_date_added`)
) TYPE=MyISAM ;

INSERT INTO `links` VALUES (1, 'http://mysticmountainnaturals.com/testsite', 'http://mysticmountainnaturals.com/testsite', '', 'Clyde Jones', 'clydejones##########################', now(), NULL, 2, 0, 0);

DROP TABLE IF EXISTS `links_description`;
CREATE TABLE `links_description` (
  `links_id` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '1',
  `links_title` varchar(64) NOT NULL default '',
  `links_description` text,
  PRIMARY KEY  (`links_id`,`language_id`),
  KEY `links_title` (`links_title`)
) ENGINE=MyISAM ;

INSERT INTO `links_description` VALUES (1, 1, 'Clyde\'s Test Site', 'Zen Cart&trade; concepts &amp; modifications');

DROP TABLE IF EXISTS `links_status`;
CREATE TABLE `links_status` (
  `links_status_id` int(11) NOT NULL default '0',
  `language_id` int(11) NOT NULL default '1',
  `links_status_name` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`links_status_id`,`language_id`),
  KEY `idx_links_status_name` (`links_status_name`)
) ENGINE=MyISAM;

INSERT INTO `links_status` VALUES (1, 1, 'Pending');
INSERT INTO `links_status` VALUES (2, 1, 'Approved');
INSERT INTO `links_status` VALUES (3, 1, 'Disabled');

DROP TABLE IF EXISTS `links_to_link_categories`;
CREATE TABLE `links_to_link_categories` (
  `links_id` int(11) NOT NULL auto_increment,
  `link_categories_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`links_id`,`link_categories_id`)
) ENGINE=MyISAM;

INSERT INTO `links_to_link_categories` VALUES (1, 1);

DROP TABLE IF EXISTS `link_categories`;
CREATE TABLE `link_categories` (
  `link_categories_id` int(11) NOT NULL auto_increment,
  `link_categories_image` varchar(64) default NULL,
  `link_categories_sort_order` int(3) default NULL,
  `link_categories_date_added` datetime default NULL,
  `link_categories_last_modified` datetime default NULL,
  `link_categories_status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`link_categories_id`),
  KEY `idx_link_categories_date_added` (`link_categories_date_added`)
) ENGINE=MyISAM;

INSERT INTO `link_categories` VALUES (1, 'zencart.png', 1, now(), NULL, 1);

DROP TABLE IF EXISTS `link_categories_description`;
CREATE TABLE `link_categories_description` (
  `link_categories_id` int(11) NOT NULL default '1',
  `language_id` int(11) NOT NULL default '1',
  `link_categories_name` varchar(40) NOT NULL default '',
  `link_categories_description` text,
  PRIMARY KEY  (`link_categories_id`,`language_id`),
  KEY `idx_link_categories_name` (`link_categories_name`)
) ENGINE=MyISAM;

INSERT INTO `link_categories_description` VALUES (1, 1, 'Zen-Cart Development', '');

**milobloom** · 26 Mar 2008, 01:22 AM

Oh boy....

This site has been revised and updated for years....
I did it again with still no change....

Thread: Link Manager 3.0 Support Thread

Thread Tools

Search Thread

Display

Re: Link Manager 3.0 release

Re: Link Manager 3.0 release

Re: Link Manager 3.0 release

Re: Link Manager 3.0 release

Re: Link Manager 3.0 release

Re: Link Manager 3.0 release

Re: Link Manager 3.0 release

Re: Link Manager 3.0 release

Re: Link Manager 3.0 release

Re: Link Manager 3.0 release

Similar Threads

Testimonial Manager Support Thread

v154 News Box Manager v2.0.0 [Support Thread]

Download File Manager Support Thread

Poll Manager Support Thread

Empty Cart Manager [support thread]

Bookmarks

Bookmarks

Posting Permissions