Skip to Content Skip to Menu

[SOLVED] Can't update

  • jurgeng
  • jurgeng
  • OFFLINE
  • Posts: 8
  • Thanks: 1
  • Karma: 0
6 years 11 months ago #298965 by jurgeng
Replied by jurgeng on topic Can't update
Thanks,

Ironically, everything works just fine otherwise. I can add new members, work with them along the way, etc...
What check could I do to find the error in the table? I don't have any issues around phpMyAdmin. I don't know the innards of com_profiler table or CB code to know what I should expect...

Thanks,
Jurgen

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

  • jurgeng
  • jurgeng
  • OFFLINE
  • Posts: 8
  • Thanks: 1
  • Karma: 0
6 years 11 months ago - 6 years 11 months ago #298970 by jurgeng
Replied by jurgeng on topic Can't update
Okay,
I found in the comprofiler table that every record was in there twice. So I had to find a way to remove duplicates. Here's what I found:

ALTER IGNORE TABLE `__comprofiler` ADD UNIQUE (user_id, id)

... and this apparently fixed the duplicates.

... and then the update worked just fine.
Last edit: 6 years 11 months ago by jurgeng.
The following user(s) said Thank You: krileon

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48444
  • Thanks: 8279
  • Karma: 1443
6 years 11 months ago #298996 by krileon
Replied by krileon on topic Can't update
I've no idea how you ended up with duplicate _comprofiler rows, but thank you for sharing your solution.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

Moderators: beatnantkrileon
Powered by Kunena Forum