Link Manager 2.0f

[yapliren]

I've installed this link manager 2.0f to my zen cart and I found error in admin under extras --> links. It gives this error and I could not get link manager to work.

Fatal error: Cannot use object of type queryFactoryResult as array in /home/caweb/public_html/admin/links.php on line 554

I open up the file links.php and on line 554 it show this
$categories_query = "select lcd.link_categories_name as links_category from " . TABLE_LINKS_TO_LINK_CATEGORIES . " l2lc left join " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd on lcd.link_categories_id = l2lc.link_categories_id where l2lc.links_id = '" . (int)$links['links_id'] . "' and lcd.language_id = '" . $_SESSION['languages_id'] . "'";


Could anyone here please kindly to help me to resolve this problem? I am using zen cart 1.3.6 running on PHP Version: 5.0.5 (Zend: 2.0.5) and MySQL version 4.1.21-standard

Thank you in advance and helps appreciated.

[yapliren]

Found the fix by myself. So I would post this instruction up for people who need it in future. This fix is for php 5

First /admin/links.php
in links.php change the (int)$links['links_id'] to (int)$links->fields['links_id']

Next

in links.php again change all of
$lInfo_array = array_merge($links->fields, $category->fields);
to
$lInfo_array = array_merge((array)$links->fields, (array)$category->fields);



Second /admin/includes/functions/extra_functions/links_manager.php
in links_manager.php file change
($duplicate_image['total'] < 2)
to
($duplicate_image->fields['total'] < 2)

Next

zen_db_input($link_category_image['link_categories_image']
to
zen_db_input($link_category_image->fields['link_categories_image']



That's all for links manager 2.0f to work in php 5

[MB1]

i'm stuck on the database i get the 18 zen_configuration errors when i try to install the patch? any suggestions?

[yapliren]

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)

) TYPE=MyISAM AUTO_INCREMENT=2 ;



INSERT INTO link_categories VALUES (1, 'link_category.jpg', 0, '2004-11-19 18:56:22', '2004-11-19 19:00:19', 1);



DROP TABLE IF EXISTS link_categories_description;

CREATE TABLE link_categories_description (

  `link_categories_id` int(11) NOT NULL default '0',

  `language_id` int(11) NOT NULL default '1',

  `link_categories_name` varchar(32) NOT NULL default '',

  `link_categories_description` text,

  PRIMARY KEY  (`link_categories_id`,`language_id`),

  KEY `idx_link_categories_name` (`link_categories_name`)

) TYPE=MyISAM;



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



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 '0',

  `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 AUTO_INCREMENT=2 ;



INSERT INTO links VALUES (1, 'http://www.xtreme-hosting-inc.com', 'http://www.xtreme-hosting-inc.com', 'http://www.xtreme-hosting-inc.com/images/logo.gif', 'Rob J.', '[email protected]', '2006-09-16 19:03:44', '2006-09-16 19:07:04', 2, 1, 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`)

) TYPE=MyISAM AUTO_INCREMENT=2 ;



INSERT INTO links_description VALUES (1, 1, 'Xtreme-Hosting-Inc.com', 'Zen-Cart customisations & development');



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

) TYPE=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 default '0',

  `link_categories_id` int(11) NOT NULL default '0',

  PRIMARY KEY  (`links_id`,`link_categories_id`)

) TYPE=MyISAM;



INSERT INTO links_to_link_categories VALUES (1, 1);





INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Click Count', 'ENABLE_LINKS_COUNT', 'true', 'Enable links click count.', '26', '1', 'cfg_select_option(array(''true'', ''false''), ', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display Description As Link', 'DISPLAY_LINK_DESCRIPTION_AS_LINK', 'false', 'Display the links description as a link', '26', '1', 'cfg_select_option(array(''true'', ''false''), ', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Submit Link - Require Reciprocal Page', 'SUBMIT_LINK_REQUIRE_RECIPROCAL', 'true', 'Require Reciprocal Page on Links Submit', '26', '1', 'cfg_select_option(array(''true'', ''false''), ', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Links Box - Display Submit Link', 'BOX_DISPLAY_SUBMIT_LINK', 'true', 'Display Submit Link on Sidebox', '26', '1', 'cfg_select_option(array(''true'', ''false''), ', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Links Box - Display View All Links', 'BOX_DISPLAY_VIEW_ALL_LINKS', 'true', 'Display View All Links on Links Sidebox', '26', '1', 'cfg_select_option(array(''true'', ''false''), ', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Links Image Width', 'LINKS_IMAGE_WIDTH', '120', 'Maximum width of the links image.', '26', '3', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Links Image Height', 'LINKS_IMAGE_HEIGHT', '60', 'Maximum height of the links image.', '26', '4', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Link Image & Title', 'LINK_LIST_IMAGE', '1', 'Do you want to display the Link Image and Title?', '26', '5', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Link Description', 'LINK_LIST_DESCRIPTION', '3', 'Do you want to display the Link Description?', '26', '8', now()); 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Display Link Click Count', 'LINK_LIST_COUNT', '5', 'Do you want to display the Link Click Count?', '26', '9', now()); 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Link Title Minimum Length', 'ENTRY_LINKS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', '26', '10', now()); 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Link URL Minimum Length', 'ENTRY_LINKS_URL_MIN_LENGTH', '10', 'Minimum length of link URL.', '26', '11', now()); 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Link Description Minimum Length', 'ENTRY_LINKS_DESCRIPTION_MIN_LENGTH', '10', 'Minimum length of link description.', '26', '12', now()); 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Link Contact Name Minimum Length', 'ENTRY_LINKS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', '26', '13', now()); 

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Links Check Phrase', 'LINKS_CHECK_PHRASE', 'yoursitename', 'Phrase to look for, when you perform a link check.', '26', '14', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('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', '26', '15', now());

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('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.', '26', '16', now());

INSERT INTO configuration_group ( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` )

VALUES ('26', 'Links Manager', 'Links Display Settings', '26' , '1');

load this sql file again and it should solve your problem
hope this helps
the main problem is zen_ value in the table

[MB1]

sweet thank you i think it's going to work like a charm