[ic] stock_alert failure from error.log

Boyd Lynn Gerber gerberb at zenez.com
Fri Mar 10 09:30:28 UTC 2017


On Friday 2017-03-10 01:54, David Etheredge wrote:

>> 
>> 174.223.2.49 t6vUW3br:174.223.2.49 - [07/March/2017:10:57:08 -0600] holdonx
>> /cgi-bin/cart.cgi/ord/checkout Runtime error: list_fields execute on
>> "userdb": ERROR: relation "userdb" does not exist
>> 
>>> LINE 1: SELECT * FROM "userdb" WHERE 2 = 1
>> 
>>> ^ at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1986.
>> 
>>> 
>> 
>> 174.223.2.49 t6vUW3br:174.223.2.49 - [07/March/2017:10:57:08 -0600] holdonx
>> /cgi-bin/cart.cgi/ord/checkout Runtime error: list_fields execute on
>> "userdb": ERROR: relation "userdb" does not exist
>> 
>>> LINE 1: SELECT * FROM "userdb" WHERE 2 = 1
>> 
>>> ^ at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1986.
>> 
>> 80.82.65.82 uZzEHCzL:80.82.65.82 - [07/March/2017:11:06:55 -0600] holdonx
>> /cgi-bin/cart.cgi/logout Runtime error: list_fields execute on "userdb":
>> ERROR: relation "userdb" does not exist
>> 
>>> LINE 1: SELECT * FROM "userdb" WHERE 2 = 1
>> 
>>> ^ at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1986.
>
> Having the same problem with userdb even when the original strap userdb.txt 
> and userdb.mysql were restored to their directories.

I found I had to change my /etc/my.cnf to

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
sql_mode=""

I hope this helps

-- 
Boyd Gerber <gerberb at zenez.com> 801 849-0213
ZENEZ   1042 East Fort Union #135, Midvale Utah  84047




More information about the interchange-users mailing list