[ic] Re: Interchange 4.6.1 and MySQL, Vol 1 #207 - 4 msgs re- msg 2

Greg St.Onge greg@lswwm.com
Wed, 20 Dec 2000 18:14:17 -0500


Greg St.Onge
LightSpeed Software Leading the Way!
On the web at www.lswwm.com

Get a FREE email certificate at
         www.thawte.com
----- Original Message -----
From: <interchange-users-admin@lists.akopia.com>
To: <interchange-users@lists.akopia.com>
Sent: Wednesday, December 20, 2000 1:46 PM
Subject: Interchange-users digest, Vol 1 #207 - 4 msgs


>
> Send Interchange-users mailing list submissions to
> interchange-users@lists.akopia.com
>
> To subscribe or unsubscribe via the web, visit
> http://lists.akopia.com/mailman/listinfo/interchange-users
> or, via email, send a message with subject or body 'help' to
> interchange-users-request@lists.akopia.com
> You can reach the person managing the list at
> interchange-users-admin@lists.akopia.com
>
> When replying, please edit your Subject line so it is more specific than
> "Re: Contents of Interchange-users digest..."
>
>
> Today's Topics:
>
>   1. Re: new payment method broke, broswer dependent (Doug Alcorn)
>   2. RE: Interchange 4.6.1 and MySQL 3.23 (Cameron B. Prince)
>   3. RE: Interchange 4.6.1 and MySQL 3.23 (Eric Hull)
>   4. RE: Interchange 4.6.1 and MySQL 3.23 (Eric Hull)
>
> --__--__--
>
> Message: 1
> To: interchange-users@minivend.com
> Subject: Re: [ic] new payment method broke, broswer dependent
> <20001220115932.A5611@bill.minivend.com>
> From: Doug Alcorn <doug@lathi.net>
> Date: 20 Dec 2000 13:27:26 -0500
> Reply-To: interchange-users@lists.akopia.com
>
> Mike Heins <mikeh@minivend.com> writes:
>
> > Quoting Doug Alcorn (doug@lathi.net):
> > > I have a store that accepts money orders and cashier's checks.  What
> > > they want to do is display the mailing address when the customer
> > > selects that payment method (on the bottom of the checkout screen,
> > > mail_receipt, and receipt.html).  The catalog is pretty much a
> > > straight construct out of IC 4.6.0.  Here's my mods to
> > > pages/ord/checkout.html:
> > >
> >
> > When in doubt on something like this, put this at the top of the
> > checkout page
> >
> >     <!-- [dump] -->
> >
> > then display the source after your submit.
>
> Good tip, thx.
>
> > Also, you should look at checkout_profile in etc/profiles.order
> > and see what it defaults to if it gets a fax_order setting it
> > doesn't know about.
>
> This was the problem. If fax_order is not set it defaults to credit
> card.  Since my checkout page didn't set any cc info, the order was
> incomplete.  I just changed my checkout page to set fax_order to 1
> (which is just Check or Money Order).
>
> Thanks for the speedy reply!
> --
>  (__) Doug Alcorn (mailto:doug@lathi.net http://www.lathi.net)
>  oo / PGP 02B3 1E26 BCF2 9AAF 93F1  61D7 450C B264 3E63 D543
>  |_/  If you're a capitalist and you have the best goods and they're
>       free, you don't have to proselytize, you just have to wait.
>
>
> --__--__--
>
> Message: 2
> Reply-To: <cameron@akopia.com>
> From: "Cameron B. Prince" <cameron@akopia.com>
> To: <interchange-users@lists.akopia.com>
> Subject: RE: [ic] Interchange 4.6.1 and MySQL 3.23
> Date: Wed, 20 Dec 2000 12:37:20 -0600
> boundary="----=_NextPart_000_0006_01C06A81.98932740"
> Reply-To: interchange-users@lists.akopia.com
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0006_01C06A81.98932740
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> Can you confirm that you have the proper rights granted in the MySQL user
> table? Something like this:
>
> | Host              | User      | Password         | Select_priv |
> Insert_priv | Update_priv | Delete_priv | Create_priv |
>  Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv |
> Grant_priv | References_priv | Index_priv |
>  Alter_priv |
>
> | localhost         | dgc   | 470aee162402249e | Y           | Y
|
> Y           | Y           | Y           |
>  Y         | N           | N             | N            | Y         | N
> | N               | Y          | Y          |
>
>
> Good luck,
>
> Cameron
>
>   -----Original Message-----
>   From: interchange-users-admin@lists.akopia.com
> [mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Thomas
McAlees
>   Sent: Wednesday, December 20, 2000 12:16 PM
>   To: interchange-users@lists.akopia.com
>   Subject: [ic] Interchange 4.6.1 and MySQL 3.23
>
>
>   I'm new to Interchange but I've found the install and configuration to
be
> very reasonable.  I have encountered only one problem that I can't seem to
> get past.  When I create a new catalog and configure it to use MySQL, I'm
> receiving error while trying to create the database indexes.  The tables
are
> all created but I receive the following error for every table:
>
>   table xxxxxxx index failed: Access denied for user: 'dgc@localhost' to
> database 'dgc'
>
>   I don't understand why I'm getting an access denied error for the index,
> but the tables are being created just fine.
>
>   Additional Information:
>
>   The site is hosted by an ISP and I only have access to a single MySQL
> database that is already created.  I've provided the appropriate
> login/password information to the makecat script and it IS creating the
> tables so I know the connection to the database is working.  Even with the
> index creation error I can access the Interchange store and perform just
> about every function.  The only thing I've been unable to do is update the
> inventory.  When I try I get this error 'Sorry, there was an error in
> processing this form action. Please report the error or try again later.
> (You have an error in your SQL syntax near '= NULL where sku = 'os28113' '
> at line 1 )'.  I'm not sure if this is related to the index problem, but
> that is where I'm starting.
>
>   Any help would be greatly appreciated!
>
>   Tom McAlees
>   tmcalees@rochester.rr.com
>

Hello,
            I have had this same problem with this error"> (You have an
error in your SQL syntax near '= NULL where sku = 'os28113' '
> at line 1 )'  Under the admin section. Just click on tables. Scroll to
inventory. Click on the far right. It kinda looks like a text document. And
edit away. It worked for me......

Jeremy Peel,

Greg St.Onge
LightSpeed Software Leading the Way!
On the web at www.lswwm.com

Get a FREE email certificate at
         www.thawte.com




> ------=_NextPart_000_0006_01C06A81.98932740
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html; =
> charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
> size=3D2>Can=20
> you confirm that you have the proper rights granted in the MySQL user =
> table?=20
> Something like this:</FONT></SPAN></DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
>
> size=3D2></FONT></SPAN>&nbsp;</DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
> size=3D2>|=20
> Host&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
> sp;&nbsp;=20
> | User&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
> Password&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Select_priv | =
>
> Insert_priv | Update_priv | Delete_priv | Create_priv =
> |</FONT></SPAN></DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
>
> size=3D2>&nbsp;Drop_priv | Reload_priv | Shutdown_priv | Process_priv | =
> File_priv=20
> | Grant_priv | References_priv | Index_priv |</FONT></SPAN></DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
>
> size=3D2>&nbsp;Alter_priv |</FONT></SPAN></DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
>
> size=3D2></FONT></SPAN>&nbsp;</DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
> size=3D2>|=20
> localhost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> |&nbsp;dgc&nbsp;&nbsp;=20
> | 470aee162402249e |=20
> Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
> Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
> Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
> Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
> Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
> |</FONT></SPAN></DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
>
> size=3D2>&nbsp;Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
> N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
> N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
>  |=20
> N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
> Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
> N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
> N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
> &nbsp;&nbsp;=20
> | Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
> Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> |</FONT></SPAN></DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
>
> size=3D2></FONT></SPAN>&nbsp;</DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
>
> size=3D2></FONT></SPAN>&nbsp;</DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
> size=3D2>Good=20
> luck,</FONT></SPAN></DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
>
> size=3D2></FONT></SPAN>&nbsp;</DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
>
> size=3D2>Cameron</FONT></SPAN></DIV>
> <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial color=3D#0000ff =
>
> size=3D2></FONT></SPAN>&nbsp;</DIV>
> <BLOCKQUOTE dir=3Dltr=20
> style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
> solid; MARGIN-RIGHT: 0px">
>   <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
> face=3DTahoma=20
>   size=3D2>-----Original Message-----<BR><B>From:</B>=20
>   interchange-users-admin@lists.akopia.com=20
>   [mailto:interchange-users-admin@lists.akopia.com]<B>On Behalf Of =
> </B>Thomas=20
>   McAlees<BR><B>Sent:</B> Wednesday, December 20, 2000 12:16 =
> PM<BR><B>To:</B>=20
>   interchange-users@lists.akopia.com<BR><B>Subject:</B> [ic] Interchange =
> 4.6.1=20
>   and MySQL 3.23<BR><BR></FONT></DIV>
>   <DIV><FONT face=3DArial size=3D2>I'm new to Interchange but I've found =
> the install=20
>   and configuration to be very reasonable.&nbsp; I have encountered only =
> one=20
>   problem that I can't seem to get past.&nbsp; When I create a new =
> catalog and=20
>   configure it to use MySQL, I'm receiving error while trying to create =
> the=20
>   database indexes.&nbsp; The tables are all created but I receive the =
> following=20
>   error for every table:</FONT></DIV>
>   <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>   <DIV><FONT face=3DArial size=3D2>table&nbsp;xxxxxxx index failed: =
> Access denied=20
>   for user: <A href=3D"mailto:'dgc@localhost'">'dgc@localhost'</A> to =
> database=20
>   'dgc'</FONT></DIV>
>   <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>   <DIV><FONT face=3DArial size=3D2>I don't understand why I'm getting an =
> access=20
>   denied error for the index, but the tables are being created just =
> fine.&nbsp;=20
>   </FONT></DIV>
>   <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>   <DIV><FONT face=3DArial size=3D2>Additional Information:</FONT></DIV>
>   <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>   <DIV><FONT face=3DArial size=3D2>The site is hosted by an ISP and I =
> only have=20
>   access to a single MySQL database that is already created.&nbsp; I've =
> provided=20
>   the appropriate login/password information to the makecat script and =
> it IS=20
>   creating the tables so I know the connection to the database is =
> working.&nbsp;=20
>   Even with the index creation error I can access the Interchange store =
> and=20
>   perform just about every function.&nbsp; The only thing I've been =
> unable to do=20
>   is update the inventory.&nbsp; When I try I get this error 'Sorry, =
> there was=20
>   an error in processing this form action. Please report the error or =
> try again=20
>   later. (You have an error in your SQL syntax near '=3D NULL where sku =
> =3D=20
>   'os28113' ' at line 1 )'.&nbsp; I'm not sure if this is related to the =
> index=20
>   problem, but that is where I'm starting.</FONT></DIV>
>   <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>   <DIV><FONT face=3DArial size=3D2>Any help would be greatly=20
>   appreciated!</FONT></DIV>
>   <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>   <DIV><FONT face=3DArial size=3D2>Tom McAlees</FONT></DIV>
>   <DIV><FONT face=3DArial=20
> size=3D2>tmcalees@rochester.rr.com</FONT></DIV></BLOCKQUOTE></BODY></HTML=
> >
>
> ------=_NextPart_000_0006_01C06A81.98932740--
>
>
> --__--__--
>
> Message: 3
> Reply-To: <eric@webuildpcs.com>
> From: "Eric Hull" <eric@webuildpcs.com>
> To: <interchange-users@lists.akopia.com>
> Subject: RE: [ic] Interchange 4.6.1 and MySQL 3.23
> Date: Wed, 20 Dec 2000 12:50:17 -0600
> boundary="----=_NextPart_000_0004_01C06A83.67234A80"
> Reply-To: interchange-users@lists.akopia.com
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0004_01C06A83.67234A80
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> I have found that using MS Access via ODBC I have to set the permissions
to
> have "%" for the host - any other way will not work.  Our server is at
> another location and we access it via ADSL.  I can log into the server as
> root even and something in the dns gives it errors.  I have tried IP
> numbers, domain names, everything.  only wide open will it work.  We are
> just sure to use strong passwords and usernames, untill we can find a
> workaround.
>
> Eric Hull
>
>   -----Original Message-----
>   From: interchange-users-admin@lists.akopia.com
> [mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Cameron B.
> Prince
>   Sent: Wednesday, December 20, 2000 12:37 PM
>   To: interchange-users@lists.akopia.com
>   Subject: RE: [ic] Interchange 4.6.1 and MySQL 3.23
>
>
>   Can you confirm that you have the proper rights granted in the MySQL
user
> table? Something like this:
>
>   | Host              | User      | Password         | Select_priv |
> Insert_priv | Update_priv | Delete_priv | Create_priv |
>    Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv |
> Grant_priv | References_priv | Index_priv |
>    Alter_priv |
>
>   | localhost         | dgc   | 470aee162402249e | Y           | Y
> | Y           | Y           | Y           |
>    Y         | N           | N             | N            | Y         | N
> | N               | Y          | Y          |
>
>
>   Good luck,
>
>   Cameron
>
>     -----Original Message-----
>     From: interchange-users-admin@lists.akopia.com
> [mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Thomas
McAlees
>     Sent: Wednesday, December 20, 2000 12:16 PM
>     To: interchange-users@lists.akopia.com
>     Subject: [ic] Interchange 4.6.1 and MySQL 3.23
>
>
>     I'm new to Interchange but I've found the install and configuration to
> be very reasonable.  I have encountered only one problem that I can't seem
> to get past.  When I create a new catalog and configure it to use MySQL,
I'm
> receiving error while trying to create the database indexes.  The tables
are
> all created but I receive the following error for every table:
>
>     table xxxxxxx index failed: Access denied for user: 'dgc@localhost' to
> database 'dgc'
>
>     I don't understand why I'm getting an access denied error for the
index,
> but the tables are being created just fine.
>
>     Additional Information:
>
>     The site is hosted by an ISP and I only have access to a single MySQL
> database that is already created.  I've provided the appropriate
> login/password information to the makecat script and it IS creating the
> tables so I know the connection to the database is working.  Even with the
> index creation error I can access the Interchange store and perform just
> about every function.  The only thing I've been unable to do is update the
> inventory.  When I try I get this error 'Sorry, there was an error in
> processing this form action. Please report the error or try again later.
> (You have an error in your SQL syntax near '= NULL where sku = 'os28113' '
> at line 1 )'.  I'm not sure if this is related to the index problem, but
> that is where I'm starting.
>
>     Any help would be greatly appreciated!
>
>     Tom McAlees
>     tmcalees@rochester.rr.com
>
> ------=_NextPart_000_0004_01C06A83.67234A80
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html; =
> charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><SPAN class=3D460114718-20122000><FONT face=3DArial size=3D2>I have =
> found that=20
> using MS Access via ODBC I have to set the permissions to have "%" for =
> the host=20
> - any other way will not work.&nbsp;&nbsp;Our server is at another =
> location and=20
> we access it via ADSL.&nbsp; I can&nbsp;log into the server as root even =
> and=20
> something in the dns gives it errors.&nbsp; I have tried IP numbers, =
> domain=20
> names, everything.&nbsp; only wide open will it work.&nbsp; We are just =
> sure to=20
> use strong passwords and usernames, untill we can find a=20
> workaround.</FONT></SPAN></DIV>
> <DIV><SPAN class=3D460114718-20122000><FONT face=3DArial=20
> size=3D2></FONT></SPAN>&nbsp;</DIV>
> <DIV><SPAN class=3D460114718-20122000><FONT face=3DArial size=3D2>Eric=20
> Hull</FONT></SPAN></DIV>
> <DIV><SPAN class=3D460114718-20122000><FONT face=3DArial size=3D2>&nbsp; =
>
> </FONT></SPAN></DIV>
> <BLOCKQUOTE dir=3Dltr=20
> style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px =
> solid; MARGIN-RIGHT: 0px">
>   <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
> face=3DTahoma=20
>   size=3D2>-----Original Message-----<BR><B>From:</B>=20
>   interchange-users-admin@lists.akopia.com=20
>   [mailto:interchange-users-admin@lists.akopia.com]<B>On Behalf Of =
> </B>Cameron=20
>   B. Prince<BR><B>Sent:</B> Wednesday, December 20, 2000 12:37 =
> PM<BR><B>To:</B>=20
>   interchange-users@lists.akopia.com<BR><B>Subject:</B> RE: [ic] =
> Interchange=20
>   4.6.1 and MySQL 3.23<BR><BR></FONT></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff size=3D2>Can=20
>   you confirm that you have the proper rights granted in the MySQL user =
> table?=20
>   Something like this:</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2></FONT></SPAN>&nbsp;</DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff size=3D2>|=20
>   =
> Host&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
> sp;&nbsp;=20
>   | User&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Password&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Select_priv =
> |=20
>   Insert_priv | Update_priv | Delete_priv | Create_priv =
> |</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2>&nbsp;Drop_priv | Reload_priv | Shutdown_priv | Process_priv =
> |=20
>   File_priv | Grant_priv | References_priv | Index_priv =
> |</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2>&nbsp;Alter_priv |</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2></FONT></SPAN>&nbsp;</DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff size=3D2>|=20
>   localhost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
>   |&nbsp;dgc&nbsp;&nbsp; | 470aee162402249e |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
>   |</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2>&nbsp;Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   =
> N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
>  |=20
>   N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   =
> N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
> &nbsp;&nbsp;=20
>   | Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> |</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2></FONT></SPAN>&nbsp;</DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2></FONT></SPAN>&nbsp;</DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff size=3D2>Good=20
>   luck,</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2></FONT></SPAN>&nbsp;</DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2>Cameron</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2></FONT></SPAN>&nbsp;</DIV>
>   <BLOCKQUOTE dir=3Dltr=20
>   style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
> solid; MARGIN-RIGHT: 0px">
>     <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
> face=3DTahoma=20
>     size=3D2>-----Original Message-----<BR><B>From:</B>=20
>     interchange-users-admin@lists.akopia.com=20
>     [mailto:interchange-users-admin@lists.akopia.com]<B>On Behalf Of =
> </B>Thomas=20
>     McAlees<BR><B>Sent:</B> Wednesday, December 20, 2000 12:16 =
> PM<BR><B>To:</B>=20
>     interchange-users@lists.akopia.com<BR><B>Subject:</B> [ic] =
> Interchange 4.6.1=20
>     and MySQL 3.23<BR><BR></FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2>I'm new to Interchange but I've =
> found the=20
>     install and configuration to be very reasonable.&nbsp; I have =
> encountered=20
>     only one problem that I can't seem to get past.&nbsp; When I create =
> a new=20
>     catalog and configure it to use MySQL, I'm receiving error while =
> trying to=20
>     create the database indexes.&nbsp; The tables are all created but I =
> receive=20
>     the following error for every table:</FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>     <DIV><FONT face=3DArial size=3D2>table&nbsp;xxxxxxx index failed: =
> Access denied=20
>     for user: <A href=3D"mailto:'dgc@localhost'">'dgc@localhost'</A> to =
> database=20
>     'dgc'</FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>     <DIV><FONT face=3DArial size=3D2>I don't understand why I'm getting =
> an access=20
>     denied error for the index, but the tables are being created just=20
>     fine.&nbsp; </FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>     <DIV><FONT face=3DArial size=3D2>Additional =
> Information:</FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>     <DIV><FONT face=3DArial size=3D2>The site is hosted by an ISP and I =
> only have=20
>     access to a single MySQL database that is already created.&nbsp; =
> I've=20
>     provided the appropriate login/password information to the makecat =
> script=20
>     and it IS creating the tables so I know the connection to the =
> database is=20
>     working.&nbsp; Even with the index creation error I can access the=20
>     Interchange store and perform just about every function.&nbsp; The =
> only=20
>     thing I've been unable to do is update the inventory.&nbsp; When I =
> try I get=20
>     this error 'Sorry, there was an error in processing this form =
> action. Please=20
>     report the error or try again later. (You have an error in your SQL =
> syntax=20
>     near '=3D NULL where sku =3D 'os28113' ' at line 1 )'.&nbsp; I'm not =
> sure if=20
>     this is related to the index problem, but that is where I'm=20
>     starting.</FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>     <DIV><FONT face=3DArial size=3D2>Any help would be greatly=20
>     appreciated!</FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>     <DIV><FONT face=3DArial size=3D2>Tom McAlees</FONT></DIV>
>     <DIV><FONT face=3DArial=20
>   =
> size=3D2>tmcalees@rochester.rr.com</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE>=
> </BODY></HTML>
>
> ------=_NextPart_000_0004_01C06A83.67234A80--
>
>
> --__--__--
>
> Message: 4
> Reply-To: <eric@webuildpcs.com>
> From: "Eric Hull" <eric@webuildpcs.com>
> To: <interchange-users@lists.akopia.com>
> Subject: RE: [ic] Interchange 4.6.1 and MySQL 3.23
> Date: Wed, 20 Dec 2000 12:51:22 -0600
> boundary="----=_NextPart_000_0008_01C06A83.8E3A0140"
> Reply-To: interchange-users@lists.akopia.com
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0008_01C06A83.8E3A0140
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> Also all priv must be Y in order for IC to write to the dir.
>
> Eric Hull
>   -----Original Message-----
>   From: interchange-users-admin@lists.akopia.com
> [mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Cameron B.
> Prince
>   Sent: Wednesday, December 20, 2000 12:37 PM
>   To: interchange-users@lists.akopia.com
>   Subject: RE: [ic] Interchange 4.6.1 and MySQL 3.23
>
>
>   Can you confirm that you have the proper rights granted in the MySQL
user
> table? Something like this:
>
>   | Host              | User      | Password         | Select_priv |
> Insert_priv | Update_priv | Delete_priv | Create_priv |
>    Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv |
> Grant_priv | References_priv | Index_priv |
>    Alter_priv |
>
>   | localhost         | dgc   | 470aee162402249e | Y           | Y
> | Y           | Y           | Y           |
>    Y         | N           | N             | N            | Y         | N
> | N               | Y          | Y          |
>
>
>   Good luck,
>
>   Cameron
>
>     -----Original Message-----
>     From: interchange-users-admin@lists.akopia.com
> [mailto:interchange-users-admin@lists.akopia.com]On Behalf Of Thomas
McAlees
>     Sent: Wednesday, December 20, 2000 12:16 PM
>     To: interchange-users@lists.akopia.com
>     Subject: [ic] Interchange 4.6.1 and MySQL 3.23
>
>
>     I'm new to Interchange but I've found the install and configuration to
> be very reasonable.  I have encountered only one problem that I can't seem
> to get past.  When I create a new catalog and configure it to use MySQL,
I'm
> receiving error while trying to create the database indexes.  The tables
are
> all created but I receive the following error for every table:
>
>     table xxxxxxx index failed: Access denied for user: 'dgc@localhost' to
> database 'dgc'
>
>     I don't understand why I'm getting an access denied error for the
index,
> but the tables are being created just fine.
>
>     Additional Information:
>
>     The site is hosted by an ISP and I only have access to a single MySQL
> database that is already created.  I've provided the appropriate
> login/password information to the makecat script and it IS creating the
> tables so I know the connection to the database is working.  Even with the
> index creation error I can access the Interchange store and perform just
> about every function.  The only thing I've been unable to do is update the
> inventory.  When I try I get this error 'Sorry, there was an error in
> processing this form action. Please report the error or try again later.
> (You have an error in your SQL syntax near '= NULL where sku = 'os28113' '
> at line 1 )'.  I'm not sure if this is related to the index problem, but
> that is where I'm starting.
>
>     Any help would be greatly appreciated!
>
>     Tom McAlees
>     tmcalees@rochester.rr.com
>
> ------=_NextPart_000_0008_01C06A83.8E3A0140
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html; =
> charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><SPAN class=3D790395018-20122000><FONT face=3DArial size=3D2>Also =
> all priv must=20
> be Y in order for IC to write to the dir.</FONT></SPAN></DIV>
> <DIV><SPAN class=3D790395018-20122000><FONT face=3DArial=20
> size=3D2></FONT></SPAN>&nbsp;</DIV>
> <DIV><SPAN class=3D790395018-20122000><FONT face=3DArial size=3D2>Eric=20
> Hull</FONT></SPAN></DIV>
> <BLOCKQUOTE dir=3Dltr=20
> style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px =
> solid; MARGIN-RIGHT: 0px">
>   <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
> face=3DTahoma=20
>   size=3D2>-----Original Message-----<BR><B>From:</B>=20
>   interchange-users-admin@lists.akopia.com=20
>   [mailto:interchange-users-admin@lists.akopia.com]<B>On Behalf Of =
> </B>Cameron=20
>   B. Prince<BR><B>Sent:</B> Wednesday, December 20, 2000 12:37 =
> PM<BR><B>To:</B>=20
>   interchange-users@lists.akopia.com<BR><B>Subject:</B> RE: [ic] =
> Interchange=20
>   4.6.1 and MySQL 3.23<BR><BR></FONT></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff size=3D2>Can=20
>   you confirm that you have the proper rights granted in the MySQL user =
> table?=20
>   Something like this:</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2></FONT></SPAN>&nbsp;</DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff size=3D2>|=20
>   =
> Host&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
> sp;&nbsp;=20
>   | User&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Password&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Select_priv =
> |=20
>   Insert_priv | Update_priv | Delete_priv | Create_priv =
> |</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2>&nbsp;Drop_priv | Reload_priv | Shutdown_priv | Process_priv =
> |=20
>   File_priv | Grant_priv | References_priv | Index_priv =
> |</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2>&nbsp;Alter_priv |</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2></FONT></SPAN>&nbsp;</DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff size=3D2>|=20
>   localhost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
>   |&nbsp;dgc&nbsp;&nbsp; | 470aee162402249e |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
>   |</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2>&nbsp;Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   =
> N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
>  |=20
>   N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   =
> N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
> &nbsp;&nbsp;=20
>   | Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |=20
>   Y&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
> |</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2></FONT></SPAN>&nbsp;</DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2></FONT></SPAN>&nbsp;</DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff size=3D2>Good=20
>   luck,</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2></FONT></SPAN>&nbsp;</DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2>Cameron</FONT></SPAN></DIV>
>   <DIV><SPAN class=3D293073318-20122000><FONT face=3DArial =
> color=3D#0000ff=20
>   size=3D2></FONT></SPAN>&nbsp;</DIV>
>   <BLOCKQUOTE dir=3Dltr=20
>   style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
> solid; MARGIN-RIGHT: 0px">
>     <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
> face=3DTahoma=20
>     size=3D2>-----Original Message-----<BR><B>From:</B>=20
>     interchange-users-admin@lists.akopia.com=20
>     [mailto:interchange-users-admin@lists.akopia.com]<B>On Behalf Of =
> </B>Thomas=20
>     McAlees<BR><B>Sent:</B> Wednesday, December 20, 2000 12:16 =
> PM<BR><B>To:</B>=20
>     interchange-users@lists.akopia.com<BR><B>Subject:</B> [ic] =
> Interchange 4.6.1=20
>     and MySQL 3.23<BR><BR></FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2>I'm new to Interchange but I've =
> found the=20
>     install and configuration to be very reasonable.&nbsp; I have =
> encountered=20
>     only one problem that I can't seem to get past.&nbsp; When I create =
> a new=20
>     catalog and configure it to use MySQL, I'm receiving error while =
> trying to=20
>     create the database indexes.&nbsp; The tables are all created but I =
> receive=20
>     the following error for every table:</FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>     <DIV><FONT face=3DArial size=3D2>table&nbsp;xxxxxxx index failed: =
> Access denied=20
>     for user: <A href=3D"mailto:'dgc@localhost'">'dgc@localhost'</A> to =
> database=20
>     'dgc'</FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>     <DIV><FONT face=3DArial size=3D2>I don't understand why I'm getting =
> an access=20
>     denied error for the index, but the tables are being created just=20
>     fine.&nbsp; </FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>     <DIV><FONT face=3DArial size=3D2>Additional =
> Information:</FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>     <DIV><FONT face=3DArial size=3D2>The site is hosted by an ISP and I =
> only have=20
>     access to a single MySQL database that is already created.&nbsp; =
> I've=20
>     provided the appropriate login/password information to the makecat =
> script=20
>     and it IS creating the tables so I know the connection to the =
> database is=20
>     working.&nbsp; Even with the index creation error I can access the=20
>     Interchange store and perform just about every function.&nbsp; The =
> only=20
>     thing I've been unable to do is update the inventory.&nbsp; When I =
> try I get=20
>     this error 'Sorry, there was an error in processing this form =
> action. Please=20
>     report the error or try again later. (You have an error in your SQL =
> syntax=20
>     near '=3D NULL where sku =3D 'os28113' ' at line 1 )'.&nbsp; I'm not =
> sure if=20
>     this is related to the index problem, but that is where I'm=20
>     starting.</FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>     <DIV><FONT face=3DArial size=3D2>Any help would be greatly=20
>     appreciated!</FONT></DIV>
>     <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
>     <DIV><FONT face=3DArial size=3D2>Tom McAlees</FONT></DIV>
>     <DIV><FONT face=3DArial=20
>   =
> size=3D2>tmcalees@rochester.rr.com</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE>=
> </BODY></HTML>
>
> ------=_NextPart_000_0008_01C06A83.8E3A0140--
>
>
>
>
> --__--__--
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>
>
> End of Interchange-users Digest