[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]

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
>