Advanced
Mailing List Archive

Mailing List Archive

  1. Home >
  2. Interchange>
  3. users
stock_alert failure from error.log
davideth at whojamadoogle
Mar 7, 2017, 10:27 AM
Post #1 of 5 (952 views)
Permalink
- - - [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
Re: stock_alert failure from error.log [ In reply to ]
davideth at whojamadoogle
Mar 9, 2017, 11:54 PM
Post #2 of 5 (950 views)
Permalink
>
> 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.


_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users
Re: stock_alert failure from error.log [ In reply to ]
gerberb at zenez
Mar 10, 2017, 1:30 AM
Post #3 of 5 (950 views)
Permalink
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@zenez.com> 801 849-0213
ZENEZ 1042 East Fort Union #135, Midvale Utah 84047


_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users
Re: stock_alert failure from error.log [ In reply to ]
davideth at whojamadoogle
Mar 10, 2017, 7:58 AM
Post #4 of 5 (949 views)
Permalink
>
> 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
> .

Modifying the my.cnf file did not help.


When adding to the userdb, this is the error generated.

(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. )
Re: stock_alert failure from error.log [ In reply to ]
gerberb at zenez
Mar 10, 2017, 10:17 AM
Post #5 of 5 (946 views)
Permalink
On Friday 2017-03-10 09:58, David Etheredge wrote:
>>
>> 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
>> .
>
> Modifying the my.cnf file did not help.

Did you restart your DB? I was getting the exact same error.

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

©2024 GT.net. A Gossamer Threads company.
5th Floor, 455 Granville St., Vancouver, BC V6C 1T1, Canada | Legal