Recent Posts

1

Feng Office 3 / Can't add tasks from template

« Last post by pablostevens on July 24, 2020, 04:15:20 PM »

When I try to add tasks from template I get this error and no tasks are added:

#1 ERROR: Error: Declaration of TemplateMilestone::trash($trashDate = NULL) should be compatible with ContentDataObject::trash($trashDate = NULL, $fire_hook = true) in 'xxxxxxxxxxx/application/models/template_milestone/TemplateMilestone.class.php' on line 7 (error code: 2)
#2 FATAL: TypeError: Argument 1 passed to instantiate_template_task_parameters() must be an instance of TemplateTask, instance of TemplateMilestone given, called in /xxxxxxxxxxxxxxx/application/controllers/TemplateController.class.php on line 794 and defined in xxxxxxxxxxxxxx/application/functions.php:2388
Stack trace:
#0 xxxxxxxxxxxxxxxxx/application/controllers/TemplateController.class.php(794): instantiate_template_task_parameters(Object(TemplateMilestone), Object(ProjectMilestone), Array)

VERSION 3.8.1..32


Is it just me or anyone else?

2

Feng Office 3 / Re: Upgrade Help to 3.7.0.5

« Last post by pablostevens on July 24, 2020, 04:13:40 PM »

On Github there is the database schema and all the upgrade scripts.  You can try running them one by one until you get one that doesn't work.

I've also manually added columns to tables and stuff like that to get it to work.  I eventually solved this.  One table was missing a column.  Added it and solved.

This was my error:

#1 FATAL: DBQueryError: Query failed with message 'Unknown column 'allows_default_selection' in 'field list'' in /home/xxxxxxx/environment/library/database/adapters/AbstractDBAdapter.class.php:395
Turns out I was missing a column in the database table. I added "allows_default_selection" and it now works.

3

Installation problems / Problem in Softaculous Install

« Last post by ankitpsaraogi on July 23, 2020, 05:14:31 PM »

I installed the latest softaculous FengOffice version and I verified all dependencies.

However, after the installation when I click on the submit button of the admin setup page, nothing happens. The same page is redirected again and again.

Please help

4

Feng Office 3 / Re: Upgrade Help to 3.7.0.5 (-> 3.8.1.32 now)

« Last post by bukbr on July 18, 2020, 02:40:09 PM »

Thanks Plotz!

In my case this line you wrote could help: 3.4.4.64 to FengOffice 3.8.x      - PaellaUpgradeScript - Class.php
What do I need to do? Can editing just this file and attempting the upgrade solve the problem? If so, would you share this file here?
Or maybe you could help with that upgrade? I propose to pay, depending on the price, of course! I just need 3.8 running without errors ... the translation to my language, I can fix it.

Thanks in advance!

I tried and failed upgrading fo 1.7.5 to a most recent version for years.

As there is no database model published or available, I installed a naked version 3.8.1.32 and did structure syncs between
1.7.5 <-> 2.1 <-> 3.8.1.32
to learn about the changes made.

Finally I got it done by editing the upgrade scripts for all tables throwing errors during upgrade process and runnig the appropriate queries of the complete upgrade script one by one separately.

Since I have more than 50 custom properties in contacts, it was a boring shit to analyse what's going on in the database.

