Re: stock_alert failure

I have still not been able to find the cause of this but it is keeping us from entering any items into the database.


  ----- Original Message ----- 
  From: [email protected] 
  To: [email protected] 
  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
[email protected]
http://www.icdevgroup.org/mailman/listinfo/interchange-users