Author Topic: Linking Documents to Tasks in Community Edition  (Read 11777 times)

Curtisf

  • Freshman
  • *
  • Posts: 23
    • View Profile
    • Email
Re: Linking Documents to Tasks in Community Edition
« Reply #30 on: May 01, 2015, 02:42:51 pm »
After WAY to many hours of fiddling, I found the problem (or at least the problem for me).

The problem is the "fo_object_types" table.   The new version sets the "plugin_id" to zero instead of null.  Switching them back to Null fixed the problem.

Running the following queries on the database fixed the problem


USE feng;
ALTER TABLE fo_object_types
CHANGE COLUMN `plugin_id` `plugin_id` INT(10) UNSIGNED NULL DEFAULT NULL ;
UPDATE fo_object_types  SET plugin_id = NULL WHERE plugin_id = 0;




Update 'feng' to the name of your database
And if you changed the prefix on your tables you might need to change the 'fo_object_types' to whatever your prefix was. 

The first query changes the structure of the table to allow for null.
The second query changes row that had a "0" to Null.

Hope this helps others as well.

yourm8

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: Linking Documents to Tasks in Community Edition
« Reply #31 on: May 01, 2015, 06:17:25 pm »
Curtisf, thank you so much - you are my hero!
Already spent many hours on trying to fix this issue too but didnt found out a fix.

I can confirm that your solution is working for Version 3.1.2.

Gr8 job!  :D

Vadym_L

  • Freshman
  • *
  • Posts: 15
    • View Profile
    • Email
Re: Linking Documents to Tasks in Community Edition
« Reply #32 on: May 02, 2015, 01:42:52 pm »

Curtisf .
You are the best. It work om fo 3.1.3.
Thank you very much!

gonggo

  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Linking Documents to Tasks in Community Edition
« Reply #33 on: May 02, 2015, 04:45:57 pm »
USE feng;
ALTER TABLE fo_object_types
CHANGE COLUMN `plugin_id` `plugin_id` INT(10) UNSIGNED NULL DEFAULT NULL ;
UPDATE fo_object_types  SET plugin_id = NULL WHERE plugin_id = 0;


it works!!
thank you so much.

now I'm getting back to FO after searching alternatives.

aRaGoRn

  • Newbie
  • *
  • Posts: 4
    • View Profile
    • Email
Re: Linking Documents to Tasks in Community Edition
« Reply #34 on: May 03, 2015, 11:13:20 am »


USE feng;
ALTER TABLE fo_object_types
CHANGE COLUMN `plugin_id` `plugin_id` INT(10) UNSIGNED NULL DEFAULT NULL ;
UPDATE fo_object_types  SET plugin_id = NULL WHERE plugin_id = 0;


It works!!!!! Thank you Curtisf !!!

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: Linking Documents to Tasks in Community Edition
« Reply #35 on: May 19, 2015, 12:27:05 pm »
After WAY to many hours of fiddling, I found the problem (or at least the problem for me).

The problem is the "fo_object_types" table.   The new version sets the "plugin_id" to zero instead of null.  Switching them back to Null fixed the problem.

Running the following queries on the database fixed the problem


USE feng;
ALTER TABLE fo_object_types
CHANGE COLUMN `plugin_id` `plugin_id` INT(10) UNSIGNED NULL DEFAULT NULL ;
UPDATE fo_object_types  SET plugin_id = NULL WHERE plugin_id = 0;




Update 'feng' to the name of your database
And if you changed the prefix on your tables you might need to change the 'fo_object_types' to whatever your prefix was. 

The first query changes the structure of the table to allow for null.
The second query changes row that had a "0" to Null.

Hope this helps others as well.

Thanks for your feedback to everyone here, well done! :)
If I am not mistaken, some fixes for this were applied not long ago as well so this change should not be done manually if you are using the latest versions available.

Best,
Francisco
Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem! Read this article!