Re: [mv] MySQL database update problem

[Stefan Hornburg <racke@linuxia.de>]

******    message to minivend-users from Stefan Hornburg <racke@linuxia.de>     ******

John Beima <jbeima@palb.com> writes:

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

Hmm... maybe you should add the SQL tables to "NoImport". 

Ciao
        Racke

-- 
LinuXia Systems && Cobolt NetServices, eCommerce and more
Shop- und Datenbanklösungen mit MiniVend, Firewalls auf Debian-Basis
http://www.linuxia.de - http://www.cobolt.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