Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Pro
 AfterLogic Forum : AfterLogic WebMail Pro
Subject Topic: Unable to save event Post ReplyPost New Topic
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 Quote jpacheco
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:
<br />
<b>Warning</b>: 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 <b>/webmail.temp.w3br.com/www/afterlogic-pro/core/base /base_manager.php</b> on line <b>114</b><br />
<br />
<b>Fatal error</b>: 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 <b>/webmail.temp.w3br.com/www/afterlogic-pro/core/base /base_manager.php</b> on line <b>114</b><br />
--<8---

What happening?

Back to Top View jpacheco's Profile Search for other posts by jpacheco
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 18 May 2010 at 4:28am | IP Logged Quote Igor
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
Back to Top View Igor's Profile Search for other posts by Igor
 
nickux
Newbie
Newbie


Joined: 08 July 2010
Online Status: Offline
Posts: 16
Posted: 08 July 2010 at 5:04am | IP Logged Quote nickux
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.
Back to Top View nickux's Profile Search for other posts by nickux
 
udgd66
Valued Community Member
Valued Community Member
Avatar

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98
Posted: 06 December 2010 at 7:08am | IP Logged Quote udgd66
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:


Back to Top View udgd66's Profile Search for other posts by udgd66
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 06 December 2010 at 7:18am | IP Logged Quote Igor
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
Back to Top View Igor's Profile Search for other posts by Igor
 
udgd66
Valued Community Member
Valued Community Member
Avatar

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98
Posted: 06 December 2010 at 7:22am | IP Logged Quote udgd66
Ooooooook.....i wait the new version!
Back to Top View udgd66's Profile Search for other posts by udgd66
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 08 December 2010 at 6:29am | IP Logged Quote Igor
New version of WebMail Pro has just been released, you can download it here. Upgrading instructions are available here.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
udgd66
Valued Community Member
Valued Community Member
Avatar

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98
Posted: 09 December 2010 at 5:15am | IP Logged Quote udgd66
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?
Back to Top View udgd66's Profile Search for other posts by udgd66
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 09 December 2010 at 5:27am | IP Logged Quote Igor
That sounds like a web server issue, is there anything relevant in PHP or Apache error logs?

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
udgd66
Valued Community Member
Valued Community Member
Avatar

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98
Posted: 09 December 2010 at 5:33am | IP Logged Quote udgd66
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



Back to Top View udgd66's Profile Search for other posts by udgd66
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 09 December 2010 at 5:57am | IP Logged Quote Igor
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
Back to Top View Igor's Profile Search for other posts by Igor
 
udgd66
Valued Community Member
Valued Community Member
Avatar

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98
Posted: 09 December 2010 at 6:01am | IP Logged Quote udgd66
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

Back to Top View udgd66's Profile Search for other posts by udgd66
 
udgd66
Valued Community Member
Valued Community Member
Avatar

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98
Posted: 09 December 2010 at 6:26am | IP Logged Quote udgd66
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);
    //}
}
Back to Top View udgd66's Profile Search for other posts by udgd66
 
udgd66
Valued Community Member
Valued Community Member
Avatar

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98
Posted: 09 December 2010 at 6:30am | IP Logged Quote udgd66
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.
Back to Top View udgd66's Profile Search for other posts by udgd66
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 09 December 2010 at 6:32am | IP Logged Quote Igor
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
Back to Top View Igor's Profile Search for other posts by Igor
 
udgd66
Valued Community Member
Valued Community Member
Avatar

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98
Posted: 09 December 2010 at 6:53am | IP Logged Quote udgd66
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!!
Back to Top View udgd66's Profile Search for other posts by udgd66
 
MichaelL
Newbie
Newbie


Joined: 09 December 2010
Location: France
Online Status: Offline
Posts: 11
Posted: 09 December 2010 at 10:06am | IP Logged Quote MichaelL
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> ;".
Back to Top View MichaelL's Profile Search for other posts by MichaelL
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 09 December 2010 at 11:16pm | IP Logged Quote Igor
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
Back to Top View Igor's Profile Search for other posts by Igor
 
udgd66
Valued Community Member
Valued Community Member
Avatar

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98
Posted: 09 December 2010 at 11:51pm | IP Logged Quote udgd66
Hi igor, nothing to do, i'm using firefox, i tryed to purge the cache (all data) but the problem remain.


Other suggestion?
Back to Top View udgd66's Profile Search for other posts by udgd66
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 10 December 2010 at 12:20am | IP Logged Quote Igor
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
Back to Top View Igor's Profile Search for other posts by Igor
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 10 December 2010 at 12:31am | IP Logged Quote Igor
Have just installed the latest release, created an account and logged into it just fine.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
udgd66
Valued Community Member
Valued Community Member
Avatar

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98
Posted: 10 December 2010 at 1:01am | IP Logged Quote udgd66
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

Back to Top View udgd66's Profile Search for other posts by udgd66
 
udgd66
Valued Community Member
Valued Community Member
Avatar

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98
Posted: 10 December 2010 at 1:03am | IP Logged Quote udgd66
Oppps! 3 messages.... sorry!
Back to Top View udgd66's Profile Search for other posts by udgd66
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 10 December 2010 at 1:14am | IP Logged Quote Igor
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
Back to Top View Igor's Profile Search for other posts by Igor
 
udgd66
Valued Community Member
Valued Community Member
Avatar

Joined: 06 December 2010
Location: Italy
Online Status: Offline
Posts: 98
Posted: 10 December 2010 at 1:45am | IP Logged Quote udgd66
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!

Back to Top View udgd66's Profile Search for other posts by udgd66
 

Page of 2 Next >>
  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide