Author Topic: Need some help, can't get email working  (Read 2677 times)

ehu

  • Newbie
  • *
  • Posts: 7
    • View Profile
    • Email
Need some help, can't get email working
« on: 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:

Quote
query failed with message 'Unknown column created_by_id in where clause

When I look it up in the logfile it says:
Quote
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

avsadmin

  • Newbie
  • *
  • Posts: 1
    • View Profile
    • Email
Re: Need some help, can't get email working
« Reply #1 on: March 17, 2014, 10:12:26 am »
I have the same issue ... waiting for a reply to your situation...

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: Need some help, can't get email working
« Reply #2 on: 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

Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem! Read this article!