[ic] Catalog configure fails

[Ed LaFrance]

At 12:37 AM 7/15/2002 +1000, you wrote:
>I have been playing around with Interchange a little and decided I will=20
>try to
>rebuild my web site(currently ZOPE)
>Interchange 4.8.3 on RedHat 7.0 worked without a problem. I upgraded to=20
>RedHat
>7.3 and Interchange 4.8.5 and I can not get it working. After I ran makecat
>(without any problems) I start Interchange and it fails to build the=
 catalog.
>Here is the junk I get:
>
>Low traffic settings.
>Calling UI......UI is loaded...
>Interchange V4.8.5
>Configuring catalog okshop...Using MySQL, DSN=3Ddbi:mysql:OKDB...table=20
>'country'
>failed: DBD::mysql::st execute failed: Table 'OKDB.country' doesn't exist=
 at
>/home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'gift_certs' failed: DBD::mysql::st execute failed: Table
>'OKDB.gift_certs' doesn't exist at
>/home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'userdb' failed: DBD::mysql::st execute failed: Table 'OKDB.userdb'
>doesn't exist at /home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'options' failed: DBD::mysql::st execute failed: Table 'OKDB.options'
>doesn't exist at /home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'affiliate' failed: DBD::mysql::st execute failed: Table
>'OKDB.affiliate' doesn't exist at
>/home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'cat' failed: DBD::mysql::st execute failed: Table 'OKDB.cat' doesn't
>exist at /home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'pricing' failed: DBD::mysql::st execute failed: Table 'OKDB.pricing'
>doesn't exist at /home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'state' failed: DBD::mysql::st execute failed: Table 'OKDB.state'
>doesn't exist at /home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'area' failed: DBD::mysql::st execute failed: Table 'OKDB.area'=
 doesn't
>exist at /home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'merchandising' failed: DBD::mysql::st execute failed: Table
>'OKDB.merchandising' doesn't exist at
>/home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'orderline' failed: DBD::mysql::st execute failed: Table
>'OKDB.orderline' doesn't exist at
>/home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'inventory' failed: DBD::mysql::st execute failed: Table
>'OKDB.inventory' doesn't exist at
>/home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'order_returns' failed: DBD::mysql::st execute failed: Table
>'OKDB.order_returns' doesn't exist at
>/home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'transactions' failed: DBD::mysql::st execute failed: Table
>'OKDB.transactions' doesn't exist at
>/home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>table 'products' failed: DBD::mysql::st execute failed: Table=
 'OKDB.products'
>doesn't exist at /home/george/interchange/lib/Vend/Table/DBI.pm line 1370.
>
>okshop config error: products not a database, cannot use as products file
>
>
>okshop: error in configuration. Skipping.
>okshop: config error. Skipping.
>Interchange server started in INET and UNIX mode(s) (process id 21013)
>
>
>Please, please help.
>
>
>
>--
>
>Regards,
>
>George Osvald
>OK Studio =AE
>http://www.okstudio.com.au

It looks like IC is trying to read a mySQL database that is not there. Did=
=20
you set that up when you did the upgrade? And do you have the data from=20
before the upgrade?

You'll need to create a mySQL database called OKDB and grant full=20
permissions on it for the mySQL user that Interchange uses to connect to=20
it. Then use mysqldump to get the data out of the old system and into this=
=20
one, then read it into this one with the mysql program. If you don't have=20
access to the old mySQL database, then I hope you exported all those tables=
=20
before you started your upgrade; in that case you can just delete *.sql in=
=20
the products directory and restart Interchange.

- Ed L.


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Increase profits from your Interchange store...
http://www.newmediaems.com/cgi-bin/nm/software_fus.html
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D