>DB Error: no such field
(INSERT INTO user SET passwd=PASSWORD(NULL),userid='dmitry' [nativecode=1054 ** Unknown column 'userid' in 'field list'])
The error messages are self-explanatory:
I don't the field names of your user table.
So, userid does not exist in your table.
>I don't want new users to be created automatically. >I thought I had that configured by setting >ALLOW_BOGO_LOGIN to false.
No, BOGO has nothing todo with password users.
You have to change your sql statements accordingly.
INSERT creates new entries (users) in the database.
UPDATE just changes them, but does not create new entries.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
> The error messages are self-explanatory:
> I don't the field names of your user table.
> So, userid does not exist in your table.
What happened was this. Since I don't want new users to be autocreated, I commented the insert statement from config.php, hoping that doing so will give the system a clue not to try to insert new users into the database. Instead, however, phpWiki tried to use the insert statement from config-default.ini. It took me a while to realise what was going on. So even though the message was self-explanatory, the cause of it was certainly not :)
> No, BOGO has nothing todo with password users.
> You have to change your sql statements accordingly.
> INSERT creates new entries (users) in the database.
> UPDATE just changes them, but does not create new entries.
I realize this, but as I said above, I don't want phpwiki to autocreate users. So how do I accomplish this?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Ok, I'm ever two steps away from getting external authentication to work :)
So, I have externals authentication set up: authentication dns is configured, the user_exists constant is set to a proper query.
The problem now, if I try to log in with a user name that doesn't exist in the authentication db, I get the following error:
lib/WikiDB/backend/PearDB.php:778: Fatal[256]: wikidb_backend_mysql: fatal database error
DB Error: no such field
(INSERT INTO user SET passwd=PASSWORD(NULL),userid='dmitry' [nativecode=1054 ** Unknown column 'userid' in 'field list'])
lib/WikiUserNew.php:1668: Notice[8]: Undefined index: auth
I don't want new users to be created automatically. I thought I had that configured by setting ALLOW_BOGO_LOGIN to false.
Any clues as to what's going on?
>DB Error: no such field
(INSERT INTO user SET passwd=PASSWORD(NULL),userid='dmitry' [nativecode=1054 ** Unknown column 'userid' in 'field list'])
The error messages are self-explanatory:
I don't the field names of your user table.
So, userid does not exist in your table.
>I don't want new users to be created automatically. >I thought I had that configured by setting >ALLOW_BOGO_LOGIN to false.
No, BOGO has nothing todo with password users.
You have to change your sql statements accordingly.
INSERT creates new entries (users) in the database.
UPDATE just changes them, but does not create new entries.
> The error messages are self-explanatory:
> I don't the field names of your user table.
> So, userid does not exist in your table.
What happened was this. Since I don't want new users to be autocreated, I commented the insert statement from config.php, hoping that doing so will give the system a clue not to try to insert new users into the database. Instead, however, phpWiki tried to use the insert statement from config-default.ini. It took me a while to realise what was going on. So even though the message was self-explanatory, the cause of it was certainly not :)
> No, BOGO has nothing todo with password users.
> You have to change your sql statements accordingly.
> INSERT creates new entries (users) in the database.
> UPDATE just changes them, but does not create new entries.
I realize this, but as I said above, I don't want phpwiki to autocreate users. So how do I accomplish this?