Hi everybody
i'm upgrading 10.1.0 to 10.2.0
I am using a clean installation of 10.1.0 to not use the real one in
operation .
after the "yum update --enablerepo=packetfence"
successfully completed, I performed the mysql schema update.
mysql -u root -p pf -v < /usr/local/pf/db/upgrade-10.1.0-10.2.0.sql
and i received this error
ERROR 1064 (42000) at line 222: You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for the
right syntax to use near 'WHERE NOT EXISTS (SELECT * FROM `radreply`
WHERE `tenant_id`='1' AND `u...' at line 3
This is line 221 and next
line 221 \! echo "Adding default radreply row";
line 222 INSERT INTO `radreply` (`tenant_id`, `username`, `attribute`,
`value`, `op`)
line 223 SELECT '1', '00:00:00:00:00:00','User-Name','*', '=*'
line 224 WHERE NOT EXISTS (SELECT * FROM `radreply`
line 225 WHERE `tenant_id`='1' AND `username`='00:00:00:00:00:00'
AND `attribute`='User-Name' AND `value`='*' AND `op`='=*' LIMIT 1);
does anyone have any ideas ?
Thanks a lot
Gino Cinotti
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
