[ic] stock_alert failure

David_e at charter.net David_e at charter.net
Tue Feb 28 18:52:01 UTC 2017




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/20170228/a4c7332a/attachment.html>


More information about the interchange-users mailing list