I have the following problem. After moving from a test domain to the main domain, I had massive problems with the database relating to Amelia (employees could not be edited / services were not shown, although they were in the database and categories disappeared again after they were created).
So I unceremoniously uninstalled Amelia and completely cleaned up the database. After the reinstallation, the old settings were "fortunately" still active, but there were still some problems - so I cannot change old links in Amelia (despite cleaning up mixed content and replacing in the tables) and I cannot activate or deactivate certain options at all ( Invoice with payment settings), and above all currently not syncing a Google calendar.
How can I be helped here?
Alternative question, which entry in the database should I edit, to change the old links? I absolutely need the Google Calender Sync :(
screenshot added.
Thanks in advance.
best regards
Moritz / Wsign Werbung
Ich habe folgendes Problem. Nachdem ich von einer Test-Domain auf die Hauptdomain umgezogen bin, hatte ich massive Probleme mit der Datenbank im Bezug auf Amelia (Mitarbeiter konnten nicht bearbeitet werden/ Dienstleistungen wurden nicht engezeigt, obwohl in der Datenbank vorhanden und Kategorien nach dem Anlegen wieder verschwunden).
Also habe ich Amelia kurzerhand deinstalliert und die Datenbank komplett aufgeräumt. Nach der Neuinstallation waren "glücklicherweise" die alten Einstellungen noch aktiv, allerdings auch noch manche Probleme vorhanden - so kann ich (trotz bereinigen von Mixed Content und ersetzen in den Tabellen) alte Verlinkungen bei Amelia nicht ändern und bestimmte Optionen gar nicht aktivieren oder deaktivieren (Rechnung bvei Zahlungseinstellungen), und v.a. im Augenblick keinen Google Calender synchroniseren.
Wie kann mir hier geholfen werden? Bzw. welchen EIntrag in der Datenbank muss ich editieren?
Siehe Screenshot (ich kann bspw. den alten Link nicht ersetzen. Das Hilfe-kästchen ist schwarz)
I suppose when you migrated the website, the old database prefixes remained saved in Amelia's tables' Foreign Keys.
We would need to log into your database and remove all foreign keys (as they are no longer needed). If you deleted all wp_amelia tables, though, those should've been deleted also.
To change the URI, you'll need to go into your database, but please be careful when you update the table, because if you delete or add anything else, it can cause the plugin not to work properly.
When you access your database via PHPMyAdmin (or some other tool), access wp_options table:
It is possible that your prefix is not "wp_", but something else, so if that is the case, please look for "your_prefix_options" table.
When you access it, you can search through the column "option_name". Search for the term "amelia_settings":
When you find that, you need to edit the property under "option_value" column and find the string "redirectURI". It will look something like this :
So, all you need to do is replace it with your new website's URI:
So basically you need to replace newsite.com with youroldsite.com and it will be shown in Google settings properly. Please note that if you use https you will need to update it also in redirectURI option. Please don't remove the escape characters ( \ ), it needs to stay in \/\/ format
When you're done with this, please check if the URL from “Redirect URI” field and on "Create OAuth client ID" section are the same:
Hi everybody,
I have the following problem. After moving from a test domain to the main domain, I had massive problems with the database relating to Amelia (employees could not be edited / services were not shown, although they were in the database and categories disappeared again after they were created).
So I unceremoniously uninstalled Amelia and completely cleaned up the database. After the reinstallation, the old settings were "fortunately" still active, but there were still some problems - so I cannot change old links in Amelia (despite cleaning up mixed content and replacing in the tables) and I cannot activate or deactivate certain options at all ( Invoice with payment settings), and above all currently not syncing a Google calendar.
How can I be helped here?
Alternative question, which entry in the database should I edit, to change the old links? I absolutely need the Google Calender Sync :(
screenshot added.
Thanks in advance.
best regards
Moritz / Wsign Werbung
Ich habe folgendes Problem. Nachdem ich von einer Test-Domain auf die Hauptdomain umgezogen bin, hatte ich massive Probleme mit der Datenbank im Bezug auf Amelia (Mitarbeiter konnten nicht bearbeitet werden/ Dienstleistungen wurden nicht engezeigt, obwohl in der Datenbank vorhanden und Kategorien nach dem Anlegen wieder verschwunden).
Also habe ich Amelia kurzerhand deinstalliert und die Datenbank komplett aufgeräumt. Nach der Neuinstallation waren "glücklicherweise" die alten Einstellungen noch aktiv, allerdings auch noch manche Probleme vorhanden - so kann ich (trotz bereinigen von Mixed Content und ersetzen in den Tabellen) alte Verlinkungen bei Amelia nicht ändern und bestimmte Optionen gar nicht aktivieren oder deaktivieren (Rechnung bvei Zahlungseinstellungen), und v.a. im Augenblick keinen Google Calender synchroniseren.
Wie kann mir hier geholfen werden?
Bzw. welchen EIntrag in der Datenbank muss ich editieren?
Siehe Screenshot (ich kann bspw. den alten Link nicht ersetzen. Das Hilfe-kästchen ist schwarz)
Vielen Dank im Voraus.
Liebe Grüße
Moritz / Wsign Werbung
Hello Moritz
I suppose when you migrated the website, the old database prefixes remained saved in Amelia's tables' Foreign Keys.
We would need to log into your database and remove all foreign keys (as they are no longer needed). If you deleted all wp_amelia tables, though, those should've been deleted also.
To change the URI, you'll need to go into your database, but please be careful when you update the table, because if you delete or add anything else, it can cause the plugin not to work properly.
When you access your database via PHPMyAdmin (or some other tool), access wp_options table:
It is possible that your prefix is not "wp_", but something else, so if that is the case, please look for "your_prefix_options" table.
When you access it, you can search through the column "option_name". Search for the term "amelia_settings":
When you find that, you need to edit the property under "option_value" column and find the string "redirectURI". It will look something like this :
So, all you need to do is replace it with your new website's URI:
So basically you need to replace newsite.com with youroldsite.com and it will be shown in Google settings properly. Please note that if you use https you will need to update it also in redirectURI option. Please don't remove the escape characters ( \ ), it needs to stay in \/\/ format
When you're done with this, please check if the URL from “Redirect URI” field and on "Create OAuth client ID" section are the same:
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