Product Type Book (by moku)

[duncanad]

Swas,

I haven't experienced this problem myself but previous posts seem to indicate that the 'glue' that holds the search functions together is the 'publisher' (manufacturer) field. If you haven't entered a publisher against your product it won't appear in your search results.

Regards,

Alan

[mlindi]

Swas: duncanad is correct. You need to have the Publisher set or everything gets boggled for some reason.

duncanad: - love the Ritchie site. Nice look to it.

I have two identical versions of the same project running on two different servers. Neither is accessible to the public, so I can't show them to you. However - one is older and is running PHP v4.3.10 / MySQL v4.0.27-standard, the other is running PHP v4.4.3 / MySQL MySQL v4.1.21-standard. The newer box runs book/author search queries just as fine as you please while the older one sputters and vomits lengthy error messages. Check your Admin>Tools>Server/Version Info.

[Darkwander]

Did you set the Manafacture on the products ?

[mlindi]

Did you set the Manafacture on the products ?

sure did. It is, in fact, a difference between MySQL versions. Not worth mucking with. I should know better - I'm just lazy.

[duncanad]

Mlindi,

Glad you liked the Ritchie website.

The server is running PHP Version: 4.3.11 and MySQL 4.1.16 and I have experienced no problems with moku's contribution. Installed first time and largely fits my requirements.

Has anyone heard from Moku recently? If you're listening Moku - thanks for your good work.

Regards,

Alan

[mlindi]

The server is running PHP Version: 4.3.11 and MySQL 4.1.16 and I have experienced no problems with moku's contribution. Installed first time and largely fits my requirements.

I think that MySQL >v4.1.x should work just fine.

Has anyone heard from Moku recently? If you're listening Moku - thanks for your good work.

echo echo. Great mod, Moku.

where did that boy get to, anyway? He started one of the longest threads here in this forum and then just scampered off into the sunset.

[Darkwander]

There is suppose to be a new site that he is making geeks4you or something, but that is half finished and it hasn't changed much in a few months, still under construction, maybe he is just busy.

[swas]

Hi!

Pardon. Adding to manufacturer to each book it works correctly.

Thank you very much to all

[nigelt74]

Ok I have a problem

I pasted the sql in PHPmyadmin and got the following error message

Error

SQL query:

-- -------
-- Filters
-- -------
INSERT INTO zen_get_terms_to_filter
VALUES (
'book_genre_id'
);

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

which comes from this bit
-- -------
-- Filters
-- -------

INSERT INTO zen_get_terms_to_filter VALUES ('book_genre_id');
INSERT INTO zen_get_terms_to_filter VALUES ('book_type_id');
INSERT INTO zen_get_terms_to_filter VALUES ('book_authors_id');


When i looked at the actual table it had 3 fields in it rather than just one, is it just me having this error or are others having it also

[mlindi]

Ok I have a problem

I pasted the sql in PHPmyadmin and got the following error message

Error

SQL query:

-- -------
-- Filters
-- -------
INSERT INTO zen_get_terms_to_filter
VALUES (
'book_genre_id'
);

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

which comes from this bit
-- -------
-- Filters
-- -------

INSERT INTO zen_get_terms_to_filter VALUES ('book_genre_id');
INSERT INTO zen_get_terms_to_filter VALUES ('book_type_id');
INSERT INTO zen_get_terms_to_filter VALUES ('book_authors_id');


When i looked at the actual table it had 3 fields in it rather than just one, is it just me having this error or are others having it also

This is actually answered back around page 8 or 9 of this thread, so I'll save some typing and point you there.