Loading...
 
Features / Usability

Features / Usability


How to move Wiki pages from v1.9 rc3 to v1.9 release ?

posts: 4

Hello!

I'm using TikiWiki v1.9 RC3 now. There are already a lot of pages in Wiki. I've read that I can export Wiki pages through Administration->Wiki->Export Wiki Pages. So I've got export.tar. But there's no Admin->Import PHPWiki Dump menu item in v1.9 release. How I can import this dump into new installation ?

posts: 4

> Have you tried just upgrading your instalation to 1.9.0, as if it was a 1.8.x version?
> http://tikiwiki.org/tiki-index.php?page=UpgradeTo19

Been there, done that.

Here is output of my upgrade attempt:
root@smdev db# mysql -f tiki190rc3 < tiki_1.8to1.9.sql
ERROR 1060 at line 22: Duplicate column name 'anonymous'
ERROR 1060 at line 24: Duplicate column name 'position'
ERROR 1060 at line 27: Duplicate column name 'longdesc'
ERROR 1060 at line 28: Duplicate column name 'version'
ERROR 1060 at line 29: Duplicate column name 'showComments'
ERROR 1060 at line 30: Duplicate column name 'orderAttachments'
ERROR 1060 at line 40: Duplicate column name 'usersTrackerId'
ERROR 1060 at line 41: Duplicate column name 'groupTrackerId'
ERROR 1060 at line 44: Duplicate column name 'isSearchable'
ERROR 1060 at line 68: Duplicate column name 'priv'
ERROR 1050 at line 71: Table 'tiki_tracker_options' already exists
ERROR 1060 at line 79: Duplicate column name 'isPublic'
ERROR 1060 at line 87: Duplicate column name 'optionId'
ERROR 1060 at line 90: Duplicate column name 'show_avatar'
ERROR 1062 at line 93: Duplicate entry 'tiki_p_view_trackers_pending' for key 1
ERROR 1060 at line 97: Duplicate column name 'isHidden'
ERROR 1062 at line 104: Duplicate entry 'tiki_p_view_trackers_closed' for key 1
ERROR 1050 at line 114: Table 'tiki_score' already exists
ERROR 1054 at line 136: Unknown column 'category' in 'field list'
ERROR 1054 at line 137: Unknown column 'category' in 'field list'
ERROR 1054 at line 138: Unknown column 'category' in 'field list'
ERROR 1054 at line 139: Unknown column 'category' in 'field list'
ERROR 1054 at line 140: Unknown column 'category' in 'field list'
ERROR 1054 at line 141: Unknown column 'category' in 'field list'
ERROR 1054 at line 142: Unknown column 'category' in 'field list'
ERROR 1054 at line 143: Unknown column 'category' in 'field list'
ERROR 1054 at line 144: Unknown column 'category' in 'field list'
ERROR 1054 at line 145: Unknown column 'category' in 'field list'
ERROR 1054 at line 146: Unknown column 'category' in 'field list'
ERROR 1054 at line 147: Unknown column 'category' in 'field list'
ERROR 1054 at line 148: Unknown column 'category' in 'field list'
ERROR 1054 at line 149: Unknown column 'category' in 'field list'
ERROR 1054 at line 150: Unknown column 'category' in 'field list'
ERROR 1054 at line 151: Unknown column 'category' in 'field list'
ERROR 1054 at line 152: Unknown column 'category' in 'field list'
ERROR 1054 at line 153: Unknown column 'category' in 'field list'
ERROR 1054 at line 154: Unknown column 'category' in 'field list'
ERROR 1054 at line 155: Unknown column 'category' in 'field list'
ERROR 1054 at line 156: Unknown column 'category' in 'field list'
ERROR 1054 at line 157: Unknown column 'category' in 'field list'
ERROR 1054 at line 158: Unknown column 'category' in 'field list'
ERROR 1054 at line 159: Unknown column 'category' in 'field list'
ERROR 1054 at line 160: Unknown column 'category' in 'field list'
ERROR 1054 at line 161: Unknown column 'category' in 'field list'
ERROR 1054 at line 162: Unknown column 'category' in 'field list'
ERROR 1054 at line 163: Unknown column 'category' in 'field list'
ERROR 1054 at line 164: Unknown column 'category' in 'field list'
ERROR 1054 at line 165: Unknown column 'category' in 'field list'
ERROR 1050 at line 174: Table 'tiki_logs' already exists
ERROR 1050 at line 191: Table 'tiki_shoutbox_words' already exists
ERROR 1060 at line 202: Duplicate column name 'usersFieldId'
ERROR 1060 at line 205: Duplicate column name 'isMandatory'
ERROR 1060 at line 212: Duplicate column name 'topline'
ERROR 1060 at line 213: Duplicate column name 'subtitle'
ERROR 1060 at line 214: Duplicate column name 'linkto'
ERROR 1060 at line 215: Duplicate column name 'image_caption'
ERROR 1060 at line 216: Duplicate column name 'topline'
ERROR 1060 at line 217: Duplicate column name 'subtitle'
ERROR 1060 at line 218: Duplicate column name 'linkto'
ERROR 1060 at line 219: Duplicate column name 'image_caption'
ERROR 1060 at line 222: Duplicate column name 'lang'
ERROR 1060 at line 223: Duplicate column name 'lang'
ERROR 1060 at line 225: Duplicate column name 'show_topline'
ERROR 1060 at line 226: Duplicate column name 'show_subtitle'
ERROR 1060 at line 227: Duplicate column name 'show_linkto'
ERROR 1060 at line 228: Duplicate column name 'show_image_caption'
ERROR 1060 at line 229: Duplicate column name 'show_lang'
ERROR 1062 at line 232: Duplicate entry 'tiki_p_admin_sheet' for key 1
ERROR 1062 at line 233: Duplicate entry 'tiki_p_edit_sheet' for key 1
ERROR 1062 at line 234: Duplicate entry 'tiki_p_view_sheet' for key 1
ERROR 1062 at line 235: Duplicate entry 'tiki_p_view_sheet_history' for key 1
ERROR 1050 at line 243: Table 'tiki_sheet_values' already exists
ERROR 1050 at line 257: Table 'tiki_sheets' already exists
ERROR 1060 at line 273: Duplicate column name 'tagcategory'
ERROR 1061 at line 274: Duplicate key name 'tagcategory'
ERROR 1050 at line 295: Table 'tiki_sheet_layout' already exists
ERROR 1060 at line 307: Duplicate column name 'lang'
ERROR 1062 at line 427: Duplicate entry 'tiki_p_send_newsletters' for key 1
ERROR 1060 at line 434: Duplicate column name 'immediateFeedback'
ERROR 1060 at line 435: Duplicate column name 'showAnswers'
ERROR 1060 at line 436: Duplicate column name 'shuffleQuestions'
ERROR 1060 at line 437: Duplicate column name 'shuffleAnswers'
ERROR 1060 at line 438: Duplicate column name 'publishDate'
ERROR 1060 at line 439: Duplicate column name 'expireDate'
ERROR 1060 at line 440: Duplicate column name 'bDeleted'
ERROR 1060 at line 441: Duplicate column name 'nVersion'
ERROR 1060 at line 442: Duplicate column name 'nAuthor'
ERROR 1060 at line 443: Duplicate column name 'bOnline'
ERROR 1060 at line 444: Duplicate column name 'bRandomQuestions'
ERROR 1060 at line 445: Duplicate column name 'nRandomQuestions'
ERROR 1060 at line 446: Duplicate column name 'bLimitQuestionsPerPage'
ERROR 1060 at line 447: Duplicate column name 'nLimitQuestionsPerPage'
ERROR 1060 at line 448: Duplicate column name 'bMultiSession'
ERROR 1060 at line 449: Duplicate column name 'nCanRepeat'
ERROR 1060 at line 450: Duplicate column name 'sGradingMethod'
ERROR 1060 at line 451: Duplicate column name 'sShowScore'
ERROR 1060 at line 452: Duplicate column name 'sShowCorrectAnswers'
ERROR 1060 at line 453: Duplicate column name 'sPublishStats'
ERROR 1060 at line 454: Duplicate column name 'bAdditionalQuestions'
ERROR 1060 at line 455: Duplicate column name 'bForum'
ERROR 1060 at line 456: Duplicate column name 'sForum'
ERROR 1060 at line 457: Duplicate column name 'sPrologue'
ERROR 1060 at line 458: Duplicate column name 'sData'
ERROR 1060 at line 459: Duplicate column name 'sEpilogue'
ERROR 1060 at line 511: Duplicate column name 'format'
ERROR 1050 at line 515: Table 'tiki_translated_objects' already exists
ERROR 1062 at line 527: Duplicate entry 'tiki_p_list_users' for key 1
ERROR 1050 at line 530: Table 'tiki_friends' already exists
ERROR 1050 at line 536: Table 'tiki_friendship_requests' already exists
ERROR 1050 at line 547: Table 'tiki_users_score' already exists
ERROR 1060 at line 548: Duplicate column name 'score'
ERROR 1060 at line 561: Duplicate column name 'bibliographical_references'
ERROR 1060 at line 562: Duplicate column name 'bibliographical_references'
ERROR 1060 at line 565: Duplicate column name 'article_topicId'
ERROR 1091 at line 574: Can't DROP 'description'. Check that column/key exists
ERROR 1091 at line 575: Can't DROP 'category'. Check that column/key exists
ERROR 1091 at line 576: Can't DROP 'ord'. Check that column/key exists
ERROR 1091 at line 579: Can't DROP 'score'. Check that column/key exists
ERROR 1050 at line 630: Table 'tiki_structure_versions' already exists
ERROR 1060 at line 636: Duplicate column name 'structure_id'
ERROR 1060 at line 637: Duplicate column name 'page_version'
ERROR 1050 at line 640: Table 'tiki_download' already exists
ERROR 1091 at line 694: Can't DROP 'customevent'. Check that column/key exists
ERROR 1091 at line 695: Can't DROP 'evId'. Check that column/key exists
ERROR 1091 at line 707: Can't DROP 'lock'. Check that column/key exists

