From: Marc G. F. <sc...@hu...> - 2009-09-27 00:02:03
|
Okay, got a problem loading the data ... one table doesn't seem to want to create, and I don't know enough about MySQL to see the bug in this TABLE schema: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 19 -- CREATE TABLE firehose_view( id mediumint(8) unsigned NOT NULL auto_increment, uid MEDIUMINT UNSIGNED NOT NULL DEFAULT '0', viewname VARCHAR(24) NOT NULL DEFAULT 'unnamed', useparentfilter ENUM("no","yes") DEFAULT "yes", tab_display ENUM("no","yes") DEFAULT "no", options_edit ENUM("no","yes") DEFAULT "no", admin_maxitems tinyint NOT NULL DEFAULT -1, maxitems tinyint NOT NULL DEFAULT -1, seclev mediumint UNSIGNED NOT NULL DEFAULT '0', filter VARCHAR(255) NOT NULL DEFAULT '', orderby ENUM("popularity","createtime", "editorpop", "activity", "neediness", "") DEFAULT "createtime", orderdir ENUM("ASC", "DESC", "") DEFAULT "DESC", color VARCHAR(16) NOT NULL DEFAULT '', duration ENUM("7","-1","") DEFAULT '', mode ENUM ("full","fulltitle", "") DEFAULT "", mixedmode ENUM("1","0","") DEFAULT "", pause ENUM("1","0","") DEFAULT "" Anyone? ---- 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... |
From: Marc G. F. <sc...@hu...> - 2009-09-27 00:42:24
|
Even more interesting is that I didn't even include firehose in my list of plugins ... not sure if it still builds the schema for it even if not included ... ? ---- 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... |
From: gnul <nul...@gm...> - 2009-09-27 05:55:22
|
On Sat, Sep 26, 2009 at 6:01 PM, Marc G. Fournier <sc...@hu...> wrote: > > Okay, got a problem loading the data ... one table doesn't seem to want to > create, and I don't know enough about MySQL to see the bug in this TABLE > schema: > > You have an error in your SQL syntax; check the manual that corresponds > to your MySQL server version for the right syntax to use near '' at line > 19 -- CREATE TABLE firehose_view( > id mediumint(8) unsigned NOT NULL auto_increment, > uid MEDIUMINT UNSIGNED NOT NULL DEFAULT '0', > viewname VARCHAR(24) NOT NULL DEFAULT 'unnamed', > useparentfilter ENUM("no","yes") DEFAULT "yes", > tab_display ENUM("no","yes") DEFAULT "no", > options_edit ENUM("no","yes") DEFAULT "no", > admin_maxitems tinyint NOT NULL DEFAULT -1, > maxitems tinyint NOT NULL DEFAULT -1, > seclev mediumint UNSIGNED NOT NULL DEFAULT '0', > > filter VARCHAR(255) NOT NULL DEFAULT '', > orderby ENUM("popularity","createtime", "editorpop", "activity", > "neediness", "") DEFAULT "createtime", > orderdir ENUM("ASC", "DESC", "") DEFAULT "DESC", > color VARCHAR(16) NOT NULL DEFAULT '', > duration ENUM("7","-1","") DEFAULT '', > mode ENUM ("full","fulltitle", "") DEFAULT "", > mixedmode ENUM("1","0","") DEFAULT "", > pause ENUM("1","0","") DEFAULT "" > > Anyone? > Try this for the first column in the table: id mediumint(8) unsigned NOT NULL auto_increment PRIMARY KEY, Also, you need a trailing ')' for the CREATE statement, but you may have just omitted that in the email. -gnul |
From: Marc G. F. <sc...@hu...> - 2009-09-27 16:26:19
|
Tried the change ... no difference ... :( On Sat, 26 Sep 2009, gnul wrote: > On Sat, Sep 26, 2009 at 6:01 PM, Marc G. Fournier <sc...@hu...> wrote: >> >> Okay, got a problem loading the data ... one table doesn't seem to want to >> create, and I don't know enough about MySQL to see the bug in this TABLE >> schema: >> >> You have an error in your SQL syntax; check the manual that corresponds >> to your MySQL server version for the right syntax to use near '' at line >> 19 -- CREATE TABLE firehose_view( >> id mediumint(8) unsigned NOT NULL auto_increment, >> uid MEDIUMINT UNSIGNED NOT NULL DEFAULT '0', >> viewname VARCHAR(24) NOT NULL DEFAULT 'unnamed', >> useparentfilter ENUM("no","yes") DEFAULT "yes", >> tab_display ENUM("no","yes") DEFAULT "no", >> options_edit ENUM("no","yes") DEFAULT "no", >> admin_maxitems tinyint NOT NULL DEFAULT -1, >> maxitems tinyint NOT NULL DEFAULT -1, >> seclev mediumint UNSIGNED NOT NULL DEFAULT '0', >> >> filter VARCHAR(255) NOT NULL DEFAULT '', >> orderby ENUM("popularity","createtime", "editorpop", "activity", >> "neediness", "") DEFAULT "createtime", >> orderdir ENUM("ASC", "DESC", "") DEFAULT "DESC", >> color VARCHAR(16) NOT NULL DEFAULT '', >> duration ENUM("7","-1","") DEFAULT '', >> mode ENUM ("full","fulltitle", "") DEFAULT "", >> mixedmode ENUM("1","0","") DEFAULT "", >> pause ENUM("1","0","") DEFAULT "" >> >> Anyone? >> > > Try this for the first column in the table: > id mediumint(8) unsigned NOT NULL auto_increment PRIMARY KEY, > > Also, you need a trailing ')' for the CREATE statement, but you may > have just omitted that in the email. > > -gnul > ---- 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... |
From: Chris N. <pu...@sl...> - 2009-10-01 18:55:57
|
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/ |
From: Marc G. F. <sc...@hu...> - 2009-10-01 19:17:01
|
Let me retry tonight ... I swore I had put the ); at the end, but now I'm not so confident that I did ... 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® 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-12, 2009. Register now! > 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... |
From: Marc G. F. <sc...@hu...> - 2009-10-02 02:16:09
|
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® 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-12, 2009. Register now! > 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... |