[ic] stock_alert failure

David_e at charter.net David_e at charter.net
Thu Mar 2 17:36:27 UTC 2017


Is there perhaps some way to override the requirement for stock alert? I have over 100 items that need to be manually entered because every import effort ends up requiring a complete recovery from backup.


  ----- 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/20170302/e8b3ba92/attachment.html>


More information about the interchange-users mailing list