TOPIC:

Installing ContentBuilder Error 2 years 1 month ago #234800

  • larryf's Avatar Topic Author
  • larryf
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 7
  • Thanks: 0
I have searched google and forums but cant find an answer. I have BreezingForms installed ok, I attempted to install content builder and I get this error:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

Help!

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

Installing ContentBuilder Error 2 years 1 month ago #234801

  • gwsdesk's Avatar
  • gwsdesk
  • Offline
  • Moderator
  • Moderator
  • Already being the preferred Service Provider
  • Posts: 200
  • Karma: 73
  • Thanks: 23
Hi there,
This is most likely caused by a wrong database collation of your MySQL DB. Two things to check or act:

1) Make sure the database you are using is MySQLi (and not mysql). You can check that in your Joomla conciguration in the tab. "Database"

2) Change the collation of your database to 'utf8mb4' which is the current advised collation for Joomla. You can do that by installing Admin Tools (free) by Akeebabackup and run a one click (!) database collation change

Leo B)
Breezingforms Professional Support Services :: gws-desk.com/extensions-support/breezingforms-support
Joomla Specialized Hosting :: gws-host.com
Joomla Specialized Webmaster Services : Hire Your Webmaster! :: gws-webmaster.services
Member of the Joomla Bug Squad & Joomla CMS - Release Team
The following user(s) said Thank You: gilanrodas

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

Last edit: Post by gwsdesk.

Installing ContentBuilder Error 2 years 1 month ago #234822

  • larryf's Avatar Topic Author
  • larryf
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 7
  • Thanks: 0
Thanks!

I know I'm using SQL (PDO) so will try SQLi. I've already tried changing the database collation to UTF8 Multibyte.

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

Installing ContentBuilder Error 2 years 1 month ago #234826

  • larryf's Avatar Topic Author
  • larryf
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 7
  • Thanks: 0
Neither of these suggestions worked. However, I did get it working and installed.

This installation was for a new (redesigned) website. I exported the contentbuilder tables form the existing website and imported them into the new website. This allowed the installation of Contentbuilder without errors on the new website.

Thanks for the suggestions and quick response.
Larry

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

Installing ContentBuilder Error 2 years 4 weeks ago #234839

  • gwsdesk's Avatar
  • gwsdesk
  • Offline
  • Moderator
  • Moderator
  • Already being the preferred Service Provider
  • Posts: 200
  • Karma: 73
  • Thanks: 23
Glad you got it working. Remember though that PHP7+ requires MySQLi (!)

Leo B)
Breezingforms Professional Support Services :: gws-desk.com/extensions-support/breezingforms-support
Joomla Specialized Hosting :: gws-host.com
Joomla Specialized Webmaster Services : Hire Your Webmaster! :: gws-webmaster.services
Member of the Joomla Bug Squad & Joomla CMS - Release Team

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

Last edit: Post by gwsdesk.

Installing ContentBuilder Error 1 week 6 days ago #256849

  • gilanrodas
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 1
  • Thanks: 0
Thank you! I had the same problem. This solved me part of the problem for me. The max key length I finally solved it with Admin Tools, changing the collation to UTF-8 (legacy).

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

  • Page:
  • 1
Moderators: ForumSupport
Time to create page: 0.053 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!