Akopia Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

[mv] 3.14-4.04 Migration Confusion



******    message to minivend-users from Barney Treadway <barney@wttech.com>     ******

Greetings all,

Having a heck of a time getting mysql going on mv 4.04. All my blood and
tears invested in 3.14 isn't paying off because of the small differences
between the catalog.cfgs (supposedly). 4.04 created shipping and userdb in
sql, but doesn't appear to be using them. I kept getting mysql syntax errors
(table creation) during reconfig so I manually created all tables and placed
empty tablename.sql files in products and I'm back to the:
"demo config error: Directive ProductFiles returned default setting error:
No default search file!"

List mentions a special page problem so I commented all those to no avail
either.

I keep commenting and uncommenting stuff willy nilly and breaking the
reconfig.  Can someone take a peek at this part of my catalog file or
perhaps forward a working one?

[--snip--]
Variable            SOMESQL      1
Variable            MYSQL       1
Variable            PGSQL

#ifndef SOMESQL
Database            area         area.txt          TAB
Database            area         AUTO_NUMBER       1
Database            cat          cat.txt           TAB
Database            country      country.txt       TAB
Database            inventory    inventory.txt     TAB
#Database   	products	 products.txt	 dbi:mysql:demo:localhost:3306
Database   	products	 products.txt	dbi:mysql:demo
Database	products  USER          mysqluser
Database	products  PASS          mysqlpass
#Database        products    products.txt     TAB
Database	products  DELIMITER     TAB
Database            pricing      pricing.txt       TAB
Database            pricing      KEY               code
Database            pricing      NUMERIC           q2
Database            products     HOT               1
#Database            products     INDEX             category:c
Database            shipping     shipping.txt      TAB
Database            shipping     AUTO_NUMBER       1
Database            orderline    orderline.txt     TAB
Database            transactions transactions.txt  TAB
Database            userdb       userdb.txt        TAB
#endif

NoImport  products inventory
[end snip]

Search for: Match: Format: Sort by: