I commented out line 75 (listed below) and the upgrade ran fine. Is there some additional modifications I need to do to my database? It sounds like the answer is "no".
Thanks, Matt On 11/25/05, Anil Gangolli <[EMAIL PROTECTED]> wrote: > As long as the rest of the script ran fine (didn't abort there), you > should be ok without even rerunning. Things will work fine even if the > new conditioncode column is not populated from the old values. > > --a. > > Matt Raible wrote: > > >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 > > > > > > > > > >
