Forum: help

Monitor Forum | Start New Thread Start New Thread
RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Franck Villaume on 2018-02-02 13:49
[forum:1090]
HI Andre,

1) well done!
2) about FRS warning: it says that your database has some references but these references do not exist on the file system.
This script is generating zipfile of the latest release for each package.
Before generating the zipfile, the script checks if the main folder of the package exists.
The folder path format is:
forge_get_config('upload_dir').'/'.<project_unixname>.'/'.<package_name>

You should check for these folders on your filesystem. If the folder exists, check about permission. The script is running as root, so it should not be a problem.
Then check in the database or through the WUI if the package has releases and optionnally has files.
If the package has releases and has files, something is missing on your filesystem. Do you copy all data from your previous system?
If the package has no release and/or no files, the warning can be skipped.

Best,
Franck

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Andre Morrby on 2018-02-02 12:21
[forum:1089]

error.log (23) downloads
Hi,

Think I managed to get the database changes done.

Got some errors/warnings from: /usr/share/fusionforge/db/20141105-frs-ziplatest.php (see attached file)

could you point me in the right direction on whats need to be fixed?

Thank you.

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Franck Villaume on 2018-01-05 12:55
[forum:1084]
Hi,

From my point of view, your database is missing a lot of information in database_changes. (see previous post on this topic)
My approach would be:
- check your fusionforge version you are running (in my exemple, I assume you are running 5.3.0)
- check the content of https://scm.fusionforge.org/anonscm/gitweb?p=fusionforge/fusionforge.git;a=tree;f=src/db;h=15c7609ed51da41eb863d56e8bd18171bf7efd1d;hb=91b0b0a808f0c90e60e4c496ad808610519a21ff which is the full list of script that should have be run to install or upgrade your database.
- on your new installation:
* when you hit an error, check if the ownership is ok. If ownership is not gforge, then change it to gforge and rerun the upgrade.
* when you hit another error but ownership, check the first error message. check the script accordingly to see if the script has be run against your database. You may need to execute partially some elements from the upgrade script and insert the value in database_changes table. Or if you think the upgrade script does not need to be apply on your database, then just insert the value in database_changes table.

In the current error message you are pointing:
- check the artifact_idx table.
- check the upgrade script 20120703-precompute-fti-vectors.sql
- execute the elements of this script that you think are needed
- insert the script in database_changes

Hope this help.

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Andre Morrby on 2018-01-05 09:54
[forum:1083]

apt3.log (6) downloads
Changed the owner of artifact_idx to gforge tried to run the installer again.
Got some new errors when running the installer. I have attached a log file.

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Franck Villaume on 2017-12-22 13:53
[forum:1080]
yes, in your case, it should be gforge.

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Andre Morrby on 2017-12-22 08:00
[forum:1079]
Schema | Name | Type | Owner
--------+----------------------------------------------------------+----------+----------
public | artifact_idx | table | postgres

Do i need to change the owner to gforge?
There are a few tables with postgres as owner, the rest is gforge.

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Franck Villaume on 2017-12-19 14:22
[forum:1078]
Hi,

you are in the right track. To perform your upgrade, you may need to fix/adjust your database since (from my point of view and I may be wrong) your database is missing some elements.

Can you check if the following table exists in your database: artifact_idx?
Can you check ownership of this table?

You may have to modify ownership of this table: artifact_idx

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Andre Morrby on 2017-12-19 08:36
[forum:1077]

apt2.log (5) downloads
I got some new error when trying to run the update again.
I did a rollback of the VM to the point before the latest update.

Install process:
1. apt-get uppdate && apt-get upgrade then reboot.
2. psql> insert into database_changes (filename) VALUES ('20111017-schema-convergence-from-nondeb.sql');
3. Installed fusionforge from http://fusionforge.fusionforge.org/deb/ jessie-6.0/

I have attached the log from apt-get install fusionforge

Maybe it is easier to set up a new VM and migrate fusionforge to it?

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Franck Villaume on 2017-12-16 08:31
[forum:1076]
Hi,

