Bienvenido, Invitado
Recordarme

TEMA:

Installing ContentBuilder Error 2 años 7 meses antes #234800

  • Avatar de larryf Autor del tema
  • larryf
  • Fuera de línea
  • Fresh Breezer
  • Fresh Breezer
  • Mensajes: 7
  • Gracias recibidas: 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!

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Installing ContentBuilder Error 2 años 7 meses antes #234801

  • Avatar de gwsdesk
  • gwsdesk
  • Fuera de línea
  • Moderator
  • Moderator
  • Already being the preferred Service Provider
  • Mensajes: 218
  • Karma: 73
  • Gracias recibidas: 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
Ex Member of the Joomla Bug Squad & Joomla CMS - Release Team
El siguiente usuario dijo gracias: gilanrodas

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Última Edición: Post by gwsdesk.

Installing ContentBuilder Error 2 años 7 meses antes #234822

  • Avatar de larryf Autor del tema
  • larryf
  • Fuera de línea
  • Fresh Breezer
  • Fresh Breezer
  • Mensajes: 7
  • Gracias recibidas: 0
Thanks!

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

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Installing ContentBuilder Error 2 años 7 meses antes #234826

  • Avatar de larryf Autor del tema
  • larryf
  • Fuera de línea
  • Fresh Breezer
  • Fresh Breezer
  • Mensajes: 7
  • Gracias recibidas: 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

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Installing ContentBuilder Error 2 años 7 meses antes #234839

  • Avatar de gwsdesk
  • gwsdesk
  • Fuera de línea
  • Moderator
  • Moderator
  • Already being the preferred Service Provider
  • Mensajes: 218
  • Karma: 73
  • Gracias recibidas: 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
Ex Member of the Joomla Bug Squad & Joomla CMS - Release Team

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

Última Edición: Post by gwsdesk.

Installing ContentBuilder Error 6 meses 2 semanas antes #256849

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).

Por favor, Identificarse o Crear cuenta para unirse a la conversación.

  • Página:
  • 1
Moderadores: ForumSupport
Tiempo de carga de la página: 0.058 segundos