stock_alert failure from error.log

"David Etheredge" <[email protected]>
Newsgroups gmane.comp.web.interchange.users
Message-ID <B482817F74F1440F81A7F08E9ABF1936@blackbox> 
- - - [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

_______________________________________________
interchange-users mailing list
[email protected]
http://www.icdevgroup.org/mailman/listinfo/interchange-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.