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] 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. 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.wordpress.org 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