[dup] Missing code in SQL upgrade script

**JeffD** · 13 Sep 2006, 05:26 PM

After upgrading to 1.3.5 I noticed the below errors in my error log and noticed the advanced search functionality was broken:

Code:

[13-Sep-2006 10:34:44] PHP Warning:  constant() [<a href='function.constant'>function.constant</a>]: Couldn't find constant  in C:\server\shop\includes\init_includes\init_add_crumbs.php on line 45

Looking at the code in init_add_crumbs.php it references fields in the get_terms_to_filter table that are not in the 1.3.02 table yet the sql upgrade script does not add these new fields.

Executing the following in the SQL patch tool seems to have corrected the errors and the problems with advanced search:

Code:

#
# Table structure for table 'get_terms_to_filter'
#
DROP TABLE IF EXISTS get_terms_to_filter;
CREATE TABLE get_terms_to_filter (
  get_term_name varchar(255) NOT NULL default '',
  get_term_table varchar(64) NOT NULL,
  get_term_name_field varchar(64) NOT NULL,
  PRIMARY KEY  (get_term_name)
) TYPE=MyISAM;

#
# Dumping data for table `get_terms_to_filter`
#

INSERT INTO get_terms_to_filter VALUES ('manufacturers_id', 'TABLE_MANUFACTURERS', 'manufacturers_name');
INSERT INTO get_terms_to_filter VALUES ('music_genre_id', 'TABLE_MUSIC_GENRE', 'music_genre_name');
INSERT INTO get_terms_to_filter VALUES ('record_company_id', 'TABLE_RECORD_COMPANY', 'record_company_name');

Hope this helps!
Jeff