Loading...
 
 Error
  • Contact the site administrator. The index needs rebuilding.
Features / Usability

Features / Usability


2 differences found in sql blog-related tables

posts: 957

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

There are no comments at this time.