Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2006
    Posts
    76
    Plugin Contributions
    0

    Help! Product can't show suddenly

    My categories can show the product list without problem but when I click inside a product, the following command show in the screen:

    29 File '.\zencart\reviews_description.MYD' not found (Errcode: 2)
    in:
    [select count(*) as count from reviews r, reviews_description rd where r.products_id = '224' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and r.status = '1']


    Because I worked on my PC, I can't provide any URL. If anyone need infomation for this problem, please tell me where I can copy and paste to here. Thank you.

    All happened suddenly now (Just worked perfect few hours ago). Please help!

  2. #2
    Join Date
    Jun 2006
    Posts
    76
    Plugin Contributions
    0

    Default Re: Help! Product can't show suddenly

    I just used my backup file to fix the problem. Here what I have done:

    1.Create a database called test.

    2.Import the backup sql file to 'test' database.

    3.Drop the reviews_description table (table with error) in the connected zencart database.

    4.Copy the reviews_description table from 'test' to the original connected zencart database with options of 'Structure and Data', ADD DROP TABLE and ADD AUTO INCREMENT value.

    Now the shop is OK. However, since I am not good for mysql operation, could anyone tell me that my procedures are corrected or not? Thanks.

  3. #3
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Help! Product can't show suddenly

    As long as your original database table for the reviews and reviews_description have matching reviews_id then you should be good to go ...

    Check with your hosting site to see what might have happended ... and be sure to keep regular backups ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  4. #4
    Join Date
    Jun 2006
    Posts
    76
    Plugin Contributions
    0

    Default Re: Help! Product can't show suddenly

    Thanks Ajeh. The reviews_id are matched. You are right, backup is VERY IMPORTANT.

 

 

Similar Threads

  1. Help! Suddenly can't log in to the admin panel
    By krusedull in forum General Questions
    Replies: 8
    Last Post: 3 Jun 2011, 08:35 PM
  2. Help...suddenly can't process credit cards
    By ccorwin in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 28 Mar 2011, 04:45 PM
  3. Suddenly product detail doesn't show
    By GerryTheMole in forum General Questions
    Replies: 4
    Last Post: 11 Dec 2010, 12:19 AM
  4. Need urgent help please - Suddenly can't get into Admin
    By beyre in forum General Questions
    Replies: 2
    Last Post: 16 Nov 2009, 05:28 PM
  5. suddenly can't edit product descriptions!
    By p m in forum General Questions
    Replies: 3
    Last Post: 23 Oct 2006, 03:02 AM

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