[wp-hackers] Re: dbDelta Upgrade not working

[Ajay D'Souza]

I was able to figure out the problem. I removed the default CURDATE() portion of the table.

dbDelta handles the upgrades without you needing to program specific alter statements.

Regards
Ajay


    ------------------------------

    Message: 9
    Date: Wed, 11 Mar 2009 12:48:26 +0200
    From: scribu <scribu at gmail.com>
    Subject: Re: [wp-hackers] dbDelta Upgrade not working
    To: wp-hackers at lists.automattic.com
    Message-ID:
    <349fe48b0903110348n2baeb9bbw898ad1163187fd6 at mail.gmail.com>
    Content-Type: text/plain; charset=UTF-8

    On Wed, Mar 11, 2009 at 7:28 AM, Ajay D'Souza <ajaydsouza at gmail.com>
    wrote:

>     >  The upgrade works only when I created a new table, but not to alter it.
>     >
>     >  Anybody have a clue as to why this isn't happening? Any solutions?
>          


    Well, to alter an existing table, you would have to use the ALTER TABLE
    statement, no? Or, delete the existing table first.