Re: stock_alert failure
David Christensen <[email protected]>
| Newsgroups | gmane.comp.web.interchange.users |
|---|---|
| Message-ID | <[email protected]> |
Sounds like your SQLDSN might not be set correctly; do you see the tables when you connect directly to the database? > On Mar 3, 2017, at 4:36 PM, <[email protected]> <[email protected]> wrote: > > 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 -- David Christensen End Point Corporation [email protected] 785-727-1171