Author Topic: new installed 2.5.1.1 Cant add email account  (Read 5227 times)

ehu

  • Newbie
  • *
  • Posts: 7
    • View Profile
    • Email
new installed 2.5.1.1 Cant add email account
« on: March 10, 2014, 05:39:20 pm »
Hello,
I am new with Feng Office. I installed with Installatron a fresh version of FengOffice 2.5.1.1 Everything looks to work, only I don't get the email work.

I can send emails, Like when I upload a document, I receive a email. But I can't add a email account.
I always get de message:

query failed with message 'Unknown column created_by_id in where clause

When I look in de log file, I get this:

<?php die(); ?>
Session "default" started at 2014-03-10T15:21:19+0000
#1 DEBUG: SQL ERROR: Query failed with message 'Unknown column 'created_by_id' in 'where clause'' - UPDATE fo_mail_contents SET account_id=1 WHERE `created_by_id` = 3 AND `account_email` = '1xxxxxx' AND `account_id` NOT IN (SELECT `id` FROM `fo_mail_accounts`)
Time since start: 0.291624069214 seconds
-------------------------------------------------------------------------------

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`)
Time since start: 0.24755692482 seconds
-------------------------------------------------------------------------------

So, I need some help

Thanks.

tverdouw

  • Freshman
  • *
  • Posts: 10
    • View Profile
Re: new installed 2.5.1.1 Cant add email account
« Reply #1 on: March 12, 2014, 07:50:31 am »
I bumb into the exact same problem with the same error message when trying to add a gmail account.
Does anyone know how to fix this?

sim

  • Freshman
  • *
  • Posts: 13
    • View Profile
Re: new installed 2.5.1.1 Cant add email account
« Reply #2 on: March 12, 2014, 08:03:44 pm »
Have the same issue.
Added Item to Feng Office Mantis Bugtracker ID 4114
Check: fengoffice.com  web bugs id 4114

ehu

  • Newbie
  • *
  • Posts: 7
    • View Profile
    • Email
Re: new installed 2.5.1.1 Cant add email account
« Reply #3 on: March 13, 2014, 11:55:36 am »
Hey Sim,

Thanks for the input.

Do you have a link? I can't find the "bugs id 4114"


ehu

  • Newbie
  • *
  • Posts: 7
    • View Profile
    • Email
Re: new installed 2.5.1.1 Cant add email account
« Reply #4 on: March 13, 2014, 12:26:53 pm »
Helo,

I found a work arround.

First I add a user in Feng Office

Then I went to the database and add a line in table fo_mail_accounts

The I opend FENGOFFIC => administrator => email. There was the added line. I filled it in correctly.

Now I can read and send email.





tverdouw

  • Freshman
  • *
  • Posts: 10
    • View Profile
Re: new installed 2.5.1.1 Cant add email account
« Reply #5 on: March 13, 2014, 05:47:33 pm »
Hi Ehu,

Sounds great!
Can you specify what line you have added to the database? (maybe send a screenshot?)

Thanks!

ehu

  • Newbie
  • *
  • Posts: 7
    • View Profile
    • Email
Re: new installed 2.5.1.1 Cant add email account
« Reply #6 on: March 14, 2014, 05:24:43 pm »
Hi,

I did it like this:
1: Make a user in feng office (or use the admin one). In this example USERNAME
2: Go to the database select table fo2_email_account and select insert (see attachment 1)
3: Fill the user in the row NAME. In this case USERNAME (see attachment 2)
4: You will get a result like this (attachment 3)
5: Go back to Feng Office
6: Go to administration and select email (not add email). There is the user. Select change account and fill it with the right settings.

« Last Edit: March 14, 2014, 05:28:18 pm by ehu »

ehu

  • Newbie
  • *
  • Posts: 7
    • View Profile
    • Email
Re: new installed 2.5.1.1 Cant add email account
« Reply #7 on: March 14, 2014, 05:28:51 pm »
Hi,
 here attachment 4

tverdouw

  • Freshman
  • *
  • Posts: 10
    • View Profile
Re: new installed 2.5.1.1 Cant add email account
« Reply #8 on: March 15, 2014, 03:53:33 pm »
Thank you so much Ehu!
Much appreciated!

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: new installed 2.5.1.1 Cant add email account
« Reply #9 on: March 17, 2014, 12:08:26 pm »
Hi there!

Thank you for reporting the issue. It has been fixed for the 2.5.1.2 version, released last Friday.

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

ehu

  • Newbie
  • *
  • Posts: 7
    • View Profile
    • Email
Re: new installed 2.5.1.1 Cant add email account
« Reply #10 on: March 19, 2014, 03:48:52 am »
Hi Franponce87,

How can I update/upgrade from 2.5.1.1 to 2.5.1.2?
I Installed Feng Office with Installatron. When I check there for a update, it tells me that 2.5.1.1 is the latest version.

Thanks.

Ehu

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: new installed 2.5.1.1 Cant add email account
« Reply #11 on: May 09, 2014, 11:16:08 am »
Hello Ehu,

Well, truth be told I do not know what is Installatron nor how it works or which kind of access it provides you with.
Dedicated servers are better, so if you have the opportunity to upgrade to 2.5.1.4 (or even 2.6 - RC) I would go for that option. You can always consider using our Cloud services as well (or OnPremise), which would not only provide you not to experience hassles with server settings and such, but you would also get to access many cool and new features not available for the Community Edition. Plus, you would help us keeping the Feng Office project alive :)

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