Hi ppl,
I need to create a product with Sku 1310050111-8799050210-8786010210-1510050210, the problem is that VM doesn't allowed it...
It blows up!
I am thinking that this field is doing math... becouse, if I chande the fist digit from 1 to 9, like 9310050111-8799050210-8786010210-1510050210 it works as it should be!
Can somebody test this on your e-shops?
I need to know if this is a bug or something else...
Thank in advanced
Virtuemart should not do any kind math on this. The field is a varchar with length of 255. Do You have some plugin or extension that maybe mistreats the field.? Check with phpmyadmin that the field is correct.
Jörgen
Maybe the problem is that I changed my Porduct_sku index on DB by recommendation of Rolland (CSVI)...
Proceeded like described on this link!
https://rolandd.com/documentation/ro-csvi/virtuemart/speed-up-product-import (https://rolandd.com/documentation/ro-csvi/virtuemart/speed-up-product-import)
So, How can I undo that?
Messing with the db is Always risky if you do not know what you are doing. The problem is not indexing, 25 characters is not enough for your specific needs. Change the size to match your sku length.
Jörgen @ Kreativ Fotografi
Problem solved (increased index)
Thank you! :)