Big Problems with Meta Tags V3.0

[PURAVIDA]

Hy,

 

I install the meta tags V3.0, make all changes in the files, and upload the meta_tag.sql with phpmyadmin on my database, i can see the files there: :blink:

 

 Field  Type Attributes Null Default Extra Action 
  meta_id  int(11)   No    auto_increment              
  categories_id  int(11)   No  0                
  manufacturers_id  int(11)   No  0                
  keywords  varchar(255)   No                  
  description  varchar(255)   No                  
  title  varchar(255)   No                  
Check All  /  Uncheck All     With selected:       



   Indexes : [Documentation]
Keyname Type Cardinality Action Field 
PRIMARY  PRIMARY  0       meta_id  

Create an index on  columns      Space usage : Type Usage 
Data 0 Bytes 
Index 1,024 Bytes 
Total 1,024 Bytes 
  Row Statistic : Statements Value 
Format dynamic  
Rows 0  
Next Autoindex 1  
Creation Aug 06, 2004 at 05:14 AM  
Last update Aug 06,

 

:blink: This was the SQL file :

 

# Table structure for table `meta_tags`

#

 

CREATE TABLE meta_tags (

  meta_id int(11) NOT NULL auto_increment,

  categories_id int(11) NOT NULL default '0',

  manufacturers_id int(11) NOT NULL default '0',

  keywords varchar(255) NOT NULL default '',

  description varchar(255) NOT NULL default '',

  title varchar(255) NOT NULL default '',

  PRIMARY KEY  (meta_id)

) TYPE=MyISAM;

 

And now when i want to save a new Manufacter in my shopadmin / manufacter i get the folowing error:

 

1146 - Table 'db106192781.TABLE_METATAGS' doesn't exist

 

select title, keywords, description from TABLE_METATAGS where manufacturers_id = '13'

 

[TEP STOP]

 

Please HEEEELLLP me out of this problem !!!

I'm new in SQL and PHP so please give me underst?nding instructions! :(

 

I hope of help

PURAVIDA

[Druide]

you need to add the mysql table definition to includes/database_tables.php

 

define('TABLE_METATAGS', 'meta_tags');

 

somewhere b4 the ?>

[PURAVIDA]

Hi,

 

thanks for your reply, i had it include before, please see here my file:

 

  <?php

/*

  $Id: database_tables.php,v 1.1 2003/03/14 02:10:58 hpdl Exp $

 

  osCommerce, Open Source E-Commerce Solutions

  http://www.oscommerce.com

 

  Copyright © 2003 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_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');

// RJW Begin Meta Tags Code

  define('TABLE_METATAGS', 'meta_tags');

// RJW End Meta Tags Code

  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');

 

 

 

?>

 

But still i have the same error!!!

 

do somebody know to help me out of this ???

thanks a lot

PURAVIDA