Subject: Unknown column 'isadmin' in 'field list'

Posted on: 16/09/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: 16/09/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: 16/09/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: 16/09/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: 16/09/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: 16/09/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: 16/09/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: 16/09/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: 16/09/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: 17/09/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: 17/09/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 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: 17/09/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: 17/09/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: 17/09/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: 17/09/11 12:24pm
By: Laugh

Using phpMyAdmin change the password field in the database for your admin user to:

PHP 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: 17/09/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: 17/09/11 01:26pm
By: Anonymous

Is that a Geeklog site?

Re: Unknown column 'isadmin' in 'field list'

Posted on: 17/09/11 01:31pm
By: linc42

No it is not. Does this matter?

Re: Unknown column 'isadmin' in 'field list'

Posted on: 17/09/11 01:46pm
By: Anonymous

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: 17/09/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: 17/09/11 07:00pm
By: Anonymous

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.

Geeklog - Forum
https://www.geeklog.net/forum/viewtopic.php?showtopic=93347