<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.5512" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><PRE>The other tables appear to build successfully. orderline, transactions, pricing, etc. At least there is a .sql for each.</PRE><PRE> </PRE><PRE> </PRE><PRE> </PRE></DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial"><PRE>Sounds like your SQLDSN might not be set correctly; do you see the tables when you connect directly to the database?
</PRE></DIV>
<DIV style="FONT: 10pt arial"> </DIV>
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=David_e@charter.net
href="mailto:David_e@charter.net">David_e@charter.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=interchange-users@icdevgroup.org
href="mailto:interchange-users@icdevgroup.org">interchange-users@icdevgroup.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, March 03, 2017 4:36
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [ic] stock_alert
failure</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Removing stock alert did help but still having:
<BR>table userdb index failed: ERROR: relation "userdb" does not
exist<BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> </DIV></FONT>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=David_e@charter.net
href="mailto:David_e@charter.net">David_e@charter.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=interchange-users@icdevgroup.org
href="mailto:interchange-users@icdevgroup.org">interchange-users@icdevgroup.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, March 02, 2017 11:55
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [ic] stock_alert
failure</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Using Strap on 5.10.0</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Also, checking further, I find that it is
blocking the UI from making any changes to any of the data
bases.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Will try removing the stock alert
temporarily.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=David_e@charter.net
href="mailto:David_e@charter.net">David_e@charter.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=interchange-users@icdevgroup.org
href="mailto:interchange-users@icdevgroup.org">interchange-users@icdevgroup.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, February 28, 2017
12:52 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [ic] stock_alert
failure</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>table stock_alert index failed: ERROR:
relation "stock_alert" does not exist<BR>table 'stock_alert' failed:
list_fields execute on "stock_alert": ERROR: relation "stock_alert"
does not exist<BR>LINE 1: SELECT * FROM "stock_alert" WHERE 2 =
1<BR>
^ at /usr/local/interchange/lib/Vend/Table/DBI.pm line
1986.<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>From stock_alert.mysql</FONT></DIV>
<DIV><FONT face=Arial size=2>___________</FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN lang=EN>
<P>Database stock_alert stock_alert.txt __SQLDSN__</P>
<P>Database stock_alert COLUMN_DEF "uid=int(11) NOT NULL auto_increment
primary key"</P>
<P>Database stock_alert COLUMN_DEF "sku=varchar(20) DEFAULT '' NOT
NULL"</P>
<P>Database stock_alert COLUMN_DEF "price=decimal(10,2) DEFAULT '0.00' NOT
NULL"</P>
<P>Database stock_alert COLUMN_DEF "description=varchar(255) DEFAULT ''
NOT NULL"</P>
<P>Database stock_alert COLUMN_DEF "fname=varchar(255) DEFAULT NULL"</P>
<P>Database stock_alert COLUMN_DEF "lname=varchar(255) DEFAULT NULL"</P>
<P>Database stock_alert COLUMN_DEF "email=varchar(255) DEFAULT '' NOT
NULL"</P>
<P>Database stock_alert COLUMN_DEF "date=date DEFAULT '0000-00-00' NOT
NULL"</P>
<P>Database stock_alert CREATE_EMPTY_TXT 1</P>
<P>Database stock_alert NAME uid sku price description fname lname email
date</P>
<DIV><FONT face=Arial size=2>___________</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV></SPAN></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></FONT></BODY></HTML>