Skip to Content Skip to Menu

🌟Discover the Joomla AI Plugin that wrote its own story! - CB Editor Assistant 1.1now for Joomla 3, 4 & 5!
✍️ 5-Day Free Trial, then 🎯 save up to 30% with our 🛍️ Intro Offer (First 50 users, ends Dec. 31)
🌲 Merry Christmas! Great savings on Professional and Developer Memberships! Get 25% off now with code XMAS-2024!

[SOLVED] DB Error after upgrading

  • grumpybug
  • grumpybug
  • OFFLINE
  • Posts: 10
  • Thanks: 1
  • Karma: 0
9 years 8 months ago - 9 years 8 months ago #261869 by grumpybug
[SOLVED] DB Error after upgrading was created by grumpybug
Hoping for some help here to work this one out.

A while ago I upgraded my site to 2.07 while still running Joomla 2.5. Now I am trying to upgrade to Joomla 3 but I was having some problems. In an effort to fix the problem I used the Tools to "Check the CB Database" After running the tool I now get following error when I view a user profile.

Unknown column 'useraccessgroupid' in 'where clause' SQL=SELECT * FROM `jos_comprofiler_tabs` WHERE `enabled` = 1 AND `viewaccesslevel` IN ( 1,2,3 ) AND `useraccessgroupid` IN ( -2,-1,1,2,3,4 )

Obviously until I can get this fixed I can't proceed with the upgrade to J3.
Last edit: 9 years 8 months ago by krileon.

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

  • grumpybug
  • grumpybug
  • OFFLINE
  • Posts: 10
  • Thanks: 1
  • Karma: 0
9 years 8 months ago #261871 by grumpybug
Replied by grumpybug on topic DB Error after upgrading
Disregard. Fixed. Turns out it was an older 1.9 plugin, which was still installed causing the problem.

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

Moderators: beatnantkrileon
Powered by Kunena Forum