Results 1 to 6 of 6
  1. #1

    Default Problem during upgrade (after renaming tables to remove zen_ prefix)

    I got the blank screen as well. As I don't follow instructions well, I ended up having to go through the new database (1.3.8) and visually compare it to the old database (1.3.7). I opened a backup SQL of 1.3.7 database and compared it to the 1.3.8 database in the zc_install/sql/mysql_zencart.sql.

    I used the 'Install SQL Patches' and the 'PHPMyAdmin' on my server to go through every table manually. Made sure that all the table prefixes were named correctly, then would insert the old data into the new (1.3.8) tables.

    This method took some time, and trial and error, but I highly recommend it in order to get to know about what is going on behind the scenes in your database.

    One must be very thorough and check/double check that everything looks correct.

    After getting some errors in the admin area, I had to change a few lines of code in admin/includes/fuctions/general.php to match up with the database tables.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Blank screen on database-upgrade step

    Quote Originally Posted by rainthebat View Post
    After getting some errors in the admin area, I had to change a few lines of code in admin/includes/fuctions/general.php to match up with the database tables.
    Huh ?
    .

    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.

  3. #3

    Default Re: Blank screen on database-upgrade step

    I was getting errors under the configuration menu in several areas. If anything I may have changed something in the database configuration table because I was changing all my table prefixes from 'zen_' to 'Z_' and did an auto replace on lots of them and perhaps it replaced one of 'zen_' that wasn't a table prefix in the configuration table data area. But I could not find that if that is what happened. So after getting errors that pointed to my admin/includes/functions/general.php file, I changed the functions it was identifying as problematic from:

    function zen_get_country_name($country_id)

    to:

    function Z_get_country_name($country_id)

    and changed several of these as well from 'function zen_cfg...' to:

    function Z_cfg_pull_down_country_list($country_id, $key = '')
    function Z_cfg_pull_down_country_list_none($country_id, $key = '')
    function Z_cfg_pull_down_zone_list
    function Z_cfg_pull_down_tax_classes
    function Z_cfg_textarea($text, $key = '')
    function Z_cfg_textarea_small($text, $key = '')

    and a few others.

    Please forgive me, but I like to see errors go away fast and resort to sometimes unconventional methods, and hey, in this case it worked.

    I will check the table zen_configuration again to see if I can pinpoint where I may have changed something other than the table prefix.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Problem during upgrade (after renaming tables to remove zen_ prefix)

    The set_function and use_function columns of the configuration and product_type_layout tables have "zen_" in the function names referenced therein.

    Thus, your move to blindly search-and-replace all "zen_" instances was overly aggressive.

    If you're going to rename your tables, be sure to ONLY rename tables ... not all the data inside those tables.
    .

    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.

  5. #5

    Default Re: Problem during upgrade (after renaming tables to remove zen_ prefix)

    I found where I made the errors. I changed the table data such as:

    'zen_get_country_name', 'zen_cfg_pull_down_country_list

    to:

    'Z_get_country_name', 'Z_cfg_pull_down_country_list

    etc.

    got a little tangled up there. Thanks for the help. Will change the functions in admin/includes/functions/general.php back to origonal and make appropriate database zen_configuration table changes.

  6. #6

    Default Re: Problem during upgrade (after renaming tables to remove zen_ prefix)

    It was an over aggressive move, but with thousands upon thousands of prefixes to change over (because the tables prefix comes up every time there is and INSERT command), it seemed appropriate at the time. I wish I could change my overly aggressive attitude, and perhaps by thinking about it I could.

 

 

Similar Threads

  1. can I remove zen_ prefix from all tables?
    By warroyo90 in forum General Questions
    Replies: 7
    Last Post: 27 Jul 2012, 09:24 PM
  2. Stock by Attributes - use a prefix such as "zen_"
    By imfsub12 in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 9 Oct 2008, 08:07 PM
  3. Fatal error after upgrade to 1.3.5 renaming phpbb file
    By mikey1719 in forum Upgrading from 1.3.x to 1.3.9
    Replies: 10
    Last Post: 8 Sep 2006, 01:54 AM

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