The dreaded 1064 ...help

[oceano]

ZC/135

I'm running into this error after clicking links int he sideboxes for music genre and manufacturers...

Could someone just give a nudge in the right direction - that may be all it takes for me to resolve this.

Warning: constant() [function.constant]: Couldn't find constant in /home/user/public_html/user_DOMAIN/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 music_genre_id = 4' at line 2
in:
[select from where music_genre_id = 4]

Server OS: Linux 2.6.9-42.0.2.ELsmp
Database: MySQL 4.1.21-standard-log
PHP Version: 4.4.4 (Zend: 1.3.0)
HTTP Server: Apache/1.3.37 (Unix)

[Ajeh]

I believe that is covered in the bugfixes for v1.3.5 ...

http://www.zen-cart.com/forum/showthread.php?t=45377

[oceano]

thanks Ajeh, but the phpMyAdmin provides this error upon executing the patch:

Error

SQL query:

ALTER TABLE get_terms_to_filter ADD get_term_table varchar( 64 ) NOT NULL ;

MySQL said: Documentation
#1146 - Table 'MYdatabasename.get_terms_to_filter' doesn't exist

I know it's something I must have done...just need to track it down now.

[oceano]

Well this is bizarre - anyone ?

the phpMyAdmin error mess. is gone - yes!

BUT - REPEATING fresh installs, same 'ol database but these sidebox searches: music genre search and manufacturer search: I've repeated this a few times now - b'gosh...darn! I keep this error mess though the demo store is fine - what could have changed about importing the DBase, not the server either AFIK -

Warning: constant() [function.constant]: Couldn't find constant in /home/user/public_html/user_DOMAIN/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 music_genre_id = 4' at line 2
in:
[select from where music_genre_id = 4]

[oceano]

- well shucks, another obvious fix.

The SQL patch obviously needed my table prefix added. A true-brain-dead-fool when it comes to databases; I fear them so much I have trouble opening my eyes to look them in the face - they're really not so ugly after all.

cheers

[Ajeh]

Thanks for the update ...