Shoppe is down, error 1054?

[kobra]

First check in your admin > tools > server version info > for Zen Cart version and DB version - they should be a match

[Christina Renee]

Is this what you mean?

Zen Cart 1.3.7
Database Patch Level: 1.3.7

[Website Rob]

Some of your pages are working just fine; Login, Create Account, Product Page which tells us the problem is not only specific to your Database but also specific to Shipping. Do you have any Modules installed that somehow affect Shipping?

Also, your Control Panel and/or phpMyAdmin allow for checking/fixing a database. You could try using that to see if it helps.

[Christina Renee]

No, nothing installed different on the shipping, but all my stuff IS virtual and it does always ask when entering in a new product if it's free shipping and defaults to yes. Don't see why it's causing a problem now tho, you know?

Also, your Control Panel and/or phpMyAdmin allow for checking/fixing a database. You could try using that to see if it helps.

Oh really, okay cooll? Now how do I do that?? lol. Sorry!

[kobra]

No, nothing installed different on the shipping, but all my stuff IS virtual and it does always ask when entering in a new product if it's free shipping and defaults to yes. Don't see why it's causing a problem now tho, you know?

As you have added some products go back to the admin and look at the last few you entered and compare the settings to one of the earlier ones...

Probably some small thing about free or virtual that was not on your earlier products

[Christina Renee]

Yea that's what I was gonna do but unfortunately I get that same error again as soon as I click on a category of products. It won't let me get to that point, does that make sense?

[Website Rob]

For Virtual Products available through download, your Product settings should be:

         Product is Virtual: No, Shipping Address Required
       Always Free Shipping: Yes, Always Free Shipping
Products Quantity Box Shows: No, Do not show Quantity Box 

The logic is bit backwards I know, but setting Product is Virtual to "NO" -- even though it is Virtual -- will apparently, allow Zen Cart to not reduce Stock levels; which is logical for downloadable products. Then, the Always Free Shipping overrides the requirement of a Shipping Address.

Not sure how many Downloadable products you have but they must all use the above settings.

Note: using the above settings does give a msg. in Red text when updating your product but that is normal.