Re: [mv] MySQL database update problem

[John Beima <jbeima@palb.com>]

******    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.
> -
> 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