[ic] stock_alert failure

[David Christensen]

Sounds like your SQLDSN might not be set correctly; do you see the tables when you connect directly to the database?

> On Mar 3, 2017, at 4:36 PM, <David_e at charter.net> <David_e at charter.net> wrote:
> 
> Removing stock alert did help but still having: 
> table userdb index failed: ERROR:  relation "userdb" does not exist
>  
>  
>  
>  
>  
>> ----- Original Message -----
>> From: David_e at charter.net
>> To: interchange-users at icdevgroup.org
>> Sent: Thursday, March 02, 2017 11:55 AM
>> Subject: Re: [ic] stock_alert failure
>> 
>> Using Strap on 5.10.0
>>  
>> Also, checking further, I find that it is blocking the UI from making any changes to any of the data bases.
>>  
>> Will try removing the stock alert temporarily.
>>  
>>  
>>> ----- Original Message -----
>>> From: David_e at charter.net
>>> To: interchange-users at icdevgroup.org
>>> Sent: Tuesday, February 28, 2017 12:52 PM
>>> Subject: [ic] stock_alert failure
>>> 
>>>  
>>>  
>>>  
>>> table stock_alert index failed: ERROR:  relation "stock_alert" does not exist
>>> table 'stock_alert' failed: list_fields execute on "stock_alert": ERROR:  relation "stock_alert" does not exist
>>> LINE 1: SELECT * FROM "stock_alert" WHERE 2 = 1
>>>                       ^ at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1986.
>>> From stock_alert.mysql
>>> ___________
>>> Database stock_alert stock_alert.txt __SQLDSN__
>>> Database stock_alert COLUMN_DEF "uid=int(11) NOT NULL auto_increment primary key"
>>> Database stock_alert COLUMN_DEF "sku=varchar(20) DEFAULT '' NOT NULL"
>>> Database stock_alert COLUMN_DEF "price=decimal(10,2) DEFAULT '0.00' NOT NULL"
>>> Database stock_alert COLUMN_DEF "description=varchar(255) DEFAULT '' NOT NULL"
>>> Database stock_alert COLUMN_DEF "fname=varchar(255) DEFAULT NULL"
>>> Database stock_alert COLUMN_DEF "lname=varchar(255) DEFAULT NULL"
>>> Database stock_alert COLUMN_DEF "email=varchar(255) DEFAULT '' NOT NULL"
>>> Database stock_alert COLUMN_DEF "date=date DEFAULT '0000-00-00' NOT NULL"
>>> Database stock_alert CREATE_EMPTY_TXT 1
>>> Database stock_alert NAME uid sku price description fname lname email date
>>> ___________
>>>  
>>>  
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

--
David Christensen
End Point Corporation
david at endpoint.com
785-727-1171