Answers.Body: <p>I reduced the number of fields in the profile - I was at 40 and brought it down to 35. I had a big text block of Terms and Conditions with a &quot;Do you accept the Terms &amp; Conditions&quot;, with a &quot;Yes&quot; radio button as required field. and that was just too big.
  I just had a successful registration for our championship, from Hawaii no less!</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-03-31T20:01:56.607Z
Answers.Text: well sleuthed - we hit a similar problem just yesterday and we are thinking about a PR to ensure that some appropriate "you may be adding too many fields to this fieldset" is added to the code. Actually in our case the problem was that the log table for the 'value' table had not added the extra columns, the fieldset itself was fine!
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-03-31T06:09:45.010Z
Answers.LastActivityDate: 2023-03-31T06:09:45.010Z
Answers.UserDisplayName: Karen-Ann
Answers.Body: <p>Are you using YOOtheme Pro? And its extension Essentials for YOOtheme by ZOOlanders?<br/>
  Try deactivating the plugin: <a href="https://lab.civicrm.org/dev/core/-/issues/4394#note_92175" rel="nofollow noreferrer">https://lab.civicrm.org/dev/core/-/issues/4394#note_92175</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-06-27T15:01:33.467Z
Answers.LastActivityDate: 2023-06-27T15:01:33.467Z
Answers.UserDisplayName: Guitarman
Answers.Body: <p>We encountered the same problem after the upgrade to CiviCRM version 5.62.1 on Joomla 3.10.11. Event registrations are impossible now.
  We didn't see this error in previous versions.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-06-26T16:05:48.747Z
Answers.LastActivityDate: 2023-06-26T16:05:48.747Z
Answers.UserDisplayName: Guitarman
Body: <p>Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred. DB Error: unknown error Return to home page.</p>
  <p>There's nothing in the DB log.</p>
  <p>I tried the Settings/Cleanup Caches and Update Paths/ panel doing both Cleanup Caches and Reset Paths, but to no avail.</p>
  <p>This was from civi that was upgraded. I read that this can be caused by a problem when the database does not upgrade properly.</p>
  <p>Since i didn't have much data, I did a fresh install, so a clean 5.94.4 and recreated custom  fields, two profiles and two events.</p>
  <p>When registering for the events i still get the same error on my clean install.</p>
  <p>Backtrace gives me the following:
  CRM_Core_Exception: Could not find valid value for id in /home/mobility/public_html/administrator/components/com_civicrm/civicrm/CRM/Event/StateMachine/Registration.php on line 27</p>
  <p>Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  Could not find valid value for id</p>
  <p>**** I did find this reference, seems this problem has been seen since 2015?
  <a href="https://civicrm.stackexchange.com/questions/4793/civievent-error-when-registering-could-not-find-valid-value-for-id">CiviEvent - Error when registering: Could not find valid value for id</a></p>
  <p>Are there any current solutions? My CiviEvent setup is quite vanilla. HELP!</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-03-30T23:48:41.643Z
Comments.Text: perhaps you could see if you can replicate problem via a joomla demo site ie https://civicrm.org/demo?field_language_value=All&field_cms_demo_value=joomla
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-03-31T02:40:14.713Z
Comments.Text: Thanks for the reply. Joomla demo site i could not create custom fields and could not create a profile. I used what was there. Created an event, and price set.
Comments.UserDisplayName: Karen-Ann
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-03-31T02:46:05.620Z
Comments.Text: Thanks for the reply. I am using civi 5.59.4 fresh install. demo site is 5.58.0.  Joomla demo site i could not create custom fields and could not create a profile. My event has alot i mean alot of custom fields in a profile. I use a price set. The preview of the price set i created looks as expected.
Comments.UserDisplayName: Karen-Ann
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-03-31T02:48:37.270Z
Comments.Text: On demo site i created an event using the price set i created. The price set does not show my first item in Event Link - Live. Note: on my event, that part is fine. 
  On demo site i get the confirmation page, and then i get to paypal. This is what i expect/want.
  On my site, i get the error before i get to paypal (standard).
Comments.UserDisplayName: Karen-Ann
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-03-31T02:48:55.143Z
Comments.Text: i would welcome some help and will pay for it.
Comments.UserDisplayName: Karen-Ann
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-03-31T03:02:08.760Z
Comments.Text: On my site, if i use a standard profile, i.e. without custom fields it works.
Comments.UserDisplayName: Karen-Ann
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-03-31T03:14:23.950Z
Comments.Text: Ok, more info... i found that if i use a profile with custom fields it fails. Issue is the custom fields not linking to the contact.
Comments.UserDisplayName: Karen-Ann
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-03-31T03:18:09.667Z
Comments.Text: DB Error: unknown error
  Mode 16
  UserInfo INSERT INTO civicrm_value_sailor_1........[nativecode=1406 ** Data too long for column 'media_consent_25' at row 1]
  PEAR_Exception: DB Error: unknown error in /home/mobility/public_html/administrator/components/com_civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 945
  - DB_Error: DB Error: unknown error in unknown on line unknown
Comments.UserDisplayName: Karen-Ann
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-03-31T05:15:17.347Z
Comments.Text: I have hit the limit of too many custom fields in 1, or 2 combined profiles at 40 records  for it to be able to save to the contact record
Comments.UserDisplayName: Karen-Ann
Tags: <civievent><joomla><database>
Title: - Could not find valid value for id
ThreadText: # - Could not find valid value for id
  
  (Asked by: username_0 on 2023-03-30)
  
  Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred. DB Error: unknown error Return to home page.
  
  There's nothing in the DB log.
  
  I tried the Settings/Cleanup Caches and Update Paths/ panel doing both Cleanup Caches and Reset Paths, but to no avail.
  
  This was from civi that was upgraded. I read that this can be caused by a problem when the database does not upgrade properly.
  
  Since i didn't have much data, I did a fresh install, so a clean 5.94.4 and recreated custom fields, two profiles and two events.
  
  When registering for the events i still get the same error on my clean install.
  
  Backtrace gives me the following:
  CRM\_Core\_Exception: Could not find valid value for id in /home/mobility/public\_html/administrator/components/com\_civicrm/civicrm/CRM/Event/StateMachine/Registration.php on line 27
  
  Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
  Could not find valid value for id
  
  \*\*\*\* I did find this reference, seems this problem has been seen since 2015?
  [CiviEvent - Error when registering: Could not find valid value for id](https://civicrm.stackexchange.com/questions/4793/civievent-error-when-registering-could-not-find-valid-value-for-id)
  
  Are there any current solutions? My CiviEvent setup is quite vanilla. HELP!
  
  **Tags:** civievent, joomla, database
  
  > **Comments:**
  > **username_1**: perhaps you could see if you can replicate problem via a joomla demo site ie https://civicrm.org/demo?field_language_value=All&field_cms_demo_value=joomla  
  > **username_0**: Thanks for the reply. Joomla demo site i could not create custom fields and could not create a profile. I used what was there. Created an event, and price set.  
  > **username_0**: Thanks for the reply. I am using civi 5.59.4 fresh install. demo site is 5.58.0.  Joomla demo site i could not create custom fields and could not create a profile. My event has alot i mean alot of custom fields in a profile. I use a price set. The preview of the price set i created looks as expected.  
  > **username_0**: On demo site i created an event using the price set i created. The price set does not show my first item in Event Link - Live. Note: on my event, that part is fine.  On demo site i get the confirmation page, and then i get to paypal. This is what i expect/want. On my site, i get the error before i get to paypal (standard).  
  > **username_0**: i would welcome some help and will pay for it.  
  > **username_0**: On my site, if i use a standard profile, i.e. without custom fields it works.  
  > **username_0**: Ok, more info... i found that if i use a profile with custom fields it fails. Issue is the custom fields not linking to the contact.  
  > **username_0**: DB Error: unknown error Mode 16 UserInfo INSERT INTO civicrm_value_sailor_1........[nativecode=1406 ** Data too long for column 'media_consent_25' at row 1] PEAR_Exception: DB Error: unknown error in /home/mobility/public_html/administrator/components/com_civicrm/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php on line 945 - DB_Error: DB Error: unknown error in unknown on line unknown  
  > **username_0**: I have hit the limit of too many custom fields in 1, or 2 combined profiles at 40 records  for it to be able to save to the contact record  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_0 on 2023-03-31. Score: 1
  
  I reduced the number of fields in the profile - I was at 40 and brought it down to 35. I had a big text block of Terms and Conditions with a "Do you accept the Terms & Conditions", with a "Yes" radio button as required field. and that was just too big.
  I just had a successful registration for our championship, from Hawaii no less!
  
  > **Comments:**
  > **username_1**: well sleuthed - we hit a similar problem just yesterday and we are thinking about a PR to ensure that some appropriate "you may be adding too many fields to this fieldset" is added to the code. Actually in our case the problem was that the log table for the 'value' table had not added the extra columns, the fieldset itself was fine!  
  
  ---
  
  ### Answer by username_2 on 2023-06-27. Score: 0
  
  Are you using YOOtheme Pro? And its extension Essentials for YOOtheme by ZOOlanders?  
  Try deactivating the plugin: <https://lab.civicrm.org/dev/core/-/issues/4394#note_92175>
  
  
  ---
  
  ### Answer by username_2 on 2023-06-26. Score: 0
  
  We encountered the same problem after the upgrade to CiviCRM version 5.62.1 on Joomla 3.10.11. Event registrations are impossible now.
  We didn't see this error in previous versions.
  
  
  ---
  
  