Mailing List Archive

I have still not been able to find the cause of this but it is keeping us from entering any items into the database.


----- Original Message -----
From: David_e@charter.net
To: interchange-users@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

___________

Is there perhaps some way to override the requirement for stock alert? I have over 100 items that need to be manually entered because every import effort ends up requiring a complete recovery from backup.


----- Original Message -----
From: David_e@charter.net
To: interchange-users@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

___________

> On Mar 2, 2017, at 11:36 AM, David_e@charter.net wrote:
>
> Is there perhaps some way to override the requirement for stock alert? I have over 100 items that need to be manually entered because every import effort ends up requiring a complete recovery from backup.

Hi David,

What version of Interchange are you using, and do you know the catalog type you used to create this?

Have you verified if that table exists in your database as expected? You might verify that the SQLDSN param is set in catalog.cfg and that you’re able to connect to the database using that param.

If you don’t need the stock alert, you could try removing it from dbconf and disabling any regular jobs which would rely on that. There also might be some admin functionality which may no longer work.

Best,

David

--
David Christensen
End Point Corporation
david@endpoint.com
785-727-1171




_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

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@charter.net
To: interchange-users@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

___________

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






----- Original Message -----
From: David_e@charter.net
To: interchange-users@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@charter.net
To: interchange-users@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

___________

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, <David_e@charter.net> <David_e@charter.net> wrote:
>
> Removing stock alert did help but still having:
> table userdb index failed: ERROR: relation "userdb" does not exist
>
>
>
>
>
>> ----- Original Message -----
>> From: David_e@charter.net
>> To: interchange-users@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@charter.net
>>> To: interchange-users@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@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

--
David Christensen
End Point Corporation
david@endpoint.com
785-727-1171




_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

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@charter.net
To: interchange-users@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@charter.net
To: interchange-users@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@charter.net
To: interchange-users@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

___________

On 03/06/2017 12:00 AM, David_e@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@charter.net <mailto:David_e@charter.net>
> *To:* interchange-users@icdevgroup.org <mailto:interchange-users@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@charter.net <mailto:David_e@charter.net>
> *To:* interchange-users@icdevgroup.org <mailto:interchange-users@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@charter.net <mailto:David_e@charter.net>
> *To:* interchange-users@icdevgroup.org <mailto:interchange-users@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@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
>


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

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users