[ic] Problem trying to add a customer via the Admin interface

[Chris Nighswonger]

> -----Original Message-----
> From: DB [mailto:DB at m-and-d.com] 
> Sent: Monday, September 29, 2003 9:30 PM
> To: interchange-users at icdevgroup.org
> Subject: [ic] Problem trying to add a customer via the Admin interface
> 
> 
> > Hi all,
> >   I am running Linux 7.3 and Interchange 4.8.7 running over MySQL. 
> > This is my first time working with Interchange and 
> everything has gone 
> > fine to this point. However, when I attempt to add a customer using 
> > the 'Create New Customer' option in the admin interface I have a 
> > problem: Everything appears to proceed fine and it seems as if the 
> > customer is added. But when I look for the customer in the userdb 
> > (either through the IC admin interface or through MySQL 
> control panel) 
> > the customer has not been added. Furthermore, I cannot seem to make 
> > any mods to existing customer records. I can add and modify 
> inventory 
> > just fine and everything else works fine as well. I can add the 
> > customer with the MySQL CP and it shows up in the IC Admin 
> interface fine.
> >   I have checked the permissions in MySQL for the account 
> IC uses and 
> > they appear to be correct.
>
> Does the catalog error, main IC error log or the apache error 
> log show 
> anything?
> 
> DB
> 

Sorry for the long delay in responding.
The only log listing an error is the catalog error log:

69.34.42.13 36iCSrIR:69.34.42.13 - [21/October/2003:10:08:22 -0400]
foundation /cgi-bin/foundation/process.html Successful login by user
'interch'
69.34.42.13 36iCSrIR:69.34.42.13 - [21/October/2003:11:16:07 -0400]
foundation /cgi-bin/foundation/ui Duplicate entry '' for key 1

This only occurs when trying to add a new customer via the admin
interface. No error occurs when trying to delete an existing customer,
however, the customer is not deleted. It also turns out that I cannot
edit existing records in the userdb via the 'tables' section in the
admin interface.

Thanks again for the help.

Chris

Chris R. Nighswonger
Network & Systems Engineer
ParkerTechGroup Incorporated
www.parkertechgroup.com
cnighswonger at parkertechgroup.com
V: 910-892-8782 F: 910-897-8781