Messages

31

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: September 25, 2010, 07:15:08 pm »

That's not PHP, its SQL. Is there an error msg?   On flight to Zurich and have to hang up soon. Run it again if necessary. 

32

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: September 25, 2010, 06:37:25 pm »

I believe so.  Good luck!

33

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: September 25, 2010, 05:05:32 pm »

Have you typed your database name in at the beginning of the script?

34

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: September 23, 2010, 01:21:31 pm »

No worries.  Good luck!

35

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: September 23, 2010, 01:15:49 pm »

Gain,

Sorry to refer you back into the (quite lengthy) thread, but I believe there are several causes of this error and the fixes are outlined within.

Allen

36

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: September 09, 2010, 03:16:22 am »

Sorry, I am not a MySQL expert, but I would read the MySQL documentation and Google the error message to find the solution to this particular problem.  Our code does not work for every iteration of MySQL implementation, but most problems like this are easily surpassed with a Google search.

37

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: August 31, 2010, 11:28:30 am »

Ah, thank you!

38

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: August 31, 2010, 11:06:46 am »

Murz,

I'm not quite certain what you are asking?  Can you help me understand?

39

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: August 16, 2010, 09:54:44 am »

Are you now seeing all of your workspaces?

Can you give me an example of contexts not appearing, or mistakenly appearing at the root level?

40

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« on: June 29, 2010, 09:50:03 am »

You were getting an error referencing a missing procedure, so my previous suggestion was to ensure the procedure (I called it a function) actually existed...

Code: [Select]

PROCEDURE database_xxxxx.get_my_workspaces does not exist
Secondly, you probably cannot drop a VIEW by issuing the DROP TABLE command, you will most likely have to use the DROP VIEW command (referencing my_milestones, my_milestonestoworkspaces and similar views).

41

Community Contributions / Re: How to display direct link to task (resolved)

« on: June 28, 2010, 10:28:40 am »

This would be exceptionally useful for the Gantt chart view - each task can have a URL associated with it, and it would be great to be able to click on a task and jump to it!

42

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« 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).

43

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« 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).

44

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« 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….

45

Community Contributions / Re: How to Add Gantt Charts (JSGantt) to Feng Office

« 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