Maybe this list will help you finding the script in /public/upgrade/scripts:

   
 0.6.4 to Feng Office 0.6.6        - DulceDeLecheUpgradeScript - Class.php
 0.6.6 to Feng Office 0.7          - TortaFritaUpgradeScript - Class.php
 0.7 to Feng Office 0.8            - ChurroUpgradeScript - Class.php
 0.8 to Feng Office 0.9            - EmpanadaUpgradeScript - Class.php
 0.9 to Feng Office 1.0            - MilangaUpgradeScript - Class.php
 1.0 to Feng Office 1.1            - BondiolaUpgradeScript - Class.php
 1.1+ to Feng Office 1.2.1         - ChinchulinUpgradeScript - Class.php
 1.2.1 to Feng Office 1.3.1        - MatambritoUpgradeScript - Class.php
 1.3.1 to Feng Office 1.4.2        - NutriaUpgradeScript - Class.php
 1.4.2 to Feng Office 1.5.3        - FigazzaUpgradeScript - Class.php
 1.5 to Feng Office 1.6.2          - ChivitoUpgradeScript - Class.php
 1.6 to FengOffice 1.7.3.3         - PastafrolaUpgradeScript - Class.php
 1.7.4 to FengOffice 2.0           - AsadoUpgradeScript - Class.php
 2.0.1 to FengOffice 2.1           - MollejaUpgradeScript - Class.php
 2.1 to FengOffice 2.2.4.1         - PamplonaUpgradeScript - Class.php
 2.2.4.1 to FengOffice 2.3.2.1     - ChorizoUpgradeScript - Class.php
 2.3.2.1 to FengOffice 2.4.1       - MorcillaUpgradeScript - Class.php
 2.4.1 to FengOffice 2.5.1.4       - VacioUpgradeScript - Class.php
 2.5.1 to FengOffice 2.6.4-beta    - ChotoUpgradeScript - Class.php
 2.6.4-beta to FengOffice 2.7.1.10 - ProvoloneUpgradeScript - Class.php
 2.7.1.1 to FengOffice 3.1         - MondongoUpgradeScript - Class.php
 3.1 to FengOffice 3.1.5.3         - ArazaUpgradeScript - Class.php
 3.1.5.3 to FengOffice 3.2.3       - ButiaUpgradeScript - Class.php
 3.2.3 to FengOffice 3.3.2-beta    - AnisUpgradeScript - Class.php
 3.3.2-beta to FengOffice 3.4.4.52 - BauruUpgradeScript - Class.php
 3.4.4.64 to FengOffice 3.8.x      - PaellaUpgradeScript - Class.php


Basically it worked then, but there was a lot more to do to get the data synchronised, because most of the object IDs change during this process.

There is still work left to adjust / rewrite existing reports.

Finally I comletely translated all the "missing lang" stuff for de_de.
I suppose that translations will only be stored locally and will not be submitted for common language updates / use.

Tools I used: Navicat Premium, WinSCP, fengoffice translation tool, deepl app.

Hope it helps.

5

Feng Office 3 / Re: Upgrade Help to 3.7.0.5 (-> 3.8.1.32 now)

« Last post by Plotz on July 18, 2020, 08:05:08 AM »

I tried and failed upgrading fo 1.7.5 to a most recent version for years.

As there is no database model published or available, I installed a naked version 3.8.1.32 and did structure syncs between
1.7.5 <-> 2.1 <-> 3.8.1.32
to learn about the changes made.

Finally I got it done by editing the upgrade scripts for all tables throwing errors during upgrade process and runnig the appropriate queries of the complete upgrade script one by one separately.

Since I have more than 50 custom properties in contacts, it was a boring shit to analyse what's going on in the database.

Maybe this list will help you finding the script in /public/upgrade/scripts:

   
 0.6.4 to Feng Office 0.6.6        - DulceDeLecheUpgradeScript - Class.php
 0.6.6 to Feng Office 0.7          - TortaFritaUpgradeScript - Class.php
 0.7 to Feng Office 0.8            - ChurroUpgradeScript - Class.php
 0.8 to Feng Office 0.9            - EmpanadaUpgradeScript - Class.php
 0.9 to Feng Office 1.0            - MilangaUpgradeScript - Class.php
 1.0 to Feng Office 1.1            - BondiolaUpgradeScript - Class.php
 1.1+ to Feng Office 1.2.1         - ChinchulinUpgradeScript - Class.php
 1.2.1 to Feng Office 1.3.1        - MatambritoUpgradeScript - Class.php
 1.3.1 to Feng Office 1.4.2        - NutriaUpgradeScript - Class.php
 1.4.2 to Feng Office 1.5.3        - FigazzaUpgradeScript - Class.php
 1.5 to Feng Office 1.6.2          - ChivitoUpgradeScript - Class.php
 1.6 to FengOffice 1.7.3.3         - PastafrolaUpgradeScript - Class.php
 1.7.4 to FengOffice 2.0           - AsadoUpgradeScript - Class.php
 2.0.1 to FengOffice 2.1           - MollejaUpgradeScript - Class.php
 2.1 to FengOffice 2.2.4.1         - PamplonaUpgradeScript - Class.php
 2.2.4.1 to FengOffice 2.3.2.1     - ChorizoUpgradeScript - Class.php
 2.3.2.1 to FengOffice 2.4.1       - MorcillaUpgradeScript - Class.php
 2.4.1 to FengOffice 2.5.1.4       - VacioUpgradeScript - Class.php
 2.5.1 to FengOffice 2.6.4-beta    - ChotoUpgradeScript - Class.php
 2.6.4-beta to FengOffice 2.7.1.10 - ProvoloneUpgradeScript - Class.php
 2.7.1.1 to FengOffice 3.1         - MondongoUpgradeScript - Class.php
 3.1 to FengOffice 3.1.5.3         - ArazaUpgradeScript - Class.php
 3.1.5.3 to FengOffice 3.2.3       - ButiaUpgradeScript - Class.php
 3.2.3 to FengOffice 3.3.2-beta    - AnisUpgradeScript - Class.php
 3.3.2-beta to FengOffice 3.4.4.52 - BauruUpgradeScript - Class.php
 3.4.4.64 to FengOffice 3.8.x      - PaellaUpgradeScript - Class.php


