Forums / Upgrading to 1.5.x / trouble with carrying the database info into V151

trouble with carrying the database info into V151

Started by adolgin on 4 Jan 2013, 6:38 PM · Views: 1,465

Results 1 to 5 of 5
4 Jan 2013, 6:38 PM
#1
adolgin avatar

adolgin

New Zenner

Join Date:
Jul 2007
Posts:
63
Plugin Contributions:
0

trouble with carrying the database info into V151

I probably do not do something right with exporting/importing the older 1.3.8 database using PHPMyadmin.
The original database has all rows starting with zen_
The new imported database has all without, and all exactly same rows starting with zen_
Zencart seems to ignore the ones with prefix, it does not show any old customers, products, etc

Attachment 11713

4 Jan 2013, 8:34 PM
#2
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,896
Plugin Contributions:
21

Re: trouble with carrying the database info into V151

If the original started with zen_, you should have created the new database with the same prefix. Since you've already uploaded the old database, you can change this without having to start over by editing the two configure.php files (includes/configure.php AND yourSeccretAdmin/includes/configure.php) to change the define('DB_PREFIX', ''); to define('DB_PREFIX', 'zen_');.
Then use the zc_install to upgrade the database.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

4 Jan 2013, 9:44 PM
#3
adolgin avatar

adolgin

New Zenner

Join Date:
Jul 2007
Posts:
63
Plugin Contributions:
0

Re: trouble with carrying the database info into V151

Thank you so much, making some progress. Once I changed the configure.php files, the data showed up, but can not make it through the db update step as it does not accept the store admin name / password any more. :-(

27 Feb 2013, 4:32 PM
#4
marvin avatar

marvin

Zen Follower

Join Date:
Feb 2006
Posts:
222
Plugin Contributions:
0

Re: trouble with carrying the database info into V151

adolgin:

Thank you so much, making some progress. Once I changed the configure.php files, the data showed up, but can not make it through the db update step as it does not accept the store admin name / password any more. :-(

I have the same problem with the admin user/password. I am absolutely entering the correct info and have changed the password several times in the admin and reset at loin screen to admin.

What's going on?

28 Feb 2013, 11:56 PM
#5
drbyte avatar

drbyte

Sensei

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

Re: trouble with carrying the database info into V151

marvin:

I have the same problem with the admin user/password. I am absolutely entering the correct info and have changed the password several times in the admin and reset at loin screen to admin.

What's going on?

Apparently you got it sorted out in the other thread you started on the same topic: http://www.zen-cart.com/showthread.php?206478-upgrading-from-1-3-8a-to-1-5-1&p=1189715#post1189715

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.