If this is your first visit, check our documentation. To post, register or login.
Forums / Bug Reports / [Done v1.3.6] Manufacter's help, other products not showing...

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

Locked

Started by downautospares on 6 Nov 2006, 10:38 AM · Views: 4,873

Results 1 to 14 of 14
This thread is locked. New replies are disabled.
6 Nov 2006, 10:38 AM
#1
downautospares avatar

downautospares

New Zenner

Join Date:
Sep 2006
Posts:
2
Plugin Contributions:
0

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

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]

6 Nov 2006, 1:54 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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

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

http://www.zen-cart.com/forum/showthread.php?t=45377&highlight=%2Ainit_add_crumbs%2A

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

29 Nov 2006, 12:50 PM
#3
downautospares avatar

downautospares

New Zenner

Join Date:
Sep 2006
Posts:
2
Plugin Contributions:
0

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

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

17 Dec 2006, 12:04 AM
#4
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

Join Date:
Apr 2005
Posts:
853
Plugin Contributions:
0

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

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

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

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

17 Dec 2006, 3:37 AM
#5
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

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

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

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

17 Dec 2006, 5:27 AM
#6
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

Join Date:
Apr 2005
Posts:
853
Plugin Contributions:
0

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

DrByte:

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]

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

17 Dec 2006, 5:35 AM
#7
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

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

Check your defines:
TABLE_book_authors

Most all constants are written in all CAPS ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

17 Dec 2006, 8:52 PM
#8
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

Join Date:
Apr 2005
Posts:
853
Plugin Contributions:
0

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

Ajeh:

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?

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

17 Dec 2006, 9:08 PM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

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

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

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

17 Dec 2006, 10:08 PM
#10
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

Join Date:
Apr 2005
Posts:
853
Plugin Contributions:
0

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

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


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]

Rich People scream, Wealthy people whisper

https://www.cooltechcentral.com

13 Jul 2007, 10:50 PM
#11
outfitters avatar

outfitters

New Zenner

Join Date:
Jun 2006
Posts:
14
Plugin Contributions:
0

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

I'm having the exact same problem.... I'm using verion 1.3.7

Any other advice?

15 Jul 2007, 3:09 AM
#12
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

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

outfitters:

I'm having the exact same problem....Which "exact same problem" are you referring to?

PLEASE never post saying "exact same problem", since those situations are indeed rare. Instead, post exactly what you are experiencing, in as much detail as possible, with a link to where it can be seen in action, and then maybe we might be able to help you.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

16 Jul 2007, 9:02 AM
#13
outfitters avatar

outfitters

New Zenner

Join Date:
Jun 2006
Posts:
14
Plugin Contributions:
0

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

DrByte:

Which "exact same problem" are you referring to?

PLEASE never post saying "exact same problem", since those situations are indeed rare. Instead, post exactly what you are experiencing, in as much detail as possible, with a link to where it can be seen in action, and then maybe we might be able to help you.

Sorry... I guess what I should have said is that the I am getting the exact same error message when I attempt the perform the same function as stated by the person who started this thread.

That message being: *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]*

The recommendation to fix the problem was to upgrade to 1.3.6, but I am using 1.3.7.

Thanks

16 Jul 2007, 9:36 AM
#14
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

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

outfitters:

The recommendation to fix the problem was to upgrade to 1.3.6, but I am using 1.3.7.Was this a fresh install of v1.3.7, or an upgrade from a prior version? Which version?
What addons/contributions have you installed?
What patches have you applied?
What is the URL where this can be seen in action?
Assuming your site has been upgraded from an older version to the current version, what exact procedure did you use for upgrading?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.