Re: [mv] Minivend3.14/MySQL Problem

[OTR Comm <otrcomm@wildapache.net>]

******    message to minivend-users from OTR Comm <otrcomm@wildapache.net>     ******

Karl,

I created my own products, pricing, and transactions tables with a
script (didn't like the MV defaults).

I removed all the .sql files from the products directory.  But I also
commented out some code in DBI.pm; i.e.

#       $db->do("drop table $tablename")
#               or warn "$DBI::errstr\n";

I had to comment out the code because every time that I restarted MV, it
wanted to drop the tables that I created and rebuild them with the
defaults; i.e., varchar(128) for all fields.  Then it would say that the
tables were created and die without actually creating the tables.

So, I commented out the code, restarted MV and things appear to be
working okay.

Now what I have to do is figure out where MV updates the transactions
table.  I assume that it is someplace in Order.pm

Thanks,
Murrah Boswell
otrcomm at wildapache dot net

Karl M. Joch wrote:
> 
> ******    message to minivend-users from "Karl M. Joch"<k_joch@yahoo.com>     ******
> 
> remove the *.sql files in the products dir and restart the server.
> 
> hope this helps
> 
> karl
> 
> >>>>>>>>>>>>>>>>>> Ursprüngliche Nachricht <<<<<<<<<<<<<<<<<<
> 
> Am 24.04.00, 23:59:34, schrieb OTR Comm <otrcomm@wildapache.net> zum
> Thema Re: [mv] Minivend3.14/MySQL Problem:
> 
> > ******    message to minivend-users from OTR Comm
> <otrcomm@wildapache.net>     ******
> 
> > Dan,
> 
> > Thanks for the reply!
> 
> > Dan Busarow wrote:
> > >
> > >
> > > Couple of possibilities.  You need to have DBI and DBD::mysql
> installed.
> 
> > I have DBI and DBD::mysql installed!  (I do perl/dbi and mysql
> > development).
> 
> > > Also you need an entry in your mysql grant tables for the USER
> specified
> > > in catalog.cfg that gives him create privs.
> > >
> 
> > I run my test database (minivend314) as root with all privileges
> 
> > >
> > > Should be in lib/Vend/Table/DBI.pm
> > >
> > > You could also create the tables yourself and then use a read only
> > > anonymous entry in the mysql.user grant table for minivend.
> 
> > I did create the tables manually and then MV started without errors,
> but
> > it did not populate the tables with data from products.asc and
> > pricing.asc.
> 
> > Incidently, it did create and populate the pricing table one time, but
> > not the products table.  Then I dropped the pricing table from MySQL
> to
> > see if it would do it again, and it never has created either one
> since.
> > I have dropped the minivend314 database and recreated it, but no luck.
> 
> > Murrah Boswell
> > otrcomm at wildapache dot net
> > >
> > > Dan
> > > --
> > >  Dan Busarow                                                  949 443
> 4172
> > >  Dana Point Communications, Inc.
> dan@dpcsys.com
> > >  Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD
> 0C 82
> > >
> > > -
> > > 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
> 
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com
> -
> 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