Confirm. You'll be fine with that line commented out. Sorry for the
problem.
Matt Raible wrote:
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
