Skip to Content Skip to Menu

🍾 Happy New Year! Great savings on Professional and Developer Memberships! Get 25% off now with code NEWYEAR-2025!

[SOLVED] Deleting Profile Book Entry

  • heyai
  • heyai
  • OFFLINE
  • Posts: 324
  • Thanks: 79
  • Karma: 24
10 years 2 weeks ago - 10 years 2 weeks ago #254963 by heyai
[SOLVED] Deleting Profile Book Entry was created by heyai
Joomla 3.3.6
CB 2.0.4
CB ProfileBook 2.0.0

When attempting to delete a ProfileBook entry this happens

1054 Unknown column 'Array' in 'where clause' SQL=DELETE FROM `***_comprofiler_plug_profilebook` WHERE Array = ******


Thought I had tested this before, but of course, as soon as I let users back on the site they broke it ;-)

The number given in the SQL query is a valid entry ID, it's just trying to delete it from the wrong column.

Can anyone confirm this or is it a problem on my end?
hey-ai - the community for asian guys and non-asian girls

The search bar is your friend, not just decoration!
Last edit: 10 years 2 weeks ago by nant.
The following user(s) said Thank You: beat

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

  • beat
  • beat
  • OFFLINE
  • Posts: 2174
  • Thanks: 463
  • Karma: 352
10 years 2 weeks ago #254995 by beat
Replied by beat on topic Deleting Profile Book Entry
Indeed a good find: It *is* a bug. Thanks for reporting!

Added to tracker items with fix here: forge.joomlapolis.com/issues/4944

We have also just released CB ProfileBook 2.0.1 which includes just that fix and that is available for downloads in our Advanced members download section here:

www.joomlapolis.com/downloads/downloads-single-items/cat_view/56-advanced-member-download-area
Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info
The following user(s) said Thank You: nant, heyai

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

  • heyai
  • heyai
  • OFFLINE
  • Posts: 324
  • Thanks: 79
  • Karma: 24
10 years 2 weeks ago #255047 by heyai
Replied by heyai on topic Deleting Profile Book Entry
Many thanks for the quick fix!!
hey-ai - the community for asian guys and non-asian girls

The search bar is your friend, not just decoration!
The following user(s) said Thank You: nant

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

Moderators: beat, nant, krileon
Powered by Kunena Forum