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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users