Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Join Date
    Mar 2011
    Posts
    6
    Plugin Contributions
    0

    database error Search/Advanced Search not returning results

    Have just had to migrate ZC after a bad hack & at the same time have added the 12leaves business template (recommended).
    We cannot get any results to be returned using either std or advances search.
    Can anyone give any suggestions on where to start looking....
    Site is www.fotoriesel.com/shop

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Search/Advanced Search not returning results

    What you have is a blank page issue

    https://www.zen-cart.com/tutorials/index.php?article=82
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Mar 2011
    Posts
    6
    Plugin Contributions
    0

    Default Re: Search/Advanced Search not returning results

    Please be patient - a PHP newbie.

    One of the debug msgs -

    [07-Mar-2011 05:01:12] PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: open(/home/fotorie/public_html/shop/cache/sess_91aeff7a64de388e0df0d7802639f6d0, O_RDWR) failed: No such file or directory (2) in /home/fotories/public_html/shop/includes/functions/sessions.php on line 114
    [07-Mar-2011 05:01:16] PHP Warning: session_write_close() [<a href='function.session-write-close'>function.session-write-close</a>]: open(/home/fotorie/public_html/shop/cache/sess_91aeff7a64de388e0df0d7802639f6d0, O_RDWR) failed: No such file or directory (2) in /home/fotories/public_html/shop/zcadmin/includes/application_bottom.php on line 13
    [07-Mar-2011 05:01:16] PHP Warning: session_write_close() [<a href='function.session-write-close'>function.session-write-close</a>]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/home/fotorie/public_html/shop/cache) in /home/fotories/public_html/shop/zcadmin/includes/application_bottom.php on line 13

    Code from above PHP file -

    <?php
    /**
    * @package admin
    * @copyright Copyright 2003-2010 Zen Cart Development Team
    * @copyright Portions Copyright 2003 osCommerce
    * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
    * @version $Id: application_bottom.php 17049 2010-07-29 06:19:52Z drbyte $
    */
    if (!defined('IS_ADMIN_FLAG')) {
    die('Illegal Access');
    }
    // close session (store variables)
    session_write_close();

    if (STORE_PAGE_PARSE_TIME == 'true') {
    if (!is_object($logger)) $logger = new logger;
    echo $logger->timer_stop(DISPLAY_PAGE_PARSE_TIME);
    }


    I can see alot of learning coming up...

  4. #4
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Search/Advanced Search not returning results

    Quote Originally Posted by scottfr View Post
    [07-Mar-2011 05:01:12] PHP Warning: session_start() [function.session-start]: open(/home/fotorie/public_html/shop/cache/sess_91aeff7a64de388e0df0d7802639f6d0, O_RDWR) failed: No such file or directory (2) in ...
    You've got your site set up to store sessions in files, but the /cache/ folder, where it stores that data, is set up in such a way that the software isn't being allowed to write to the files inside.

    It's recommended that you use the database for session storage anyway. Make the appropriate changes in your configure.php files, or choose the "database" setting for that option during initial installation / reinstallation using zc_install.
    .

    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.

  5. #5
    Join Date
    Mar 2011
    Posts
    6
    Plugin Contributions
    0

    Default Re: Search/Advanced Search not returning results

    Okay, If I change below -

    // The next 2 "defines" are for SQL cache support.
    // For SQL_CACHE_METHOD, you can select from: none, database, or file
    // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache
    // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder
    // ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash
    define('SQL_CACHE_METHOD', 'file');
    define('DIR_FS_SQL_CACHE', '/home/fotories/public_html/shop/cache');

    to 'database' would be the best practice option?

  6. #6
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Search/Advanced Search not returning results

    No, that's not the one I meant. That's for SQL caching. I'd still set that to 'database' though.

    This is the one for session handling: define('STORE_SESSIONS', 'db');
    .

    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.

  7. #7
    Join Date
    Mar 2011
    Posts
    6
    Plugin Contributions
    0

    Default Re: Search/Advanced Search not returning results

    That already seems to be set - ??

    define('USE_PCONNECT', 'false');
    define('shop_SESSIONS', 'db');
    // for shop_SESSIONS, use 'db' for best support, or '' for file-based storage

    I'll change over the SQL session to 'database' as suggested in the meantime.

  8. #8
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Search/Advanced Search not returning results

    Zen Cart doesn't use a constant named "shop_SESSIONS".
    It's called "STORE_SESSIONS".

    What have you been doing with the original code? Why have you hacked it up with replacements of names in critical core system components?
    .

    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.

  9. #9
    Join Date
    Mar 2011
    Posts
    6
    Plugin Contributions
    0

    Default Re: Search/Advanced Search not returning results

    Excuse the ignorance from this end.

    We had the install done by another provider and the only thing I can think of is that it was changed because the ZC install is in a folder called "shop".

    I've just changed that instance to 'STORE' and the site seems to work the same, including no search function.

  10. #10
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Search/Advanced Search not returning results

    Sounds like the integrity of the files on your site is in question.

    I suggest reinstalling or setting up another clean site with original uncustomized files and satisfy yourself that it does indeed work out-of-the-box on your server just like it does on thousands of others.

    Or, you can identify and fix all the differences by hand: http://www.zen-cart.com/wiki/index.p...Obscure_Issues This is the step I'd take if I were investigating it myself.
    .

    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.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v154 Advanced Search Results Pagination not working correctly
    By delia in forum General Questions
    Replies: 0
    Last Post: 16 Nov 2015, 09:31 PM
  2. Product filter Module: Advanced search results page not working
    By WWRepair in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 5 Mar 2013, 11:51 PM
  3. Advanced Search :: Search Results stacking up
    By bogyi in forum General Questions
    Replies: 3
    Last Post: 7 Nov 2010, 03:11 AM
  4. Search and Advanced search not returning results
    By paisore in forum General Questions
    Replies: 6
    Last Post: 4 Nov 2010, 03:43 PM
  5. Replies: 1
    Last Post: 29 May 2008, 10:54 PM

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