Results 1 to 8 of 8
  1. #1
    Join Date
    Feb 2010
    Posts
    74
    Plugin Contributions
    0

    Default I can't see my products in my admin page

    hello zencart master ..I can't see my products in my zencart admin page...!
    I know they're there....you can see them at www.candygoround.com
    I had a database problem...and my host had to re-install the database.........I'm not sure where the problem is.

    thanks for helping!


    p.s...I can't checkout either...

  2. #2
    Join Date
    Apr 2007
    Location
    Ontario, Canada
    Posts
    1,731
    Plugin Contributions
    27

    Default Re: hello zencart master ..I can't see my products in my zencart admin page

    Quote Originally Posted by lrfowler24 View Post
    hello zencart master ..I can't see my products in my zencart admin page...!
    I know they're there....you can see them at www.candygoround.com
    I had a database problem...and my host had to re-install the database.........I'm not sure where the problem is.

    thanks for helping!


    p.s...I can't checkout either...

    There should be an error in your /logs folder if you're using Zen Cart 1.5x ?
    Twitch.
    https://www.twitchtoo.com Do you work for free? Please donate.
    Twitch Base7 with Wholesale PRO - 88 preinstalled plugins zero errors.

  3. #3
    Join Date
    Feb 2010
    Posts
    74
    Plugin Contributions
    0

    Default Re: hello zencart master ..I can't see my products in my zencart admin page

    Quote Originally Posted by twitchtoo View Post
    There should be an error in your /logs folder if you're using Zen Cart 1.5x ?
    Here is the log file:
    [28-Mar-2020 08:04:58 America/Boise] Request URI: /store/index.php?main_page=page&id=1&chapter=1, IP address: 10.179.3.142
    #1 trigger_error() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/includes/classes/db/mysql/query_factory.php:171]
    #2 queryFactory->show_error() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/includes/classes/db/mysql/query_factory.php:143]
    #3 queryFactory->set_error() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/includes/classes/db/mysql/query_factory.php:270]
    #4 queryFactory->Execute() called at [/home4/twomuch1/public_html/other_websites/candygoround/store/includes/modules/pages/page/header_php.php:40]
    #5 require(/home4/twomuch1/public_html/other_websites/candygoround/store/includes/modules/pages/page/header_php.php) called at [/home4/twomuch1/public_html/other_websites/candygoround/store/index.php:36]
    --> PHP Fatal error: 1054:Unknown column 'status_visible' in 'where clause' :: SELECT e.*, ec.*
    FROM ezpages e,
    ezpages_content ec
    WHERE e.pages_id = ec.pages_id
    AND ec.languages_id = '1'
    AND e.pages_id = 1 AND (status_toc > 0 or status_header > 0 or status_sidebox > 0 or status_footer > 0 or status_visible > 0) ==> (as called by) /home4/twomuch1/public_html/other_websites/candygoround/store/includes/modules/pages/page/header_php.php on line 40 <== in /home4/twomuch1/public_html/other_websites/candygoround/store/includes/classes/db/mysql/query_factory.php on line 171.

    any ideas?

  4. #4
    Join Date
    Apr 2007
    Location
    Ontario, Canada
    Posts
    1,731
    Plugin Contributions
    27

    Default Re: hello zencart master ..I can't see my products in my zencart admin page

    From the error - That unknown column status_visible is not in the database and the Zen code is looking for it. Was the database restored form an older version?

    Secondly - Perhaps you added a new EZ page that isn't recognized/lost during the changes?
    Twitch.
    https://www.twitchtoo.com Do you work for free? Please donate.
    Twitch Base7 with Wholesale PRO - 88 preinstalled plugins zero errors.

  5. #5
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,106
    Plugin Contributions
    11

    Default Re: hello zencart master ..I can't see my products in my zencart admin page


  6. #6
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,399
    Plugin Contributions
    87

    Default Re: hello zencart master ..I can't see my products in my zencart admin page

    @lrfowler24, this error (like the one you posted here about the checkout problem) is due to a 'missing' database field (ezpages::status_visible) that was added for Zen Cart 1.5.6.

    What version of Zen Cart are you currently using and what's the site's Zen Cart upgrade history? If upgraded, how was it upgraded ... i.e. by a person or by a webhost's automatic (and many times incorrect) upgrade script?

  7. #7
    Join Date
    Jul 2012
    Posts
    16,718
    Plugin Contributions
    17

    Default Re: hello zencart master ..I can't see my products in my zencart admin page

    Quote Originally Posted by lat9 View Post
    @lrfowler24, this error (like the one you posted here about the checkout problem) is due to a 'missing' database field (ezpages::status_visible) that was added for Zen Cart 1.5.6.

    What version of Zen Cart are you currently using and what's the site's Zen Cart upgrade history? If upgraded, how was it upgraded ... i.e. by a person or by a webhost's automatic (and many times incorrect) upgrade script?
    If you're able to login to your admin (as described possible) the requested information should be available from the version link located at the top of the admin area.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  8. #8
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,622
    Plugin Contributions
    123

    Default Re: hello zencart master ..I can't see my products in my zencart admin page

    I would guess that you haven't yet run zc_install. You have to do this before you login to admin on Zen Cart 1.5.6.

    Upload the zc_install folder from a fresh download of Zen Cart 1.5.6, and go to
    www.candygoround.com/zc_install

    Run the procedure, and then delete the zc_install folder.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

 

 

Similar Threads

  1. Can't SEE admin page
    By ordi260 in forum General Questions
    Replies: 2
    Last Post: 25 Aug 2010, 04:25 AM
  2. can't see my admin page
    By pewan in forum General Questions
    Replies: 4
    Last Post: 14 Jan 2010, 08:39 AM
  3. how can i see all products in admin?
    By uncentaur in forum Customization from the Admin
    Replies: 2
    Last Post: 24 Jul 2008, 05:38 PM
  4. help!!!!! can't see page in admin
    By williamL in forum General Questions
    Replies: 2
    Last Post: 30 Mar 2007, 11:17 PM
  5. Can only see page 1 products
    By Urban in forum Basic Configuration
    Replies: 2
    Last Post: 11 Jun 2006, 12:17 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