Page 18 of 65 FirstFirst ... 8161718192028 ... LastLast
Results 171 to 180 of 647
  1. #171
    Join Date
    Oct 2005
    Posts
    96
    Plugin Contributions
    0

    database error Re: Product Type Book (by moku)

    I am trying to install the Extended Product Type Book mod on a fresh 1.3.7 installation running MySQL ver. 5.0.27. I've encountered a couple of sql errors that I've been able to resolve, thanks to this thread, but I don't know what to do with this one:

    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 'id'=>'1', 'text'=>'True'), array('id'=>'0', 'text'=>'False')), ', now())' at line 1
    in:
    [INSERT INTO febproduct_type_layout (configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, set_function, date_added) VALUES ('Enable the Book Search', 'SEARCH_PRODUCT_BOOK_ENABLED', '1', 'Add the books to the search engine 0= off 1= on', '7', '0', 'zen_cfg_select_drop_down(array(array('id'=>'1', 'text'=>'True'), array('id'=>'0', 'text'=>'False')), ', now());]

    Any help would be appreciated.

    Thanks

  2. #172
    Join Date
    Oct 2005
    Posts
    96
    Plugin Contributions
    0

    Default Re: Product Type Book (by moku)

    Well, I solved the previous problem by pasting the sql into the box rather than loading the whole file.

    Now things seem to be working until I try to insert a new product. When I click 'preview', all I get is the title. No other info and no 'insert/cancel' buttons.

    Any ideas? Thanks.

  3. #173
    Join Date
    Oct 2005
    Posts
    96
    Plugin Contributions
    0

    database error Re: Product Type Book (by moku)

    I was able to fix the problem in the previous post by removing the UK pricing section from preview_info.php.

    I have changed all book => music_single and author => artist. The tables and fields are renamed and everything appears to me as it should be until I get the the product_info page in the cart. I'm getting this SQL error:

    1146 Table 'feb_mods.TABLE_MUSIC_SINGLE_ARTISTS' doesn't exist
    in:
    [select a.music_single_artists_name from TABLE_MUSIC_SINGLE_ARTISTS a, TABLE_MUSIC_SINGLE_ARTISTS_INFO ad, TABLE_MUSIC_SINGLE_TO_ARTISTS b where b.products_id = '181' and b.music_single_artists_id = a.music_single_artists_id and a.music_single_artists_id = ad.music_single_artists_id and ad.language_id = '1' order by music_single_artists_name]

    The table is there and contains artist info. I was able to add the artist to the product in admin without any trouble. I've searched until I'm cross-eyed and can't find where this error is coming from.

    Anybody have any idea where I could look? Thanks

  4. #174
    Join Date
    Oct 2005
    Posts
    96
    Plugin Contributions
    0

    Default Re: Product Type Book (by moku)

    An update on the last post:

    I've now turned on the Artists (Authors) sidebox and in place of the box, it shows the error mentioned above.

  5. #175
    Join Date
    Oct 2005
    Posts
    96
    Plugin Contributions
    0

    Default Re: Product Type Book (by moku)

    Problem solved. I found one that the authors table name definition had not been changed to artists. Sorry for all the posts.

  6. #176
    Join Date
    Nov 2004
    Location
    U.K. South Wales
    Posts
    501
    Plugin Contributions
    0

    Default Re: Product Type Book (by moku)

    Hi
    Here's my extended book product type version V2, specifically for zencart 1.3.7, some bugs removed compared to the beta 136 version. Hopefully no new bugs created.. copy/paste the sql patch, it seems more reliable.

    Moku might have gone away..but I saw him looking the other day :)

    Info/download at:
    http://www.hareslade.com/zc/index.ph...roducts_id=482

    (hareslade.com/zc/index.php?main_page=document_general_info&cPath=51&products_id=482)

    It incorprates the 3 improved book search filters, and category / alpha search operations. I added the off-site webpage url option (as on other product types) to the book info template.

    If you're running a beta 136 extended version, compare the new fileset and use anything that looks better, remembering there are now some 137 zc files used in this V2 fileset.

    I don't have mysql 5 to test on, so any specific probs on that maybe you could p.m me.

    biscayne? let me know if you succeed in advanced search mods?

  7. #177
    Join Date
    Nov 2004
    Location
    U.K. South Wales
    Posts
    501
    Plugin Contributions
    0

    Default Re: Product Type Book (by moku)

    ...and
    I share a tentative accessory for the above 137 extended book version, that selects some keywords from a list you provide, and also adds another set of constant keywords you also provide.

    This works on books only, (and only where no existing keywords are present for a book) and gets rid of those zc standard keywords - which usually don't relate to books very accurately.

    Currently mystery books in my site (higher in the listing) are activating this add on, as I did not do keywords yet for them. Check out the change-ing html metatag keywords content on
    http://www.hareslade.com/zc/index.ph...roducts_id=215

    A side effect is that crawlers will get 'flavour of the day' keywords which might interest them more than the constant default zencart list.

    download/info at:
    http://www.hareslade.com/zc/index.ph...roducts_id=483

    It probably also works on moku's original version, as it only replaces the metatags.php file and metatags.php defines.

  8. #178
    Join Date
    Oct 2006
    Location
    the Netherlands
    Posts
    32
    Plugin Contributions
    0

    Default Re: Product Type Book (by moku)

    Our book search is finished. But during testing we get an error on advanced search results.
    It's something in the original "from" statement that gives the following error:


    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 zen_products p LEFT JOIN zen_manufacturers m USING ( manufact' at line 1
    in:
    [ FROM zen_products p LEFT JOIN zen_manufacturers m USING ( manufacturers_id ) , zen_products_description pd WHERE p.products_status = 1 AND p.products_id = pd.products_id AND ( p.products_id IN ( SELECT DISTINCT p.products_id ) OR p.products_id IN ( SELECT DISTINCT p.products_id FROM zen_products p LEFT JOIN zen_manufacturers m USING ( manufacturers_id ), zen_products_description pd, zen_categories c, zen_products_to_categories p2c LEFT JOIN zen_meta_tags_products_description mtpd ON mtpd.products_id = p2c.products_id AND mtpd.language_id = 2, zen_product_book_extra pbe, zen_books_to_authors bta, zen_book_authors ba, zen_book_authors_info bai WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 2 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND pbe.products_id = p.products_id AND bta.products_id = p.products_id AND bta.book_authors_id = ba.book_authors_id AND ba.book_authors_id = bai.book_authors_id AND bai.language_id = 2 ) ) limit 0, 9]


    The statement was not modified, just added a condition to check if new book search called the function or the standard.

  9. #179
    Join Date
    Nov 2004
    Location
    U.K. South Wales
    Posts
    501
    Plugin Contributions
    0

    Default Re: Product Type Book (by moku)

    Hi biscayne
    sql a pain, isn't it, I'll pm you in a minute

  10. #180
    Join Date
    Mar 2007
    Posts
    7
    Plugin Contributions
    0

    Default Re: Product Type Book (by moku)

    Quote Originally Posted by biscayne View Post
    Our book search is finished.
    I'm working too on this product type (Hareslade version), it seems really what I was searching for. So thanks Hareslade! =)
    For now I've got no problems on getting it working but a lot of problems on making Zen Cart do what i want...
    Maybe because I'm not a programmer.

    My request is for biscayne.
    Can you share your advanced search modification?
    I'd really like to use it.
    Thanks in advance,
    Colosimo

 

 
Page 18 of 65 FirstFirst ... 8161718192028 ... LastLast

Similar Threads

  1. Using Book Product Type Extra fields (Book DD2)
    By Beau91324 in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 15 Nov 2009, 08:07 PM
  2. Help Product Type Books (by Moku) broken
    By cshart in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 31 Mar 2007, 03:19 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR