Re: [mv] MySQL database update problem

[Sydney Urshan <urshan@nethollywood.net>]

******    message to minivend-users from Sydney Urshan <urshan@nethollywood.net>     ******

I tried "NoImport products" per Joachim in catalog.cfg, but it did 
not work.  I tried commenting out the products line in 
mysql/products.mysql and then nothing worked.  Then I did the st=sql 
(actually <INPUT TYPE=hidden NAME=mv_searchtype VALUE=sql> in my 
testing) and it worked, so I'll stick with that one.  Seems much 
better than reloading the db every 5 minutes!

Thanks for saving me a couple days sweat!

Sydney Urshan

>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