FYI... The following line failed to work on my database in production - which is MySQL 3.23.56-Max-log.
update pingtarget pt set pt.conditioncode=pt.condition; The error I get is: ERROR 1064 (00000) at line 75: You have an error in your SQL syntax near 'pt set pt.conditioncode=pt.condition' at line 1 Any ideas? Everything worked locally with MySQL 4.1 and 5.0. Maybe there's something different with 3.23.56? I'll try getting my ISP to restore my database and run the upgrade script again with this line commented out. Matt
