Keyword

K2 users: 1054 Unknown column 'ip' in 'field list'

  • Davide Marchi
  • Davide Marchi's Avatar Topic Author
  • Offline
  • New Member
More
7 years 4 months ago #161739 by Davide Marchi
Hi friends,
I've migrate a Joomla 1.5.x to Joomla 3.7, and all seems works fine.
Except for one thing:
if I go to K2->Users obtain the error: 1054 Unknown column 'ip' in 'field list'

And if I enable the debug mode I can see 4 duplicate entries in the database.

Then, if I enable the User - K2 I can no longer authenticate from the front-end and the same error message is shown to me.

I'm using K2 version 2.7.1

many thanks

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 4 months ago #161744 by Krikor Boghossian
Replied by Krikor Boghossian on topic K2 users: 1054 Unknown column 'ip' in 'field list'
Hello Davide,

Is this happening with all users or a certain one?
Are new users behaving properly?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • Davide Marchi
  • Davide Marchi's Avatar Topic Author
  • Offline
  • New Member
More
7 years 4 months ago #161799 by Davide Marchi
Replied by Davide Marchi on topic K2 users: 1054 Unknown column 'ip' in 'field list'
Hi Krikor and thanks for your kind help!

I've managed around the database user, and now I'm able to access to the K2 user section.
But I'm unable to edit (from K2) a single user (I obtain the above message) and I'm unable (with the user plugin enabled) log into the front end. If I disable the user k2 plugin I can login into the frontend.

I've look into the Joomla database user structure, and there isn't a field "IP", in fact if I go to the user K2 section, I'm unable to see the IP field compiled, that it's empty.

So I think all this issues could be caused by this missing information?


Thanks again

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 4 months ago #161857 by Krikor Boghossian
Replied by Krikor Boghossian on topic K2 users: 1054 Unknown column 'ip' in 'field list'
1) Backup
2) Try reinstalling K2.
Was K2 in the old site an older version?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • Davide Marchi
  • Davide Marchi's Avatar Topic Author
  • Offline
  • New Member
More
7 years 4 months ago #161877 by Davide Marchi
Replied by Davide Marchi on topic K2 users: 1054 Unknown column 'ip' in 'field list'
Yes Krikor,
your indications are the only possible at this point. And I confirm that they resolve.
Many thanks for your help.

Please Log in or Create an account to join the conversation.

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 4 months ago #161905 by Krikor Boghossian
Replied by Krikor Boghossian on topic K2 users: 1054 Unknown column 'ip' in 'field list'
You 're welcome Davide :)

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum