[geeklog-devel] [geeklog-cvs] Geeklog-1.x/sql mssql_tableanddata.php, 1.33, 1.34 mysql_tableanddata.php, 1.200, 1.201
Mark R. Evans
mevans at ecsnet.com
Thu Feb 21 20:05:55 EST 2008
I see we have a new feature in v1.5. As a result, I needed to reinstall
my cvs base since there are new tables and trying to use the Admin
interface was causing SQL errors (the new tables didn't exist).
Unfortunately, this is the error I receive when installing:
1064: 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 '( token varchar(32) NOT NULL, created datetime NOT NULL, owner_id'
at line 1
Looks like $_TABLE['tokens'] wasn't defined in lib-database.php
What happened to the feature freeze? Is it off again?
Thanks!
Mark
Michael Jervis wrote:
> Update of /cvsroot/geeklog/Geeklog-1.x/sql
> In directory qs1489.pair.com:/tmp/cvs-serv78690/sql
>
> Modified Files:
> mssql_tableanddata.php mysql_tableanddata.php
> Log Message:
> Security changes.
>
> Index: mssql_tableanddata.php
> ===================================================================
> RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/mssql_tableanddata.php,v
> retrieving revision 1.33
> retrieving revision 1.34
> diff -C2 -d -r1.33 -r1.34
> *** mssql_tableanddata.php 27 Jan 2008 15:23:32 -0000 1.33
> --- mssql_tableanddata.php 21 Feb 2008 19:52:52 -0000 1.34
> ***************
> *** 517,520 ****
> --- 517,530 ----
> ";
>
> + $_SQL[] = "
> + CREATE TABLE {$_TABLES['tokens']} (
> + [token] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
> + [created] [datetime] NOT NULL,
> + [owner_id] [numeric] (8,0) NOT NULL,
> + [urlfor] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
> + [ttl] numeric(8,0) NOT NULL DEFAULT 1
> + ) ON [PRIMARY]
> + ";
> +
>
> $_SQL[] = "
> ***************
> *** 910,913 ****
> --- 920,930 ----
> (
> [fid]
> + ) ON [PRIMARY]
> + ";
> +
> + $_SQL[] = "ALTER TABLE [dbo].[{$_TABLES['tokens']}] ADD
> + CONSTRAINT [PK_gl_tokens] PRIMARY KEY CLUSTERED
> + (
> + [toekn]
> ) ON [PRIMARY]
> ";
>
> Index: mysql_tableanddata.php
> ===================================================================
> RCS file: /cvsroot/geeklog/Geeklog-1.x/sql/mysql_tableanddata.php,v
> retrieving revision 1.200
> retrieving revision 1.201
> diff -C2 -d -r1.200 -r1.201
> *** mysql_tableanddata.php 3 Feb 2008 19:11:50 -0000 1.200
> --- mysql_tableanddata.php 21 Feb 2008 19:52:53 -0000 1.201
> ***************
> *** 724,727 ****
> --- 724,738 ----
> ";
>
> + $_SQL[47] = "
> + CREATE TABLE {$_TABLES['tokens']} (
> + token varchar(32) NOT NULL,
> + created datetime NOT NULL,
> + owner_id mediumint(8) unsigned NOT NULL,
> + urlfor varchar(2000) NOT NULL,
> + ttl mediumint(8) unsigned NOT NULL default '1',
> + PRIMARY KEY (token)
> + ) TYPE=MyISAM
> + ";
> +
> $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (1,3) ";
> $_DATA[] = "INSERT INTO {$_TABLES['access']} (acc_ft_id, acc_grp_id) VALUES (2,3) ";
>
> _______________________________________________
> geeklog-cvs mailing list
> geeklog-cvs at lists.geeklog.net
> http://eight.pairlist.net/mailman/listinfo/geeklog-cvs
>
More information about the geeklog-devel
mailing list