Skip to Content Skip to Menu

🌲 Merry Christmas! Great savings on Professional and Developer Memberships! Get 25% off now with code XMAS-2024!

Problem when verifying database

  • chanteur94
  • chanteur94
  • OFFLINE
  • Posts: 302
  • Thanks: 13
  • Karma: 1
9 years 9 months ago - 9 years 9 months ago #261302 by chanteur94
Problem when verifying database was created by chanteur94
Hi

In CB Tools, I start Verify/Check Database and I obtain error message :


Vérification de la base de données de Community Builder:

"Toutes les lignes de la table comprofiler_field_values fieldid correspondent à tous les champs existants

Attention: 6 entrées dans comprofiler_field_values renvoient à de mauvais champs de fieldtype.

fieldvalueid=117 fieldtype=textarea

fieldvalueid=119 fieldtype=textarea

fieldvalueid=118 fieldtype=textarea

fieldvalueid=132 fieldtype=textarea

fieldvalueid=133 fieldtype=textarea

fieldvalueid=134 fieldtype=textarea

Ceci peut être fixé dans SQL en utilisant un outil comme phpMyAdmin. "

The rest is OK.

I found nothing wrong with phpMyadmin (I check and analyse table `#__comprofiler_field_values` and `#__comprofiler_field`) and nothing wrong when I open my different fields.

Notice that fieldvalueid 119,132 and 134 doesn't exist and fieldvalueid 117,118 and 133 are textarea

Need some help please.

Thank you.

Joomla 3.4 CB 2.0.7
Last edit: 9 years 9 months ago by chanteur94.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48622
  • Thanks: 8303
  • Karma: 1446
9 years 9 months ago #261327 by krileon
Replied by krileon on topic Problem when verifying database
You changed a fields type from a select to a textarea, but that field had field values stored in the database. That's all that test is telling you. You can delete them within the _comprofiler_field_values database table as needed or just ignore it; it's up to you as it won't cause any harm. We'll be improving our tools checks in a future release.


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