MYSQL check_error: 1064 received

[Dave]

I get this error on some of my queries but not from all users in the
database, just some?  I cant find much useful google information on it
Here is a query that fails with that error: 

rad_recv: Access-Request packet from host 127.0.0.1 port 42830, id=69,
length=57
        User-Name = "hheeg"
        User-Password = "hheeg"
        NAS-IP-Address = 127.0.0.1
        NAS-Port = 1348
+- entering group authorize {...}
++[preprocess] returns ok
++[chap] returns noop
++[mschap] returns noop
[suffix] No '@' in User-Name = "hheeg", looking up realm NULL
[suffix] No such realm "NULL"
++[suffix] returns noop
[eap] No EAP-Message, not doing EAP
++[eap] returns noop
++[unix] returns notfound
++[files] returns noop
[sql]   expand: %{User-Name} -> hheeg
[sql] sql_set_user escaped user --> 'hheeg'
rlm_sql (sql): Reserving sql socket id: 4
[sql]   expand: SELECT id, username, attribute, value, op           FROM
radcheck           WHERE username = '%{SQL-User-Name}'           ORDER
BY id -> SELECT id, username, attribute, value, op           FROM
radcheck           WHERE username = 'hheeg'           ORDER BY id
[sql] User found in radcheck table
[sql]   expand: SELECT id, username, attribute, value, op           FROM
radreply           WHERE username = '%{SQL-User-Name}'           ORDER
BY id -> SELECT id, username, attribute, value, op           FROM
radreply           WHERE username = 'hheeg'           ORDER BY id
[sql]   expand: SELECT groupname           FROM usergroup          
WHERE username = '%{SQL-User-Name}'           ORDER BY priority ->
SELECT groupname           FROM usergroup           WHERE username =
'hheeg'           ORDER BY priority
[sql]   expand: SELECT id, groupname, attribute,           Value,
op           FROM radgroupcheck           WHERE groupname =
'%{Sql-Group}'           ORDER BY id -> SELECT id, groupname,
attribute,           Value, op           FROM radgroupcheck          
WHERE groupname = 'wisp-dynamic-pool2'           ORDER BY id
[sql] User found in group wisp-dynamic-pool2
[sql]   expand: SELECT id, groupname, attribute,           value,
op           FROM radgroupreply           WHERE groupname =
'%{Sql-Group}'           ORDER BY id -> SELECT id, groupname,
attribute,           value, op           FROM radgroupreply          
WHERE groupname = 'wisp-dynamic-pool2'           ORDER BY id
rlm_sql (sql): Released sql socket id: 4
++[sql] returns ok
++[expiration] returns noop
++[logintime] returns noop
++[pap] returns updated
Found Auth-Type = PAP
+- entering group PAP {...}
[pap] login attempt with password "hheeg"
[pap] Using clear text password "hheeg"
[pap] User authenticated successfully
++[pap] returns ok
+- entering group post-auth {...}
rlm_sql (sql): Reserving sql socket id: 3
[sqlippool]     expand: %{User-Name} -> hheeg
[sqlippool] sql_set_user escaped user --> 'hheeg'
[sqlippool]     expand: START TRANSACTION -> START TRANSACTION
[sqlippool]     expand: UPDATE radippool  SET nasipaddress = '',
pool_key = 0,  callingstationid = '', username = '',  expiry_time IS
NULL  WHERE expiry_time <= NOW() - INTERVAL 1 SECOND  AND nasipaddress =
'%{Nas-IP-Address}' -> UPDATE radippool  SET nasipaddress = '', pool_key
= 0,  callingstationid = '', username = '',  expiry_time IS NULL  WHERE
expiry_time <= NOW() - INTERVAL 1 SECOND  AND nasipaddress = '127.0.0.1'
rlm_sql_mysql: MYSQL check_error: 1064 received
sqlippool_command: database query error in: 'UPDATE radippool  SET
nasipaddress = '', pool_key = 0,  callingstationid = '', username = '', 
expiry_time IS NULL  WHERE expiry_time <= NOW() - INTERVAL 1 SECOND  AND
nasipaddress = '127.0.0.1''
[sqlippool]     expand: SELECT framedipaddress FROM radippool  WHERE
pool_name = '%{control:Pool-Name}' AND expiry_time < NOW()  ORDER BY
(username <> '%{User-Name}'),  (callingstationid <>
'%{Calling-Station-Id}'),  expiry_time  LIMIT 1  FOR UPDATE -> SELECT
framedipaddress FROM radippool  WHERE pool_name = 'IP-Pool' AND
expiry_time < NOW()  ORDER BY (username <> 'hheeg'),  (callingstationid
<> ''),  expiry_time  LIMIT 1  FOR UPDATE
[sqlippool]     expand: UPDATE radippool  SET nasipaddress =
'%{NAS-IP-Address}', pool_key = '%{NAS-Port}',  callingstationid =
'%{Calling-Station-Id}', username = '%{User-Name}',  expiry_time = NOW()
+ INTERVAL 60 SECOND  WHERE framedipaddress = '75.119.231.190' -> UPDATE
radippool  SET nasipaddress = '127.0.0.1', pool_key = '1348', 
callingstationid = '', username = 'hheeg',  expiry_time = NOW() +
INTERVAL 60 SECOND  WHERE framedipaddress = '75.119.231.190'
[sqlippool] Allocated IP 75.119.231.190 [bee7774b]
[sqlippool]     expand: COMMIT -> COMMIT
rlm_sql (sql): Released sql socket id: 3
[sqlippool]     expand: Allocated IP: %{reply:Framed-IP-Address} from
%{control:Pool-Name}   (did %{Called-Station-Id} cli
%{Calling-Station-Id} port %{NAS-Port} user %{User-Name}) -> Allocated
IP: 75.119.231.190 from IP-Pool   (did  cli  port 1348 user hheeg)
Allocated IP: 75.119.231.190 from IP-Pool   (did  cli  port 1348 user hheeg)
++[sqlippool] returns ok
++[exec] returns noop
Sending Access-Accept of id 69 to 127.0.0.1 port 42830
        Framed-IP-Address = 75.119.231.190
Finished request 7.
Going to the next request
Waking up in 2.2 seconds.
Cleaning up request 6 ID 241 with timestamp +493
Waking up in 2.7 seconds.
Cleaning up request 7 ID 69 with timestamp +496
Ready to process requests.