Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Join Date
    Aug 2006
    Posts
    11
    Plugin Contributions
    0

    Default Database appears blank after upgrade (but it's not)

    Hello! My host upgraded their PHP and that caused my Zen Cart to break, so I upgraded to the new version. I went through the steps of upgrading my database, too.

    Now none of the information in my database is displaying (products, customer records, reviews, etc)--either in the admin area or in the store. When I view the database in notepad, the information is still there, so I feel like I must've missed a step or something to get it to recognize the data.

    I've been working on this for a week, and have consulted the forums lots of times (and have learned lots about this great program--thanks!) but so far nothing I've tried has worked. I've also started from scratch a couple times, but that doesn't mean I'm not missing something completely obvious.

    I'll be very grateful for any advice!

    Thanks,

    Gezzyka

  2. #2
    Join Date
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default Re: Database appears blank after upgrade (but it's not)

    What do you mean by
    "When I view the database in notepad, "

    Also, can you go to phpmyadmin and see if the database tables are populated
    Thanks
    San
    Tutorials on Zen Cart
    http://tutorials.zen-cart.com/index.php
    ---------------
    advanced.programmer at gmail dot com
    In love with Zen Cart!!

  3. #3
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Database appears blank after upgrade (but it's not)

    If the database contains no products in the admin side, then it's possible that you haven't imported the data properly.

    You haven't detailed all the steps you've taken, and probably cannot, since you've been doing it over a lengthy period of time.

    Try this:
    0. make sure that the DB_PREFIX in your old configure.php is also in your new configure.php files.
    1. backup the existing database just in case.
    2. import your old database into the new database
    3. you should now see errors in your store
    4. run zc_install/index.php and choose "Database Upgrade" ... NOT "Install".
    5. Follow the prompts for upgrading the database to new structure.
    .

    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.

  4. #4
    Join Date
    Aug 2006
    Posts
    11
    Plugin Contributions
    0

    Default Re: Database appears blank after upgrade (but it's not)

    Hi superprg,

    Thanks for the response!

    When I log into phpmyadmin and looked up the "zen_products_description" there are indeed product names and descriptions there of my products. (Since my host's upgrade, phpmyadmin has taken forever to load everything so I haven't been using it at all when I can help it.)

    What do you mean by
    "When I view the database in notepad, "
    Sorry, I meant that when I download the backup and then view it in notepad, there's data there :-).

    Thanks,

    Gezzyka

  5. #5
    Join Date
    Aug 2006
    Posts
    11
    Plugin Contributions
    0

    Default Re: Database appears blank after upgrade (but it's not)

    Hi DrByte,

    Thanks for the response! You're right, I don't really remember what all I've done--I probably should have been taking notes, but kept feeling like, "This will fix it!" :-)

    Thank you for these steps, I'll go through them right now and post back with what happens.

    All my best,

    Gezzyka

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

    Default Re: Database appears blank after upgrade (but it's not)

    Quote Originally Posted by gezzyka
    (Since my host's upgrade, phpmyadmin has taken forever to load everything so I haven't been using it at all when I can help it.)
    Does your host know about this? What are they doing about it?
    .

    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
    Feb 2006
    Location
    Chicago
    Posts
    1,162
    Plugin Contributions
    0

    Default Re: Database appears blank after upgrade (but it's not)

    And what about the table
    zen_products?
    Tutorials on Zen Cart
    http://tutorials.zen-cart.com/index.php
    ---------------
    advanced.programmer at gmail dot com
    In love with Zen Cart!!

  8. #8
    Join Date
    Aug 2006
    Posts
    11
    Plugin Contributions
    0

    Default Re: Database appears blank after upgrade (but it's not)

    Hi DrByte,

    That fixed it! Thank you so much. (And I was afraid I'd missed something simple--looks like I copied/pasted the DB_PREFIX from includes\configure.php incorrectly...)

    I haven't mentioned the slowdown at phpmyadmin to my host yet--but you're right, I definitely should. (I've only ever really used it to restore backups, so avoiding it hasn't been a big deal.)

    I feel like a dolt, but it's wonderful to have everything working again! Thank you so much!

    Gezzyka

  9. #9
    Join Date
    Aug 2006
    Posts
    11
    Plugin Contributions
    0

    Default Re: Database appears blank after upgrade (but it's not)

    Thank you so much for your help, superprg! I really appreciate your help with this.

    All my best,

    Gezzyka

  10. #10
    Join Date
    Aug 2006
    Posts
    11
    Plugin Contributions
    0

    Default Re: Database appears blank after upgrade--spoke too soon

    Yikes, it appears I spoke too soon! The products are now displaying on my store page, but not anywhere in the admin menus... I was working on getting the template to display nicely again and didn't realize that the products and customers aren't listed anywhere among the admin lists.

    Any suggestions?

    Thanks,

    Gezzyka

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v154 Blank Screen After Upgrade (fixed) but now blank screen after login!
    By Kias Henry in forum Upgrading to 1.5.x
    Replies: 6
    Last Post: 23 Jun 2015, 07:32 PM
  2. Replies: 1
    Last Post: 4 Jan 2013, 06:13 AM
  3. v139h Orders completing but not showing up in admin after upgrade
    By isaiah36 in forum Upgrading from 1.3.x to 1.3.9
    Replies: 9
    Last Post: 29 Feb 2012, 02:27 AM
  4. Update still appears after upgrade
    By commdiver in forum Upgrading from 1.3.x to 1.3.9
    Replies: 3
    Last Post: 19 Jul 2010, 03:56 AM
  5. blank page appears after login
    By rajoo.sharma in forum General Questions
    Replies: 0
    Last Post: 22 Mar 2010, 10:30 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