>
> I guess it will do fine for your purposes...
> Cheers,
> Xavi
>
> P.S. Note that PHPWiki is another wiki engine, different from TikiWiki

Documentation states that I can import Tiki content:
http://tikiwiki.org/tiki-index.php?page=ConversionFromPhpwiki

posts: 4656 Japan

It's normal to get error warnings when doing the database update, because often the changes have already been made.

Are you upgrading one Tiki installation, or transferring pages between two installations? If you are upgrading a single installation, there's no need to move wiki pages; they (like all content) aren't touched by updates except in special cases, and there no such cases in this particular upgrade.

If you are moving pages between two distinct Tiki installations, then I guess you could add the new pages to the wiki pages table of the second installation, maybe making adjustments where necessary. If this is the case, please post again and I can probably give more details.

-- Gary

posts: 4

> Are you upgrading one Tiki installation, or transferring pages between two installations? If you are upgrading a single installation, there's no need to move wiki pages; they (like all content) aren't touched by updates except in special cases, and there no such cases in this particular upgrade.

Yes, I'm upgrading a single installation. Which tables I must dump and restore into new tiki version to get all my Wiki pages ?

posts: 4656 Japan

> Yes, I'm upgrading a single installation. Which tables I must dump and restore into new tiki version to get all my Wiki pages ?

If you are updating your existing Tiki database, no tables need to be dumped or restored, except for what is specified in the Tiki_1.8toTiki_1.9.sql upgrade file. Use this file to update your database; this update does not touch your wiki page table. This update script may delete or create or alter tables, depending on what has changed since your previous install or upgrade; but you don't need to do anything other than what the upgrade script specifies.

(In my case, I use phpMyAdmin to update my Tiki sites, and it terminates at the first error (such as the errors you listed), so I have to run the statements "manually," that is, I have to start again with a new statement after the error-causing line. Most errors are due to a change already having been made — either an item to be added was already added, or one to be deleted was already deleted, by an earlier database update.)

The point is, one way or another, just execute the statements in the sql update script to bring your database up to date. Again, this update is done "around" your wiki pages and other content — no need to dump and re-import them.

-- Gary

posts: 4

> The point is, one way or another, just execute the statements in the sql update script to bring your database up to date. Again, this update is done "around" your wiki pages and other content — no need to dump and re-import them.
>
> — Gary

Thank you for your response. I'll try to follow your tips.


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting