Error occurred while creating tables or indexes…

  • Hi there!

    I was testing the plugin on a testing domain using MariaDB and WordPress was working fine. I started the plugin, but after i enter the information on the WordPress installation, step2 gives me an error and i’m unable to go further:

    Error occurred while creating tables or indexes...
    Query was: 'CREATE TABLE 5HEbuVs_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default \'\', user_pass varchar(255) NOT NULL default \'\', user_nicename varchar(50) NOT NULL default \'\', user_email varchar(100) NOT NULL default \'\', user_url varchar(100) NOT NULL default \'\', user_registered datetime NOT NULL default \'0000-00-00 00:00:00\', user_activation_key varchar(255) NOT NULL default \'\', user_status int(11) NOT NULL default \'0\', display_name varchar(250) NOT NULL default \'\', PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename), KEY user_email (user_email) ) DEFAULT CHARACTER SET utf8mb4'
    Error message is:

    Can someone help?
    Thanks!

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hello @filipecostacom thanks for getting in touch. Sorry to hear that you are facing these issues with the plugin and MariaDB. Could I please ask you to check this from another test site to see if you encounter the same on both sites?

    Could I also check if you have tested the same with a MySQL database to see if you encounter anything similar? We can run some tests also on our side with MariaDB to see if we can replicate this.

    You may also wish to share with us your Site Health information which we can check to see if anything here about your setup stands out.

    Thread Starter Filipe Costa

    (@filipecostacom)

    Hi there and thanks!

    Unfortunately i don’t have a server with MySQL, only with MariaDB 10.6.17… This plugin is only compatible with MySQL? I thought MariaDB and MySQL were compatible if not mostly the same?

    Here is my site information:

    ` wp-core

version: 6.5.3
site_language: pt_PT
user_language: pt_PT
timezone: +00:00
permalink: undefined
https_status: true
multisite: false
user_registration: 0
blog_public: 0
default_comment_status: open
environment_type: production
user_count: 1
dotorg_communication: true wp-paths-sizes

wordpress_path: /var/www/vhosts/i9ware.com/wpsqlite.i9ware.com
wordpress_size: 107,89 MB (113130017 bytes)
uploads_path: /var/www/vhosts/i9ware.com/wpsqlite.i9ware.com/wp-content/uploads
uploads_size: 420,64 KB (430733 bytes)
themes_path: /var/www/vhosts/i9ware.com/wpsqlite.i9ware.com/wp-content/themes
themes_size: 6,08 MB (6370607 bytes)
plugins_path: /var/www/vhosts/i9ware.com/wpsqlite.i9ware.com/wp-content/plugins
plugins_size: 17,30 MB (18135494 bytes)
database_size: 2,91 MB (3047424 bytes)
total_size: 134,58 MB (141114275 bytes) wp-dropins (3)

advanced-cache.php: true
maintenance.php: true
object-cache.php: true wp-active-theme

name: Twenty Twenty-Three (twentytwentythree)
version: 1.4
author: a equipa do WordPress
author_website: https://pt.www.ads-software.com
parent_theme: none
theme_features: core-block-patterns, post-thumbnails, responsive-embeds, editor-styles, html5, automatic-feed-links, widgets-block-editor, block-templates
theme_path: /var/www/vhosts/i9ware.com/wpsqlite.i9ware.com/wp-content/themes/twentytwentythree
auto_update: Activado wp-themes-inactive (2)

Hello Elementor: version: 3.0.1, author: Elementor Team, Actualiza??es automáticas activadas
Twenty Twenty-Four: version: 1.1, author: a equipa do WordPress, Actualiza??es automáticas activadas wp-plugins-active (7)

Duplicator: version: 1.5.9, author: Duplicator, Actualiza??es automáticas desactivadas
Image Placeholders: version: 1.1.0, author: WordPress Performance Team, Actualiza??es automáticas activadas
Maintenance: version: 4.08, author: WebFactory Ltd, Actualiza??es automáticas activadas
Modern Image Formats: version: 1.1.0, author: WordPress Performance Team, Actualiza??es automáticas activadas
Performance Lab: version: 3.0.0, author: WordPress Performance Team, Actualiza??es automáticas activadas
Performant Translations: version: 1.2.0, author: WordPress Performance Team, Actualiza??es automáticas activadas
WP Reset: version: 2.01, author: WebFactory Ltd, Actualiza??es automáticas activadas wp-plugins-inactive (4)

Cache Master: version: 2.1.3, author: Terry Lin, Actualiza??es automáticas activadas
Index WP MySQL For Speed: version: 1.4.17, author: Oliver Jones, Rick James, Actualiza??es automáticas activadas
SQLite Database Integration: version: 2.1.9, author: The WordPress Team, Actualiza??es automáticas desactivadas
SQLite Object Cache: version: 1.3.8, author: Oliver Jones, Actualiza??es automáticas activadas wp-media

image_editor: WP_Image_Editor_Imagick
imagick_module_version: 1690
imagemagick_version: ImageMagick 6.9.10-68 Q16 x86_64 2024-01-12 https://imagemagick.org
imagick_version: 3.7.0
file_uploads: 1
post_max_size: 16M
upload_max_filesize: 16M
max_effective_size: 16 MB
max_file_uploads: 20
imagick_limits:
imagick::RESOURCETYPE_AREA: 12 GB
imagick::RESOURCETYPE_DISK: 9.2233720368548E+18
imagick::RESOURCETYPE_FILE: 768
imagick::RESOURCETYPE_MAP: 12 GB
imagick::RESOURCETYPE_MEMORY: 6 GB
imagick::RESOURCETYPE_THREAD: 1
imagick::RESOURCETYPE_TIME: 9.2233720368548E+18
imagemagick_file_formats: 3FR, 3G2, 3GP, AAI, AI, ART, ARW, AVI, AVS, BGR, BGRA, BGRO, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DNG, DOT, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, EXR, FAX, FILE, FITS, FRACTAL, FTP, FTS, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, GV, H, HALD, HDR, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K25, KDC, LABEL, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPEG, MPG, MRW, MSL, MSVG, MTV, MVG, NEF, NRW, NULL, ORF, OTB, OTF, PAL, PALM, PAM, PANGO, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, PPM, PREVIEW, PS, PS2, PS3, PSB, PSD, PTIF, PWP, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, SVG, SVGZ, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIFF, VIPS, VST, WBMP, WMF, WMV, WMZ, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YCbCr, YCbCrA, YUV
gd_version: bundled (2.1.0 compatible)
gd_formats: GIF, JPEG, PNG, WebP, BMP, XPM
ghostscript_version: 9.25 wp-server

server_architecture: Linux 3.10.0-1160.90.1.vz7.200.7 x86_64
httpd_software: nginx/1.24.0
php_version: 8.3.6 64bit
php_sapi: fpm-fcgi
max_input_variables: 1000
time_limit: 120
memory_limit: 256M
max_input_time: 120
upload_max_filesize: 16M
php_post_max_size: 16M
curl_version: 7.29.0 NSS/3.90
suhosin: false
imagick_availability: true
pretty_permalinks: true
current: 2024-05-10T10:30:46+00:00
utc-time: Friday, 10-May-24 10:30:46 UTC
server-time: 2024-05-10T10:30:45+00:00 wp-database

extension: mysqli
server_version: 10.6.17-MariaDB
client_version: mysqlnd 8.3.6
max_allowed_packet: 16777216
max_connections: 151 wp-constants

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /var/www/vhosts/i9ware.com/wpsqlite.i9ware.com/wp-content
WP_PLUGIN_DIR: /var/www/vhosts/i9ware.com/wpsqlite.i9ware.com/wp-content/plugins
WP_MEMORY_LIMIT: 40M
WP_MAX_MEMORY_LIMIT: 256M
WP_DEBUG: false
WP_DEBUG_DISPLAY: true
WP_DEBUG_LOG: false
SCRIPT_DEBUG: false
WP_CACHE: false
CONCATENATE_SCRIPTS: false
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_ENVIRONMENT_TYPE: Indefinido
WP_DEVELOPMENT_MODE: undefined
DB_CHARSET: utf8
DB_COLLATE: undefined wp-filesystem

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
mu-plugins: writable
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error occurred while creating tables or indexes…’ is closed to new replies.