Show Posts
1
Feng Office 3 / Can't create Workspace
« on: April 22, 2015, 10:25:35 am »
Hi to all,
The Mojo script return me to my hosting and my hosting return me to Feng Office support. Hope someone could help.
I just install Feng Office 3.1.3 and in the tutorial, when must create a workspace, i have an error (error 1146) saying "Query failed with message 'Table 'xxxxxxx_fe4296.fo_sharing_table' doesn't exist'". It's point the file AbstractDBAdapter.class.php at line 392.
I look throught the SQL command and I think it don't take in consideration the prefixe selected from the sql table (prefixe is gyr_)
If it could help, the SQL line is:
SELECT * FROM gyr_objects o INNER JOIN gyr_project_files e ON e.object_id = o.id WHERE IF(e.mail_id > 0, e.mail_id IN ( SELECT sh.object_id FROM fo_sharing_table sh WHERE e.mail_id = sh.object_id AND sh.group_id IN (14) ), true ) AND (EXISTS (SELECT om.object_id FROM gyr_object_members om WHERE om.member_id IN (2) AND o.id = om.object_id GROUP BY object_id HAVING count(member_id) = 1 )) AND o.object_type_id = 6 AND `o`.`trashed_on` = '0000-00-00 00:00:00' AND `o`.`archived_on` = '0000-00-00 00:00:00' AND updated_by_id > 0 ORDER BY updated_on desc LIMIT 0 , 5
I was with Feng Office 2.7 before and was working perfectly but I upgrade to Feng Office 3 and all my problems begin.
Thanks
The Mojo script return me to my hosting and my hosting return me to Feng Office support. Hope someone could help.
I just install Feng Office 3.1.3 and in the tutorial, when must create a workspace, i have an error (error 1146) saying "Query failed with message 'Table 'xxxxxxx_fe4296.fo_sharing_table' doesn't exist'". It's point the file AbstractDBAdapter.class.php at line 392.
I look throught the SQL command and I think it don't take in consideration the prefixe selected from the sql table (prefixe is gyr_)
If it could help, the SQL line is:
SELECT * FROM gyr_objects o INNER JOIN gyr_project_files e ON e.object_id = o.id WHERE IF(e.mail_id > 0, e.mail_id IN ( SELECT sh.object_id FROM fo_sharing_table sh WHERE e.mail_id = sh.object_id AND sh.group_id IN (14) ), true ) AND (EXISTS (SELECT om.object_id FROM gyr_object_members om WHERE om.member_id IN (2) AND o.id = om.object_id GROUP BY object_id HAVING count(member_id) = 1 )) AND o.object_type_id = 6 AND `o`.`trashed_on` = '0000-00-00 00:00:00' AND `o`.`archived_on` = '0000-00-00 00:00:00' AND updated_by_id > 0 ORDER BY updated_on desc LIMIT 0 , 5
I was with Feng Office 2.7 before and was working perfectly but I upgrade to Feng Office 3 and all my problems begin.
Thanks