Iam also really interested in some information about updating tiki when I've done many customizations. Please somebody, give some advice, Thanks.


> Although ReleaseProcess192 gives a list of fixes, there's nothing that tells me which files were changed. Likewise, ReleaseNotes192 contains no detailed information at all about this release.
>
> It would be great to have list of files that have changed, so I don't have to DIFF through 3,600+ files in order to port my customizations to this new release. Even beter, how about a 1.9.1 to 1.9.2 zip that includes only the new files, similarly to what was done for 1.9.1.1. That would make the upgrades MUCH easier.
>
> What is the best process for upgrading a TIKI if you've made vast customizations?

"reads" is a reserved word, if you change to anyhting elese it will work.
But now the question for developers, what can be done
> Did anyone else get these errors? I can't find a reference to them.
>
> Command: CREATE TABLE tiki_articles (
> articleId int(8) NOT NULL auto_increment,
> topline varchar(255) default NULL,
> title varchar(80) default NULL,
> subtitle varchar(255) default NULL,
> linkto varchar(255) default NULL,
> lang varchar(16) default NULL,
> state char(1) default 's',
> authorName varchar(60) default NULL,
> topicId int(14) default NULL,
> topicName varchar(40) default NULL,
> size int(12) default NULL,
> useImage char(1) default NULL,
> image_name varchar(80) default NULL,
> image_caption text default NULL,
> image_type varchar(80) default NULL,
> image_size int(14) default NULL,
> image_x int(4) default NULL,
> image_y int(4) default NULL,
> image_data longblob,
> publishDate int(14) default NULL,
> expireDate int(14) default NULL,
> created int(14) default NULL,
> heading text,
> body text,
> hash varchar(32) default NULL,
> author varchar(200) default NULL,
> reads int(14) default NULL,
> votes int(8) default NULL,
> points int(14) default NULL,
> type varchar(50) default NULL,
> rating decimal(3,2) default NULL,
> isfloat char(1) default NULL,
> PRIMARY KEY (articleId),
> KEY title (title),
> KEY heading 255?,
> KEY body 255?,
> KEY reads (reads),
> KEY author 32?,
> FULLTEXT KEY ft (title,heading,body)
> ) TYPE=MyISAM AUTO_INCREMENT=1
> Message: 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 'reads int(14) default NULL,
> votes int(8) default NULL,
> points int(14) defaul' at line 28
>
>
> Command: CREATE TABLE tiki_submissions (
> subId int(8) NOT NULL auto_increment,
> topline varchar(255) default NULL,
> title varchar(80) default NULL,
> subtitle varchar(255) default NULL,
> linkto varchar(255) default NULL,
> lang varchar(16) default NULL,
> authorName varchar(60) default NULL,
> topicId int(14) default NULL,
> topicName varchar(40) default NULL,
> size int(12) default NULL,
> useImage char(1) default NULL,
> image_name varchar(80) default NULL,
> image_caption text default NULL,
> image_type varchar(80) default NULL,
> image_size int(14) default NULL,
> image_x int(4) default NULL,
> image_y int(4) default NULL,
> image_data longblob,
> publishDate int(14) default NULL,
> expireDate int(14) default NULL,
> created int(14) default NULL,
> bibliographical_references text,
> resume text,
> heading text,
> body text,
> hash varchar(32) default NULL,
> author varchar(200) default NULL,
> reads int(14) default NULL,
> votes int(8) default NULL,
> points int(14) default NULL,
> type varchar(50) default NULL,
> rating decimal(3,2) default NULL,
> isfloat char(1) default NULL,
> PRIMARY KEY (subId)
> ) TYPE=MyISAM AUTO_INCREMENT=1
> Message: 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 'reads int(14) default NULL,
> votes int(8) default NULL,
> points int(14) defaul' at line 29
>