RE: [mv] 3.14-4.04 Migration Confusion

["Cameron B. Prince" <cbp@internetexpertsllc.com>]

******    message to minivend-users from "Cameron B. Prince" <cbp@InternetExpertsLLC.com>     ******

Hi Barney,

When I converted I had similar errors at times. I finally found that in my
particular case, using MiniMate's spreadsheet function was at least part of
the problem.

It was somehow corrupting the tables in mysql and the only way I was able to
fix them was by deleting each of the .sql files in the products directory
and the corresponding database files in /var/lib/mysql... the restarting so
the databases were recreated.

Mike Heins recently did report that he knew of the problem and advised
against using the spreadsheet function.

Here's what I use:

Variable            SOMESQL      1
Variable            MYSQL        1

#ifdef MYSQL

Variable  SQLDSN   dbi:mysql:database
Message <<EOF

Using MySQL for databases, DSN=__SQLDSN__.
EOF

# Uncomment if needed
Variable  SQLUSER  username
Variable  SQLPASS  password

# The tables are in separate files in the mysql directory

#include mysql/*

#endif

The tables in the mysql directory are pretty much default except for other
new databases I use for other things.

Hope this helps,

Cameron

-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of Barney Treadway
Sent: Monday, May 22, 2000 4:33 PM
To: minivend-users@minivend.com
Subject: [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]
>From error_log in mvend

- - - [22/May/2000:17:01:22 -0400] - - demo config error: Directive
ProductFiles returned default setting error: No default search file!
> In line 0 of the configuration file '':
> Require usertag   reconfig
>
>
- - - [22/May/2000:17:01:22 -0400] - - Error reconfiguring catalog
/cgi-bin/demo from running server (30515)
>

Any advice would be greatly appreciated!

Barney Treadway

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to
Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list