Louis,
That's what I was doing at first when I got the error. I only tried to run
the command from within mysql because of Fabrice's question. So it sounded
like an option. But running the command you listed as where I was getting
this SQL error:
--------------
-
-
-
ALTER TABLE node ADD `time_balance` int unsigned AFTER `lastskip`
--------------
ERROR 1064 (42000) at line 1: 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 '-
-
-
ALTER TABLE node ADD `time_balance` int unsigned AFTER `lastskip`' at line 1
I don't know if this helps, but here's the status from my mysql server:
mysql> status;
--------------
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using
readline 5.1
Connection id: 18
Current database: pf
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.73 Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 18 hours 18 min 42 sec
Threads: 2 Questions: 12214 Slow queries: 0 Opens: 47 Flush tables: 1
Open tables: 40 Queries per second avg: 0.185
Thanks,
Joshua Nathan
IT Administrator
Black Forest Academy
+49 (0) 7626-916123
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
