Geeklog Forums

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?

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

I added it into the users table. this is the only area where I remember changing anything.

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

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?

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

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

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."

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

Dirk, In which area do I find this information in mysql. I am having a tough time this. I have been at all day.

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

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.

Can you provide us a link to your site?

Thanks,

Ben

---

I'm available to customise your themes or plugins for your Geeklog CMS

Ben here you are http://www.spitfirehiphop.com/corporate-corner.php.

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



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

---

One of the Geeklog Core Developers.

Tom, I tried that with same results. It must be something else I did.

Is that a Geeklog site?

No it is not. Does this matter?

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.

Ok, thank you for this response. Is there any way to know which CMS has been used other than speaking with the developer?