[ic] stock_alert failure from error.log

David Etheredge davideth at whojamadoogle.com
Tue Mar 7 18:27:15 UTC 2017


- - - [07/March/2017:10:54:00 -0600] parade2 - STOP server (30066) on signal 
TERM

- - - [07/March/2017:10:54:00 -0600] parade2 - Removed catalog holdonx 
(/cgi-bin/cart.cgi)

- - - [07/March/2017:10:54:00 -0600] parade2 - Removed catalog parade2 
(/~parade2/cgi-bin/cart.cgi)

- - - [07/March/2017:10:54:04 -0600] - - Vend::Payment::AuthorizeNet payment 
module initialized, using Net::SSLeay

- - - [07/March/2017:10:54:04 -0600] - - Sending debug to 
/var/interchange/tmp/icdebug.

- - - [07/March/2017:10:54:04 -0600] - - Low traffic settings.

- - - [07/March/2017:10:54:05 -0600] - - ...UI is loaded...

- - - [07/March/2017:10:54:05 -0600] - - Interchange V5.10.0

- - - [07/March/2017:10:54:05 -0600] - - Running with old signals.

- - - [07/March/2017:10:54:05 -0600] - - Config 'holdonx' at server startup

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> username redefined to "varchar(64) NOT NULL PRIMARY 
KEY", was "varchar(64) NOT NULL PRIMARY KEY".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> usernick redefined to "varchar(64) NOT NULL", was 
"varchar(64) NOT NULL".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> password redefined to "varchar(64) NOT NULL", was 
"varchar(64) NOT NULL".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> expiration redefined to "varchar(32)", was 
"varchar(32)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> accounts redefined to "BLOB", was "BLOB".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> acl redefined to "text", was "text".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> address1 redefined to "varchar(64)", was 
"varchar(64)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> address2 redefined to "varchar(64)", was 
"varchar(64)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> address3 redefined to "varchar(64)", was 
"varchar(64)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> address_book redefined to "BLOB", was "BLOB".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> b_address1 redefined to "varchar(64)", was 
"varchar(64)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> b_address2 redefined to "varchar(64)", was 
"varchar(64)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> b_address3 redefined to "varchar(64)", was 
"varchar(64)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> b_city redefined to "varchar(30)", was 
"varchar(30)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> b_company redefined to "varchar(64)", was 
"varchar(64)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> b_country redefined to "varchar(10)", was 
"varchar(10)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> b_fname redefined to "varchar(30)", was 
"varchar(30)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> b_lname redefined to "varchar(30)", was 
"varchar(30)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> b_nickname redefined to "text", was "text".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> b_phone redefined to "varchar(30)", was 
"varchar(30)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> b_state redefined to "varchar(10)", was 
"varchar(10)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> b_zip redefined to "varchar(10)", was 
"varchar(10)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> carts redefined to "BLOB", was "BLOB".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> city redefined to "varchar(30)", was "varchar(30)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> company redefined to "varchar(64)", was 
"varchar(64)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> country redefined to "varchar(10)", was 
"varchar(10)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> created redefined to "varchar(32)", was 
"varchar(32)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> credit_limit redefined to "varchar(16)", was 
"varchar(16)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> db_acl redefined to "BLOB", was "BLOB".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> dealer redefined to "varchar(32)", was 
"varchar(32)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> email redefined to "varchar(42)", was 
"varchar(42)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> fax redefined to "varchar(30)", was "varchar(30)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> file_acl redefined to "BLOB", was "BLOB".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> fname redefined to "varchar(30)", was 
"varchar(30)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> inactive redefined to "varchar(8)", was 
"varchar(8)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> lname redefined to "varchar(30)", was 
"varchar(30)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> mail_list redefined to "text", was "text".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> mod_time redefined to "timestamp", was "timestamp".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> mv_shipmode redefined to "varchar(255)", was 
"varchar(255)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> owner redefined to "varchar(20)", was 
"varchar(20)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> p_nickname redefined to "text", was "text".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> phone_day redefined to "varchar(30)", was 
"varchar(30)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> phone_night redefined to "varchar(30)", was 
"varchar(30)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> price_level redefined to "varchar(30)", was 
"varchar(30)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> preferences redefined to "BLOB", was "BLOB".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> s_nickname redefined to "text", was "text".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> state redefined to "varchar(20)", was 
"varchar(20)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> updated redefined to "varchar(32)", was 
"varchar(32)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Database userdb explode 
parameter COLUMN_DEF --> zip redefined to "varchar(10)", was "varchar(10)".

- - - [07/March/2017:10:54:06 -0600] holdonx - Config 'parade2' at server 
startup

- - - [07/March/2017:10:54:08 -0600] parade2 - START server (1749) (INET and 
UNIX)

- - - [07/March/2017:10:54:08 -0600] parade2 - Accepting connections from 
localhost|127\.0\.0\.1

- - - [07/March/2017:10:54:08 -0600] parade2 - START server (1749) (INET and 
UNIX)

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.

>

_______________________ and userdb.mysql  ___________________

Database userdb userdb.txt __SQLDSN__

Database userdb DEFAULT_TYPE varchar(255)

Database userdb COLUMN_DEF "username=varchar(64) NOT NULL PRIMARY KEY"

Database userdb COLUMN_DEF "password=varchar(64) NOT NULL"

Database userdb COLUMN_DEF "accounts=BLOB"

Database userdb COLUMN_DEF "acl=text"

Database userdb COLUMN_DEF "address1=varchar(64)"

Database userdb COLUMN_DEF "address2=varchar(64)"

Database userdb COLUMN_DEF "address3=varchar(64)"

Database userdb COLUMN_DEF "address_book=BLOB"

Database userdb COLUMN_DEF "b_address1=varchar(64)"

Database userdb COLUMN_DEF "b_address2=varchar(64)"

Database userdb COLUMN_DEF "b_address3=varchar(64)"

Database userdb COLUMN_DEF "b_city=varchar(30)"

Database userdb COLUMN_DEF "b_company=varchar(64)"

Database userdb COLUMN_DEF "b_country=varchar(10)"

Database userdb COLUMN_DEF "b_fname=varchar(30)"

Database userdb COLUMN_DEF "b_lname=varchar(30)"

Database userdb COLUMN_DEF "b_nickname=text"

Database userdb COLUMN_DEF "b_phone=varchar(30)"

Database userdb COLUMN_DEF "b_state=varchar(10)"

Database userdb COLUMN_DEF "b_zip=varchar(10)"

Database userdb COLUMN_DEF "carts=BLOB"

Database userdb COLUMN_DEF "city=varchar(30)"

Database userdb COLUMN_DEF "company=varchar(64)"

Database userdb COLUMN_DEF "country=varchar(10)"

Database userdb COLUMN_DEF "created=varchar(32)"

Database userdb COLUMN_DEF "credit_limit=varchar(16)"

Database userdb COLUMN_DEF "db_acl=BLOB"

Database userdb COLUMN_DEF "dealer=varchar(32)"

Database userdb COLUMN_DEF "email=varchar(42)"

Database userdb COLUMN_DEF "fax=varchar(30)"

Database userdb COLUMN_DEF "file_acl=BLOB"

Database userdb COLUMN_DEF "fname=varchar(30)"

Database userdb COLUMN_DEF "inactive=varchar(8)"

Database userdb COLUMN_DEF "lname=varchar(30)"

Database userdb COLUMN_DEF "mail_list=text"

Database userdb COLUMN_DEF "mod_time=timestamp"

Database userdb COLUMN_DEF "mv_shipmode=varchar(255)"

Database userdb COLUMN_DEF "owner=varchar(20)"

Database userdb COLUMN_DEF "p_nickname=text"

Database userdb COLUMN_DEF "phone_day=varchar(30)"

Database userdb COLUMN_DEF "phone_night=varchar(30)"

Database userdb COLUMN_DEF "price_level=varchar(30)"

Database userdb COLUMN_DEF "preferences=BLOB"

Database userdb COLUMN_DEF "s_nickname=text"

Database userdb COLUMN_DEF "state=varchar(20)"

Database userdb COLUMN_DEF "updated=varchar(32)"

Database userdb COLUMN_DEF "zip=varchar(10)"

Database userdb PREFER_NULL mod_time




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.icdevgroup.org/pipermail/interchange-users/attachments/20170307/43d9528d/attachment.html>


More information about the interchange-users mailing list