Hi Lucy,
You must save a publication before you can test it, so we need to fix the save action first. What error do you get when you try to save? Can you add a screenshot?
Best regards,
Peter
So the error in the title of this topic is the error i get when i try to save the publication and as shown in the picture in the first post. It happens right after i click “Save changes to database”.
Thanks Lucy,
Can you add screenshot of table wp_wpda_publisher? From the plugin menu:
– Start the Data Explorer
– Search for wp_wpda_publisher
– Click on the Manage link
– Click on tab Colums
– Create the screenshot
Best regards,
Peter
Hi Lucy,
For some reason your enum values for columns pub_responsive and pub_responsive_icon are gone. To solve this issue, copy the following line of code into a script file (named update.sql for example) and execute that script file from the Data Explorer (button Import data/Execute script(s)).
alter table wp_wpda_publisher modify pub_responsive enum('Yes','No'), modify pub_responsive_icon enum('Yes','No');
This will add the missing enum values. Please let me know if this solves your problem.
Best regards,
Peter
It almost solved my problem, but i got to the solution. So when i executed your script, the pub_responsive and pub_responsive_icon changed to enum(‘Y’,’N’) instead of enum(‘Yes’,’No’). I don’t really know why, but when i only changed pub_responsive data type, which seemed to cause problem it worked! So the final script that I used was:
alter table wp_wpda_publisher modify pub_responsive enum('Yes','No'), modify pub_responsive_icon enum('Y','N');
Thank you very much Peter, for your patience and help.
Hi Lucy,
Good to hear that part works, but you will not be able to set the icon property with this list. Can you try this:
alter table wp_wpda_publisher modify modify pub_responsive_icon enum('Yes','No');
Maybe it works if you modify column pub_responsive_icon only…
Best regards,
Peter
Hi, I have exactly the same problem (with the same image). I tried your script, manual editing via phpMyAdmin, it is still going back to the question marks (Y??, N?) or (???, ??)
I tried manually to add enum type field and the same result. Xampp 7.2.24, mariadb 10.4.8
Your plugin looks absolutely awesome, but this looks like the problem in the environment.
Hi Jimako,
What if you first set those column values to null
update wp_wpda_publisher set pub_responsive = null, modify pub_responsive_icon = null;
and then change the column type
alter table wp_wpda_publisher modify pub_responsive enum('Yes','No'), modify pub_responsive_icon enum('Yes','No');
Best regards,
Peter
