MAILBEE POP3 SMTP WEBMAIL IMAP4 POP IMAP EMAIL COMPONENT VB ASP ACTIVEX COM VBA OCX NET .NET C# VB.NET ASP.NET DOWNLOAD QUEUE SSL SECURITY CENSOR ACCESS PARSER C++ DLL CONTROL LIBRARY MIME INTERFACE

AfterLogic WebMail Pro

AfterLogic Forum : AfterLogic WebMail Pro

Topic: Unable to save event

Author

Message

<< Prev Topic | Next Topic >>

jpacheco
Newbie
Newbie

Joined: 17 May 2010
Location: Brazil
Online Status: Offline
Posts: 2

Posted: 17 May 2010 at 12:56pm \| IP Logged

I'm getting "Unable to save event" when I try to create a new event on calendar (Webmail Pro).

In debug log:

--<8---
[17/05/2010][15:47:57.136] INFORMATION:
 > [GET] /afterlogic-pro/calendar/processing.php?action=update_event& event_id=0&name=teste&text=teste&from=20100520&till=20100520 &time_from=08:30&time_till=13:00&allday=0&nocache=0.17708527 088373816&calendar_id=1&allow_repeat=0
 > ver.4.10.0 [SERVER-IP:200.187.64.90][USER-IP:200.201.188.66]
 > PHP-5.2.13, Apache/2.0
[15:47:57.142] :: connection time -> 0.0092570781707764
[15:47:57.153] MySQL Query: SELECT * FROM awm_domains WHERE url = 'webmail.temp.w3br.com'
505::[15:47:57.658] >>> calendar GET:
$_GET = array()
{
 "action" = "update_event"
 "event_id" = "0"
 "name" = "teste"
 "text" = "teste"
 "from" = "20100520"
 "till" = "20100520"
 "time_from" = "08:30"
 "time_till" = "13:00"
 "allday" = "0"
 "nocache" = "0.17708527088373816"
 "calendar_id" = "1"
 "allow_repeat" = "0"
}
[15:47:57.658] calendar MYSQL: SELECT * FROM acal_users_data WHERE user_id=1
[15:47:57.662] calendar MYSQL: SELECT * FROM awm_settings WHERE id_user=1
[15:47:57.664] calendar MYSQL: SELECT * FROM awm_accounts WHERE id_acct=1
[15:47:57.670] calendar MYSQL: SELECT calendar_id FROM acal_calendars WHERE calendar_id=1 AND user_id=1
[15:47:57.672] calendar MYSQL: SELECT event_appointment_access FROM acal_events WHERE event_id=0
[15:47:57.674] calendar MYSQL: SELECT id_appointment FROM acal_appointments WHERE id_event=0 AND id_user=1
[15:47:57.677] :: connection time -> 2.3126602172852E-5
[15:47:57.678] <<< calendar JSON:
 
