Jump to content
Jack_mcs

Links Manager II

Recommended Posts

Also,in configuration when I go to links manager II I get this error, something doesnt exist and I have no idea what it might be.

 

1146 - Table 'ajl1266_osc1.link_categories_description' doesn't exist

 

select count(*) as total from link_categories_description where language_id = '1'

 

[TEP STOP]

Share this post


Link to post
Share on other sites
Jack I have come a long way, it is installed, now I am getting an error,I have checked it seems to be ok, maybe you can give me some direction, below is the error code and the php file for that code.

'<a href="' . tep_href_link(FILENAME_LINKS) . '">' . BOX_INFORMATION_LINKS . '</a><br>' . // Links Manager II v1.00 added

Change the above line to the following:
'<a href="' . tep_href_link(FILENAME_LINKS) . '">' . BOX_INFORMATION_LINKS . '</a>'); // Links Manager II v1.00 added

 

Jack

Share this post


Link to post
Share on other sites
Also,in configuration when I go to links manager II I get this error, something doesnt exist and I have no idea what it might be.

 

1146 - Table 'ajl1266_osc1.link_categories_description' doesn't exist

 

select count(*) as total from link_categories_description where language_id = '1'

 

[TEP STOP]

It means that table doesn't exist in your database.

 

Jack

Share this post


Link to post
Share on other sites

I realize that that table is not there, my problem is that it must be in one of the files, I have double checked the files in the download,I have exhausted all energy in trying to find where it can be and still cannot find, I even downloaded links manager again to check those files, I am sure it is looking at me right in the face, maybe you can give me a hint of where I am overlooking.

Share this post


Link to post
Share on other sites
I realize that that table is not there, my problem is that it must be in one of the files, I have double checked the files in the download,I have exhausted all energy in trying to find where it can be and still cannot find, I even downloaded links manager again to check those files, I am sure it is looking at me right in the face, maybe you can give me a hint of where I am overlooking.

the only refrence I can find towards link catagories is step 5 in database_tables.php, I double checked in conTEXT and in site file manager, looks the same maybe you can see something;

 

<?php

/*

$Id: database_tables.php 1739 2007-12-20 00:52:16Z hpdl $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2007 osCommerce

 

Released under the GNU General Public License

*/

 

// define the database table names used in the project

define('TABLE_ADDRESS_BOOK', 'address_book');

define('TABLE_ADDRESS_FORMAT', 'address_format');

define('TABLE_ADMINISTRATORS', 'administrators');

define('TABLE_BANNERS', 'banners');

define('TABLE_BANNERS_HISTORY', 'banners_history');

define('TABLE_CATEGORIES', 'categories');

define('TABLE_CATEGORIES_DESCRIPTION', 'categories_description');

define('TABLE_CONFIGURATION', 'configuration');

define('TABLE_CONFIGURATION_GROUP', 'configuration_group');

define('TABLE_COUNTER', 'counter');

define('TABLE_COUNTER_HISTORY', 'counter_history');

define('TABLE_COUNTRIES', 'countries');

define('TABLE_CURRENCIES', 'currencies');

define('TABLE_CUSTOMERS', 'customers');

define('TABLE_CUSTOMERS_BASKET', 'customers_basket');

define('TABLE_CUSTOMERS_BASKET_ATTRIBUTES', 'customers_basket_attributes');

define('TABLE_CUSTOMERS_INFO', 'customers_info');

define('TABLE_LANGUAGES', 'languages');

define('TABLE_MANUFACTURERS', 'manufacturers');

define('TABLE_MANUFACTURERS_INFO', 'manufacturers_info');

define('TABLE_ORDERS', 'orders');

define('TABLE_ORDERS_PRODUCTS', 'orders_products');

define('TABLE_ORDERS_PRODUCTS_ATTRIBUTES', 'orders_products_attributes');

define('TABLE_ORDERS_PRODUCTS_DOWNLOAD', 'orders_products_download');

define('TABLE_ORDERS_STATUS', 'orders_status');

