For more reference I use Local app:
Web server Nginx
PHP 8.3.23
WP version 6.8.2
Theme is Kadence, recently updated to version 1.2.28
-
This reply was modified 8 months, 3 weeks ago by
rowanrho.
Plugin Support
Laszlo
(@laszloszalvak)
Hi @rowanrho
Your error messages seem quite strange as none of those columns should be BLOB or TEXT types.
- wp_nextend2_section_storage -application should be varchar(20)
- wp_nextend2_smartslider3_sliders – slider_status should be varchar(50)
- wp_nextend2_smartslider3_sliders – time should be datetime
So according to your error messages, something ( most likely a third party plugin ) modified our database tables and messed their structures up.
To figure this out please:
- connect to your phpMyAdmin
- find the “wp_nextend2_section_storage” and “wp_nextend2_smartslider3_sliders” tables
- open them
- check their structure on the Structure tab and compare them to the one that you see in my screenshots: https://imgur.com/a/YFGWWlz
If the types are different indeed, then a third party modified your database tables indeed.
In this case, you should:
A.) ask your server host if they have a previous backup, where the database tables still have the correct structure. If they do ,then they should roll back to that backup.
B.) if they don’t have one, then you should create a backup just in case, then try modifying the structures manually to the correct type.
Note: you should find the plugin that modifies the database table structure, as this could happen in the future again. My first guess would be a backup / migrator / database optimizer plugin, as regular plugins don’t really tend to modify the database tables of other plugins.
I don’t have Web hosting (this web is only visible thru Local hosting, nobody has access aside from me).
However, I could not tell if any other Plugin that was updated might have messed up any Slider file.
I’ve tried changing the name of the Smart slider folder under the Plugin section (to turn it off manually) and, when the smart slider is “off”, I can go back to my Admin page in WP. However, if I turn it back to normal, it goes into “Fatal error” again.
I have backups for my web page, however when going back, also the plugin will go back to the last version. Which might be a solution. But I probably won’t be able to keep on track of updates if so.
Plugin Support
Laszlo
(@laszloszalvak)
@rowanrho
Yes, until the table structure is wrong, the error will occur as we won’t be able to complete the update because a database error will be triggered each time we try to modify the tables.
So just to confirm that the problem is actually caused by the wrong column types, please check the database structure in the mentioned tables in your phpMyAdmin and send us a screenshot of each.
Tip: I am not really sure what software you used for the hosting of the website, but in case of softwares like XAMPP or Wamp, you can access the phpMyAdmin at http://localhost/phpmyadmin/
I don’t use any of those (Not phpMyadmin, XAMPP or Wamp). I use a program called Local (https://localwp.com/), it’s a tool used for Local Hosting, which I’m currently using (I didn’t finish my project, so I’m not paying any Hosting service yet). My site is not published (it’s only stored in my own computer).
Plugin Support
Gabor
(@nextendweb_gabor)
Hi @rowanrho!
We are not familiar with managing/configuring LocalWP, but you should be able to access your database as you see here:
https://community.localwp.com/t/does-localwp-has-myphpadmin-server-how-could-i-access-to-myphpadmin-server-used-by-localwp/29301/2
That is where you should check, whether or not the listed database columns have correct types, and if they do not, their types should be modified:
- wp_nextend2_section_storage – application should be varchar(20)
- wp_nextend2_smartslider3_sliders – slider_status should be varchar(50)
- wp_nextend2_smartslider3_sliders – time should be datetime
Please note, that configuring servers is out of scope of our support. So if you aren’t sure how to fix LocalWP’s database, you could try to get in touch with their support:
https://community.localwp.com/c/support/
From our end the only thing we can suggest is that if you don’t have too many sliders, then:
- Restore the working version of your website.
- As you see here at (2), export all your sliders: https://smartslider.helpscoutdocs.com/article/1728-export-import-slider#export
and unzip the zip file into your computer, to see the .ss3 files.
- Try to update Smart Slider again, in case now the database will be correct.
- If the database won’t be correct, delete all our database tables: https://smartslider.helpscoutdocs.com/article/1956-all-folder-file-and-database-table-created-by-smart-slider#db
- Press “Analyze & Repair”: https://smartslider.helpscoutdocs.com/article/1944-smart-slider-3s-menu-is-missing#installation-caused-problem
which will reinstall the tables, and hopefully that will work out fine.
- If you can access Smart Slider afterwards, import the .ss3 files of your sliders:
https://smartslider.helpscoutdocs.com/article/1728-export-import-slider#import
Turn on “Restore Slider” at importing:
https://smartslider.helpscoutdocs.com/article/1728-export-import-slider#import-project
to ensure the IDs will be the same as they were. This way the published sliders should be fine.
So all in all, this is a LocalWP error that can only be fixed within its configuration, as from our codes we don’t have control over ensuring the server’s database works correctly. It is also possible, that LocalWP has a bug in its code, which creates an issue with database column types.
