Skip to Content Skip to Menu

Incorrect date value

  • jmaridon
  • jmaridon
  • OFFLINE
  • Posts: 51
  • Thanks: 8
  • Karma: 2
1 day 7 hours ago #340879 by jmaridon
Incorrect date value was created by jmaridon
The site is mostly working, but users are almost always getting an invalid security token error when trying to log in.

I tried to install 2.10.0 (the previous version was 2.7.3), but the installer says the installation failed with the following error:

System Information
Joomla: 4.4.13
PHP: 8.2.18
Database: mysql 5.7.23-23

Package
File: 001_pkg_communitybuilder_2.10.0+build.2025.04.08.18.34.52.851a26ece.zip
Log:
Code:
<div>Incorrect date value: '' for column 'cb_pglastupdate' at row 1</div><div>Package Install: There was an error installing an extension: com_comprofiler.zip</div>

When I go to the CB Configuration page, it says that 2.10.0 is installed and no updates are available. When I look at the CB login module, it shows: Community Builder Login module
Login module to be used with Community Builder instead of the Login module.SiteModule2.7.3+build.2022.08.17.14.22.51.6a2f19b48
I have run checks on the CB Tools for database issues, and none were found.

Thank you in advance for your assistance. 

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 49058
  • Thanks: 8386
  • Karma: 1457
12 hours 25 minutes ago #340885 by krileon
Replied by krileon on topic Incorrect date value
cb_pglastupdate is an old field for CB ProfileGallery. That plugin has been discontinued for quite some time. I recommend just deleting that field in CB > Field Management. If you don't see it there try running the CB > Tools database tools first.


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.

  • jmaridon
  • jmaridon
  • OFFLINE
  • Posts: 51
  • Thanks: 8
  • Karma: 2
7 hours 55 minutes ago #340893 by jmaridon
Replied by jmaridon on topic Incorrect date value
Thank you for your guidance on resolving the CB 2.10.0 installation issue! Your suggestion to address the cb_pglastupdate field pointed us in the right direction. Our site has a bit of history—previous IT work left some lingering database issues from older CB versions, including the discontinued ProfileGallery plugin. While Field Management didn’t show the field, and CB Tools initially reported no errors, we found the cb_pglastupdate column in the database with problematic data. It took some extra steps to clean it up, including manually dropping the column and removing a related field definition, but we got there! CB 2.10.0 is now installed successfully on Joomla 4.4.13. Really appreciate your help in steering us toward the fix.

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

Moderators: beatnantkrileon
Powered by Kunena Forum