Re: stock_alert failure

The other tables appear to build successfully. orderline, transactions, pricing, etc. At least there is a .sql for each.Sounds like your SQLDSN might not be set correctly; do you see the tables when you connect directly to the database?

  ----- Original Message ----- 
  From: [email protected] 
  To: [email protected] 
  Sent: Friday, March 03, 2017 4:36 PM
  Subject: Re: [ic] stock_alert failure


  Removing stock alert did help but still having: 
  table userdb index failed: ERROR:  relation "userdb" does not exist






    ----- Original Message ----- 
    From: [email protected] 
    To: [email protected] 
    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: [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