2 differences found in sql blog-related tables
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):
Copy to clipboard
`data_size` int(11) unsigned NOT NULL default '0',
Line from a updated 1.7 to 1.8 with update sql scripts:
Copy to clipboard
`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:
Copy to clipboard
FULLTEXT KEY `ft` (`data`,`title`)
Updated 1.7.x to 1.8.4:
Copy to clipboard
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