Loading...
 
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.

Upcoming Events

1)  21 Mar 2024 18:00 GMT-0000
Tiki Roundtable Meeting
2)  25 Mar 2024 17:00 GMT-0000
29th anniversary WikiBirthday (With Ward Cunningham)
3)  18 Apr 2024 18:00 GMT-0000
Tiki Roundtable Meeting
4)  16 May 2024 18:00 GMT-0000
Tiki Roundtable Meeting
5)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
8)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9) 
Tiki birthday
10)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting