Upgrade from 1.8.2 to 8.05

# 1 Old 05-26-2008, 06:43 PM
aldago aldago is offline aldago's reputation aldago is on a distinguished road » Newcomer
Join Date: Mar 2008 Posts: 9
Send a message via ICQ to aldago
Post Upgrade from 1.8.2 to 8.05
I have carry the sql database and attachments from version 1.8.2 to 8.05.

All actions is done as described in http://wiki.opengarden.org/Deki_Wiki...your_Deki_Wiki

But after "rebuild index" procedure.
( cd /var/www/dekiwiki/maintenance
php update-db.php )


i cannot see pictures and files attached to the pages, because of different path in new version (/dekiwiki/attachments instead of /deki-hayes/attachments). I was able to see attached files after "/deki-hayes/attachments" directory creation and files copying.
But error "Internal Error (500) Unable to create directory \'/var/www/deki-hayes/attachments/31\' for attachment" on upload attachment still persists. And where are no preview for images.

can I convert pages to use new attachments path automatically?
Last edited by aldago : 05-27-2008 at 03:31 AM.
# 2 Old 05-27-2008, 08:46 PM
brigettek brigettek is online now brigettek's reputation brigettek is a jewel in the rough » MindTouch Team
Join Date: Feb 2007 Location: San Diego, CA Posts: 720
Could you verify that the value of the storage/fs/path configuration setting matches the location of the attachments directory? Also, make sure to chown -R the directory to www-data.
Last edited by brigettek : 05-27-2008 at 08:49 PM.
# 3 Old 05-29-2008, 05:17 AM
aldago aldago is offline aldago's reputation aldago is on a distinguished road » Newcomer
Join Date: Mar 2008 Posts: 9
Send a message via ICQ to aldago
Default Error 500
hello, brigettek.

I have change fs path to "storage/fs/path = /var/www/dekiwiki/attachments".
And all my attachments and pictures are visible fine.

But if i attach new files, i have see following message (error 500):

Quote: URI \u0437\u0430\u043f\u0440\u043e\u0441:\nhttp:\/\/localhost:8081\/deki\/pages\/32\/files\/=32C.jpg?dream.out.format=php&dream.in.host=192.16 8.0.129&dream.in.scheme=http&dream.in.origin=192.1 68.0.1\n\n\u041e\u0442\u0432\u0435\u0442 \u0441\u0435\u0440\u0432\u0435\u0440\u0430:\nArray \n(\n [exception] => Array\n (\n [message] => Unknown column 'rc_transaction_id' in 'field list'\n [source] => MySql.Data\n [stacktrace] => Array\n (\n [frame] => Array\n (\n [0] => MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000]\n [1] => MySql.Data.MySqlClient.NativeDriver.ReadResult (System.UInt64& affectedRows, System.Int64& lastInsertId) [0x00000]\n [2] => MySql.Data.MySqlClient.MySqlDataReader.GetResultSe t () [0x00000]\n [3] => MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000]\n )\n\n )\n\n [type] => MySql.Data.MySqlClient.MySqlException\n )\n\n)\n
but file is attached fine and become visible.

and while new page create occurs following error (Something seems to have broken! Please try saving again - we've already filled in the editor with your last contents.):

Quote: URI запрос:
http://localhost:8081/deki/pages/=%2...ts=0&edittime=

Ответ сервера:
Array
(
[exception] => Array
(
[message] => Unknown column 'rc_transaction_id' in 'field list'
[source] => MySql.Data
[stacktrace] => Array
(
[frame] => Array
(
[0] => MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000]
[1] => MySql.Data.MySqlClient.NativeDriver.ReadResult (System.UInt64& affectedRows, System.Int64& lastInsertId) [0x00000]
[2] => MySql.Data.MySqlClient.MySqlDataReader.GetResultSe t () [0x00000]
[3] => MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000]
)

)

[type] => MySql.Data.MySqlClient.MySqlException
)

)
api security keys is the same in /etc/dekiwiki/mindtouch.host.conf /etc/dekiwiki/mindtouch.deki.startup.xml /../dekiwiki/LocalSettings.php

if i try to add file through desktop connector then message "unknown column 'rc_transaction_id' in 'field list'" occure. but file is added to folder.

i also do the 'chown -R www-data /var/www/dekiwiki/attachments'.


