Features / Usability

Features / Usability

2 differences found in sql blog-related tables

posts: 956

I found out 2 differences regarding blogs, from a brand new 1.8.4 tiki installation compared to a updated 1.7.x updated to 1.8.4 with the provided scripts so far (with 1.8.4):

1. On table "tiki_blog_posts", column "data_size" seems to be wrong.
Line copied from a brand new 1.8.4 installation):

`data_size` int(11) unsigned NOT NULL default '0',

Line from a updated 1.7 to 1.8 with update sql scripts:

`data_size` int(10) unsigned default '0',

(I wonder if this may be important or not, but the fact is there).

2. On table "tiki_blog_posts", full text key info is uncomplete:

Brand new 1.8.4:

FULLTEXT KEY `ft` (`data`,`title`)

Updated 1.7.x to 1.8.4:

FULLTEXT KEY `ft` (`data`)

I'll post this also at the sf.net bugs, and I hope it is updated for the new 1.8.5 to be relased soon, due to the security whole, etc.
Cheers, Xavi