Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    6
    Plugin Contributions
    0

    Default Re: where has the COLUMNS table disappeared?

    Searched forums but no joy... hope it's ok to post here.

    I just upgraded to v 1.3.9h from 1.3.8. Manually copying the SQL data. New install as standard. But being careful not to lose data, I am going through thousands of lines of SQL code. Now:

    1. It seems the main database contains just 93 tables (information_schema excluded). Is that normal? I could have sworn there were more.

    2. MORE IMPORTANTLY:
    I exported the SQL from 1.3.8 as you know. There were some 800 lines of code which do not seem to appear when I dump the data from the v1.3.9h. They are as below. Please does anyone know if this should be cause for concern?

    Please note - I used the prefix meromero_ for the tables.

    Thanks all!!

    The code:

    HTML Code:
    -- Dumping data for table `COLUMNS`
    --
    
    INSERT INTO `COLUMNS` (`TABLE_CATALOG`, `TABLE_SCHEMA`, `TABLE_NAME`, `COLUMN_NAME`, `ORDINAL_POSITION`, `COLUMN_DEFAULT`, `IS_NULLABLE`, `DATA_TYPE`, `CHARACTER_MAXIMUM_LENGTH`, `CHARACTER_OCTET_LENGTH`, `NUMERIC_PRECISION`, `NUMERIC_SCALE`, `CHARACTER_SET_NAME`, `COLLATION_NAME`, `COLUMN_TYPE`, `COLUMN_KEY`, `EXTRA`, `PRIVILEGES`, `COLUMN_COMMENT`) VALUES
    (NULL, 'meromero_shopcart', 'mm_address_book', 'address_book_id', 1, NULL, 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'PRI', 'auto_increment', 'select,insert,update', ''),
    (NULL, 'meromero_shopcart', 'mm_address_book', 'customers_id', 2, '0', 'NO', 'int', NULL, NULL, 10, 0, NULL, NULL, 'int(11)', 'MUL', '', 'select,insert,update', ''),
    
    ...
    
    (NULL, 'meromero_shopcart', 'mm_address_format', 'address_format', 2, '', 'NO', 'varchar', 128, 384, NULL, NULL, 'utf8', 'utf8_general_ci', 'varchar(128)', '', '', 'select,insert,update', ''),
    
    ...
    
    (NULL, 'meromero_shopcart', 'mm_zones_to_geo_zones', 'date_added', 6, '0001-01-01 00:00:00', 'NO', 'datetime', NULL, NULL, NULL, NULL, NULL, NULL, 'datetime', '', '', 'select,insert,update', '');

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: where has the COLUMNS table disappeared?

    COLUMNS is not a table in 1.3.8 or 1.3.9
    all ZenCart tables are lower case so this must be from some 3rd party addon
    Zen-Venom Get Bitten

 

 

Similar Threads

  1. Replies: 9
    Last Post: 9 Mar 2009, 08:31 PM
  2. Where has the categories header gone?!?
    By 1kell in forum Templates, Stylesheets, Page Layout
    Replies: 6
    Last Post: 19 Feb 2009, 12:48 AM
  3. Where is the file for editing the table displayed by Quantity Discount...
    By flipjargendy in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 28 Aug 2007, 02:56 PM
  4. Where has the extra $ come from
    By RKB in forum Customization from the Admin
    Replies: 2
    Last Post: 23 Oct 2006, 11:21 PM
  5. where do I begin to change the order of display with columns module?
    By bjraines in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 8 Oct 2006, 08:35 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