Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2007
    Posts
    21
    Plugin Contributions
    1

    bug admin/sqlpatch.php bug

    using zc 1.3.7 i noticed when looking through the db after running a 'create table' query (that failed) with sqlpatch.php that the upgrade exceptions table was empty. however, there was another table with two DB_PREFIXes that contained the errors (e.g if your db prefix was x_ the errors would be in a new table named x_x_upgrade_exceptions).

    the problem was that the constant TABLE_UPGRADE_EXCEPTIONS already contains the constant DB_PREFIX but the functions in sqlpatch.php add the prefix again (including the function that test for the existence of the table).

    i have attached a fixed sqlpatch.php that corrects the problem by removing the unnecessary additional DB_PREFIXes and corrects the broken call to zen_table_exists() on line 644 without changing the function so as not to break other calls to it.

    i tested this with my own install and all further errors appeared in the correct table.
    Attached Files Attached Files

 

 

Similar Threads

  1. [Done v1.3.9] Bug in admin\sqlpatch.sql
    By hem in forum Bug Reports
    Replies: 0
    Last Post: 26 Mar 2009, 09:18 PM
  2. FORBIDDEN access admin/sqlpatch.php
    By wasana in forum General Questions
    Replies: 3
    Last Post: 30 Aug 2006, 02:46 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