Re: Link Manager 3.0 release
Quote:
Originally Posted by
quantum
Hello,
I have installed V3.3.1 of the links manager and have just tried to install the sql patch but get the following error:
Code:
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 '; SELECT @configuration_group_id:=configuration_group_id FROM configuration_g' at line 1
I am using ZenCart V1.3.7.
I have gone through almost all the posts in this thread, and can see similar problems, but not the same one... Any help would be appreciated!
Thanks
Andrew
Try running this:
Just copy and paste into admin -> tools -> install SQL patches and click the send button.
Code:
# Links Manager SQL Install
# For Zen-Cart 1.3.7
# Last Updated: 27/01/2007
# New configuration options are added to the zen_configuration table.
# run this sql patch using the Zen-Cart Sql Patches tool
# (admin -> tools -> install sql patches)
# For best results, cut-and-paste the code into the query field and press 'Send'.
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 Title/Image', 'LINK_LIST_IMAGE', '1', 'Do you want to display the Link Title?', @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, 'Image - Link Category Height', 'LINK_CATEGORY_IMAGE_HEIGHT', '80', 'The pixel width of Link Category images', @configuration_group_id, 18, NULL, now(), NULL, NULL), (NULL, 'Image - Link Category Width', 'LINK_CATEGORY_IMAGE_WIDTH', '80', 'The pixel width of Link Category images', @configuration_group_id, 19, NULL, now(), NULL, NULL), (NULL, 'Image - Link Image Width', 'LINK_IMAGE_WIDTH', '150', 'The pixel width of Link images', @configuration_group_id, 20, NULL, now(), NULL, NULL), (NULL, 'Image - Link Image Height', 'LINK_IMAGE_HEIGHT', '30', 'The pixel height of Link images', @configuration_group_id, 21, 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, 22, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (NULL, 'Link Category Image Directory', 'LINK_CATEGORY_IMAGE_DIRECTORY', 'link_category/', 'Set the Directory for the Category Image', @configuration_group_id, 23, NULL, 'now()', NULL, NULL);
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(');
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™ concepts & 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', '');
Re: Link Manager 3.0 release
Hi Clyde,
Thank you for looking at that, but I still get the same error message. When I add it in, I need to remove the following, otherwise I simply get a 'failed' error message.
# Links Manager SQL Install
# For Zen-Cart 1.3.7
# Last Updated: 27/01/2007
# New configuration options are added to the zen_configuration table.
# run this sql patch using the Zen-Cart Sql Patches tool
# (admin -> tools -> install sql patches)
# For best results, cut-and-paste the code into the query field and press 'Send'.
Re: Link Manager 3.0 release
Quote:
Originally Posted by
quantum
Hi Clyde,
Thank you for looking at that, but I still get the same error message. When I add it in, I need to remove the following, otherwise I simply get a 'failed' error message.
# Links Manager SQL Install
# For Zen-Cart 1.3.7
# Last Updated: 27/01/2007
# New configuration options are added to the zen_configuration table.
# run this sql patch using the Zen-Cart Sql Patches tool
# (admin -> tools -> install sql patches)
# For best results, cut-and-paste the code into the query field and press 'Send'.
What versions of php and mysql are running on your server?
Re: Link Manager 3.0 release
Hi,
MySQL 4.1.22
PHP: 5.0.5
Re: Link Manager 3.0 release
Quote:
Originally Posted by
quantum
Hi,
MySQL 4.1.22
PHP: 5.0.5
Check your PM
Re: Link Manager 3.0 release
Hello, Clyde:
I downloaded your newest link manager and intalled freshly on zencart v.1.3.8. I had the same problem with Wsmith48. In the admin:
Parse error: syntax error, unexpected $end in /home/.nonsense/xxxxxx/xxxxxxxx.com/admin/includes/boxes/extra_boxes/links_extras_dhtml.php on line 17
My Server OS: Linux 2.6.18.1-grsec+e+f6b+gr219+opt+c4a+gr2b-grsec
My PHP Version: 5.2.3 (Zend: 2.2.0)
Why it still doesn't work right?
Lina
Re: Link Manager 3.0 release
Hello, Clyde:
One more small question about link manager.
In the admin, when I want to approve/disable a submitted link, under "Options", I cannot find the drop down menu under "Status". Instead I only see
Status: 1 Required Notify Contact:
Rating: 0 Required
I have to manually type in "2" for approve, or "3" for disable. Is this the new change you made for this new version of link manager?
Lina
Re: Link Manager 3.0 release
Quote:
Originally Posted by
lina0962
Hello, Clyde:
One more small question about link manager.
In the admin, when I want to approve/disable a submitted link, under "Options", I cannot find the drop down menu under "Status". Instead I only see
Status: 1 Required Notify Contact:
Rating: 0 Required
I have to manually type in "2" for approve, or "3" for disable. Is this the new change you made for this new version of link manager?
Lina
This should fix it.
Just unzip the file and upload the entire admin folder to your server.
Attachment 3364
Re: Link Manager 3.0 release
Quote:
Originally Posted by
lina0962
Hello, Clyde:
I downloaded your newest link manager and intalled freshly on zencart v.1.3.8. I had the same problem with Wsmith48. In the admin:
Parse error: syntax error, unexpected $end in /home/.nonsense/xxxxxx/xxxxxxxx.com/admin/includes/boxes/extra_boxes/links_extras_dhtml.php on line 17
My Server OS: Linux 2.6.18.1-grsec+e+f6b+gr219+opt+c4a+gr2b-grsec
My PHP Version: 5.2.3 (Zend: 2.2.0)
Why it still doesn't work right?
Lina
I get this too...
Re: Link Manager 3.0 release
Quote:
Originally Posted by
Doodlebuckets
I get this too...
OK, add a } just above the ?> at the end of the file that you see listed in the error. That fixes it :)
