Mailing List Archive: variant table delete error

: Must input some sort of search -- at least 2 characters total

When trying to delete defunct items from the variant table, I am getting
the error above. This in the latest version of Strap installed by
Endpoint on my server.
Error log:
query was:insert into inventory (`sku`,`quantity`) VALUES (?,?)
> values were:'36807-835 Truffle',''
68.166.116.32 vMVmiQRG:68.166.116.32 - [31/May/2018:05:07:13 -0400]
basicq /cgi-bin/basicq/admin/flex_editor set_slice error as called by
Vend::Data: DBD::mysql::st execute failed: Incorrect integer value: ''
for column 'quantity' at row 1 at
/home/interch/live/interchange/lib/Vend/Table/DBI.pm line 1453.
>
See no comments on it in the docs.
Kerry
--
BasicQ Inc.
PO Box 381
Boca Raton, FL 33429

Phone: 800-448-0665
email: kerry@basicq.com
www.basicq.com
https://johnson.basicq.com

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

On Thu, 31 May 2018, kerry wrote:

> : Must input some sort of search -- at least 2 characters total
>
> When trying to delete defunct items from the variant table, I am getting
> the error above. This in the latest version of Strap installed by
> Endpoint on my server.
> Error log:
> query was:insert into inventory (`sku`,`quantity`) VALUES (?,?)
>> values were:'36807-835 Truffle',''
> 68.166.116.32 vMVmiQRG:68.166.116.32 - [31/May/2018:05:07:13 -0400]
> basicq /cgi-bin/basicq/admin/flex_editor set_slice error as called by
> Vend::Data: DBD::mysql::st execute failed: Incorrect integer value: ''
> for column 'quantity' at row 1 at
> /home/interch/live/interchange/lib/Vend/Table/DBI.pm line 1453.

You might try updating the database config for the inventory table to say
NULL is preferred to an empty string, in
dist/strap/dbconf/mysql/inventory.mysql:

Database inventory PREFER_NULL quantity

Old versions of MySQL tolerated bogus data like an empty string '' for a
numeric column, but newer versions no longer do, by default.

Jon

--
Jon Jensen
End Point Corporation
https://www.endpoint.com/

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users