[ic] stock_alert failure
David_e at charter.net
David_e at charter.net
Sun Mar 5 23:00:47 UTC 2017
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: David_e at charter.net
To: interchange-users at icdevgroup.org
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: David_e at charter.net
To: interchange-users at icdevgroup.org
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: 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/20170305/12561ad0/attachment.html>
More information about the interchange-users
mailing list