[Serusers] serweb - DB Error: syntax error

[John Clements]

Thanks Karel, I must have missed the line in the install file that said 
MySQL 4. I looked again and sure enough, it was there :-) Working on it now. 
Thanks again.


  -John



> 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