[ic] Upgrade from IC 4.6.5 to 4.8.1 problems starting IC

[Ian Riddler]

I just had the same thing happen

It's because you dropped the MySQL database.
My workaround was to uninstall the old version of interchange and reinstall
from fresh.

Ian Riddler

----- Original Message -----
From: "Boyd Lynn Gerber" <gerberb@zenez.com>
To: <interchange-users@interchange.redhat.com>
Sent: Wednesday, August 15, 2001 1:58 PM
Subject: [ic] Upgrade from IC 4.6.5 to 4.8.1 problems starting IC


> After installing IC from the CVS or the 4.8.1 I get the following errors.
>
> I have three calalogs.  Construct my demo cataloge from 4.6.5, a
> foundation catalog.  I was using during alpha and beta, and a second
> foundation catalog using tools that was working yesterday.  I did a
> bin/makecat with database foundation-tools and then tried to restart
> interchange as user interch...
>
> This is from the CVS...  Does this message mean it does not like my
> interchange.cfg file?
>
> line 2716
>         # Read interchange.cfg (or whatever its name is set to be)
>         global_config();
>
> # l interchange.cfg
> -rw-r--r--    1 interch  zenez          2589 Aug 14 19:25 interchange.cfg
>
> "mode" is not defined in %Fcntl::EXPORT_TAGS at
> /usr/local/interchange/bin/interchange line 2716
>
> Low traffic settings.
> Calling UI....
> ...UI is loaded...
> Interchange V4.9.0
> Configuring catalog construct...Using MySQL, DSN=dbi:mysql:test_construct.
> done.
> Configuring catalog foundation...Using MySQL,
DSN=dbi:mysql:test_foundation.
> done.
> Configuring catalog foundation-tools...Using MySQL,
DSN=dbi:mysql:test_foundation-tools...table 'state' failed: DBD::mysql::st
execute failed: Table 'test_foundation-tools.state' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'orderline' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.orderline' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'userdb' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.userdb' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'affiliate' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.affiliate' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'gift_certs' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.gift_certs' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'pricing' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.pricing' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'options' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.options' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'order_returns' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.order_returns' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'inventory' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.inventory' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'country' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.country' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'products' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.products' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'cat' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.cat' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'area' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.area' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'transactions' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.transactions' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> table 'merchandising' failed: DBD::mysql::st execute failed: Table
'test_foundation-tools.merchandising' doesn't exist at
/usr/local/interchange/lib/Vend/Table/DBI.pm line 1321.
>
> foundation-tools config error: products not a database, cannot use as
products file
>
>
> foundation-tools: error in configuration. Skipping.
> foundation-tools: config error. Skipping.
> Interchange server started in UNIX mode(s) (process id 1500)
>
>
>
> I did a bin/makecat on my foundation-tools and something got broken.  This
> is how I started.
>
> mysqladmin -uuser -p drop test_foundation-tools and the database was
> dropped
>
> bin/makecat does create the database test_foundation-tools, but when I
> restart interchange it get this above.
>
>
> Any ideas on what happened?
>
> Thanks,
>
> --
> Boyd Gerber <gerberb@zenez.com>
> ZENEZ 3748 Valley Forge Road, Magna Utah  84044
> Office 801-250-0795 FAX 801-250-7975
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
>