Author Topic: How to Add Gantt Charts (JSGantt) to Feng Office  (Read 254695 times)

emjay

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #210 on: May 25, 2010, 08:48:05 am »
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

  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #211 on: May 27, 2010, 04:25:04 am »
Hello Allen,

Thanks for your GREAT WORK!! :D 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

  • Volunteer Moderator
  • Sr. Member
  • ****
  • Posts: 312
    • MSN Messenger - sii_lookal@hotmail.com
    • View Profile
    • SI Group, Inc.
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #212 on: May 27, 2010, 08:58:19 am »
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?
I am a volunteer moderator.  Any statements, opinions or observations I contribute are solely mine and are not necessarily shared by the makers of Feng Office.

gah242s

  • Newbie
  • *
  • Posts: 9
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #213 on: May 28, 2010, 02:48:53 pm »
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

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #214 on: May 31, 2010, 10:34:28 am »
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

  • Volunteer Moderator
  • Sr. Member
  • ****
  • Posts: 312
    • MSN Messenger - sii_lookal@hotmail.com
    • View Profile
    • SI Group, Inc.
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #215 on: June 01, 2010, 09:34:11 am »
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
I am a volunteer moderator.  Any statements, opinions or observations I contribute are solely mine and are not necessarily shared by the makers of Feng Office.

Gertjan Tillema

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #216 on: June 02, 2010, 09:12:44 am »
I'm running MySQL 5.1.36.

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

Gertjan Tillema

  • Newbie
  • *
  • Posts: 4
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #217 on: June 02, 2010, 10:09:55 am »
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.
« Last Edit: June 02, 2010, 10:55:16 am by Gertjan Tillema »

allenlook

  • Volunteer Moderator
  • Sr. Member
  • ****
  • Posts: 312
    • MSN Messenger - sii_lookal@hotmail.com
    • View Profile
    • SI Group, Inc.
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #218 on: June 02, 2010, 01:34:20 pm »
My SQL guru Kevin is taking a look into it.  We're not really MySQL or collation experts however  :-[
I am a volunteer moderator.  Any statements, opinions or observations I contribute are solely mine and are not necessarily shared by the makers of Feng Office.

allenlook

  • Volunteer Moderator
  • Sr. Member
  • ****
  • Posts: 312
    • MSN Messenger - sii_lookal@hotmail.com
    • View Profile
    • SI Group, Inc.
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #219 on: June 02, 2010, 02:17:47 pm »
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….
I am a volunteer moderator.  Any statements, opinions or observations I contribute are solely mine and are not necessarily shared by the makers of Feng Office.

rayanami

  • Newbie
  • *
  • Posts: 3
    • View Profile
    • Email
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #220 on: June 04, 2010, 04:17:01 am »
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

  • Volunteer Moderator
  • Sr. Member
  • ****
  • Posts: 312
    • MSN Messenger - sii_lookal@hotmail.com
    • View Profile
    • SI Group, Inc.
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #221 on: June 04, 2010, 08:50:40 am »
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).
I am a volunteer moderator.  Any statements, opinions or observations I contribute are solely mine and are not necessarily shared by the makers of Feng Office.

akiuser

  • Newbie
  • *
  • Posts: 2
    • View Profile
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #222 on: June 18, 2010, 05:12:14 am »
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

  • Newbie
  • *
  • Posts: 13
    • View Profile
    • Email
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #223 on: June 23, 2010, 09:32:08 pm »
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

  • Volunteer Moderator
  • Sr. Member
  • ****
  • Posts: 312
    • MSN Messenger - sii_lookal@hotmail.com
    • View Profile
    • SI Group, Inc.
Re: How to Add Gantt Charts (JSGantt) to Feng Office
« Reply #224 on: June 28, 2010, 10:18:42 am »
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).
I am a volunteer moderator.  Any statements, opinions or observations I contribute are solely mine and are not necessarily shared by the makers of Feng Office.