Forums / General Questions / Help w SQL Database

Help w SQL Database

Started by xcergy on 22 Jun 2012, 5:57 PM · Views: 418

Results 1 to 5 of 5
22 Jun 2012, 5:57 PM
#1
xcergy avatar

xcergy

Zen Follower

Join Date:
Feb 2009
Location:
Landrum SC
Posts:
141
Plugin Contributions:
0

Help w SQL Database

Can anyone provide a link to 'SQL for dummies' or other information to learn how the SQL database works?

I have posted of problems w my site that have gone unanswered, so I guess I now need to learn about the complete system to be able to de-bug/solve my current problem.

TIA

22 Jun 2012, 6:01 PM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Help w SQL Database

There will be a support site for MySQL... but beware... it is not something you can learn in a couple of hours. And bear in mind that zencart's database schema is extremely complex.

There should be NO NEED to mess about with the database. If you are having problems, then it's probably a configuration error beyond your control - such as software versions on your server.

Who is your webhost?

20 years a Zencart User

22 Jun 2012, 6:13 PM
#3
xcergy avatar

xcergy

Zen Follower

Join Date:
Feb 2009
Location:
Landrum SC
Posts:
141
Plugin Contributions:
0

Re: Help w SQL Database

freeyellow.com. The problem started when they misconfigured a renewal of my SSL cert. The cart now works. I'm getting sales, emails notifications and proper inventory counts, but the cart admin pages are missing many things, including customer info (missing the last 25 orders), page views, and I noticed today, the who's online screen is blank.

25 Jun 2012, 7:50 AM
#4
angelkring avatar

angelkring

New Zenner

Join Date:
Jun 2012
Posts:
1
Plugin Contributions:
0

Re: Help w SQL Database

check your webhost.

http://newzmash.com/ is in your hand

25 Jun 2012, 5:02 PM
#5
xcergy avatar

xcergy

Zen Follower

Join Date:
Feb 2009
Location:
Landrum SC
Posts:
141
Plugin Contributions:
0

Re: Help w SQL Database

angelkring:

check your webhost.

LOL. I did. The latest reply was that "We cannot duplicate the error."