I've just updated the version of Amelia from version 5.2 to version 5.4. After the update, the booking form kept showing the load icon. I'm using "Booking forms 1.0".
I do backups every 50 minutes so I was able to revert to my backup. I did not need an older version of the plugin. Was not able to find anything online thats trustworthy :/
Darn it. I didn't notice it in time, and I have a subscription service on the site so can't rollback to yesterday without potential other issues. I'll just have to take my booking page offline until Amelia support comes back to me.
As far as know, TMS isn't having any way to roll back to a certain plugin version, or download an older version. I've backed up the plugins before updating them so I was able to roll back.
First thing would of course be to make a backup, but it would really be nice if TMS would make a plug-in rollback possible, or to download the older version of a plug-in.
Yeah I made the mistake of not checking the events page right after updating, and didn't notice until the next day.
Thankfully, I found I had 5.2 installed on the staging site, so used those files. Events are back up now and I still have a ticket open, waiting on support.
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Thanks for your reply. I'm sorry but that won't be a possibility for me. That would mean I have to update the plug-in on the live website which will prevent any customers from booking their appointments and possibly other things too.
If there's anything else i can help, i'll gladly help out, but this won't be an option.
Would you be able to provide us with a staging site, If you're not able to provide us with a staging site, can you clone your website?
If yes - I'll ask you to install the Duplicator plugin. It will generate a couple of files that you can send me (along with the login credentials), and then I can create an exact copy of your website, see what the issue is and try to resolve it.
The Duplicator plugin can export only up to 500MB of data, so if your site is bigger than that, please use the All-in-One WP Migration plugin.
Please note that the files will be too large to attach to the ticket, so you can upload them via wetransfer.com and just send me the link.
There was a missing column in the wp_amelia_users table. This was probably caused by an issue in the database and the column was not added. The column name is "description".
Hope this helps you.
Please let me know if you have any other questions.
As this seems to be an issue that multiple people are experiencing, it looks like this is a generic issue. Currently the website is using Amelia v5.2 and is working fine, i'll wait till a new version has been released that'll fix this issue. If the issue persists i dont mind taking further action to solve the issue, but for now i'd say lets wait till a fix has been deployed in an upcoming version.
The fix will be included in the next update. When this type of issue occurs after the update, first try to reactivate the plugin and clean the cache afterward, if that does not help you, reach out to us and we will assist you with it.
Hope this helps you.
Please let us know if you have any other questions.
Our developers are working to launch a new update very soon.
We can't say an exact ETA on it, but they are doing their best to finish as quick as possible.
We just wanted to add more details on how you guys can fix this issue, if you have access to your WordPress database ( of course, you can always ask your hosting support, they should be able to help you access it).
-
Basically, what happened here is, during the update, there is one column that did not correctly get generated in your database, so it's missing.
We don't have many people that reported it, but there are several users.
-
If you wish to try, here is how to fix it, by adding the missing column manually.
It is in "wp_amelia_users" table, the column name is "description".
( the wp_ prefix is the default WordPress database prefix; but you have to check on your DB, you probably have a different table prefix)
First, you have to run this SQL Query on the database,
in PHPMyAdmin.
This is required to allow the column to be added to the wp_amelia_users table :
ALTER TABLE wp_amelia_users ROW_FORMAT=DYNAMIC;
As mentioned, the "wp_" prefix is the default WordPress prefix,
but if you have another prefix for your database tables, you will need to alter the query.
For example, if your prefix is "my_database", the table would be "my_database_amelia_users".
-
Once you run this Query, you need to insert a new column into the table "wp_amelia_users",
and it should be inserted after the column "note".
Collation should be the same as it is for other columns in the table;
name : "description";
type : "TEXT" without character limit;
NULL : YES/checked.
-
-
Once you add this column, the issue should be fixed.
If you need us to do this for you,
we would need access to your WordPress Database.
Since Bart is the creator of the ticket, you could send us the access in a Private response;
but for the others -you would have to open a new, private ticket, then you can send us your access there.
We would need the access page URL , for the PHPMyAdmin, along with the login credentials for it.
Then we can log in to the database and add this missing column for you.
Let us know how it goes, and we hope this has helped.
The next update will be released next week (I hope it will be on Monday, but I can't make any promises).
As for the issue, Uros described:
In 5.4 we've included the "Employee Description", which was also added to the database as a column in the wp_amelia_users table.
For some reason, the plugin couldn't create that column, which resulted in the error when the services linked to your employees were pulled - the plugin tried pulling the data from the "description" column, while the column was never created.
You can reach out to your hosting provider and have them check if the plugins have the necessary permissions to create/update database tables.
As it doesn't happen on all installations, it can't be classified as an official bug, but our developers will make some changes to the code and attempt to override the behavior of some databases when it comes to issues like this.
We've added some programmatical fixes for this issue and it should work for most servers.
We can't, however, guarantee that there aren't some servers that are still blocking the ability for the plugin to create a column. Can you create a backup of your site, update Amelia, purge the cache and then try to update to v5.4.1. Please let me know if it works correctly.
Just got around to doing this. The new update does not resolve this issue. One still has to go back and alter the table.
Commands to do so from CLI are.
Connect to db:
mysql -u root -p'PASSWORD'
use WORDPRESS;
ALTER TABLE wp_amelia_users ROW_FORMAT=DYNAMIC;
ALTER TABLE wp_amelia_users
ADD description TEXT
AFTER note;
Ive tried these and they do work on bringing back up the plugin. I do how ever would like to get these commands confirmed by a developer please. Would it be wise to connect in as root?
It is OK, but I'd change the ADD statement to this:
ADD `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `note`
Since this column needs to have NULL as the default value, and the character set is usually utf8, but of course, you need to check that in your database.
Oddly, I reverted back when I had asked to confirm the commands. Updating to from 5.4 to 5.6 and doing it today with my original commands it would not work. I then reverted back and tried again with your suggested command and it was the same issue.
I have noticed the following error after updating and running the db fix.
This is how my table looks like after making the changes.
Ive reverted back to a working backup in the meantime.
I was hoping that the newer versions of Amelia would fix the issue, but that wasn't the case. Not very familiair with databases, but i managed to get the changes done after following the steps mentioned by Miloš; that worked!
Thanks a lot for the support and description on how to update the database.
I finally attempted the update again, (had to because the notification short code bugs that were fixed in one of the updates were causing me issues).
In the attempt, the same thing happened and my events disappeared just like before. So I followed these instructions on manually adding a column. I am comfortable editing databases so this did not really worry me, but it wasn't as straightforward as I had hoped. I got a few errors and I'll explain here in hopes to help understand why some are having the issues and not everyone.
First of all, I am hosted with Cloudways.
When I attempted to add the column, I got this error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs 10:08:15 SQL command
I contacted Cloudways support and they had to add this to the server configuration:
I attempted to add the column again. This time it was successful, but I got this warning:
Warning 139 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
Even with the warning, the site did seem to be fixed and my events loaded. I gave the error to Cloudways support and then they added this server settings to get rid of the warning message, so it can use ROW_FORMAT=DYNAMIC
nnodb_file_format = barracuda
I asked support if there was anything else I should do at this point since I already altered the table, and they said I would need to check with the plugin developer.
So, with this information:
1. Do I need to make any further changes to my database table/column? 2. I hope you can use this information and error data to further troubleshoot the upgrade issues I, and others, had during this update. Hopefully this helps others.
UPDATE. I just tried to update WP Amelia on another site, and this time the new column "description" was added to the table during the update, however it was added at the end instead of immediately after the column "note".
I edited the table and moved the column up to be after "note". Do you know why this would happen, and how important is it that "description" immediately follow "note" in the database table?
Interesting! Im glad you got your to work out! Would you have the commands(Just to compare) that you used when adding to the database or did you use a UI?
We've never had issues like this, and we had to add at least 30 of these columns in the past couple of months.
In order to help you out, I will need to check out your database, I can't say what helps without trial and error. Since this is not your ticket, you can't provide us with credentials, but you can open a new Private ticket, where you'll provide us with the site access and the database access URL and credentials, and we'll gladly take a look and see what's going on.
Sorry for the delay. Had some time off in the holidays.
It seems this has not worked for me. It appeared to work on the site I have using events, but my other site using appointments broke. Huge blocks of time(in the middle of the day) are now unavailable for admin making appointments (probably customers too).
I updated to latest version at the time (5.6) and in my new ticket, support is very unhelpful, since the now latest version is 6.1. https://tmsplugins.ticksy.com/ticket/3197758
Anyway, I have rolled back to 5.2, since that is the only version I have to rollback to, and Amelia doesn't offer past versions to help with this. Atleast 5.2 is allowing me to enter my appointments again.
My guess is that more columns were meant to be added between 5.2 and 5.6 and didn't get added or didn't get added correctly. I have no way of knowing.
So, just updating this post here in case anyone else has this issue. I want them to know that the problem is not solved with updates and updates seem to be getting worse. I am now going through and further testing my other site which uses events. Its currently on 5.2 and I need to track down any issues there.
I'm sorry to hear that you're still having issues with Amelia, Traci.
The fact is that, with over 10.000 active installations, there's only a handful of sites that face this issue where new columns (or tables) are not added correctly to the database, but we can't figure out why that is happening, since we can't replicate the issue.
Can you please tell me who's your hosting provider, what type of database you have, what versions of PHP and the database are, and we'll see if we can create a site with that provider and replicate the issue.
I'll take over the ticket you've mentioned, and we'll see what I can do to help there.
We can then update this ticket once the issue is resolved.
Hi there,
I've just updated the version of Amelia from version 5.2 to version 5.4. After the update, the booking form kept showing the load icon. I'm using "Booking forms 1.0".
Best regards,
I can confirm that this happened to me too.
I have since gone back to 5.3
This has happened to me to. Where do you get the old versions of the plugin? I'd like to go back to 5.3 asap.
I do backups every 50 minutes so I was able to revert to my backup. I did not need an older version of the plugin. Was not able to find anything online thats trustworthy :/
Darn it. I didn't notice it in time, and I have a subscription service on the site so can't rollback to yesterday without potential other issues. I'll just have to take my booking page offline until Amelia support comes back to me.
As far as know, TMS isn't having any way to roll back to a certain plugin version, or download an older version. I've backed up the plugins before updating them so I was able to roll back.
First thing would of course be to make a backup, but it would really be nice if TMS would make a plug-in rollback possible, or to download the older version of a plug-in.
Yeah I made the mistake of not checking the events page right after updating, and didn't notice until the next day.
Thankfully, I found I had 5.2 installed on the staging site, so used those files. Events are back up now and I still have a ticket open, waiting on support.
Hello,
Thank you for reaching out to us.
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello Uroš,
Thanks for your reply. I'm sorry but that won't be a possibility for me. That would mean I have to update the plug-in on the live website which will prevent any customers from booking their appointments and possibly other things too.
If there's anything else i can help, i'll gladly help out, but this won't be an option.
Best regards,
Hello,
That is fine, I completely understand.
Would you be able to provide us with a staging site, If you're not able to provide us with a staging site, can you clone your website?
If yes - I'll ask you to install the Duplicator plugin. It will generate a couple of files that you can send me (along with the login credentials), and then I can create an exact copy of your website, see what the issue is and try to resolve it.
The Duplicator plugin can export only up to 500MB of data, so if your site is bigger than that, please use the All-in-One WP Migration plugin.
Please note that the files will be too large to attach to the ticket, so you can upload them via wetransfer.com and just send me the link.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Happens to me everytime there is an update too. This is ridiculous that we have to go through this every time there is an update.
Hello Georgi,
Thank you for reaching out to us.
I can see that you have created a ticket for this issue, we will have this covered for you.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
How did you solve Georgi's issue? Can you share here so that others can learn from the solution?
Yes it would be great if solution steps are shared.
Hello Najib and Traci,
There was a missing column in the wp_amelia_users table. This was probably caused by an issue in the database and the column was not added. The column name is "description".
Hope this helps you.
Please let me know if you have any other questions.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello,
Thanks for getting back to us, has this issue been marked to be fixed in the 5.5 update?
Thanks,
Najib.
Hello Uroš,
As this seems to be an issue that multiple people are experiencing, it looks like this is a generic issue. Currently the website is using Amelia v5.2 and is working fine, i'll wait till a new version has been released that'll fix this issue. If the issue persists i dont mind taking further action to solve the issue, but for now i'd say lets wait till a fix has been deployed in an upcoming version.
Hello Najib and Denboer,
The fix will be included in the next update. When this type of issue occurs after the update, first try to reactivate the plugin and clean the cache afterward, if that does not help you, reach out to us and we will assist you with it.
Hope this helps you.
Please let us know if you have any other questions.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks for the support and quick replies, Uroš!
Hello,
We are here to help!
Please let us know if you have any other questions.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank you. When can we expect the next update with this fix to be released?
Hi, everyone.
Our developers are working to launch a new update very soon.
We can't say an exact ETA on it, but they are doing their best to finish as quick as possible.
We just wanted to add more details on how you guys can fix this issue, if you have access to your WordPress database ( of course, you can always ask your hosting support, they should be able to help you access it).
-
Basically, what happened here is, during the update, there is one column that did not correctly get generated in your database, so it's missing.
We don't have many people that reported it, but there are several users.
-
If you wish to try, here is how to fix it, by adding the missing column manually.
It is in "wp_amelia_users" table, the column name is "description".
( the wp_ prefix is the default WordPress database prefix; but you have to check on your DB, you probably have a different table prefix)
First, you have to run this SQL Query on the database,
in PHPMyAdmin.
This is required to allow the column to be added to the wp_amelia_users table :
As mentioned, the "wp_" prefix is the default WordPress prefix,
but if you have another prefix for your database tables, you will need to alter the query.
For example, if your prefix is "my_database", the table would be "my_database_amelia_users".
Once you run this Query, you need to insert a new column into the table "wp_amelia_users",
and it should be inserted after the column "note".
Collation should be the same as it is for other columns in the table;
name : "description";
type : "TEXT" without character limit;
NULL : YES/checked.
-
-
Once you add this column, the issue should be fixed.
If you need us to do this for you,
we would need access to your WordPress Database.
Since Bart is the creator of the ticket, you could send us the access in a Private response;
but for the others -you would have to open a new, private ticket, then you can send us your access there.
We would need the access page URL , for the PHPMyAdmin, along with the login credentials for it.
Then we can log in to the database and add this missing column for you.
Let us know how it goes, and we hope this has helped.
Thank you all.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello Traci, and everyone.
The next update will be released next week (I hope it will be on Monday, but I can't make any promises).
As for the issue, Uros described:
In 5.4 we've included the "Employee Description", which was also added to the database as a column in the wp_amelia_users table.
For some reason, the plugin couldn't create that column, which resulted in the error when the services linked to your employees were pulled - the plugin tried pulling the data from the "description" column, while the column was never created.
You can reach out to your hosting provider and have them check if the plugins have the necessary permissions to create/update database tables.
As it doesn't happen on all installations, it can't be classified as an official bug, but our developers will make some changes to the code and attempt to override the behavior of some databases when it comes to issues like this.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Good day,
I noticed 5.4.1 has been released. Has the Employee description issue been fixed in that update?
Thanks.
Hello Najib
We've added some programmatical fixes for this issue and it should work for most servers.
We can't, however, guarantee that there aren't some servers that are still blocking the ability for the plugin to create a column. Can you create a backup of your site, update Amelia, purge the cache and then try to update to v5.4.1. Please let me know if it works correctly.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello,
Just got around to doing this. The new update does not resolve this issue. One still has to go back and alter the table.
Commands to do so from CLI are.
Ive tried these and they do work on bringing back up the plugin. I do how ever would like to get these commands confirmed by a developer please. Would it be wise to connect in as root?
Let me know!
Thanks,
Najib.
Hello Najib
We will forward this to our developers. As soon ass we get feedback from them we will contact you.
Kind Regards,
Marko Davidovic
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello Najib.
Usually, another user is used here, not root. You can see which user that is in wp-config.php file.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
That’s fair, are the commands them selves proper for the db change?
Hi again Najib.
It is OK, but I'd change the ADD statement to this:
Since this column needs to have NULL as the default value, and the character set is usually utf8, but of course, you need to check that in your database.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank you for your input!
Hopefully others can benefit from our docs :)
Oddly, I reverted back when I had asked to confirm the commands. Updating to from 5.4 to 5.6 and doing it today with my original commands it would not work. I then reverted back and tried again with your suggested command and it was the same issue.
I have noticed the following error after updating and running the db fix.
This is how my table looks like after making the changes.
Ive reverted back to a working backup in the meantime.
Let me know what the suggested actions are.
Hi everyone,
I was hoping that the newer versions of Amelia would fix the issue, but that wasn't the case. Not very familiair with databases, but i managed to get the changes done after following the steps mentioned by Miloš; that worked!
Thanks a lot for the support and description on how to update the database.
Enjoy the coming days!
I finally attempted the update again, (had to because the notification short code bugs that were fixed in one of the updates were causing me issues).
In the attempt, the same thing happened and my events disappeared just like before. So I followed these instructions on manually adding a column. I am comfortable editing databases so this did not really worry me, but it wasn't as straightforward as I had hoped. I got a few errors and I'll explain here in hopes to help understand why some are having the issues and not everyone.
First of all, I am hosted with Cloudways.
When I attempted to add the column, I got this error:
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs 10:08:15 SQL command
I contacted Cloudways support and they had to add this to the server configuration:
innodb_log_file_size = 512M
innodb_strict_mode = 0
I attempted to add the column again. This time it was successful, but I got this warning:
Warning 139 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
Even with the warning, the site did seem to be fixed and my events loaded. I gave the error to Cloudways support and then they added this server settings to get rid of the warning message, so it can use ROW_FORMAT=DYNAMIC
nnodb_file_format = barracuda
I asked support if there was anything else I should do at this point since I already altered the table, and they said I would need to check with the plugin developer.
So, with this information:
1. Do I need to make any further changes to my database table/column?
2. I hope you can use this information and error data to further troubleshoot the upgrade issues I, and others, had during this update. Hopefully this helps others.
UPDATE. I just tried to update WP Amelia on another site, and this time the new column "description" was added to the table during the update, however it was added at the end instead of immediately after the column "note".
I edited the table and moved the column up to be after "note". Do you know why this would happen, and how important is it that "description" immediately follow "note" in the database table?
@Traci
Interesting! Im glad you got your to work out! Would you have the commands(Just to compare) that you used when adding to the database or did you use a UI?
opening a separate issue
Najib, I used a UI in the Cloudways Database manager
Hi all!
Traci, the BLOB warning is related to the database, and the way to resolve it is to run this query:
After that, you should be able to add the column without any issues.
Najib - run the same command, and then try adding the column again.
Please let me know if you face any other issues after this.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
I have given that command a shot multiple times with no luck. Just tried it on the 6.0 update and still no luck.
Hi again Najib.
We've never had issues like this, and we had to add at least 30 of these columns in the past couple of months.
In order to help you out, I will need to check out your database, I can't say what helps without trial and error. Since this is not your ticket, you can't provide us with credentials, but you can open a new Private ticket, where you'll provide us with the site access and the database access URL and credentials, and we'll gladly take a look and see what's going on.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Sorry for the delay. Had some time off in the holidays.
It seems this has not worked for me. It appeared to work on the site I have using events, but my other site using appointments broke. Huge blocks of time(in the middle of the day) are now unavailable for admin making appointments (probably customers too).
I updated to latest version at the time (5.6) and in my new ticket, support is very unhelpful, since the now latest version is 6.1. https://tmsplugins.ticksy.com/ticket/3197758
Anyway, I have rolled back to 5.2, since that is the only version I have to rollback to, and Amelia doesn't offer past versions to help with this. Atleast 5.2 is allowing me to enter my appointments again.
My guess is that more columns were meant to be added between 5.2 and 5.6 and didn't get added or didn't get added correctly. I have no way of knowing.
So, just updating this post here in case anyone else has this issue. I want them to know that the problem is not solved with updates and updates seem to be getting worse. I am now going through and further testing my other site which uses events. Its currently on 5.2 and I need to track down any issues there.
I'm sorry to hear that you're still having issues with Amelia, Traci.
The fact is that, with over 10.000 active installations, there's only a handful of sites that face this issue where new columns (or tables) are not added correctly to the database, but we can't figure out why that is happening, since we can't replicate the issue.
Can you please tell me who's your hosting provider, what type of database you have, what versions of PHP and the database are, and we'll see if we can create a site with that provider and replicate the issue.
I'll take over the ticket you've mentioned, and we'll see what I can do to help there.
We can then update this ticket once the issue is resolved.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables