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
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users


_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users

Reply via email to