Thread: Field List

Results 1 to 10 of 12

Threaded View

  1. #7
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,167
    Plugin Contributions
    7

    Default Re: Field List

    Quote Originally Posted by WWWD View Post
    I have not deleted the "new" files because all references to them should have been deleted when I ran the uninstal sql file; no?
    No. not so. The uninstal.sql scripts only revert changes made to the database. It doesn't touch any 'new' files. The 'new' files need to be deleted manually. Leaving them in place could *cause* errors if they happen to be 1) automatically loaded by Zen-Cart, and 2) if they contain references to the tables/records that were removed when running the uninstall scripts.

    For future reference, other can keeping the database 'tidy' there is never a need to undo/uninstall any changes made to the database by an install script. These changes, on their own, will *never cause or create a problem. The problem(s) only occur if you uninstall the SQL changes but neglect to take care of the related files.

    Cheers
    RodG

    *never means except in extreme cases where code has been *very poorly* written and expects table records to have an explicit field count in a specific order (and no one has written code like that for years)
    Last edited by RodG; 30 Jun 2015 at 04:25 AM.

 

 

Similar Threads

  1. v139h 1109 Unknown table 'p' in field list
    By Dexter71 in forum General Questions
    Replies: 2
    Last Post: 12 Sep 2013, 07:11 PM
  2. Unknown column 'zen_order_id' in 'field list'
    By rramirezb in forum Built-in Shipping and Payment Modules
    Replies: 5
    Last Post: 4 Sep 2008, 07:56 PM

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