Posted on: 09/16/11 09:00am
By: linc42
I am receiving the message Unknown column 'isadmin' in 'field list' when trying to log into my CMS. I did add this column to phpMyAdmin and then received the message that my user name and or password was incorrect. Can anyone help me?
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/16/11 09:10am
By: Dirk
Geeklog doesn't have a "isadmin" field anywhere in its tables. It could be from a plugin, though.
Where (into which table) did you add that field?
bye, Dirk
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/16/11 09:16am
By: linc42
I added it into the users table. this is the only area where I remember changing anything.
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/16/11 09:19am
By: Dirk
Very odd ...
As for your login problem: If you've lost/messed up your password, you can request a new one by following the "forgot password" link.
For more troubleshooting tips, see
this wiki article.
bye, Dirk
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/16/11 09:27am
By: linc42
Dirk thank you for your comments and your help. For your information I am not a developer. Where would I find the "forgot password" link in phpMyAdmin?
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/16/11 09:30am
By: linc42
Also, how do setup these fields when I add the "isadmin" back to the database? Thank you again.
Field Type Collation Attributes Null Default Extra
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/16/11 09:34am
By: Dirk
When you try to log in and it tells you that your password is wrong, there's also a link to request a new password. If your email address is correct and working, that's the easiest way to get a new password. No phpMyAdmin required. Only when that doesn't work do you need to dive into the database ...
bye, Dirk
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/16/11 09:50am
By: linc42
Let me try this. I do not remember seeing a link to change my password. I have really messed up here.
it now says "Invalid credentials, please try again."
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/16/11 10:54am
By: Dirk
The link on geeklog.net would be
http://www.geeklog.net/users.php?mode=getpassword
Try that with your site, replacing "www.geeklog.net" accordingly.
bye, Dirk
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/17/11 12:14am
By: linc42
Dirk, In which area do I find this information in mysql. I am having a tough time this. I have been at all day.
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/17/11 02:53am
By: Dirk
I'm beginning to wonder if you are trolling ...
Did you try the "forgot password" link? What happened?
If you really want to go the phpMyAdmin way, for whatever reason: The
wiki article[*1] mentions the tables that are involved (gl_users to reset the password to a known value; gl_group_assignments if you really need to create a new admin user). So what exactly is the problem you are having?
bye, Dirk
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/17/11 11:35am
By: linc42
Dirk, I do not know what trolling is but I am sure I am not doing it. I am not a developer or programmer. I really need help getting into my CMS to update my website and cannot.
I truly do not know where this link is and I have looked at the examples that you have provided and am unsure what to do. In phpMyAdmin I can see the password which is a string of numbers and letters. This I have changed but I still can not get into the CMS. I am not sure what else it could be. I still get the "invalid credentials" message.
I am losing visitors and advertisers every day because I cannot change the content. I really appreciate your help with this.
Whenever I remove the "isadmin" i receive this message (Unknown column isadmin in field list) when trying to enter the CMS. When I add the "isadmin" to the "users table" I received the "invalid credentials" message. I am not sure what do to. I am desperate at this point.
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/17/11 12:20pm
By: ::Ben
Can you provide us a link to your site?
Thanks,
Ben
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/17/11 12:23pm
By: linc42
Ben here you are http://www.spitfirehiphop.com/corporate-corner.php.
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/17/11 12:24pm
By: Laugh
Using phpMyAdmin change the password field in the database for your admin user to:
Text Formatted Code
5f4dcc3b5aa765d61d8327deb882cf99
This will change your password to:
password
You should then be able to log in at that point using password as your passowrd but you should then go and change your password right away to something else (using the admin users form).
Tom
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/17/11 12:52pm
By: linc42
Tom, I tried that with same results. It must be something else I did.
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/17/11 01:26pm
By: Anonymous (lgarner)
Is that a Geeklog site?
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/17/11 01:31pm
By: linc42
No it is not. Does this matter?
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/17/11 01:46pm
By: Anonymous (lgarner)
Yes, because that's where you're asking for help. The password reset instructions here all pertain to the Geeklog CMS, and would be different depending on how your CMS encodes passwords and what functions it provides.
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/17/11 01:55pm
By: linc42
Ok, thank you for this response. Is there any way to know which CMS has been used other than speaking with the developer?
Re: Unknown column 'isadmin' in 'field list'
Posted on: 09/17/11 07:00pm
By: Anonymous (lgarner)
I think that's probably the best option. Someone else might know, but I didn't see anything in the page source to indicate if it's an off-the-shelf CMS or something custom.