Zen Cart Logo
Forums / General Questions / Restore database after (unfortunately) installing "add customer fields"

Restore database after (unfortunately) installing "add customer fields"

Locked

Views: 575

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
9 Feb 2010, 8:30 PM
#1
australian_caching avatar

australian_caching

Zen Follower

Join Date:
Feb 2010
Posts:
106
Plugin Contributions:
0

Restore database after (unfortunately) installing "add customer fields"

I installed "add customer fields"
I restored my database as instructed, ran it, it stalled and did nothing.

So I gave up on it.

I got my first customer, he was added fine, but when I went to add group discount for him, it wouldn't add, it would say it did, then when you go into customers, the discount wasn't there.

I then tried to adjust mine by adding my middle name, same thing.

I then went to restore my sql using the back up module I added in tools.

I can see the back up "mysql -hlocalhost -u***** -p australiancaching < /var/www/html/store/admin/backups/d b_australiancaching-201002(with more numbers.sql.gz)'

I click restore, NOTHING, it just does nothing.

It also suggests "The larger the backup, the longer this process takes!

If possible, use the mysql client."

ok, how do I do that, went into sql admin, and was confused, all I could see there was "bla bla"

What do I have to do to restore it, I deleted my customer details (my name) and added it again, then tried group discount, nothing, seems that I am blocked from editing the database.

I want this fixed before any more customers add themselves.

Guy

9 Feb 2010, 9:29 PM
#2
australian_caching avatar

australian_caching

Zen Follower

Join Date:
Feb 2010
Posts:
106
Plugin Contributions:
0

Re: Restore database after (unfortunately) installing "add customer fields"

I worked out how to restore the database, after copying the file to my hard drive, then restore again.

I lost my only customer (e-mailed him to let him know it might happen),

Tried it again,
I edited my details, took my group discount away, pressed update, screen refreshed, showed no group pricing, then when I went back to customer details, there was my previous discount, it did nothing.

What do I have to do?

I have invested 20 hours so far, don't want to start again.

10 Feb 2010, 3:57 AM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Restore database after (unfortunately) installing "add customer fields"

Addons consist of both "PHP files" and "database content/changes".

So, removing an addon requires undoing all PHP changes and undoing all database changes/additions made by the addon's installation process and/or actual use.