New Zenner
- Join Date:
- Apr 2005
- Posts:
- 10
- Plugin Contributions:
- 0
Help! Database Failure!
Hi Guys,
I finally overcame my procrastination and moved everything from 1and1 to Sashbox, plus upgraded from 1.2.4 to 1.3.7. Thankfully with the help from some real nice Sashbox staff, I was able to upgrade with ease.
Then it took me 2 days to redesign the whole site, and I was finally ready to go live. Before I launched my new site, I had to update the database because there were a few new customers that came in through my 1and1 server (my original website).
So I backed-up (with the database backup module provided by zen-cart), FTP the .sql.gz file from my 1and1 server to my desktop, then import the file through the Sashbox PHPMyAdmin...then it gave me an error message which was about timezone can't be "null" (the window was closed by accident and I got a different msg the second time I attempted to import).
After the first failure, I tried loading my website and this is the error msg I got:
1054 Unknown column 'user_agent' in 'field list'
in:
[insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, host_address, user_agent) values ('0', '¥Guest', '3c315274cbce7d83ea8a8c11e410a634', '76.185.189.85', '1172214822', '1172214822', '/store/', 'OFFICE_IP_TO_HOST_ADDRESS', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.1) Gecko/20061204 Firefox/2.0.0.1')]
So I tried to import again, and PHPMyAdmin says:
**LOCK TABLES orders WRITE ;
MySQL said: Documentation
#1046 - No database selected **
Is there a way to recover? I'm really about to cry...I spent so many days, and I was so close of being done!!!
Any feedback would be greatly appreciated.
