Messages

1

Feng Office 2 / Re: FIX - Can't change user permissions

« on: September 30, 2014, 09:48:46 am »

Hi all,

I'm the friend of tverdouw

this is a real problem (bug) that occur only with fengoffice running under UNIX machine.

the bug is located in the /application/helpers/permissions.php file and affects two functions save_member_permissions_background and save_user_permissions_background

the problem is the call of the exec function without any check. infact if the function is disabled, does not exists or simply we don't have privileges to use it, the error occur.

a possible solution can be to add something like the code below at the top of the permissions.php file

https://gist.github.com/aSeptik/9643471

hope this help

Luca Filosofi

The problem still exists with version 2.7.1.1

With the suggested code at the top of the permissions file the module permissions are now saved.

it still has problems with workspace permissions though when editing permissions from a user. When I change the permission from one option of a workspace (expl. Read only to Read & Write for Time) it resets all other to Read Only. The only way I can make sure that all permissions are set correctly is to set all Workspace Options to Read Only, save, then modify the user's permissions again to set the correct/new workspace permissions. Alternatively, I can also set the correct permissions by setting them for each user inside the settings of a workspace instead of inside the permissions of a user.

2

Feng Office 2 / Re: Email Issue

« on: February 05, 2012, 08:25:19 am »

See the cache/log.php and:

SELECT `uid` FROM `fo_mail_contents` WHERE `account_id` = 3 AND `imap_folder_name` = 'INBOX' AND id = (SELECT max(id) FROM `fo_mail_contents` WHERE `account_id` = 3 AND `state` < 2)

#1054 - Unknown column 'id' in 'where clause'

Change 'id' field by 'uid' (2 coincidences)

SELECT `uid` FROM `fo_mail_contents` WHERE `account_id` = 3 AND `imap_folder_name` = 'INBOX' AND uid = (SELECT max(uid) FROM `fo_mail_contents` WHERE `account_id` = 3 AND `state` < 2)

Showing rows 0 - 0 ( 1 total, Query took 0.0012 sec)

I am not sure that it's the final solution but the id does not exist in 2.0 rc3.

I am trying to find where is generate the query.

PD: sorry but my english is not very good looking

Nice find!
I changed the query as you suggested, and now IMAP emails are being received and stored in the database, but unfortunately still no email are showing up...

This was in my log

Code: [Select]

Session "default" started at 2012-02-05T09:48:02+0000
#1 FATAL: exception 'DBQueryError' with message 'Query failed with message 'Unknown column 'mc.id' in 'IN/ALL/ANY subquery''' in /home/public_html/office/environment/library/database/adapters/AbstractDBAdapter.class.php:386
    Stack trace:
    #0 /home/public_html/office/environment/library/database/adapters/AbstractDBAdapter.class.php(272): AbstractDBAdapter->prepareAndExecute('???    ?SELECT ...', NULL)
    #1 /home/public_html/office/environment/library/database/DB.class.php(145): AbstractDBAdapter->execute('???    ?SELECT ...', NULL)
    #2 /home/public_html/office/plugins/mail/application/models/mail_contents/MailContents.class.php(348): DB::execute('???    ?SELECT ...')
    #3 /home/public_html/office/plugins/mail/application/models/mail_contents/MailContents.class.php(279): MailContents::findByContext(Array)
    #4 /home/public_html/office/plugins/mail/application/controllers/MailController.class.php(2426): MailContents->getEmails('', 'received', 'unread', 'all', Array, '0', 50, '`received_date`', 'DESC')
    #5 /home/public_html/office/plugins/mail/application/controllers/MailController.class.php(2390): MailController->getEmails(Array, Array, '0', 50, '`received_date`', 'DESC')
    #6 /home/public_html/office/environment/classes/controller/Controller.class.php(76): MailController->list_all()
    #7 /home/public_html/office/environment/classes/controller/PageController.class.php(62): Controller->execute('list_all')
    #8 /home/public_html/office/environment/classes/Env.class.php(133): PageController->execute('list_all')
    #9 /home/public_html/office/init.php(164): Env::executeAction('mail', 'list_all')
    #10 /home/public_html/office/index.php(9): require('/home/pu...')
    #11 {main}
Time since start: 0.12056303024292 seconds
Searched all the files and db and there is no instance of mc.id .

mc.id mean the field "id" in a table that was shortened to mc

Example: SELECT * FROM mail_contents mc, other_table ot WHERE mc.id = ot.id

When does this error show happen, and what version are you using?

3

Feng Office 2 / Re: Email not showing

« on: December 14, 2011, 08:15:22 am »

Hi,

I have reported the same error in this thread about Beta 2: index.php?topic=14417.msg30558#msg30558

Francisco said it would be fixed in the "next release", I guess he didn't mean BETA 3  

I think it has to do with viewing permissions. I have looked a bit into it, and the emails are being saved in the database, they are just not shown in Feng Office.

Let's hope it works in the next Beta Version...

4

Feng Office 2 / Re: Email Issue

« on: December 09, 2011, 01:25:45 am »

Hello,

I am using the BETA 3.

The problem still exists.

I made a fresh install and setup an email account with IMAP, the edited it to add the folders (sent,drafts).

When clicking on Check Mails, I get the error message:

Code: [Select]

...Query failed with message "Unknown column id in where clause"...
Also, when editing the Email Account, the last option: "Account permissions" is empty.

When I switch to POP it tells me that it downloaded x-many emails, but the INBOX is empty, not a single email is showing.

I tried switching views between "Workspaces" and "People", but in every possible view, the inbox remains empty.

When I use the Filter for "Read/Unread", I get an error message:

Code: [Select]

We are sorry, but Feng Office is not currently able to execute your request. An Error Report has been sent to the administrator.I have to switch it to "View All" so it shows "By State:", then it page loads, but still no emails. Also, no email was sent to the Administrator.


Definitely still a bug here...