Welcome to Geeklog Saturday, October 19 2019 @ 08:29 pm EDT

Geeklog Forums

Unknown column 'isadmin' in 'field list'


Status: offline

linc42

Forum User
Newbie
Registered: 16/09/11
Posts: 11
tired
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?

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
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

Status: offline

linc42

Forum User
Newbie
Registered: 16/09/11
Posts: 11
I added it into the users table. this is the only area where I remember changing anything.

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
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

Status: offline

linc42

Forum User
Newbie
Registered: 16/09/11
Posts: 11
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?

Status: offline

linc42

Forum User
Newbie
Registered: 16/09/11
Posts: 11
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

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
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

Status: offline

linc42

Forum User
Newbie
Registered: 16/09/11
Posts: 11
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."

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
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

Status: offline

linc42

Forum User
Newbie
Registered: 16/09/11
Posts: 11
worried
Dirk, In which area do I find this information in mysql. I am having a tough time this. I have been at all day.

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
confused
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

Status: offline

linc42

Forum User
Newbie
Registered: 16/09/11
Posts: 11
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.

Status: offline

::Ben

Forum User
Full Member
Registered: 14/01/05
Posts: 1569
Location:la rochelle, France
Can you provide us a link to your site?

Thanks,

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

Status: offline

linc42

Forum User
Newbie
Registered: 16/09/11
Posts: 11
Ben here you are http://www.spitfirehiphop.com/corporate-corner.php.

Status: offline

Laugh

Site Admin
Admin
Registered: 27/09/05
Posts: 1381
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
One of the Geeklog Core Developers.

Status: offline

linc42

Forum User
Newbie
Registered: 16/09/11
Posts: 11
Tom, I tried that with same results. It must be something else I did.

lgarner

Anonymous
Is that a Geeklog site?

Status: offline

linc42

Forum User
Newbie
Registered: 16/09/11
Posts: 11
No it is not. Does this matter?

lgarner

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.

Status: offline

linc42

Forum User
Newbie
Registered: 16/09/11
Posts: 11
Ok, thank you for this response. Is there any way to know which CMS has been used other than speaking with the developer?

All times are EDT. The time is now 08:29 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content