[ic] 5.0.0 Not creating tables at startup

Sandy Thomson sandy at scotwebshops.com
Fri Dec 26 18:43:08 EST 2003


cbcurrier wrote:

>Upgraded server
>makecat'ed new catalog.
>DB created & files written
>
>on ./restart as interch ... no tables created:
>
>errors from stdout to the console are:
>        Configuring catalog vc...Using MySQL,
>        DSN=dbi:mysql:test_vc...table 'merchandisi
>        ng' failed: Undefined subroutine &Vend::Table::DBI::create
>        called at /usr/local/
>        interchange/lib/Vend/Table/Common.pm line 1107, <IN> line 2.
>         
>        table 'tree' failed: Undefined subroutine
>        &Vend::Table::DBI::create called at /u
>        sr/local/interchange/lib/Vend/Table/Common.pm line 1107, <IN>
>        line 3.
>         
>        table 'options' failed: Undefined subroutine
>        &Vend::Table::DBI::create called at
>         /usr/local/interchange/lib/Vend/Table/Common.pm line 1107, <IN>
>        line 4.
>         
>        table 'area' failed: Undefined subroutine
>        &Vend::Table::DBI::create called at /u
>        sr/local/interchange/lib/Vend/Table/Common.pm line 1107, <IN>
>        line 5.
>         
>        table 'state' failed: Undefined subroutine
>        &Vend::Table::DBI::create called at /
>        usr/local/interchange/lib/Vend/Table/Common.pm line 1107, <IN>
>        line 6.
>         
>        table 'forum' failed: Undefined subroutine
>        &Vend::Table::DBI::create called at /
>        usr/local/interchange/lib/Vend/Table/Common.pm line 1107, <IN>
>        line 7.
>         
>        table 'cat' failed: Undefined subroutine
>        &Vend::Table::DBI::create called at /us
>        r/local/interchange/lib/Vend/Table/Common.pm line 1107, <IN>
>        line 8.
>         
>        table 'transactions' failed: Undefined subroutine
>        &Vend::Table::DBI::create call
>        ed at /usr/local/interchange/lib/Vend/Table/Common.pm line 1107,
>        <IN> line 9.
>         
>        table 'products' failed: Undefined subroutine
>        &Vend::Table::DBI::create called a
>        t /usr/local/interchange/lib/Vend/Table/Common.pm line 1107,
>        <IN> line 10.
>         
>        table 'country' failed: Undefined subroutine
>        &Vend::Table::DBI::create called at
>         /usr/local/interchange/lib/Vend/Table/Common.pm line 1107, <IN>
>        line 11.
>         
>        table 'inventory' failed: Undefined subroutine
>        &Vend::Table::DBI::create called
>        at /usr/local/interchange/lib/Vend/Table/Common.pm line 1107,
>        <IN> line 12.
>         
>        table 'order_returns' failed: Undefined subroutine
>        &Vend::Table::DBI::create cal
>        led at /usr/local/interchange/lib/Vend/Table/Common.pm line
>        1107, <IN> line 13.
>         
>        table 'userdb' failed: Undefined subroutine
>        &Vend::Table::DBI::create called at
>        /usr/local/interchange/lib/Vend/Table/Common.pm line 1107, <IN>
>        line 14.
>         
>        table 'affiliate' failed: Undefined subroutine
>        &Vend::Table::DBI::create called
>        at /usr/local/interchange/lib/Vend/Table/Common.pm line 1107,
>        <IN> line 15.
>         
>        table 'variants' failed: Undefined subroutine
>        &Vend::Table::DBI::create called a
>        t /usr/local/interchange/lib/Vend/Table/Common.pm line 1107,
>        <IN> line 16.
>         
>        table 'gift_certs' failed: Undefined subroutine
>        &Vend::Table::DBI::create called
>         at /usr/local/interchange/lib/Vend/Table/Common.pm line 1107,
>        <IN> line 17.
>         
>        table 'orderline' failed: Undefined subroutine
>        &Vend::Table::DBI::create called
>        at /usr/local/interchange/lib/Vend/Table/Common.pm line 1107,
>        <IN> line 18.
>        
>no error messages in error.log.
>
>Perl is 5.8.0
>Bundle::Interchange is up to date
>Bundle::Interchange5 is up to date.
>DBI::mysql is up to date
>DBD is upto date
>
>MYSQL queries through perl fine.
>
>It has been suggested that there are permissions erros yet all
>permissions on a new catalog look great.
>
>any suggestions really appreciated. this is a live server & I had no
>problems with 4.9.8 so would like to try to get back up soon.
>

Off the top of my head, here is what I do:
1. Make sure the sql tables arent already created, ensure you have 
permissions etc etc.
2. Ensure the table column definitions in catalog.cfg (or included 
files) are correct.
3. Remove all instances of files like <tablename>.sql from products/ 
subdirectory.
4. Ensure the column names in products/<tablename>.txt are in the same 
order as defined in the catalog, tab separated, and that there is no new 
line at the end. I found even a space would make interchange have a fit.
5. Restart interchange and pray. :)

Sandy.




More information about the interchange-users mailing list