[ic] New Account Creation Failure - Fixed

[Russ Mann]

Dear Ed,

Thanks for all your help.  I feel like a complete bonehead. I added an
auto_increment field to the userdb, but for some reason the field was
changed to not be auto_increment, but still set as default='0'.  So, what
was happening is when it went to create the 2nd account, it couldn't add it
to the userdb because that field would have a duplicate value.

I'm posting this in hopes that someone in the far distant future with the
same completely off the wall problem will find this and be saved hours of
hair pulling.

Russ

-----Original Message-----
From: interchange-users-admin@developer.akopia.com
[mailto:interchange-users-admin@developer.akopia.com]On Behalf Of Ed
LaFrance
Sent: Wednesday, May 23, 2001 10:00 AM
To: interchange-users@developer.akopia.com
Subject: RE: [ic] New Account Creation Failure


At 09:26 PM 05/22/2001 -0600, you wrote:
>The userdb is stored in mySQL.  I added the ignore_case after it didn't
>work, to try to make it work.  Its supposed to help.
>
>Russ

If you haven't already done so, you may need to log in to mysql from the
shell and GRANT full permissions on the database and all tables to the user
which runs interchange.  Other than that, did you try running it with the
default dbm's to see if it behaves better?  That would at least narrow it
down to a MySQL issue.

- Ed L.




>-----Original Message-----
>From: interchange-users-admin@developer.akopia.com
>[mailto:interchange-users-admin@developer.akopia.com]On Behalf Of Ed
>LaFrance
>Sent: Tuesday, May 22, 2001 4:36 PM
>To: interchange-users@developer.akopia.com
>Subject: RE: [ic] New Account Creation Failure
>
>
>At 03:52 PM 05/22/2001 -0600, you wrote:
> >The pertinant code in the construct demo is this:
> >
> >         <FORM ACTION="[process-target]" METHOD=POST>
> >         <INPUT TYPE=hidden NAME=mv_click VALUE=NewAccount>
> >         <INPUT TYPE=hidden NAME=mv_doit  VALUE=return>
> >         <INPUT TYPE=hidden NAME=function  VALUE=new_account>
> >         <INPUT TYPE=hidden NAME=mv_nextpage VALUE=ord/basket>
> >
> >Changing this to mv_check does not seem to make any difference.
>
>Your right - I never paid much attention to it, it seems counterintuitive
>but it does work that way (checked it out on some cats over here) and the
>docs essentially say that it will work either way.
>
>I'm not sure if I can be of much more help.  try removing the 'ignore_case'
>input and observing case sensitivity; otherwise I would look to the
>write-ability of your userdb file (permissions, etc).
>
>- Ed L.
>
>
>
>
>===============================================================
>New Media E.M.S.               Software Solutions for Business
>463 Main St., Suite D          eCommerce | Consulting | Hosting
>Placerville, CA  95667         edl@newmediaems.com
>(530) 622-9421                 http://www.newmediaems.com
>(866) 519-4680 Toll-Free       (530) 622-9426 Fax
>===============================================================
>
>_______________________________________________
>Interchange-users mailing list
>Interchange-users@lists.akopia.com
>http://lists.akopia.com/mailman/listinfo/interchange-users
>
>_______________________________________________
>Interchange-users mailing list
>Interchange-users@lists.akopia.com
>http://lists.akopia.com/mailman/listinfo/interchange-users

===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================

_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users