SQL Error after upgrade
Hi,
I’ve just updated to the latest scalability pro plug-in and I’m now getting this error:
[You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘CHARACTER SET utf8, primary key (postid, userid, cacheview, cachegr’ at line 6]
CREATE TABLE wp_scalability_pro_cache ( postid int not null, userid int not null, cacheview varchar(50) not null, cachegroup varchar(50) not null, cachedata text not null CHARACTER SET utf8, primary key (postid, userid, cacheview, cachegroup) )
Cheers,
Gav
April 26, 2019 @ 3:40 pm
Hi – I believe this was fixed 1st April version 4.49.
You can see the changelog here:
https://www.wpintense.com/product/scalability-pro/
Turns out it was a bug in how WordPress dbdelta works!
Re-open this if the issue still exists somehow.