Updated / New data cannot be shown

[kennythesheep]

Dear all,

Zen cart version 1.3.9h (upgraded from 1.3.9d)

Recently I found that my store cannot show any new/updated information (all data remain unchanged). My store got 33 products and 4 categories but after I added 10 products and 1 category, the query result in my store is unchanged (still 33 products and 4 cat). I can update / create new product/categories successfully in Admin page (those changes can be shown again in all admin function page) but when I go back to the store front end, no changes can be made. I checked the database using PHPadmin and confirmed that the data was changed.

Do you have any idea about this case? Please advise.

Thanks for your help.

Kenny

[katydid]

[QUOTE=kennythesheep;974870]Dear all,

Zen cart version 1.3.9h (upgraded from 1.3.9d)

Recently I found that my store cannot show any new/updated information (all data remain unchanged). My store got 33 products and 4 categories but after I added 10 products and 1 category, the query result in my store is unchanged (still 33 products and 4 cat). I can update / create new product/categories successfully in Admin page (those changes can be shown again in all admin function page) but when I go back to the store front end, no changes can be made. I checked the database using PHPadmin and confirmed that the data was changed.

Do you have any idea about this case? Please advise.

Thanks for your help.

Kenny

Finally, somebody experiencing the same thing I am. It is so frustrating. This all started for me when I tried to do an sqlpatch (which I had never done) and the whole site disappeared. oh, I'm using zen cart 1.38a. After about 20 hours the server and I (mostly them) got it back online. Now, I can add new products, but they don't show up in the database. I got an error message "Cannot create table reward_master because it already exists" twice, only it is dated for way back in March and there are 2 of them. Further, it doesn't say what. groovingrannylive.com worked great until a couple of days ago. I'm at a loss as to what to do next. I don't know if I should dump the database, reinstall 1.38a (don't want to create more problems) then restore the database or is there a way to get them married again. It reminds me of a couple that are no longer speaking to each other, and no matter what you do, they sure aren't going to produce anything new. Somebody please help, I just want to go get some sleep.

Katydid