This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Can't Edit or Delete an Activity in Garmin Connect

Former Member over 12 years ago

Not sure what's going on. Some kind of cascading delete error I'm guessing. Connect decided that my latest run was my longest run. I got a footpod.

It then buggered up the data .... showing 11.4 mph as my max speed which would be nice if it was true.
I checked the data file in Training Center on my laptop and this bogus data was not in the .tcx file from my 405 so it's an artifact of the import/insert query.

First I attempted to update the details of my run but it failed and showed a red "Executing an update/delete query" when in "Full Edit" mode.

Then I tried changing a subset of the details in Quick Edit.. This worked "no record locking" I'm guessing.

After buggering around a bit and finding a place to post the bug to support I then figured I would delete the Actitivity and Import it again from my Laptop to see if it the "file load" function would do the import/insert correctly.

But then I discovered Delete doesn't work for the record. When I deleted the Activity record it did delete the "Longest Run" record but I'm guessing "Dollars to Donuts" that it didn't cascade to delete the Record in the intermediate table being used to join the two table.

Now I've got a zombie.

How does one get the Garmin Connect maintenance/support to fix their SQL and punt a zombie record?

0 Former Member over 12 years ago

Delete and Unlock / Lock

Not sure what's going on. Some kind of cascading delete error I'm guessing. Connect decided that my latest run was my longest run. I got a footpod.

It then buggered up the data .... showing 11.4 mph as my max speed which would be nice if it was true.
I checked the data file in Training Center on my laptop and this bogus data was not in the .tcx file from my 405 so it's an artifact of the import/insert query.

First I attempted to update the details of my run but it failed and showed a red "Executing an update/delete query" when in "Full Edit" mode.

Then I tried changing a subset of the details in Quick Edit.. This worked "no record locking" I'm guessing.

After buggering around a bit and finding a place to post the bug to support I then figured I would delete the Actitivity and Import it again from my Laptop to see if it the "file load" function would do the import/insert correctly.

But then I discovered Delete doesn't work for the record. When I deleted the Activity record it did delete the "Longest Run" record but I'm guessing "Dollars to Donuts" that it didn't cascade to delete the Record in the intermediate table being used to join the two table.

Now I've got a zombie.

How does one get the Garmin Connect maintenance/support to fix their SQL and punt a zombie record?

Hey, I am having the same problems as well. I have items on my activities that were false starts most show like 1min times or 5min...so I was going to go through and delete them. It will not allow me to delete in any way form or fashion. I also tried to change privacy setting to see if it would allow me to delete that way. The privacy will not stay changed to only me, it keeps unlocking to not private. What the heck??? :mad::confused::mad::confused:

0 Former Member over 12 years ago

Same deal, just happened today. Forerunner 405 uploaded my run through ANT Agent, but distance was off from the mapped route. Tried to modify the distance in Full Edit and was refused with red print "Executing an update/delete query".

Last week the device refused to upload, kept crashing at "tracks". Had to upload manually.

Glitchiest software ever. :confused::(:mad:

0 jamesnamorrison over 12 years ago

Executing an update/delete query

Not sure what's going on.... First I attempted to update the details of my run but it failed and showed a red "Executing an update/delete query" when in "Full Edit" mode.

I was also getting this problem when trying to add distance to a heart rate/time record. Was able to 'quick edit', but the full edit returned the same "Executing an update/delete query".

It resolved itself after 20 minutes.

0 Former Member over 12 years ago

... Interesting... I was able to delete the record just now when I went back to it as well. Some kind of lock on the record.

0 EvoSwim3 over 11 years ago

Can't Save in Full Edit mode

Same story with me! Can't Save in Full Edit mode and has not resolved by itself yet.