DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'trigger' at line 1 at /usr/local/pf/lib/pf/trigger.pm line 91.

DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'trigger where vid='1100005' and tid_start<='1100005' and tid_end>='1100005' and ' at line 1 at /usr/local/pf/lib/pf/trigger.pm line 98.

DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'trigger(vid,tid_start,tid_end,type) values('1100005','1100005','1100005','detect' at line 1 at /usr/local/pf/lib/pf/trigger.pm line 113.

Then it repeats the last two errors quite a bit. I'm still using 1.6 here wanting to make sure it still works until we cutover to 1.7

Cheers

Matt

mda@unb.ca

-----Original Message-----
From: packetfence-devel-bounces@lists.sourceforge.net [mailto:packetfence-devel-bounces@lists.sourceforge.net] On Behalf Of Dominik Gehl
Sent: Thursday, July 17, 2008 3:13 PM
To: mda@unb.ca
Cc: packetfence-devel@lists.sourceforge.net
Subject: Re: [Packetfence-devel] mysql version?

Hi Matt,

we've tested PacketFence on the default mysql versions shipped with 

RHEL4 and RHEL5.

Could you let us know the exact error messages you see ?

Dominik

On 17-Jul-08, at 12:15 PM, Matt Ashfield wrote:

> Hello,

>

> We upgraded our server from RHEL4 to RHEL5 and unfortunately that 

> also upgraded our version of mysql server to version 5 as well. This 

> has cuased a bunch of mysql errors when starting up. I’m assuming 

> because of the incompatibilities.

>

> What version of mysqld is Packtefence recommending to use ?

>

> Thanks!

>

> Matt Ashfield

> mda@unb.ca

>

> -------------------------------------------------------------------------

> This SF.Net email is sponsored by the Moblin Your Move Developer's 

> challenge

> Build the coolest Linux based applications with Moblin SDK & win 

> great prizes

> Grand prize is a trip for two to an Open Source event anywhere in 

> the world

> http://moblin-contest.org/redirect.php?banner_id=100&url=/_______________________________________________

> Packetfence-devel mailing list

> Packetfence-devel@lists.sourceforge.net

> https://lists.sourceforge.net/lists/listinfo/packetfence-devel


-------------------------------------------------------------------------

This SF.Net email is sponsored by the Moblin Your Move Developer's challenge

Build the coolest Linux based applications with Moblin SDK & win great prizes

Grand prize is a trip for two to an Open Source event anywhere in the world

http://moblin-contest.org/redirect.php?banner_id=100&url=/

_______________________________________________

Packetfence-devel mailing list

Packetfence-devel@lists.sourceforge.net

https://lists.sourceforge.net/lists/listinfo/packetfence-devel