[ic] stock_alert failure

[David_e at charter.net]

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

    ___________

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