Hi,

you can check in the mysql logs to see what is wrong with the query - you might need to enable text logging of mysqld. Try to run the same command from mysql console and see the error message.

regards, bogdan

cv aik wrote:

Dear all,

Thank you very much.

Now, I tried to build serweb in my openser server. I user openser-1.1.0-tls and for serweb, I use serweb-2004-07-27. I can install it successfully. I mean that from the serweb browser, I can login as admin and I can login with username that I have added from "openserctl add" command before. But, I have a problem when I add a new user from serweb browser. When I try to add a new user, I always get the error message in register confirmation. The error message says that : *"SQL query error in line 43".*

I have tried to analize it. But I can not. Maybe because I have lack skill in this. I do hope anybody can give me some suggestions. Please help me....Please...

Thank you very much

Regards,

Aldi

*Note:*

This the contain of confirmation.php file from line 41 to 45

// get the max alias number if (!$alias=get_alias_number($errors)) break;

            $q="insert into ".$config->table_subscriber." select * 

from ".$config->table_pending." where confirmation='$nr'"; $res=mySQL_query($q); if (!$res) {$errors[]="error in SQL query, line: ".__LINE__; break;}

---

Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

---

---

Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users