a pickle of a db problem

[xanthakita]

The other night I inadvertantly did "something" (I still don't knwo for sure) that caused my zencart site to lose connectivity to the database. I get an erorr stating it can't conenct and that there is a problem

I attempted to verify that the software still had the correct username and password etc etc

I then downloaded a backup of the database, and tried to upload it (using sql) into the database. That times out losing connectivity to the mysql server. (Is there a way to increase that processing time?) so I decided I would open the gzip file and manually paste the sql statememtns in. the problem is that on many of there there is so much data (I guess) that the end of the line either disappears into graphic garbage characters (in notepad++) or jsut cuts off (when I paste into the sql dialog box) As a esult I can't restore my database..


Questions:

1. Can I increase the timeout time on the mysql application?
2. Has anyone seen mysql dump out corrupt data in a backup file?

Thanks,
Jonathan

bagsexpresssc.com

[YvetteKuhns]

1. Can I increase the timeout time on the mysql application?

No.

2. Has anyone seen mysql dump out corrupt data in a backup file?

Yes. Larger databases may take longer to process and the limit for processes is one minute.

Try BigDump (http://www.ozerov.de/bigdump.php), a php script that will import your database and restart where it stopped if interrupted. The alternative is to run SQL queries for each table individually in phpmyadmin. I did this for a client whose Zen Cart database was too big to import as a whole.

[YvetteKuhns]

If you cannot restore your database, you could also contact support. They normally make daily backups and store them for up to three days. Of course, I remember a while back when support had the same problem and corrupted the database which is why I mentioned the other methods to you.

[xanthakita]

Thank you Yvette I'll try the BigDump and see if that works.
The tables are too big for me to restore individually I tried. :(

[YvetteKuhns]

The tables are too big for me to restore individually I tried.

Wow! Your database must be big! Some tables are much bigger than others. The products tables are usually the biggest and can be broken down, but the BigDump script will probably be easier for you.

[xanthakita]

I'm hopping that Yvette or someone will be able to help me.
Same database. I got the database restored. (thank you so much for that BigDump Script link! it's a lifesaver!)

Now I can get into the admin side of the zencart, but I keep getting the conneciton error on the custoemr facing side.

I have verified that the includes/configure.php and admin/includes/configure.php have the same database access info.

is there anything else that I can check?

url is bagsexpresssc.com thank you.

[YvetteKuhns]

If you can log into the admin but not see the front end, you are still connecting to the database for the admin. So there may be a problem with the database or configuration. The tables may need optimization or repair. Check your database tables for overhead and optimize them. I get nervous about using a script to move large databases since an interruption may corrupt any part of it.

I still suspect a configuration problem. Check your permissions for your database in OPS. Also check your permissions (http://tutorials.zen-cart.com/index.php?article=2)(chmod) for your files on your server (http://tutorials.zen-cart.com/index.php?article=2).

Hmm... How are you handling your sessions? Are you using the default method which is storing sessions in the database? Or did you create a cache folder and set permissions (http://tutorials.zen-cart.com/index.php?article=2) to use it?

Do you have any .htaccess files or anything that could interfere with Zen Cart? Be sure to make backup copies of files on the server before making any changes.

We may need to use private messages to continue this conversation. I don't want people to visit your website or try to access the admin while you are still trying to complete installation and have those installation files still accessible. You can reach me by email, phone and Skype, too.

[xanthakita]

Yvette, I ended up upgrading the whole kit and caboodle. and everything works fine with one.. major bugaboo... customers can't log in.. and as a result can't buy anything :( the page goes to http://bagsexpresssc.com/index.php?main_page=login and is just blank nothing loads nothing happens no errors no problems.. just nothing. The site goes through products admin panel works fine.. I can't find any settings that would impact this. I have played with permissions to no avail.

Do you have ANY ideas?

I appreciate your help.

Jonathan

[Dbrazzell]

There is an error message in the html source of that page.

"<b>Fatal error</b>: Call to undefined function zen_js_zone_list() in <b>/hermes/web01/bNNNN/pow.name/bags/htdocs/includes/modules/pages/login/jscript_addr_pulldowns.php</b> on line <b>32</b><br />
"

[xanthakita]

hmmm the joys of chrome... for some reason it wasnt' showing it to me... thanks... of course it doesn't help that I noticed this abotu 20 minutes before I ready to go to bed... thanks for pointing this out. Still trying to decide why this zen_js_zone_list is a pain to the script.. but... will find it!

Jonathan

[xanthakita]

thank you for your help... if you want to get something from the shop (www.bagsexpresssc.com ) use coupon code [#deleted] for 20% off first order.

[Croc Hunter]

Jonathan we greatly appreciate your offer however the Powweb forums are not the place to advertise promo codes period. Anyone interested will PM you.