How to Add Gantt Charts (JSGantt) to Feng Office

[emjay]

Problem:

CREATE FUNCTION opengoo16fresh.`my_getworkspace` (

sCHAR( 20 )
) RETURNS CHAR( 128 ) CHARSET latin1 RETURN (
SELECT pID
FROM my_workspaces
WHERE pID = s
);

#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)

UPDATE:
sed -i "s/fengoffice_dev/enter_db_name_here/g" feng_gantt_13.1.sql

sed -i "s/CREATE PROCEDURE /delimiter \$\$\r\nCREATE PROCEDURE /g"
feng_gantt_13.1.sql

sed -i "s/END;/END\$\$\r\ndelimiter ;\n/g" feng_gantt_13.1.sql


works much better now for me, using phpmyadmin for executing the sql-statements

[peterchanhua]

Hello Allen,

Thanks for your GREAT WORK!! The Chart can be shown and it is nice!

However, does it support multilingual? When I input chinese characters in the task subject in Feng Office Task, I can see the chinese words. But the chart cannot shows chinese characters, it show some "" instead. Do you have any clue for this issue?

[allenlook]

You're very welcome, and thanks for the appreciation.

Does it help to change the "Character Set" field to something else?  Like, ASCII/Unicode, or Chinese Simplified, or Chinese Traditional, or Chinese+HK?

[gah242s]

I seem to have a problem with Charsets that is killing things.  In looking at the Page Source, as the last line I see:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

I've tried changing everything to utf8_unicode_ci, tried removing the implicit from all of the Functions, and dropped, re-imported the tables multiple times.  This was only an issue when I chose specific resources on 11.2, but 13.1 gives this for everything and just gives me a blank page.

The last few lines before the error are:

   g.setDateDisplayFormat('mm/dd/yyyy'); // Set format to display dates ('mm/dd/yyyy', 'dd/mm/yyyy', 'yyyy-mm-dd')
   g.setFormatArr("day","week","month","quarter"); // Set format options (up to 4 : "minute","hour","day","week","month","quarter")
   
   if( g ) {

        Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

Thanks,

[Gertjan Tillema]

I have the same

Code: [Select]

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT)error.

Can somebody give a hint to solve this issue? Thanks in advance!

[allenlook]

What version of MySQL are you running?

There is some information on the error (in vBulletin) here:

http://www.vbulletin.com/forum/showthread.php?121120-SQL-Error

[Gertjan Tillema]

I'm running MySQL 5.1.36.

I'll take a look at the link you posted, thanks.

[Gertjan Tillema]

Hmz, I tried to alter all the tables, but I still receive the error from the php part of the index.php. It doesn't matter if I change all tables to unicode or to general.

Update: the problem seems to be when I do 'call get_my_tasks1'. All other procedures (except get_my_gantt, because get_my_task1 is in it) don't give the error.

[allenlook]

My SQL guru Kevin is taking a look into it.  We're not really MySQL or collation experts however 

[allenlook]

Here's his response(s)...

A few things to check….in this order preferably

1.   He has the latest scripts we loaded?
2.   What happens if he calls the stored procedure through Toad?
3.   He is on version 5.1.36, w are on 5.1.44.  It could be here…?
4.   It looks like he is getting the error when running this particular part of get_my_tasks1 (cast(concat(77777,`og_project_tasks`.`id`) as char(16) charset utf8)), if so, then he should try playing with the cast function on it to convert it to a more appropriate collation setting for him, or perhaps removing it altogether.

That should give some things to try….

[rayanami]

Hi all,

I followed the instructions on the front page and after that run the index.php and it gave me this error:

Warning: include(../chartglobal.php) [function.include]: failed to open stream: No such file or directory in C:\xampp\htdocs\fengoffice\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\fengoffice\application\views\lab\index.php on line 203

I am using XAMPP 1.7.3 and Fengoffice 1.7RC2

Has anyone encountered this problem?

[allenlook]

Please read the instructions inside the index.php file - it tells you how to set up your database connection, either by including the settings right inside the index.php file itself, or by referencing a file one level above called chartglobal.php that contains the settings.

With frequent updates, it's easier to keep the settings in a separate directory so they don't constantly get overwritten (or accidentally shared with the world).

[akiuser]

Hi,
I get the SQL-Error #1418 using phpmyadmin for the SQL-statements:

SQL-Befehl:

CREATE FUNCTION opengoo16fresh.`my_getworkspace` (

sCHAR( 20 )
) RETURNS CHAR( 128 ) CHARSET latin1 RETURN (
SELECT pID
FROM my_workspaces
WHERE pID = s
);

MySQL meldet:

#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)



hmmm, whats wrong?

emjay

I had the same problem in feng_gantt_13.1.sql
Fixed this by adding  READS SQL DATA do every CREATE FUNCTION statement.

e.g.: (i use $$ delimiters)
DROP FUNCTION IF EXISTS my_getworkspace$$
CREATE FUNCTION `my_getworkspace`(s CHAR(20)) RETURNS char(128) CHARSET utf8 READS SQL DATA
RETURN (select pID from my_workspaces where pID=s)$$

[mangoman]

After successfully installing, I cannot generate a Gantt chart. In the frame source, I get this error - but don't know what it is or how to fix:

PROCEDURE database_xxxxx.get_my_workspaces does not exist

Suggestions welcome. 
John

[allenlook]

It would appear your script did not run completely, try running it again, and then ensure that the function in question does exist.  Also make sure you are referring to the correct database in your settings in the index.php file (near the GIMME_GANTT tag).