Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2006
    Posts
    42
    Plugin Contributions
    0

    Default sql table problems after upgrade

    I was using version 3.5 and upgraded to 3.8. I backed up my database and then restored after upgrading. My problem seems to be that the restored tables all have "zen_" in front of the table name..ie zen_customers where are I suddenly have tables named customers -- the new version is directed to the customers table but my customers are actually listed in the zen_customers table. What can I do to correct this? Do I somehow merge the old tables into the new or do I redirect all of the php files? Please be a bit specific in answering.
    thanks!

  2. #2
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: sql table problems after upgrade

    Edit your includes/configure.php file and admin/includes/configure.php files to change the DB_PREFIX to 'zen_' and the new tables will be ignored in favor of the old ones.

    I'm wondering though whether you have completed the upgrade process, since if your new site hasn't accessed the old tables, they probably haven't been upgraded.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  3. #3
    Join Date
    Dec 2006
    Posts
    42
    Plugin Contributions
    0

    Default Re: sql table problems after upgrade

    I'll look into it more. thanks for your quick reply.

  4. #4
    Join Date
    Jul 2006
    Location
    Montreal, Canada
    Posts
    2,279
    Plugin Contributions
    0

    Default Re: sql table problems after upgrade

    i don't know why you restored your old database after upgrade .

  5. #5
    Join Date
    Dec 2006
    Posts
    42
    Plugin Contributions
    0

    Default Re: sql table problems after upgrade

    kuroi's solution fixed my problem. thanks!

 

 

Similar Threads

  1. v151 EZ-Pages Table of Contents links not working after upgrade to 1.5.1
    By seattleannie in forum Upgrading to 1.5.x
    Replies: 4
    Last Post: 7 Aug 2013, 08:58 PM
  2. Advance Search Results SQL syntax error after 1.3.9b upgrade
    By chrisruggia in forum Upgrading from 1.3.x to 1.3.9
    Replies: 3
    Last Post: 13 May 2010, 01:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR