Loading...
 
Architecture / Installation

Architecture / Installation


An upgrade query: forum structure

posts: 1

Hi there,

I have a large tikiwiki and am currently doing an upgrade from v1.7.9 to 1.9.2. It's been an interesting process and after some trial and error I got the upgrade scripts working on the database by pulling out all of the data from some of the tables, most notably tiki_comments and tiki_articles. I took a look at the structure of tiki_comments in both versions and can see that there are 4 extra fields in the 1.9.2 version. I restructured the v1.7.9 data into the 1.9.2 format, creating empty entrys for objectType, message_id, in_reply_to and comment_ratings. The data went into the database just fine and in fact all the items appear to be present in the database at the same address as before: tiki/tiki-view_forum_thread.php?forumId=x&comments_parentId=y - the only problem appears to be that there is no list of posts on the individual forum homepage: tiki-view_forum.php?forumId=x.

It's occurred to me that the field object (Var char 32) in 1.7.9 might actually correspond to ObjectType (Var char 32) in 1.9.2 in which case my initial restructuring could be off but I was wondering if anyone else had any ideas?

Thanks in advance!

Jacob

posts: 2881 United Kingdom

Hi Jacob,

The upgrade from 1.7 is not straight forward. Here is the process you must do:

Restore a backup of your 1.7.9 database
Run the 1.7to1.8.sql upgrade
Run the commentsfix.sql
Run the structurefix.sql
Run the 1.7to1.8.sql again
Run the 1.8to1.9.sql

Do not run the comments and structures a second time as they will result in data corruption.

This upgrade is detailed on the UpgradeTo18 / UpgradeTo19 pages.

Cheers

Damian