Akopia Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

[mv] Wrong db-count in MV3 and MV4



******    message to minivend-users from jojo@buchonline.net     ******

Hi List,

I use [db-count products] and I get a weird results!
At first, I've 490 items and [db-count..] print out "265".
ONe cause of this behavior is the period "." without any space befor
and after this for example "Hello.World". 

I try to find out another cause of the wrong results by [db-count...].
Step by step, I've add some and some items. At the 420 item, I get "421"
instead of "420" by [db-count..]. I've found the place. It is the sku
number "3779913054". If I change this to "37799x13054", I get the right
count as "420". This is the list of some results:

SKU               db-count
3779913054        421  <--- WRONG!
377991305         420
37799x13054       420
377991305 4       421  <--- WRONG!
377991 305 4      420
377991305x4       420
9999913054        420
9779913054        420
1779913054        420
13054             420
1305              420
etc..

After using 

 [tag export products exppro]Proceed[/tag]

and diff -u products.asc exppro > DIFF

I get

----------snipp------------
--- sortpro	Thu Jun 29 14:30:11 2000
+++ sortexp	Thu Jun 29 14:30:21 2000
@@ -402,6 +402,7 @@
 3779912120	3-7799-1212-0	
 3779912317	3-7799-1231-7
 3779912325	3-7799-1232-5  <------
+3779912325	3-7799-1232-5  <------ Why twice???
 3779912333	3-7799-1233-3
 3779912341	3-7799-1234-1
 3779912511	3-7799-1251-1
----------snipp------------

Removeing the item "3779912325", I get the right count "420".
Adding this item at the last item. I get the wrong count "421" again.
Changing this as "37799x12325", I get the right count "420".

After using

 [tag export products exppro]Proceed[/tag]

again and diff -u products.asc exppro > DIFF

I get

----------snipp------------
--- sortpro	Thu Jun 29 14:50:48 2000
+++ sortexp	Thu Jun 29 14:50:09 2000
@@ -418,4 +418,5 @@
 3779913038	3-7799-1303-8
 3779913046	3-7799-1304-6
 3779913054	3-7799-1305-4 <------
+3779913054	3-7799-1305-4 <------ Why twice???
----------snipp------------


Very strange! 8-0

Any hints, helps and suggestions?

Thanks!

Joachim


-- 
Hans-Joachim Leidinger
buch online                 jojo@buchonline.net
Munscheidstr. 14            FAX: +49 209 1671449
45886 Gelsenkirchen         FAX: 0209 1671449

-
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


Search for: Match: Format: Sort by: