[ic] Catalog configure fails

[George Osvald]

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.


>It looks like IC is trying to read a mySQL database that is not there. Did
>you set that up when you did the upgrade? And do you have the data from
>before the upgrade?
>You'll need to create a mySQL database called OKDB and grant full
>permissions on it for the mySQL user that Interchange uses to connect to
>it. Then use mysqldump to get the data out of the old system and into this
>one, then read it into this one with the mysql program. If you don't have
>access to the old mySQL database, then I hope you exported all those tables
>before you started your upgrade; in that case you can just delete *.sql in
>the products directory and restart Interchange.

Database OKDB is actualy a new empty database that I created for testing 
purposes. I do have all permissions I can get. Once I have the new 
Interchange up and running I will migrate the data.


-- 

Regards,

George Osvald
OK Studio ®
http://www.okstudio.com.au
Email: mail@okstudio.com.au