April 21, 20169 yr Is it bad to delete all the records in the EasySync_Payloads table? It's kind of building up.
April 21, 20169 yr Hmm, with regular syncing the only reasons records should be building up in the payloads table are The delete settings variable is set to save payloads, or The sync isn't working properly. It should automatically delete successful/all payloads depending on the setting. Check out the easysync settings scripts and confirm they're set the way you want. Oh, and yes you can safely delete records from payload table as long as they're not logged deletions. I.e. ES_Deletion_UUID should be empty.
April 21, 20169 yr Author It is set to "Successful", but I had 3500 records in that table on the server.
April 21, 20169 yr Woah. Does the account running the script have delete privileges for the payloads table?
April 22, 20169 yr Author Yes, there were several accounts, and they all do. Many of the payloads were mine.Which is really weird, cause I didn't have that many failures. Edited April 22, 20169 yr by RyanESmith7
April 22, 20169 yr Hmm. I think this calls for a debug session. If the sync is behaving properly you might be fine just deleting these occasionally, but really they should not be accumulating. I'd use the debugger and set a breakpoint where the delete should occur. See if the the deletion returns an error. For this you may have to switch the settings to not perform script on server for the relevant scripts. Wish I had more insight.
Create an account or sign in to comment