How to Add Gantt Charts (JSGantt) to Feng Office

[allenlook]

Did you try the mysql_upgrade command as indicated?

[alexandz]

how I can create for jsgantt index.php?

[stephan33]

Resolved, had to change the delimiter to // for the version of MySQL I am using.

First thank you for all the good post on here, I am just getting started with Fengoffice 1.7 and got everything running just fine.

I was intrigued with the Gantt cart "patch" and downloaded v 13.1 which is attached to this thread.

The SQL script appears to bum at the (everything before was executed fine)
CREATE PROCEDURE getwebit_office17.`get_my_workspaces`()

The error I am getting in the client is:

/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS `pParent`,  (CASE `og_projects`.`p2` WHEN 0 THEN  `og_projects`.`p1` ELSE' at line 1 */
 END;
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 1 */
/* 0 rows affected, 0 rows found. Duration for 1 of 5 queries: 0.062 sec. */

I am not seeing anything obvious but not a SQL guru either.

Any help welcome!
Thanks,
Stephan

[stephan33]

Thanks to all the tips on this thread I have the Gantt Chart & Tab working.  My question is around permissions, a user x who has access to workspace x is able to view gantt charts for all workspaces.  Is there a way to limit user x to view only his own workspace tasks this user is assigned to?

Also interestingly, one personal workspace is included in the options while the "main" workspace" for that user is not? I had the project workspace assigned to the user instead of the his personal one.

Thanks,
Stephan

[proffnet]

I get a slightly different error within MySQLadmin:

CREATE FUNCTION fengoffice.`my_getworkspace` (
s CHAR( 20 )
) RETURNS char( 128 ) CHARSET latin1 RETURN (
SELECT pID
FROM my_workspaces
WHERE pID = s
);

MySQL said: Documentation
#1418 - This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Any ideas, got me stumped.... using V13.1 installed in a tab. But this is the SQL code to create the tables/functions etc... where it is failing.

Add

 SET GLOBAL log_bin_trust_function_creators = 1;

It should help. You have to have administrator rights to do this.

[memnon]

Hi there...

i use FengOffice 1.7.5 and have 2 problems with the installation:

if i switch to the "tab" i get following errors:

<sup>Warning: include(../chartglobal.php) [function.include]: failed to open stream: No such file or directory in C:\xampp\htdocs\og\application\views\lab\index.php on line 203

Warning: include() [function.include]: Failed opening '../chartglobal.php' for inclusion (include_path='.;C:\xampp\php\PEAR') in C:\xampp\htdocs\og\application\views\lab\index.php on line 203</sup>



i searched the folder xampp, i dont have a chartglobal.php file - where do i get this ?


2nd Problem

if i try to use your php script with phpMyAdmin i get errors even on the 1st command:

^{ROP TABLE IF EXISTS my_tblmilestones$$
CREATE TABLE `my_tblmilestones` (
  `rowcount` varchar(20) DEFAULT NULL,
  `pID` int(32) DEFAULT NULL,
  `pName` varchar(128) DEFAULT NULL,
  `pStart` date DEFAULT NULL,
  `pEnd` date DEFAULT NULL,
  `pColor` decimal(10,0) DEFAULT NULL,
  `pMile` int(11) DEFAULT NULL,
  `pRes` varchar(32) DEFAULT NULL,
  `pEmail` varchar(32) DEFAULT NULL,
  `pComp` decimal(10,0) DEFAULT NULL,
  `pGroup` int(11) DEFAULT NULL,
  `pParent` varchar(64) DEFAULT NULL,
  `pWBS` varchar(64) DEFAULT NULL,
  `pOrderBy` varchar(256) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1$$}


#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `my_tblmilestones` ( `rowcount` varchar(20) DEFAULT NULL, `pID`' at line 2


i am really new to all this but any help would be great...

i made all the steps before (i use the solution with TAB integrated view)

[memnon]

1st problem solved

i included the chartglobal.php whilst i didnt need that file

2nd problem , still no clue

[memnon]

well i dont have to replace ";" with "$$" as noted in the discription

so 2nd prob itself is solfed, but leads me into next problem...


BTW: my Version: Server Version: 5.5.16
Protokoll-Version: 10

SQL-Befehl:

CREATE PROCEDURE fengoffice.`get_my_workspaces` (
) BEGIN DELETE FROM my_tblworkspaces;

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

[luci]

yea,
 the same with me

sql file: feng_gantt_13.1.sql, importing it with PhpMyAdmin..

Code: [Select]

SQL query:
CREATE PROCEDURE track.`get_my_workspaces` (
)$$ BEGIN DELETE FROM my_tblworkspaces;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BEGIN

DELETE FROM my_tblworkspaces' at line 2


[asdfghj]

@luci
i had similar issues when i was tring to install this on feng office 2 beta 3.  once i downgraded to 1.7.5  the script completed without error and i am able to pull up the page.  

i am however getting some errors about undefined variables and indexes when its listing the workspaces and a few other things.  It can pull the resources fine, just errors with a few others.

--errors--

(top of page)
Notice: Undefined index: hidSubmitted in C:\wamp\www\manager\application\views\gantt\index.php on line 215


(these are workspaces)
Notice: Undefined variable: sel in C:\wamp\www\manager\application\views\gantt\index.php on line 368

Notice: Undefined index: pID in C:\wamp\www\manager\application\views\gantt\index.php on line 371

Notice: Undefined index: pID in C:\wamp\www\manager\application\views\gantt\index.php on line 371

Notice: Undefined index: pID in C:\wamp\www\manager\application\views\gantt\index.php on line 371

Notice: Undefined index: pID in C:\wamp\www\manager\application\views\gantt\index.php on line 371

Notice: Undefined index: pID in C:\wamp\www\manager\application\views\gantt\index.php on line 371

(colors checkbox)
Notice: Undefined index: chkColor in C:\wamp\www\manager\application\views\gantt\index.php on line 454

(duration checkbox
Notice: Undefined index: chkDuration in C:\wamp\www\manager\application\views\gantt\index.php on line 468

(dates checkbox)
Notice: Undefined index: chkDates in C:\wamp\www\manager\application\views\gantt\index.php on line 470

(bottom of page)
Notice: Undefined variable: SQL_Start in C:\wamp\www\manager\application\views\gantt\index.php on line

Notice: Undefined variable: SQL_End in C:\wamp\www\manager\application\views\gantt\index.php on line

[jolivaresd]

Friends,

I need export to a pdf file or print the gantt, but when i ty to print, the color bars don't appears...
Somebody can help me or can solve this issue?

Thanks,
J

[VER]

Friends,

I need export to a pdf file or print the gantt, but when i ty to print, the color bars don't appears...
Somebody can help me or can solve this issue?

Thanks,
J

In my case this has been solved by modifying all instances of opacity:0.9 to opacity:1 in both jsgantt.js and jsgantt.compressed.js

Thx for the great work!

The only problem I'm having is that it shows all workspaces and all resources. I've put all my tasks in one Workspace and limited the query to that workspace. This worked fine in this particular case.
I did not manage to get the tab working though (but stopped  investigating it for the time being).

[beto]

Hi Allen,

Could you help a little bit, I want to show the Gantt Tab only to certain users and hide the tab for everyone else, for this maybe I could use the username.

Thanks, Roberto.

[jeob]

Hi,

First thank you for trying to help us to add gantt chart in fengoffice.

I would like to know if your jsgantt code work in fengoffice 2.0 ?

I tried to install it but it seems that some tables doesn't exit in the new version (fo_projects, fo_workspaces_object)

Thank you for help

Have a nice day

[stmitchell]

I would like to know if your jsgantt code work in fengoffice 2.1?

I am having exact same issues as above post