define('TABLE_ORDERS_STATUS_HISTORY', 'orders_status_history');

define('TABLE_ORDERS_TOTAL', 'orders_total');

define('TABLE_PRODUCTS', 'products');

define('TABLE_PRODUCTS_ATTRIBUTES', 'products_attributes');

define('TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD', 'products_attributes_download');

define('TABLE_PRODUCTS_DESCRIPTION', 'products_description');

define('TABLE_PRODUCTS_NOTIFICATIONS', 'products_notifications');

define('TABLE_PRODUCTS_OPTIONS', 'products_options');

define('TABLE_PRODUCTS_OPTIONS_VALUES', 'products_options_values');

define('TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS', 'products_options_values_to_products_options');

define('TABLE_PRODUCTS_TO_CATEGORIES', 'products_to_categories');

define('TABLE_REVIEWS', 'reviews');

define('TABLE_REVIEWS_DESCRIPTION', 'reviews_description');

define('TABLE_SESSIONS', 'sessions');

define('TABLE_SPECIALS', 'specials');

define('TABLE_TAX_CLASS', 'tax_class');

define('TABLE_TAX_RATES', 'tax_rates');

define('TABLE_GEO_ZONES', 'geo_zones');

define('TABLE_ZONES_TO_GEO_ZONES', 'zones_to_geo_zones');

define('TABLE_WHOS_ONLINE', 'whos_online');

define('TABLE_ZONES', 'zones');

// Links Manager II v1.18 begin

define('TABLE_LINK_CATEGORIES', 'link_categories');

define('TABLE_LINK_CATEGORIES_DESCRIPTION', 'link_categories_description');

define('TABLE_LINKS', 'links');

define('TABLE_LINKS_DESCRIPTION', 'links_description');

define('TABLE_LINKS_TO_LINK_CATEGORIES', 'links_to_link_categories');

define('TABLE_LINKS_FEATURED', 'links_featured');

// Links Manager II v1.18 end

?>

Share this post


Link to post
Share on other sites
I realize that that table is not there, my problem is that it must be in one of the files, I have double checked the files in the download,I have exhausted all energy in trying to find where it can be and still cannot find, I even downloaded links manager again to check those files, I am sure it is looking at me right in the face, maybe you can give me a hint of where I am overlooking.
It's in the links_setup.php file.

 

Jack

Share this post


Link to post
Share on other sites

