[Serusers] serweb - DB Error: syntax error

[Karel Kozlik]

Hi John,

> I have SER 0.9.3 and SERWEB 0.9.3 installed and when I log into SERWEB 
> as a user and go to "Missed Calls" or "Accounting" I get the error: "DB 
> Error: syntax error". 

which version of MySQL are you useing? Serweb require MySQL >= 4.0

> I looked in apache log and I have a bunch of PEAR 
> errors. I followed the instructions (I hope) and I have the Pear package 
> LOG installed. These are probably two seperate issues, but if I could 
> get either one fixed I would be a happy camper.

Thanks for report this. It is bug in serweb. You have the Pear package 
LOG installed but you have probably disabled logging in serweb. And this 
is cause of the error messages. I fixed it in cvs.

Karel


> 
> /var/log/messages
> ------------------
> [client 192.168.10.130] PHP Notice:  Use of undefined constant 
> PEAR_LOG_INFO - assumed 'PEAR_LOG_INFO' in 
> /home/serweb/serweb/html/functions.php on line 513, referer: 
> http://192.168.0.155/serweb/user/missed_calls.php?kvrk=42d588fe936fd
> 
> [client 192.168.10.130] PHP Notice:  Use of undefined constant 
> PEAR_LOG_INFO - assumed 'PEAR_LOG_INFO' in 
> /home/serweb/serweb/html/functions.php on line 513, referer: 
> http://192.168.0.155/serweb/user/accounting.php?kvrk=42d5890017dab
> 
> 
> PEAR Packages
> ----------------
> Package        Version State
> Archive_Tar    1.3.1   stable
> Console_Getopt 1.2     stable
> DB             1.7.6   stable
> HTTP           1.3.5   stable
> Log            1.8.7   stable
> Mail           1.1.6   stable
> Net_SMTP       1.2.6   stable
> Net_Socket     1.0.6   stable
> PEAR           1.3.5   stable
> PHPUnit        1.2.3   stable
> XML_Parser     1.2.6   stable
> XML_RPC        1.3.2   stable
> 
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers