Re: stock_alert failure

On 03/06/2017 12:00 AM, [email protected] 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:* [email protected] <mailto:[email protected]>
>     *To:* [email protected] <mailto:[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] <mailto:[email protected]>
>         *To:* [email protected] <mailto:[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] <mailto:[email protected]>
>             *To:* [email protected] <mailto:[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
> 


-- 
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration.