Only one new entry can be added in the "subscriber" table. Or, "Duplicate entry '' for key 3" error responses.
Is there any way to create more than one user in this table?
Kevin,
_________________________________________________________________ MSN圣诞礼物火热登场，免费发放中，快来领取吧！ http://im.live.cn/emoticons/?ID=18
I guess you have installed serweb tables as well. If you have installed serweb tables there is a setting in /etc/openser/openserctlrc which you have to set to 1 (something like USE_SERWEB)
klaus
KevinKinnan wrote:
Only one new entry can be added in the "subscriber" table. Or, "Duplicate entry '' for key 3" error responses.
Is there any way to create more than one user in this table?
Kevin,
“七件武器，七种完美” 立刻体验！ http://get.live.cn
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
El Jueves, 17 de Enero de 2008, KevinKinnan escribió:
Only one new entry can be added in the "subscriber" table. Or, "Duplicate entry '' for key 3" error responses.
Is there any way to create more than one user in this table?
The problem is that the "phplib" column is a UNIQUE key so you must make it unique for each entry. But when creating a user with "openserctl" it set this field as NULL (or maybe it's configurable).
So since I don't know what "phplib" column is (I suppose for "SerWeb") what I do is deleting that key.
Hmm ... this serweb tables seems to be creating a lot of confusion.
We should modify the default openserctlrc to not ask for serweb tables install. This is as simple as setting: INSTALL_SERWEB_TABLES=no
If the serweb tables are installed, the you need to set: HAS_SERWEB=yes
If you don't install serweb tables, then you need to have HAS_SERWEB=no (the default value).
By having INSTALL_SERWEB_TABLES=no in the default openserctl will avoid a lot of trouble for new users. Who ever want's to install the serweb tables, will need to deal with it. But by letting a new user to choose to install the table or not to install is not good, because most of the time they will choose to install it and then they will run into this issue.
Regards, Ovidiu Sas
On Jan 17, 2008 4:03 PM, Iñaki Baz Castillo ibc@aliax.net wrote:
El Jueves, 17 de Enero de 2008, KevinKinnan escribió:
Only one new entry can be added in the "subscriber" table. Or, "Duplicate entry '' for key 3" error responses.
Is there any way to create more than one user in this table?
The problem is that the "phplib" column is a UNIQUE key so you must make it unique for each entry. But when creating a user with "openserctl" it set this field as NULL (or maybe it's configurable).
So since I don't know what "phplib" column is (I suppose for "SerWeb") what I do is deleting that key.
-- Iñaki Baz Castillo
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
On Thursday 17 January 2008 22:13:55 Ovidiu Sas wrote:
Hmm ... this serweb tables seems to be creating a lot of confusion.
By having INSTALL_SERWEB_TABLES=no in the default openserctl will avoid a lot of trouble for new users. Who ever want's to install the serweb tables, will need to deal with it. But by letting a new user to choose to install the table or not to install is not good, because most of the time they will choose to install it and then they will run into this issue.
Completely agree. I know many cases of new users having this first issue.
I have already added a note to the install script which tell the use to activate HAS_SERWEB if serweb tables are installed.
Maybe we should add another note during serweb table installation question: "...say "no" if you don't know..."
regards klaus
Ovidiu Sas schrieb:
Hmm ... this serweb tables seems to be creating a lot of confusion.
We should modify the default openserctlrc to not ask for serweb tables install. This is as simple as setting: INSTALL_SERWEB_TABLES=no
If the serweb tables are installed, the you need to set: HAS_SERWEB=yes
If you don't install serweb tables, then you need to have HAS_SERWEB=no (the default value).
By having INSTALL_SERWEB_TABLES=no in the default openserctl will avoid a lot of trouble for new users. Who ever want's to install the serweb tables, will need to deal with it. But by letting a new user to choose to install the table or not to install is not good, because most of the time they will choose to install it and then they will run into this issue.
Regards, Ovidiu Sas
On Jan 17, 2008 4:03 PM, Iñaki Baz Castillo ibc@aliax.net wrote:
El Jueves, 17 de Enero de 2008, KevinKinnan escribió:
Only one new entry can be added in the "subscriber" table. Or, "Duplicate entry '' for key 3" error responses.
Is there any way to create more than one user in this table?
The problem is that the "phplib" column is a UNIQUE key so you must make it unique for each entry. But when creating a user with "openserctl" it set this field as NULL (or maybe it's configurable).
So since I don't know what "phplib" column is (I suppose for "SerWeb") what I do is deleting that key.
-- Iñaki Baz Castillo
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
On Thursday 17 January 2008, Ovidiu Sas wrote:
Hmm ... this serweb tables seems to be creating a lot of confusion.
We should modify the default openserctlrc to not ask for serweb tables install. This is as simple as setting: INSTALL_SERWEB_TABLES=no
If the serweb tables are installed, the you need to set: HAS_SERWEB=yes
If you don't install serweb tables, then you need to have HAS_SERWEB=no (the default value).
Hi,
sounds reasonable. As this creates really confusion among new users, i'll later change this, and also improve the documentation a little bit.
Cheers,
Henning
-
Henning Westerholt -
Iñaki Baz Castillo -
Iñaki Baz Castillo -
KevinKinnan -
Klaus Darilion -
Ovidiu Sas