View Full Version : updated table fields rolling back after update
kehers
09-27-2006, 01:51 PM
I'm having to correct some scripts written by a collegue who is presently not around. I had to update 2 fields with over 13000 rows. The update do work well but the problem is that somehow, the initial values in the fields do roll back in again - kind of auto updating to the former values itself. Any ideas what could be wrong? Any way round it?
guelphdad
09-27-2006, 03:11 PM
do you have a slave server that could be overwriting your values on the master server?
do you have any cron jobs that could be writing to the files?
are you using transactions but not using COMMIT to commit the changes to the database?
vBulletin® v3.8.2, Copyright ©2000-2012, Jelsoft Enterprises Ltd.