Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - emjay

Pages: [1]
1
Indeed, we recognized that right yesterday!

2
Feng Office 2 / Re: serious bug in 2.0.0.8 when moving workspace
« on: March 31, 2012, 04:19:31 pm »
I noticed the same problem in 2.0.0.8.

Since I installed directly to 2.0.0.8, I would like to know if the problem also occurs in 2.0.0.7? Where can I download 2.0.0.7?

This bug makes 2.0.0.8 absolute unusable - sorry.

emjay

3
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 ;)

4
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

5
Applications / Re: New application: equipment tab
« on: May 06, 2010, 05:44:26 am »
Hi,

this application would be a excellent addon for our needs too.
What is the state of your work?

emjay

Pages: [1]