Warning: require_once(/webmail.temp.w3br.com/www/afterlogic-pro/calen dar/../webmail/command_creators/webmail_command_creator.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in /webmail.temp.w3br.com/www/afterlogic-pro/core/base /base_manager.php on line 114 
 
Fatal error: require_once() [<a href='function.require'>function.require</a>]: Failed opening required '/webmail.temp.w3br.com/www/afterlogic-pro/calendar/../webma il/command_creators/webmail_command_creator.php' (include_path='.:~/') in /webmail.temp.w3br.com/www/afterlogic-pro/core/base /base_manager.php on line 114 
--<8---

What happening?

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6092

Posted: 18 May 2010 at 4:28am \| IP Logged

We recommend to recheck your installation and make sure that webmail/command_creators/webmail_command_creator.php file is in place. To avoid misunderstanding, webmail is a subfolder of main WebMail Pro directory.

--
Regards,
Igor, AfterLogic Support

nickux
Newbie
Newbie

Joined: 08 July 2010
Online Status: Offline
Posts: 16

Posted: 08 July 2010 at 5:04am \| IP Logged

I think this may be happening because in your ZIP file (I downloaded the PHP/Pro/4.10.0/5 user version) the main directory is called "webmail".

Perhaps you should rename the main directory and make it somethin like webmail-pro-4.10. This way you don't have ./webmail/webmail/ structure which may confuse during file & dir move.

In principal, I think it may be more useful to have the version # in the zip file itself also.

udgd66
Valued Community Member

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98

Posted: 06 December 2010 at 7:08am \| IP Logged

Hi at all.
I have same problem.
This is my log file:

Code:

[06/12/2010][16:07:56.896] INFORMATION: 

   > [POST(13)] /webmail-pro/calendar/processing.php 

   > ver.5.1.7 [SERVER-IP:192.168.2.196][USER-IP:192.168.2.5]

   > PHP-5.3.2-1ubuntu4.5, Apache/2.2.14 (Ubuntu)

[16:07:56.897] :: connection time -> 0.0019941329956055

[16:07:56.909] MySQL Query: SELECT * FROM awm_domains WHERE url = '192.168.2.196'

[16:07:57.5] >>> calendar REQUEST:

$_REQUEST = array() 

{

     "action" = "update_event"

     "event_id" = "0"

     "name" = "Event1"

     "text" = "Event1"

     "from" = "20101206"

     "till" = "20101206"

     "time_from" = "16:30"

     "time_till" = "17:00"

     "allday" = "0"

     "eventChanged" = "1"

     "nocache" = "0.8475503186810648"

     "calendar_id" = "1"

     "allow_repeat" = "0"

}

[16:07:57.6] calendar MYSQL: SELECT * FROM acal_users_data WHERE user_id=1

[16:07:57.7] calendar MYSQL: SELECT * FROM awm_settings WHERE id_user=1

[16:07:57.8] calendar MYSQL: SELECT * FROM awm_accounts WHERE id_acct=1

[16:07:57.9] calendar MYSQL: SELECT calendar_id FROM acal_calendars WHERE calendar_id=1 AND user_id=1

[16:07:57.10] calendar MYSQL: SELECT event_appointment_access FROM acal_events WHERE event_id=0

[16:07:57.11] calendar MYSQL: SELECT id_appointment FROM acal_appointments WHERE id_event=0 AND id_user=1

[16:07:57.16] :: connection time -> 3.2901763916016E-5

[16:07:57.19] <<< calendar JSON:

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6092

Posted: 06 December 2010 at 7:18am \| IP Logged

We're aware of multiple issues in calendar, and the fixed version of WebMail Pro is on it's way. Version 5.1.8 is planned for release within next few days.

--
Regards,
Igor, AfterLogic Support

udgd66
Valued Community Member

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98

Posted: 06 December 2010 at 7:22am \| IP Logged

Ooooooook.....i wait the new version!

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6092

Posted: 08 December 2010 at 6:29am \| IP Logged

New version of WebMail Pro has just been released, you can download it here. Upgrading instructions are available here.

--
Regards,
Igor, AfterLogic Support

udgd66
Valued Community Member

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98

Posted: 09 December 2010 at 5:15am \| IP Logged

Thanck you very much for the nwe version. I installed new version and when i make login a ihave this error : "Failed to connect (500 - Internal Server Error)". If i connect with the old version i don't have any problem.

I already updated the database from the adminpanel.

Where is the problem?

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6092

Posted: 09 December 2010 at 5:27am \| IP Logged

That sounds like a web server issue, is there anything relevant in PHP or Apache error logs?

--
Regards,
Igor, AfterLogic Support

udgd66
Valued Community Member

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98

Posted: 09 December 2010 at 5:33am \| IP Logged

i dont' think are server issue, because i saved the older dir version and if i login with this there are not problem:

http://myip/webnmail-old/webmail.php
Nothing problem. I access correctly

http://myip/webnmail/webmail.php
i have : Failed to connect (500 - Internal Server Error)

myip is same, database server is same php and apache are same

this is log:

Code:

[09/12/2010][14:32:32.220] INFORMATION: 

   > [GET] /webmail/webmail.php 

   > ver.5.1.8 [SERVER-IP:192.168.2.196][USER-IP:192.168.2.5]

   > PHP-5.3.2-1ubuntu4.5, Apache/2.2.14 (Ubuntu)

[14:32:32.238] :: connection time -> 0.0024847984313965

[14:32:32.251] MySQL Query: SELECT * FROM awm_domains WHERE url = '192.168.2.196'

[14:32:32.268] MySQL Query: SELECT id_acct, acct.id_user as id_user, def_acct, deleted, email, mail_protocol,

                                       mail_inc_host,  mail_inc_login, mail_inc_pass, mail_inc_port, mail_out_host,

                                       mail_out_login,  mail_out_pass, mail_out_port, mail_out_auth, friendly_nm,

                                       use_friendly_nm,  def_order,     getmail_at_login, mail_mode, mails_on_server_days,

                                       signature_type,  signature_opt, delimiter, personal_namespace,

                                       msgs_per_page,  white_listing, x_spam, DATE_FORMAT(last_login, "%Y-%m-%d %T") as last_login, logins_count, def_skin,

                                       def_lang,  def_charset_inc, def_charset_out, def_timezone, def_date_fmt,

                                       hide_folders,  mailbox_limit, mailbox_size, id_domain, mailing_list,

                                       allow_change_settings,  allow_dhtml_editor, allow_direct_mode, hide_contacts, db_charset,

                                       horiz_resizer,  vert_resizer, mark, reply, contacts_per_page, view_mode, imap_quota,

                                       question_1,  answer_1, question_2, answer_2, auto_checkmail_interval, enable_fnbl_sync,

                                       allow_contacts,  allow_compose, allow_reply, allow_forward

                                  FROM awm_accounts AS acct

                                  INNER JOIN awm_settings AS sett ON acct.id_user = sett.id_user

                                  WHERE id_acct = 1 AND mailing_list = 0

[14:32:32.274] MySQL Query: SELECT id_acct, signature FROM awm_accounts WHERE id_acct = 1

[14:32:32.280] MySQL Query: SELECT id_column, column_value FROM awm_columns WHERE id_user = 1

[09/12/2010][14:32:32.714] INFORMATION: 

   > [POST(1)] /webmail/processing.php 

   > ver.5.1.8 [SERVER-IP:192.168.2.196][USER-IP:192.168.2.5]

   > PHP-5.3.2-1ubuntu4.5, Apache/2.2.14 (Ubuntu)

[14:32:32.719] :: connection time -> 0.0019478797912598

[14:32:32.737] MySQL Query: SELECT * FROM awm_domains WHERE url = '192.168.2.196'

[14:32:32.748] <<<[client_xml]<<<

<?_xml version="1.0" encoding="utf-8"?><webmail><param name="action" value="get"/><param name="request" value="base"/><param name="flash_version" value="10"/></webmail>

[14:32:32.767] Do: CProcessingSwitch->DoGetBase

[14:32:32.772] MySQL Query: SELECT id_acct, acct.id_user as id_user, def_acct, deleted, email, mail_protocol,

                                       mail_inc_host,  mail_inc_login, mail_inc_pass, mail_inc_port, mail_out_host,

                                       mail_out_login,  mail_out_pass, mail_out_port, mail_out_auth, friendly_nm,

                                       use_friendly_nm,  def_order,     getmail_at_login, mail_mode, mails_on_server_days,

                                       signature_type,  signature_opt, delimiter, personal_namespace,

                                       msgs_per_page,  white_listing, x_spam, DATE_FORMAT(last_login, "%Y-%m-%d %T") as last_login, logins_count, def_skin,

                                       def_lang,  def_charset_inc, def_charset_out, def_timezone, def_date_fmt,

                                       hide_folders,  mailbox_limit, mailbox_size, id_domain, mailing_list,

                                       allow_change_settings,  allow_dhtml_editor, allow_direct_mode, hide_contacts, db_charset,

                                       horiz_resizer,  vert_resizer, mark, reply, contacts_per_page, view_mode, imap_quota,

                                       question_1,  answer_1, question_2, answer_2, auto_checkmail_interval, enable_fnbl_sync,

                                       allow_contacts,  allow_compose, allow_reply, allow_forward

                                  FROM awm_accounts AS acct

                                  INNER JOIN awm_settings AS sett ON acct.id_user = sett.id_user

                                  WHERE id_acct = 1 AND mailing_list = 0

[14:32:32.778] MySQL Query: SELECT id_acct, signature FROM awm_accounts WHERE id_acct = 1

[14:32:32.784] MySQL Query: SELECT id_column, column_value FROM awm_columns WHERE id_user = 1

[14:32:32.798] MySQL Query: SELECT SUM(mailbox_size) AS mailboxes_size

                            FROM  awm_accounts WHERE id_user = 1 AND mailing_list = 0

[14:32:32.805] MySQL Query: SELECT id_acct, mail_protocol, def_order, use_friendly_nm,

                                       friendly_nm,  email, getmail_at_login, def_acct, mailbox_size, mailing_list

                            FROM  awm_accounts

                            WHERE  id_user = 1

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6092

Posted: 09 December 2010 at 5:57am \| IP Logged

I wasn't speaking of WebMail logs, you'll need to check web server logs as error 500 is a typical error code for web server configuration error. This kind of errors may be triggered by PHP scripts but it's hard if not impossible to find the reason without accessing server logs.

--
Regards,
Igor, AfterLogic Support

udgd66
Valued Community Member

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98

Posted: 09 December 2010 at 6:01am \| IP Logged

This is apache2 error.log:

[Thu Dec 09 15:00:57 2010] [error] [client 192.168.2.5] PHP Catchable fatal error: Object of class stdClass could not be converted to string in
/var/www/webmail/common/class_dbstorage.php on line 319, referer: http://192.168.2.196/webmail/webmail.php

udgd66
Valued Community Member

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98

Posted: 09 December 2010 at 6:26am \| IP Logged

I modified class_dbstorage.php at line 319, in this way and now work

Code:

while (($row = $this->_dbConnection->GetNextRecord()) != false)

{

    //if (!$row->$row->friendly_nm)

    //{

        $outArray[$row->id_acct] = array($row->mail_protocol, $row->def_order,

              $row->use_friendly_nm,  $row->friendly_nm, $row->email, (bool)

              abs($row->getmail_at_login),  (bool) abs($row->def_acct), 

              $row->mailbox_size);
 
    //}

}

udgd66
Valued Community Member

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98

Posted: 09 December 2010 at 6:30am \| IP Logged

Mmmmm....don't work so good. ...now i can view the mails but don't work Contacts and Calendar. Don't work any functions of top menu, only "logout" work.

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6092

Posted: 09 December 2010 at 6:32am \| IP Logged

Thanks for the log extract, we've added a fix, please download an updated version (5.1.9), the link is the same.

--
Regards,
Igor, AfterLogic Support

udgd66
Valued Community Member

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98

Posted: 09 December 2010 at 6:53am \| IP Logged

Ok....with the 5.1.9 i don't have any error but after login, the page is don't loaded:
"Webmail is loading..." with the progress bar full.

There are nothing error into the webmail.log and into the apache2 log.

The old version (5.1.7) is always ok!!

MichaelL
Newbie
Newbie

Joined: 09 December 2010
Location: France
Online Status: Offline
Posts: 11

Posted: 09 December 2010 at 10:06am \| IP Logged

Bonjour,

Same problem here : a previous version downloaded last week worked but the last one 5.1.9 shows a hanging "WebMail is loading…".
Nothing into the Debug logs but "[18:58:45.879] >>>[server_xml]>>> ...... </uid></message></messages></webmail> ;".

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6092

Posted: 09 December 2010 at 11:16pm \| IP Logged

It could occur due to some JavaScript code remaining in web browser cache, try purging the cache and see if that helps.

--
Regards,
Igor, AfterLogic Support

udgd66
Valued Community Member

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98

Posted: 09 December 2010 at 11:51pm \| IP Logged

Hi igor, nothing to do, i'm using firefox, i tryed to purge the cache (all data) but the problem remain.

Other suggestion?

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6092

Posted: 10 December 2010 at 12:20am \| IP Logged

There's a nice and useful addon for Firefox, it's called Firebug. It allows detecting various issues with client-side code. Install the addon and see if there's any error output in its console. In the meantime, I will install 5.1.9 myself from scratch and see if any issue occurs.

--
Regards,
Igor, AfterLogic Support

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6092

Posted: 10 December 2010 at 12:31am \| IP Logged

Have just installed the latest release, created an account and logged into it just fine.

--
Regards,
Igor, AfterLogic Support

udgd66
Valued Community Member

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98

Posted: 10 December 2010 at 1:01am \| IP Logged

Ok...i discovered were is the problem!!!!!!!
The problem is not on the JavaScript but on the database, because if i
login with a new user all is OK, and i view the mails.
The problem there is if i access with a user created on the 5.1.7 version.

And now??? I have hundreds mail in my accout i cannot delete and create new user

udgd66
Valued Community Member

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98

Posted: 10 December 2010 at 1:03am \| IP Logged

Oppps! 3 messages....

sorry!

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6092

Posted: 10 December 2010 at 1:14am \| IP Logged

Did you run "Update" in Database Settings screen of AdminPanel? That's critical part of version upgrade procedure.

Quote:

Oppps! 3 messages.... sorry!

No worries, only one is left now

--
Regards,
Igor, AfterLogic Support

udgd66
Valued Community Member

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98

Posted: 10 December 2010 at 1:45am \| IP Logged

Igor wrote:

Did you run "Update" in Database Settings screen of AdminPanel? That's critical part of version upgrade procedure.

Yes. I have already run "update" from the adminpanel. It has been the first made operation! But the problem remain!

Page of 2 Next >>

Printable version

Forum Jump

.NET Components

ActiveX Components

Web scripts

Solutions

AfterLogic WebMail Pro