[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] MySQL database update problem
****** message to minivend-users from Matthew Emmerton <matt@compar.com> ******
On Tue, 27 Jun 2000, Sydney Urshan wrote:
> ****** 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.
Are you remembering to export the products database after you make updates
to the SKU? If not, then that is why you're having problems.
Minivend uses the flat-file for certain searching and indexing functions,
all of which centre around the SKU value. The other data is always fetched
from the database.
--
Matthew Emmerton
Computer Partners
IT Specialist
-
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