Basically it worked then, but there was a lot more to do to get the data synchronised, because most of the object IDs change during this process.

There is still work left to adjust / rewrite existing reports.

Finally I comletely translated all the "missing lang" stuff for de_de.
I suppose that translations will only be stored locally and will not be submitted for common language updates / use.

Tools I used: Navicat Premium, WinSCP, fengoffice translation tool, deepl app.

Hope it helps.

6

Feng Office 3 / Re: Use this for reporting bugs

« Last post by Plotz on July 18, 2020, 07:07:06 AM »

Latest Bug report is two years old now.
Submission ends up in error:

Invalid form security token. Did you submit the form twice by accident?

This bug report system seems to be unmaintained / useless.

7

Feng Office 3 / Re: Upgrade Help to 3.7.0.5

« Last post by bukbr on July 13, 2020, 02:49:43 PM »

Thanks!!! Once I ran the script to update to version 3.8 that is on Github, however, it started to give some issues and I decided to go back to the previous one. So, I already have the new fields in the tables ... and the errors I'm having is because they already have these fields. 
---
I commented a few points in the script to skip adding fields. Then it updates, but gives a blank screen error, loads just the top.
I think there must be data that it inserts and makes relationships between tables.

8

Feng Office 3 / Can't edit an existing Workspace

« Last post by pablostevens on July 13, 2020, 02:44:25 PM »

I'm on 3.8.1.32 and I can create workspaces, just not edit.  Once I click on save the "loading" message comes up, disappears and nothing happens.

9

Feng Office 3 / Re: Can't create Workspace!!!

« Last post by pablostevens on July 13, 2020, 02:42:33 PM »

I have problems with upgrades all the time the database scripts always crash or miss tables to be added.  Go look in  https://github.com/fengoffice/fengoffice/blob/master/public/install/installation/templates/sql/mysql_schema.php   and you'll find the DB schema.  Just add the table and columns as defined.  Use PHPMyAdmin if you know how to do this.   It's pretty simple.  Then you'll fix the missing table error.

Here's the relevant part:

CREATE TABLE  `<?php echo $table_prefix ?>sharing_table` (
  `group_id` INTEGER UNSIGNED NOT NULL,
  `object_id` INTEGER UNSIGNED NOT NULL,
  PRIMARY KEY (`group_id`, `object_id`),
  INDEX `object_id`(`object_id`),
  INDEX `group_id` (`group_id`)
) ENGINE=<?php echo $engine ?> <?php echo $default_charset ?>;

10

Feng Office 3 / Re: Upgrade Help to 3.7.0.5

« Last post by pablostevens on July 13, 2020, 02:36:36 PM »

I bypassed this version and went to Github and downloaded the most current version.  This worked!  However, there are all kinds of Database transformation errors.  So I had to run the database script manually via SSH and then fix all the missing columns before I could get it to run.  If you know PHPmyAdmin and a little bit of MYSQL you can get it going.