Skip to Content Skip to Menu

[SOLVED] Error 1118 When Saving New Field

  • nwrightau
  • nwrightau
  • OFFLINE
  • Posts: 16
  • Thanks: 1
  • Karma: 0
10 years 5 months ago - 10 years 5 months ago #245571 by nwrightau
Hi,


On friday I was happily adding fields to a CB site we are working on (CB 1.91 & Joomla 3.3), we've added most of them, but now have reached this error when we attempt to save a new field and also when trying to execute the fix fields script in CB tools.

Any ideas what causes this and how to fix?




Thanks
Attachments:
Last edit: 10 years 5 months ago by krileon.

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
10 years 5 months ago #245573 by nant
Replied by nant on topic Error 1118 When Saving New Field

nwrightau wrote: Hi,


On friday I was happily adding fields to a CB site we are working on (CB 1.91 & Joomla 3.3), we've added most of them, but now have reached this error when we attempt to save a new field and also when trying to execute the fix fields script in CB tools.

Any ideas what causes this and how to fix?




Thanks


Please turn on Joomla debug to maximum level and see if something more useful is displayed.

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

  • nwrightau
  • nwrightau
  • OFFLINE
  • Posts: 16
  • Thanks: 1
  • Karma: 0
10 years 5 months ago #245574 by nwrightau
Replied by nwrightau on topic Error 1118 When Saving New Field

nant wrote:

nwrightau wrote: Hi,


On friday I was happily adding fields to a CB site we are working on (CB 1.91 & Joomla 3.3), we've added most of them, but now have reached this error when we attempt to save a new field and also when trying to execute the fix fields script in CB tools.

Any ideas what causes this and how to fix?




Thanks


Please turn on Joomla debug to maximum level and see if something more useful is displayed.


Hi,

Already did that no extra errors were displayed.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48478
  • Thanks: 8282
  • Karma: 1443
10 years 5 months ago #245602 by krileon
Replied by krileon on topic Error 1118 When Saving New Field
How many fields do you have? Likely hit the field limit due to database column size limits.


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.

  • nwrightau
  • nwrightau
  • OFFLINE
  • Posts: 16
  • Thanks: 1
  • Karma: 0
10 years 5 months ago #245629 by nwrightau
Replied by nwrightau on topic Error 1118 When Saving New Field

krileon wrote: How many fields do you have? Likely hit the field limit due to database column size limits.


132 fields surely there's a way around it?

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48478
  • Thanks: 8282
  • Karma: 1443
10 years 5 months ago #245643 by krileon
Replied by krileon on topic Error 1118 When Saving New Field
Yeah, you're hitting column size limit. The below is a possible workaround.

www.joomlapolis.com/forum/64-rc3-general-discussions/78961-comprofiler-table-reaches-maximum-database-fields#78981

The alternative is to edit all of your _comprofiler database tables and change their engine from MyISAM to InnoDB, which should allow for up to 1,000 fields. The engine change is already done in CB 2.0.


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