Re: [Slashcode-general] Any mysql users out there?

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

D'oh, looking at it further, the thought was right, fix was wrong ...

There is one too many ;'s in it ... I just went in to try what was 
suggested, and noticed that if you look 2 lines past the "pause ENUM", 
there is both the PRIMARY KEY statement, and 2 lines past that hte missing 
); ...

The ; on the "pause ENUM" line is out of place ... patch:

*** mysql_schema.dump.orig      Fri Oct  2 02:07:44 2009
--- mysql_schema.sql    Fri Oct  2 02:09:02 2009
***************
*** 108,114 ****
         duration ENUM("7","-1","") DEFAULT '',
         mode ENUM ("full","fulltitle", "") DEFAULT "",
         mixedmode ENUM("1","0","") DEFAULT "",
!       pause ENUM("1","0","") DEFAULT "";

         PRIMARY KEY (id),
         UNIQUE id_viewname(id,viewname)
--- 108,114 ----
         duration ENUM("7","-1","") DEFAULT '',
         mode ENUM ("full","fulltitle", "") DEFAULT "",
         mixedmode ENUM("1","0","") DEFAULT "",
!       pause ENUM("1","0","") DEFAULT "",

         PRIMARY KEY (id),
         UNIQUE id_viewname(id,viewname)

Now it loads properly ...

On Thu, 1 Oct 2009, Chris Nandor wrote:

> Those two changes worked for me: making it PRIMARY KEY and adding the
> ");" at the end.
>
>
> On Sep 27, 2009, at 09:26, Marc G. Fournier wrote:
>
>> Tried the change ... no difference ... :(
>
>
> -- 
> Chris Nandor             pu...@po...             http://pudge.net/
> Slashdot / SourceForge   pu...@sl...       http://slashdot.org/
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry&reg; Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9&#45;12, 2009. Register now&#33;
> http://p.sf.net/sfu/devconf
> _______________________________________________
> Slashcode-general mailing list
> Sla...@li...
> https://lists.sourceforge.net/lists/listinfo/slashcode-general
>

----
Marc G. Fournier                        Hub.Org Hosting Solutions S.A.
sc...@hu...                                     http://www.hub.org

Yahoo:yscrappy    Skype: hub.org    ICQ:7615664    MSN:sc...@hu...