Product Type Book (by moku)

I get this error message when I click on author:

Quote:

---

Warning: constant() [function.constant]: Couldn't find constant 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 'from where book_authors_id = 25' at line 2
in:
[select from where book_authors_id = 25]

---

and publisher:

Quote:

---

Warning: constant() [function.constant]: Couldn't find constant 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 'from where manufacturers_id = 2' at line 2
in:
[select from where manufacturers_id = 2]

---

I am using ultimate SEO urls how can I fix this?

I just had this problem the other day... My Ukrainian developer said that it was a problem in one of my database tables, in rough English he said, "There is problem with database content. Missing values in table 'get_terms_to_filter.'"

That's all I know, he fixed it without telling me what he did. :yes: I can ask if you want.

Quote:

---

Originally Posted by MyLibros.com

I just had this problem the other day... My Ukrainian developer said that it was a problem in one of my database tables, in rough English he said, "There is problem with database content. Missing values in table 'get_terms_to_filter.'"

That's all I know, he fixed it without telling me what he did. :yes: I can ask if you want.

---

Thank you, I would apprecaite any help you could provide.

Anyone know waht could be causing the issue I described above?

I don't know if I have the syntax correct, but the problem was that while the 'get_term_name' was filled in for 'book_genre_id' 'book_type_id' and 'book_authors_id', none of the other two fields were filled in.

After a bit of stumbling, I was able to figure out what the values needed to be.

Code:

---

get_term_name        get_term_table        get_term_name_field
manufacturers_id        TABLE_MANUFACTURERS        manufacturers_name
music_genre_id        TABLE_MUSIC_GENRE        music_genre_name
record_company_id        TABLE_RECORD_COMPANY        record_company_name
book_genre_id        TABLE_BOOK_GENRE        book_genre_id
book_type_id        TABLE_BOOK_TYPE        book_type_id
book_authors_id        TABLE_BOOK_AUTHORS        book_authors_name

---

Here are some (untested) SQL statements that should populate those empty fields:

UPDATE zen_get_terms_to_filter SET get_term_table="TABLE_BOOK_GENRE", get_term_name_field="book_genre_id" WHERE get_term_name="book_genre_id";

UPDATE zen_get_terms_to_filter SET get_term_table="TABLE_BOOK_TYPE", get_term_name_field="book_type_id" WHERE get_term_name="book_type_id";

UPDATE zen_get_terms_to_filter SET get_term_table="TABLE_BOOK_AUTHOR", get_term_name_field="book_authors_id" WHERE get_term_name="book_authors_id";

Thanks for the assist, but that did not help. If you click on the author link here:

http://www.books-japan-online.com/pr...roducts_id=448

You get this error message:

Quote:

---

Warning: constant() [function.constant]: Couldn't find constant 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 = 30' at line 3
in:
[select book_authors_id from where book_authors_id = 30]

---

Is Moku still around?

Please if anyone could help I would apprciate it.

Your version of MySQL needs to be >4.1.x.

I had all sorts of issues when running 4.0.27 - as soon as I upgraded all problems went away.

Don't know how MySQL 5.x behaves.

HTH

cheers

Quote:

---

Originally Posted by mlindi

Your version of MySQL needs to be >4.1.x.

I had all sorts of issues when running 4.0.27 - as soon as I upgraded all problems went away.

Don't know how MySQL 5.x behaves.

HTH

cheers

---

My version of MySQL is 4.1.10

From what I can tell, this mod does not include a page to display author info (bio, pic), although it is entered in admin.

Has anyone created an author page they would be willing to share?

Thanks,
Scott

This mod would be perfect if the authors section would work, I mean I followed the instructions to the letter, and it isn't my fault that this mod is not working properly. It would be great if moku was around to look iinto it and fix it, but he hasn't be around in sometime. If I find the solution to this issue I will pass it on.