thank for the information.
It seems that your database is missing one entry in database_changes. And I dont know why. Your database_changes includes older files and newer files to 20111017-schema-convergence-from-nondeb.sql
I believe the database does not need this file to be execute. Just run this sql command against your database:
psql> insert into database_changes (filename) VALUES ('20111017-schema-convergence-from-nondeb.sql');
And rerun the fusionforge upgrade.

Best,
Franck

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Andre Morrby on 2017-12-15 15:51
[forum:1075]

database_changes.txt (38) downloads
Sorry for late reply.

I have attached the output from database_changes.

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Franck Villaume on 2017-12-04 14:10
[forum:1074]
hi,

can you provide the full content of database_changes?
I'm surprise that you have 2012* script where 2011* needs to be execute.

Best,
Franck

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Andre Morrby on 2017-12-04 12:53
[forum:1073]
root@test:~# lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description: Debian GNU/Linux 8.9 (jessie)
Release: 8.9
Codename: jessie

root@test:~# psql --version
psql (PostgreSQL) 9.4.15


fusionforge-5.3.2

scmgit:20121128-drop-old-tables.sql

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Franck Villaume on 2017-11-24 15:34
[forum:1068]
thanks for the file.

What version of debian are you using? Jessie I suppose. Is it fully uptodate?
What version of postgresql?
What version of fusionforge are you using?
What is the last entry in database_changes table?

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Andre Morrby on 2017-11-24 15:12
[forum:1067]

forum_attachment (6) downloads
Se the attached file.

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Franck Villaume on 2017-11-22 19:36
[forum:1066]
Can you provide me the description of the forum_attachment table?

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Franck Villaume on 2017-11-22 09:50
[forum:1065]
Got the attachment.
Looks like there are some errors with this script:
Running script: 20111017-schema-convergence-from-nondeb.sql
SQL: ALTER TABLE forum_attachment DROP CONSTRAINT "$1";
SQL> ERROR: constraint "$1" of relation "forum_attachment" does not exist
ERROR: constraint "$1" of relation "forum_attachment" does not exist
QUERY: ALTER TABLE forum_attachment DROP CONSTRAINT "$1";
Continue executing ([Y]es/[N]o)?
Y

I need to investigate a little bit. I get back to you asap.

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Andre Morrby on 2017-11-22 09:44
[forum:1064]

apt.log (10) downloads
Looks like you're right.
Se if it is working now.

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Franck Villaume on 2017-11-22 09:33
[forum:1063]
looks like there is no attachment. Am I wrong?

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Andre Morrby on 2017-11-22 09:04
[forum:1062]
I have attached the full log.

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Franck Villaume on 2017-11-22 08:48
[forum:1061]
That is strange. It looks like the fusionforge-db-local package cannot run some upgrade scripts.

Can you provide the full log of deb installation ?

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Andre Morrby on 2017-11-22 08:19
[forum:1060]

apt-error.log (5) downloads
Okay, when I install from deb http://fusionforge.fusionforge.org/deb/ jessie-6.0/ I get some new errors:
Errors were encountered while processing:
fusionforge-db-local
gforge-db-postgresql
fusionforge-web
fusionforge
E: Sub-process /usr/bin/dpkg returned an error code (1)

I have include some more errors in the attached file.

Have I missed something?

RE: Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Franck Villaume on 2017-11-15 10:54
[forum:1059]
Hi,

the issue is due to PHP7.
The current fusionforge version available in Debian Official Repo is a little old.
You may want to use the autopublished packages from FusionForge DEB repo: https://fusionforge.org/plugins/mediawiki/wiki/fusionforge/index.php/DEB_Installation#Autobuilt_packages_from_the_project

Upgrade from fusionforge 5.3 to 6 [ Reply ]
By: Andre Morrby on 2017-11-14 22:07
[forum:1058]
I have taken over an VM running fusionforge and now want to upgrade it to verison 6.
The VM is running Debian 8.

I have installed fusionforge from backports: apt-get install -t jessie-backports fusionforge

When I run the post install script (/usr/share/fusionforge/bin/post-install.sh) i get the following error:
PHP Fatal error: Class 'FFError' not found in /usr/share/fusionforge/plugins/contribtracker/common/ContribTrackerPlugin.class.php on line 275

I'm new to fusionforge so I'm pretty sure i have missed something of importance.