<?php
/*
 $Id: links_setup.php,v 1.00 2003/10/02 Exp $

 osCommerce, Open Source E-Commerce Solutions
 [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url]

 Copyright © 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 // check if links db already installed
 $links_check_query = tep_db_query("select * from configuration_group where configuration_group_title = 'Links'");

 if (tep_db_num_rows($links_check_query) > 0) {
   echo 'Looks like Links Manager is already installed. Aborting...';
   tep_exit();
 }

 $links_sql_array = array(array("DROP TABLE IF EXISTS link_categories"), 
               array("CREATE TABLE link_categories (link_categories_id int NOT NULL auto_increment, parent_id INT(11) NOT NULL DEFAULT '0', link_categories_image varchar(64), link_categories_sort_order int(3), link_categories_date_added datetime, link_categories_last_modified datetime,  link_categories_status tinyint(1) NOT NULL default '1', PRIMARY KEY (link_categories_id), KEY idx_link_categories_date_added (link_categories_date_added))"), 
               array("DROP TABLE IF EXISTS link_categories_description"), 
               array("CREATE TABLE link_categories_description (link_categories_id int DEFAULT '0' NOT NULL, language_id int DEFAULT '1' NOT NULL, link_categories_name varchar(32) NOT NULL, link_categories_description text, categories_description_subtext LONGTEXT NULL, PRIMARY KEY (link_categories_id, language_id), KEY idx_link_categories_name (link_categories_name))"),
               array("DROP TABLE IF EXISTS links_to_link_categories"),
               array("CREATE TABLE links_to_link_categories (links_id int NOT NULL, link_categories_id int NOT NULL, PRIMARY KEY (links_id,link_categories_id))"),
               array("DROP TABLE IF EXISTS links"),
               array("CREATE TABLE links (links_id int NOT NULL auto_increment, links_url varchar(255), links_reciprocal_url varchar(255), links_reciprocal_disable tinyint(0) NOT NULL, links_reciprocal_check_count tinyint(4) NOT NULL DEFAULT '0', links_image_url varchar(255), links_contact_name varchar(64), links_contact_email varchar(96), links_date_added datetime NOT NULL, links_last_modified datetime, links_status tinyint(1) NOT NULL, links_clicked int NOT NULL default '0', links_category_suggest varchar(32) NULL, links_partner_username varchar(64) NOT NULL DEFAULT '', links_partner_password varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (links_id), KEY idx_links_date_added (links_date_added))"),
               array("DROP TABLE IF EXISTS links_description"),
               array("CREATE TABLE links_description (links_id int NOT NULL auto_increment, language_id int 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))"),
               array("DROP TABLE IF EXISTS links_status"),
               array("CREATE TABLE links_status (links_status_id int DEFAULT '0' NOT NULL, language_id int DEFAULT '1' NOT NULL, links_status_name varchar(32) NOT NULL, PRIMARY KEY (links_status_id, language_id), KEY idx_links_status_name (links_status_name))"),
               array("DROP TABLE IF EXISTS links_featured"),
               array("CREATE TABLE links_featured (links_id int not null auto_increment, date_added datetime , expires_date datetime, links_all_pages TINYINT(1) NOT NULL DEFAULT '0', PRIMARY KEY (links_id))"),
               array("DROP TABLE IF EXISTS links_check"),
               array("CREATE TABLE links_check (links_id int not null auto_increment, date_last_checked datetime , link_found tinyint(1) NOT NULL, PRIMARY KEY (links_id))"));

 $db_error = false;

 // create tables
 foreach ($links_sql_array as $sql_array) {
   foreach ($sql_array as $value) {
     //echo $value . '<br>';
     if (tep_db_query($value) == false) {
       $db_error = true;
     }
   }
 }

 $links_sql_array = array(array("INSERT INTO links_status VALUES ( '1', '1', 'Pending')"),
                    array("INSERT INTO links_status VALUES ( '2', '1', 'Approved')"),
                    array("INSERT INTO links_status VALUES ( '3', '1', 'Disabled')"),
                    array("INSERT INTO links_status VALUES ( '4', '1', 'Waiting')"),

                    array("INSERT INTO links_status VALUES ( '1', '2', 'Pending')"),
                    array("INSERT INTO links_status VALUES ( '2', '2', 'Approved')"),
                    array("INSERT INTO links_status VALUES ( '3', '2', 'Disabled')"),
                    array("INSERT INTO links_status VALUES ( '4', '2', 'Waiting')"),

                    array("INSERT INTO links_status VALUES ( '1', '3', 'Pending')"),
                    array("INSERT INTO links_status VALUES ( '2', '3', 'Approved')"),
                    array("INSERT INTO links_status VALUES ( '3', '3', 'Disabled')"),
                    array("INSERT INTO links_status VALUES ( '4', '3', 'Waiting')"),

                    array("INSERT INTO links_status VALUES ( '1', '4', 'Pending')"),
                    array("INSERT INTO links_status VALUES ( '2', '4', 'Approved')"),
                    array("INSERT INTO links_status VALUES ( '3', '4', 'Disabled')"),
                    array("INSERT INTO links_status VALUES ( '4', '4', 'Waiting')"));

 $db_error = false;

 // create tables
 foreach ($links_sql_array as $sql_array) {
   foreach ($sql_array as $value) {
     if (tep_db_query($value) == false) {
       $db_error = true;
     }
   }
 }

 // create configuration group
 $group_query = "INSERT INTO configuration_group (configuration_group_title, configuration_group_description, sort_order) VALUES ('Links', 'Links Manager configuration options', '99')";

 if (tep_db_query($group_query) == false) {
   $db_error = true;
 }

 $configuration_group_id = tep_db_insert_id();

 // create configuration variables
 $config_sql_array = array(array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('<font color=blue>Click Count</font>', 'ENABLE_LINKS_COUNT', 'False', 'Enable links click count.', '" . $configuration_group_id . "', '1', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('<font color=blue>Spider Friendly Links</font>', 'ENABLE_SPIDER_FRIENDLY_LINKS', 'True', 'Enable spider friendly links (recommended).', '" . $configuration_group_id . "', '2', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=blue>Links Image Width</font>', 'LINKS_IMAGE_WIDTH', '120', 'Maximum width of the links image.', '" . $configuration_group_id . "', '3', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=blue>Links Image Height</font>', 'LINKS_IMAGE_HEIGHT', '60', 'Maximum height of the links image.', '" . $configuration_group_id . "', '4', now())"),

                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=green>Display Link Image</font>', 'LINK_LIST_IMAGE', '1', 'Do you want to display the Link Image?', '" . $configuration_group_id . "', '5', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=green>Display Link URL</font>', 'LINK_LIST_URL', '4', 'Do you want to display the Link URL?', '" . $configuration_group_id . "', '6', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=green>Display Link Title</font>', 'LINK_LIST_TITLE', '2', 'Do you want to display the Link Title?', '" . $configuration_group_id . "', '7', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=green>Display Link Description</font>', 'LINK_LIST_DESCRIPTION', '3', 'Do you want to display the Link Description?', '" . $configuration_group_id . "', '8', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=green>Display Link Click Count</font>', 'LINK_LIST_COUNT', '0', 'Do you want to display the Link Click Count?', '" . $configuration_group_id . "', '9', now())"),

                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=fuchsia>Display English Links</font>', 'LINKS_DISPLAY_ENGLISH', 'True', 'Display links in this language in the shop.', '" . $configuration_group_id . "', '10', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=fuchsia>Display German Links</font>', 'LINKS_DISPLAY_GERMAN', 'False', 'Display links in this language in the shop.', '" . $configuration_group_id . "', '11', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=fuchsia>Display Spanish Links</font>', 'LINKS_DISPLAY_SPANISH', 'False', 'Display links in this language in the shop.', '" . $configuration_group_id . "', '12', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=fuchsia>Display French Links</font>', 'LINKS_DISPLAY_FRENCH', 'False', 'Display links in this language in the shop.', '" . $configuration_group_id . "', '13', now())"),

                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('<font color=Brown>Display Link Title as links</font>', 'TITLES_AS_LINKS', 'False', 'Make the links title a link.', '" . $configuration_group_id . "', '14', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('<font color=Brown>Display Links Category images</font>', 'SHOW_LINKS_CATEGORIES_IMAGE', 'True', 'Display the images for the Links Categories.', '" . $configuration_group_id . "', '15', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('<font color=Brown>Display in standard format</font>', 'LINKS_DISPLAY_FORMAT_STANDARD', 'True', 'Dislay the links in the standard format (true) or in a vertical listing (false).', '" . $configuration_group_id . "', '16', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('<font color=Brown>Display Featured Link</font>', 'LINKS_FEATURED_LINK', 'True', 'Display a randomly selected link.', '" . $configuration_group_id . "', '17', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('<font color=Brown>Display Links in Categories</font>', 'LINKS_SHOW_CATEGORIES', 'True', 'Use categories to show the links. If this is disabled, all links are shown on one page.', '" . $configuration_group_id . "', '18', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('<font color=Brown>Display Link Count in Categories</font>', 'LINKS_SHOW_CATEGORIES_COUNT', 'False', 'Show the number of links in a category.', '" . $configuration_group_id . "', '19', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"),

                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=purple>Link Title Minimum Length</font>', 'ENTRY_LINKS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', '" . $configuration_group_id . "', '20', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=purple>Link URL Minimum Length</font>', 'ENTRY_LINKS_URL_MIN_LENGTH', '10', 'Minimum length of link URL.', '" . $configuration_group_id . "', '21', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=purple>Link Description Minimum Length</font>', 'ENTRY_LINKS_DESCRIPTION_MIN_LENGTH', '10', 'Minimum length of link description.', '" . $configuration_group_id . "', '22', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=purple>Link Description Maximum Length</font>', 'ENTRY_LINKS_DESCRIPTION_MAX_LENGTH', '200', 'Maximum length of link description.', '" . $configuration_group_id . "', '23', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=purple>Link Contact Name Minimum Length</font>', 'ENTRY_LINKS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', '" . $configuration_group_id . "', '24', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('<font color=purple>Link Maximum to Display</font>', 'MAX_LINKS_DISPLAY', '20', 'How many links should be displayed per page?', '" . $configuration_group_id . "', '25', now())"),

                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Links Blacklist', 'LINKS_CHECK_BLACKLIST', '', 'Do not allow links to be submitted if they contain these words. To enter more than one one, use a comma seperator, i.e., bad word a, bad word b.', '" . $configuration_group_id . "', '26', now())"),
                     array("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', '" . $HTTP_SERVER_VARS['SERVER_NAME'] . "', 'Phrase to look for, when you perform a link check. To enter more than one phase, use a comma seperator, i.e., phase a, phase b.', '" . $configuration_group_id . "', '27', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Check Link on Edit', 'LINKS_CHECK_ON_EDIT', 'True', 'Check if a reciprocol link is valid when Edit is clicked. This will slow down the loading of the edit page a little.', '" . $configuration_group_id . "', '28', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Links open in new page', 'LINKS_OPEN_NEW_PAGE', 'True', 'Open links in new page when clicked.', '" . $configuration_group_id . "', '29', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Reciprocal Link required', 'LINKS_RECIPROCAL_REQUIRED', 'True', 'A reciprocal link is required when a link is submitted.', '" . $configuration_group_id . "', '30', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Reciprocal Link Check Count', 'LINKS_RECIPROCAL_CHECK_COUNT', '2', 'How many times a link is checked by the link_check script before it is disabled.', '" . $configuration_group_id . "', '31', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Check for Duplicate Links', 'LINKS_CHECK_DUPLICATE', 'True', 'Check if the submitted link is already on file.', '" . $configuration_group_id . "', '32', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"),
                     array("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Allow Link Editing', 'LINKS_ALLOW_EDITING', 'False', 'Set this option to true to allow link partners to edit their links.', '" . $configuration_group_id . "', '34', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())"));

 foreach ($config_sql_array as $sql_array) {
   foreach ($sql_array as $value) {
     //echo $value . '<br>';
     if (tep_db_query($value) == false) {
       $db_error = true;
     }
   }
 }

?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> 
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
 <tr>
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
   </table></td>
<!-- body_text //-->
   <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
     <tr>
       <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
         <tr>
           <td class="pageHeading"><?php echo 'Links Manager Setup'; ?></td>
         </tr>
       </table></td>
     </tr>
     <tr>
       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
     </tr>
     <tr>
       <td class="main">
<?php
 if ($db_error == false) {
   echo 'Database successfully updated!!!';
 } else {
   echo 'Error encountered during database update.';
 }
?>
       </td>
     </tr>
     <tr>
       <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
     </tr>
   </table></td>
<!-- body_text_eof //-->
   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
   </table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Jack, I have triple checked set up file, I even reloaded links_setup file in another area to try and restart I am at wits end with this, I have links manager file in configuration, also pulls up links, links categories,links contact, links featured, and links satus when I click on them this is what I get; enclosed here will also be set up file maybe you can review;

 

 

1146 - Table 'ajl1266_osc1.link_categories' doesn't exist

 

select c.link_categories_id, cd.link_categories_name, c.parent_id from link_categories c, link_categories_description cd where c.link_categories_id = cd.link_categories_id and cd.language_id = '1' and c.parent_id = '0' order by c.link_categories_sort_order, cd.link_categories_name

 

[TEP STOP]

Share this post


Link to post
Share on other sites

The links_setup file is for setting up the database. It isn't used for anything else. You have to run it in a browser. See the instructions on how to do that.

 

Jack

Share this post


Link to post
Share on other sites

I do not know what happened, but I just did the same thing I have done 20 times and it is now working, WOW, now I am going in to see how she works, thank you for sticking with me.

 

AJ

Share this post


Link to post
Share on other sites

Jack,

Thanks for contribution, it works fine (well it worked up to now :().

I am not sure what hapenned, but I noticed today that it cannot open page with links now. I mean, it opens link.php page fine, search works fine and Submit button works too. But if I click on links category to open it cannot find the page. I tried to create new link category but it does the same with new created link category. I don't know where to look the answer.

Thanks for any help!

Mike


Computers777dotcom

Share this post


Link to post
Share on other sites
Jack,

Thanks for contribution, it works fine (well it worked up to now :().

I am not sure what hapenned, but I noticed today that it cannot open page with links now. I mean, it opens link.php page fine, search works fine and Submit button works too. But if I click on links category to open it cannot find the page. I tried to create new link category but it does the same with new created link category. I don't know where to look the answer.

Thanks for any help!

Mike

Hmm, that's a strange one. I sugguest first checking to see if anything changed on the server - maybe your host upraded something. You could also try running a repair on the database. If everything works in the admin section, then the problem could be in the files in the shop so you could try replacing those to see if it helps.

 

Jack

Share this post


Link to post
Share on other sites
Hmm, that's a strange one. I sugguest first checking to see if anything changed on the server - maybe your host upraded something. You could also try running a repair on the database. If everything works in the admin section, then the problem could be in the files in the shop so you could try replacing those to see if it helps.

 

Jack

 

Thanks!

It's kinda late now, but tomorrow I will check database. Sometimes I backup database, but I never restored it before today. Today I backup and then restored it just to seee how it works. Probably it was restored somehow not that good. I will check table(s) related to link manager if anything OK with the keys.

I'm going to check if MySQL Admin panel has option like repair.

 

Thank you very much!


Computers777dotcom

Share this post


Link to post
Share on other sites

I just updated to the latest Links Manager (1.18) and am having the same problem:

 

404 Not Found error - .../graphic-arts-supply-links-2.html was not found on this server.

 

without search engine friendly urls (I have Ultimate SEO URL's installed) the link would be /links.php?parentid=1&IPath=2

 

I don't really understand how links.php processes these variables, but the end result is a broken link. I have two categories, with category id's 0 and 1. And I have two links, both are in category 1 and are link_id's 2 and 3. I don't have any featured links. I'm using php5.2.4.

 

Anything that you can do to help resolve the issue would be great. Thank you in advance for the help.

 

Tony

Share this post


Link to post
Share on other sites

Are there any compatibility issues with Links Manager and Ultimate SEO URLs ??

 

Im using your latest version of links manager and Ultimate SEO URLs 2.1d Original Updated by FWR Media and I noticed when trying to click on a category of links it'll just revert back to the same page ... looking at the URL it generates:

 

links.php/parentid/0/lPath/1

 

If I change it to links.php?parentid=0&lPath=1 it works fine

Edited by sLaV-

Share this post


Link to post
Share on other sites
I just updated to the latest Links Manager (1.18) and am having the same problem:

 

404 Not Found error - .../graphic-arts-supply-links-2.html was not found on this server.

 

without search engine friendly urls (I have Ultimate SEO URL's installed) the link would be /links.php?parentid=1&IPath=2

 

I don't really understand how links.php processes these variables, but the end result is a broken link. I have two categories, with category id's 0 and 1. And I have two links, both are in category 1 and are link_id's 2 and 3. I don't have any featured links. I'm using php5.2.4.

 

Anything that you can do to help resolve the issue would be great. Thank you in advance for the help.

 

Tony

Not all versions of Ultimate SEO has the code in it to handle Links Manager links. You need version D or E.

 

Jack

Share this post


Link to post
Share on other sites
Are there any compatibility issues with Links Manager and Ultimate SEO URLs ??

 

Im using your latest version of links manager and Ultimate SEO URLs 2.1d Original Updated by FWR Media and I noticed when trying to click on a category of links it'll just revert back to the same page ... looking at the URL it generates:

 

links.php/parentid/0/lPath/1

 

If I change it to links.php?parentid=0&lPath=1 it works fine

No, they work fine together. But neither of the above links are valid Ultimate SEO links so it appears that contribution isn't working correctly.

 

Jack

Share this post


Link to post
Share on other sites

Well, I check database and didn't find anything wrong. Browse all link tables and they look fine.

Just in case repared and optimised it.

In links I have category "links" (I know this is stupid, just didn't have a time to name it right).

 

When SEO URL is OFF, the link to that category is

http://www.computers777.com/links.php?parentid=0&lPath=2

 

When SEO URL is ON, the link to that category is

http://www.computers777.com/links-links-2.html?parentid=0

 

It doesn't work in both cases, with SEO ON and SEO OFF.

 

It gives me Error 404.

I'm on server with PHP Version: 5.2.6 (Zend: 2.2.0) and Database: MySQL 5.0.51a-community.

 

Thanks for any ideas.

 

P.S. I recently installed Who's Online 3.51, but I am not sure if this can be cause of it. :(

Edited by AlwaysNewbie

Computers777dotcom

Share this post


Link to post
Share on other sites

If it fails with Ultimate SEO turned off, then that is not the problem. Be sure you don't have the search engine friendly option turned on in admin->Configuration->My Store. Other than that, I can't think of any reason why it wouldn't work.

 

Jack

Share this post


Link to post
Share on other sites
If it fails with Ultimate SEO turned off, then that is not the problem. Be sure you don't have the search engine friendly option turned on in admin->Configuration->My Store. Other than that, I can't think of any reason why it wouldn't work.

 

Jack

 

No, it is OFF :(

Very strange. Probably I should try to recover some of my last backups and see. I hate to do that :(


Computers777dotcom

Share this post


Link to post
Share on other sites

Last update:

I copied all files right from contribution and error still appear, BUT:

I noticed when I changed option Display Links in Categories to FALSE it starts work fine (not showing link categories page, but all links were there fine!). Probably it will help to find what can be wrong.


Computers777dotcom

Share this post


Link to post
Share on other sites

i had to restore my database and now the links page woont load from my site...says this:

 

1146 - Table 'xxxxxxx.TABLE_LINKS' doesn't exist

 

select l.links_id, l.links_url, l.links_image_url, ld.links_title, ld.links_description, lf.expires_date from TABLE_LINKS l, TABLE_LINKS_DESCRIPTION ld, TABLE_LINKS_FEATURED lf where l.links_id = ld.links_id AND ld.links_id = lf.links_id AND lf.links_all_pages = '1' and (ld.language_id = '1' or ld.language_id = 99) AND lf.expires_date >= now() order by RAND()

 

[TEP STOP]

 

i ran the links_setup file again thinking it would help but it said

 

it looks like links manager is already installed, aborting?

Share this post


Link to post
Share on other sites

The capital letters in the failure indicate the definitions for the database tables are not in the code. Take a look at the includes/database.php file to be sure they are (same with admin/includes/database.php).

 

Jack

Share this post


Link to post
Share on other sites

I am using an old version of Links manager: Links Manager For osC v1 02. It works great excepting one small bug. When I Send Email To one or multiple Link Partners from with the Admin panel, each link partner receives more than 20 duplicate emails. I think it is a bug for Links Manager For OSC v102. Could someone here let me know how I can fix it?

 

I don't plan to upgrade the Links Manager to the most recent version, just wanted to fix the small bug of the version I am using. Thanks in advance for the help.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×