Hi Nicholas, On 18/01/11 10:42 AM, Ritter, Nicholas wrote: > I did not delete that user, but in the form, I specified a number for > the identifier that didn’t exist in the database. I had, for some > reason, assumed that the identifier was same as the number listed with > the category name, which is not the case. > > That explains that part of the error. > > I still don’t understand why I add nodes, and the form says “Added > Record” yet the node is not in the database.
That's a bug: #840: pfcmd node edit (web node edit) fails silently http://www.packetfence.org/bugs/view.php?id=840 and it's caused by the fact that the return code for the SQL query is not evaluated and the error/exception not thrown to the caller and reported. > Last night I increased the MySQL settings as outlined in the > administration document, despite not seeing any reason to do so given > that the system load doesn’t show any issues. This does not appear to > have fixed the issue. It won't. > > For the node add that I did, I didn’t specify an identifier, I again > assumed that the software inserts the default identifier (of 1) if no > identifier is specified. I did another test and specified an identifier > of 1 and the node did get entered and there was no database related > error in the packetfence.log. > > When I then do a lookup for the node that was just confirmed as added to > the database, I get an error: > > *Error: Problems executing 'PFCMD lookup node 00:50:56:85:00:11'* > > /usr/local/pf/lib/pf/lookup/node.pm line 115 (#1) This is an unrelated new issue. I think it's because you are doing a lookup on a node that has no locationlog entry yet and the validation in place doesn't work however it should.. What's at your line 115? Mine is: if (defined($last_locationlog_entry[0]->{'end_time'}) && $last_locationlog_entry[0]->{'end_time'} !~ /0000/) { Thanks, -- Olivier Bilodeau [email protected] :: +1.514.447.4918 *115 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) ------------------------------------------------------------------------------ Protect Your Site and Customers from Malware Attacks Learn about various malware tactics and how to avoid them. Understand malware threats, the impact they can have on your business, and how you can protect your company and customers by using code signing. http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
