Re: [mv] MySQL database update problem

[Hans-Joachim Leidinger <jojo@buchonline.net>]

******    message to minivend-users from Hans-Joachim Leidinger <jojo@buchonline.net>     ******

I´m in a muddle! Any changes of my own MySQL databases has an
immediately effect.
Maybe you have not define the NoImport directive in your catalog.cfg?

Joachim :-!

John Beima schrieb:
> 
> ******    message to minivend-users from John Beima <jbeima@palb.com>     ******
> 
> Actually this problem is kinda wierd...
> 
> We use phpMyAdmin to update the database, and just lik eyou said if you
> edit an existing code everything goes live fine, but if you add new items
> they don't appear.
> 
> The key to getting around this is one of two procedures.
> 
> First go into MiniMate and export the database/table back to the original
> text file, stop MiniVend and remove the database/table.sql file, restart
> MiniVend and when it re-imports the database/table it will work fine.
> 
> Two go to your searches and add teh parameter of "st=sql". This tells
> MiniVend to look at the sql tables and not the text source files.
> 
> Even though MiniVend is sposely looking at the MySQl tables, if the
> "code" is not in the source text file, it wont appear in your on-line
> catalog.
> 
> This was was a pain in my behind for a long time.
> 
> John Beima
> 
> Quoting Sydney Urshan <urshan@nethollywood.net>:
> 
> > ******    message to minivend-users from Sydney Urshan
> > <urshan@nethollywood.net>     ******
> >
> > I use MySQL (3.22.32 ) with MV 4.04.  I update the MySQL db directly
> > with wdbi (a web-based database editor).  If I update anything *but*
> > the code (sku), it works immediately in the mv catalog.  If I change
> > the sku or insert a new record, it screws up the results for that
> > record.  If I modify the flat file in /products (products.txt), it
> > works, but wdbi works on the MySQL db directly.
> >
> > Any thoughts would be greatly appreciated.
> >
> > Sydney Urshan
> >
> > please cc responses to me directly at urshan@nethollywood.net.


-- 
-------------Hans-Joachim Leidinger---------------------

-
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