Feng Forum

Support => Feng Office 2 => : ehu March 12, 2014, 04:10:42 AM

: Need some help, can't get email working
: ehu March 12, 2014, 04:10:42 AM

Hello,

I am new with FengOffice.
I download the community version 2.5 and installed it. Everything looks to work fine. The only I can send emails.

The problem is that I can't add a email account. When I push the "ADD ACOUNT" button, I get the message:

query failed with message 'Unknown column created_by_id in where clause

When I look it up in the logfile it says:

Session "default" started at 2014-03-10T15:24:05+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 'created_by_id' in 'where clause'' - UPDATE fo_mail_contents SET account_id=2 WHERE `created_by_id` = 2 AND `account_email` = 'xxxxxxx' AND `account_id` NOT IN (SELECT `id` FROM `fo_mail_accounts`)

Looks like a database thing. Can somebody help me?

Thanks

: Re: Need some help, can't get email working
: avsadmin March 17, 2014, 10:12:26 AM

I have the same issue ... waiting for a reply to your situation...

: Re: Need some help, can't get email working
: franponce87 March 17, 2014, 11:44:40 AM

Hello! Welcome to the Feng Forums!

I would suggest going for the 2.5.1.2 and try installing the email module again as it seems like the 2.5.1.1 version had an issue when creating the MySQL structure.
Otherwise you could look for the missing column in the source code, get the SQL statement that creates it, and run it in your Feng Office installation.

Hope you find this information useful.

Best regards,
Francisco