why errors occured?
and why new VM size have 30G limit?
Last edited by aldago : 05-29-2008 at 10:43 AM.
# 4 Old 05-29-2008, 07:00 PM
brigettek brigettek is online now brigettek's reputation brigettek is a jewel in the rough » MindTouch Team
Join Date: Feb 2007 Location: San Diego, CA Posts: 720
Although you ran update-db.php, the database did not get updated to the latest schema (rc_transaction_id is a new database column). This sounds like it might be the same issue encountered here: http://forums.opengarden.org/showthread.php?t=2697.
# 5 Old 05-30-2008, 06:35 PM
aldago aldago is offline aldago's reputation aldago is on a distinguished road » Newcomer
Join Date: Mar 2008 Posts: 9
Send a message via ICQ to aldago
I had read http://forums.opengarden.org/showthread.php?t=2697. carefully, but cannot achieve the same result.

steps:
1. delete database.
Quote: mysql -u root -ppassword -e "drop database wikidb"
2. create database
Quote: /var/www/deki-hayes/maintenance$ sh createdb.sh --dbName wikidb --dbAdminUser root --dbAdminPassword password --dbServer localhost --dbWikiUser wikiuser --wikiAdmin Admin --wikiAdminPassword my_wiki_admin_password --wikiAdminEmail myself@whatever.com --storageDir /var/www/deki-hayes/attachments/wikidb
3. restore database
Quote: mysql -uroot -ppassword wikidb < backup.sql
4. update
Quote: php update-db.php
5. have problem with 'rc_transaction_id' in 'field list', and verify the table structure
mysqlshow -uroot -ppassword wikidb recentchanges | more

.... and see that database not contain 'rc_transaction_id' in 'field list'.
also i find that necessary fields from 'archive' table are missing. such as
Quote: `ar_transaction_id` int(4) unsigned NOT NULL default '0',
so. i think that database have old structure.
I have try manually add necessary fields, and addition/deletion of pages now working fine. But I want do these actions automatically.

maybe i must use another dump/import procedure??
Last edited by aldago : 05-30-2008 at 06:37 PM.
# 6 Old 05-30-2008, 07:02 PM
brigettek brigettek is online now brigettek's reputation brigettek is a jewel in the rough » MindTouch Team
Join Date: Feb 2007 Location: San Diego, CA Posts: 720
That sounds like the correct backup/restore procedure. A couple things to check:
  1. Verify patch-transactions.sql is in maintenance\archives
  2. Verify updaters-mindtouch.in in maintenance references patch-transactions
  3. Assuming you have 1 and 2, I would suspect a database permissions problem. update-db.php uses the db username/password in adminsettings.php and if that is not present it looks in localsettings.php. Verify that you are able to update the database with these settings.
# 7 Old 06-24-2008, 07:36 PM
ipstatic ipstatic is offline ipstatic's reputation ipstatic is on a distinguished road » Newcomer
Join Date: Jun 2008 Posts: 1
I am having the same issue and I have followed the steps outlined above but I am still having page edit/delete issues. How can I add those columns manually?
# 8 Old 07-01-2008, 11:02 PM
devslashnull devslashnull is offline devslashnull's reputation devslashnull is on a distinguished road » Newcomer
Join Date: Jul 2008 Posts: 2
It took me a bit to figure out what need to be done but if you run the following commands you can update the tables and have everything run correctly.
Quote: mysql -u root -ppassword
Within mysql run the following:
Quote: use wikidb;
alter table recentchanges add column rc_transaction_id int;
alter table archive add column ar_transaction_id int;
# 9 Old 07-11-2008, 04:47 PM
gabriel84 gabriel84 is offline gabriel84's reputation gabriel84 is on a distinguished road » Junior Community Member
Join Date: Mar 2008 Posts: 52
hello devslashnull,

I did what you said about adding the columns rc_transaction_id and ar_transaction_id and when I did it seems to work perfectly but, after a few days a realized that the recent changes doesn't work cprrectly, it shows who and when the changes were made, but the edit sumary shows "missing" instead of how many word were changed.

do you know anyway to fix it??

thanks for your time!!
# 10 Old 07-14-2008, 08:24 PM
devslashnull devslashnull is offline devslashnull's reputation devslashnull is on a distinguished road » Newcomer
Join Date: Jul 2008 Posts: 2
Gaberiel,

I haven't noticed this issue that you mentioned; however, I not exactly sure where you are seeing this error as I am rather new to MindTouch and have not dealt with it before I was asked to preform the upgrade.

The way I determined that the columns I listed need to be added was by generating the error and checking the log file in:
Quote: /var/log/dekiwiki
I would recommend using the following command on the log file so you can see the last lines as it is generated:
Quote: tail -f /var/log/dekiwiki/checkdeki.log
That should help to determine what errors are being generated so that the proper columns can be added or adjusted as need be. If you need help debugging the error message please post the error message in full and I will try to help as best as I can.

-/dev/null
Page 1 of 2 1 2 >

Thread Tools

Search this Thread

Search this Thread Advanced Search

Display Modes