Re: stock_alert failure from error.log
Boyd Lynn Gerber <[email protected]>
| Newsgroups | gmane.comp.web.interchange.users |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]> 801 849-0213 ZENEZ 1042 East Fort Union #135, Midvale Utah 84047