[Done v1.3.6] Manufacter's help, other products not showing...

[downautospares]

When i click on 'other products' for the manufacturers, i get this error message below, any ideas?

Warning: constant(): Couldn't find constant in /home/procarst/public_html/shop/includes/init_includes/init_add_crumbs.php on line 45

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 'from where manufacturers_id = 46' at line 2
in:
[select from where manufacturers_id = 46]

[Ajeh]

This is a bug that was fixed in v1.3.6 which we strongly recommend you upgrade to:

http://www.zen-cart.com/forum/showth..._add_crumbs%2A

[downautospares]

USING PHPMYADMIN HOW EXCATLY DO I DO THIS:

Warning: constant(): Couldn't find constant in myroot/includes/init_includes/init_add_crumbs.php on line 45
1064 You have an error in your SQL syntax near 'from where manufacturers_id = 0' at line 2
in:
[select from where manufacturers_id = 0]
SOLUTION:
Upgrade to v1.3.6

Or, if you think you can live without doing a full and proper upgrade, you can try:

Apply the following SQL to your database using SQLPatch or phpMyAdmin:

## Updating table `get_terms_to_filter`#ALTER TABLE get_terms_to_filter ADD get_term_table varchar(64) NOT NULL;ALTER TABLE get_terms_to_filter ADD get_term_name_field varchar(64) NOT NULL;UPDATE get_terms_to_filter SET get_term_table = 'TABLE_MANUFACTURERS', get_term_name_field = 'manufacturers_name' where get_term_name = 'manufacturers_id';UPDATE get_terms_to_filter SET get_term_table = 'TABLE_MUSIC_GENRE', get_term_name_field = 'music_genre_name' where get_term_name = 'music_genre_id';UPDATE get_terms_to_filter SET get_term_table = 'TABLE_RECORD_COMPANY', get_term_name_field = 'record_company_name' where get_term_name = 'record_company_id';


Edit: Moderator added comments in red

[ctcentralinfo]

USING PHPMYADMIN HOW EXCATLY DO I DO THIS:

Warning: constant(): Couldn't find constant in myroot/includes/init_includes/init_add_crumbs.php on line 45
1064 You have an error in your SQL syntax near 'from where manufacturers_id = 0' at line 2
in:
[select from where manufacturers_id = 0]
SOLUTION:
Upgrade to v1.3.6

Or, if you think you can live without doing a full and proper upgrade, you can try:

Apply the following SQL to your database using SQLPatch or phpMyAdmin:

## Updating table `get_terms_to_filter`#ALTER TABLE get_terms_to_filter ADD get_term_table varchar(64) NOT NULL;ALTER TABLE get_terms_to_filter ADD get_term_name_field varchar(64) NOT NULL;UPDATE get_terms_to_filter SET get_term_table = 'TABLE_MANUFACTURERS', get_term_name_field = 'manufacturers_name' where get_term_name = 'manufacturers_id';UPDATE get_terms_to_filter SET get_term_table = 'TABLE_MUSIC_GENRE', get_term_name_field = 'music_genre_name' where get_term_name = 'music_genre_id';UPDATE get_terms_to_filter SET get_term_table = 'TABLE_RECORD_COMPANY', get_term_name_field = 'record_company_name' where get_term_name = 'record_company_id';


Edit: Moderator added comments in red

Will this fix the issue with authors for the books mod?

[DrByte]

Following the example provided, but adapting it for your custom product type should suffice.

[ctcentralinfo]

Following the example provided, but adapting it for your custom product type should suffice.

I used this bit of code:

UPDATE get_terms_to_filter SET get_term_table = 'TABLE_book_authors',get_term_name_field = 'book_authors'where get_term_name = 'book_authors';

But I still get this:

Warning: constant() [function.constant]: Couldn't find constant TABLE_book_authors in /home/sonny1/public_html/includes/init_includes/init_add_crumbs.php on line 45
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 'where book_authors_id = 26' at line 3
in:
[select book_authors_name from where book_authors_id = 26]

[Ajeh]

Check your defines:
TABLE_book_authors

Most all constants are written in all CAPS ...

[ctcentralinfo]

Check your defines:
TABLE_book_authors

Most all constants are written in all CAPS ...

I went to define and found these:

define('TEXT_PRODUCT_BOOK_LISTINGS_ISBN', 'ISBN/Ref.: ');

define('TEXT_PRODUCT_BOOK_FIND_THIS_AUTHOR', 'Find all %s\'s books');
define('TEXT_PRODUCT_BOOK_FIND_THIS_GENRE', 'Show all %s books');
define('TEXT_PRODUCT_BOOK_FIND_THIS_TYPE', 'Show all %s');
define('TEXT_PRODUCT_BOOK_FIND_THIS_PUBLISHER', 'Show all books published by %s');

define('BOX_HEADING_BOOK_AUTHORS', 'Authors');
define('PULL_DOWN_BOOK_AUTHORS', 'Authors...');
define('PULL_DOWN_BOOK_AUTHORS_RESET', '- Reset -');

define('BOX_HEADING_BOOK_GENRES', 'Book Genres');
define('PULL_DOWN_BOOK_GENRES', 'Genres...');
define('PULL_DOWN_BOOK_GENRES_RESET', '- Reset -');

define('BOX_HEADING_BOOK_TYPES', 'Book Types');
define('PULL_DOWN_BOOK_TYPES', 'Types...');
define('PULL_DOWN_BOOK_TYPES_RESET', '- Reset -');
?>

I am not really good with php and I am having a hard time getting it to work. Can anyone help me out?

[DrByte]

Since it's unclear what your database table-prefixes are, if any, try this adjustment to the SQL statement you posted earlier:

UPDATE get_terms_to_filter SET get_term_table = 'book_authors',get_term_name_field = 'book_authors' where get_term_name = 'book_authors';

[ctcentralinfo]

Since it's unclear what your database table-prefixes are, if any, try this adjustment to the SQL statement you posted earlier:

UPDATE get_terms_to_filter SET get_term_table = 'book_authors',get_term_name_field = 'book_authors' where get_term_name = 'book_authors';

Thanks, but it didn't work.


I added this earlier:

UPDATE get_terms_to_filter SET get_term_table = 'TABLE_BOX_HEADING_BOOK_AUTHORS',get_term_name_field = 'Authors'where get_term_name = 'book_authors_id';

And now I get this:

Warning: constant() [function.constant]: Couldn't find constant TABLE_BOX_HEADING_BOOK_AUTHORS in /home/sonny1/public_html/includes/init_includes/init_add_crumbs.php on line 45
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 'where book_authors_id = 25' at line 3
in:
[select book_authors from where book_authors_id = 25]