Dear Friends, i have installed SER correctly, it works well and registers users present in mysql database.
After SER installation i have installed SERWEB following step by step Dan Austin's HOW-TO. I have encountered this problems:
1) The web interface don't displays correclty...i don't see the background images, but the buttons are visible.
2) When a user logs in, on the missed_calls tab, i see the message "error in SQL query, line: 77"
3) When i click on email confirmation link....i see on the web page the message "400 Table "aliases" not in memory, please run save("aliases") or lookup("aliases") in the confirmation script first"
Can you help me to solve this problem, please?
Thanks all in advance
Francesco Russo
At 01:19 PM 7/8/2004, Ing. Francesco Russo - NoCable s.p.a. wrote:
Dear Friends, i have installed SER correctly, it works well and registers users present in mysql database.
After SER installation i have installed SERWEB following step by step Dan Austin's HOW-TO. I have encountered this problems:
The web interface don't displays correclty...i don't see the background images, but the buttons are visible.
When a user logs in, on the missed_calls tab, i see the message "error in SQL query, line: 77"
perhaps yuo don't use mysql 4.x, do you? see archives.
- When i click on email confirmation link....i see on the web page the message "400 Table "aliases" not in memory, please run save("aliases") or lookup("aliases") in the confirmation script first"
do what the error message tells you and you will be just fine. more on that numerously in archives too.
-jiri
Hi,
please see commnets inline bogdan
Ing. Francesco Russo - NoCable s.p.a. wrote:
Dear Friends, i have installed SER correctly, it works well and registers users present in mysql database.
After SER installation i have installed SERWEB following step by step Dan Austin's HOW-TO. I have encountered this problems:
- The web interface don't displays correclty...i don't see the
background images, but the buttons are visible.
what exactly background images are you talking about - there are no such images
- When a user logs in, on the missed_calls tab, i see the message
"error in SQL query, line: 77"
most probably you have a mysql version older than 4.0.0 and it doesn't support UNIONs. Check in the log of the mysql server.
- When i click on email confirmation link....i see on the web page
the message "400 Table "aliases" not in memory, please run save("aliases") or lookup("aliases") in the confirmation script first"
you have to put somewhere in your ser.cfg lookup or save("aliases") to force ser to generate into memeory the aliases table - if there are no reference from script to aliases, makes no sens to ser to build the table into mem.
Can you help me to solve this problem, please?
Thanks all in advance
Francesco Russo
Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers