[ic] stock_alert failure
Stefan Hornburg (Racke)
racke at linuxia.de
Mon Mar 6 07:12:32 UTC 2017
On 03/06/2017 12:00 AM, David_e at charter.net wrote:
> The other tables appear to build successfully. orderline, transactions, pricing, etc. At least there is a .sql for each.
>
>
So there is probably an error creating these tables which are now missing. Please restart and report the error messages
here.
Regards
Racke
>
>
>
>
>
> 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 <mailto:David_e at charter.net>
> *To:* interchange-users at icdevgroup.org <mailto: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 <mailto:David_e at charter.net>
> *To:* interchange-users at icdevgroup.org <mailto: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 <mailto:David_e at charter.net>
> *To:* interchange-users at icdevgroup.org <mailto: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
>
> ___________
>
>
>
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>
--
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration.
More information about the interchange-users
mailing list