Roundcube Community Forum

 

Error error error =( help.

Started by (:Pro:), October 13, 2009, 07:40:13 AM

Previous topic - Next topic

(:Pro:)

MySQL: 5.1.11
PHP: 5.2.11
roundcube: 0.3-stable
WebServ: IIS 6.0

Quote[13-Oct-2009 15:09:53 +0400]: DB Error: MDB2 Error: unknown error Query: _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO contacts (user_id, changed, del, `name`, `email`) VALUES (2, now(), 0, '╨Р╨┤╨╝╨╕╨╜', 'pro@vek.local')] [Native code: 1364] [Native message: Field 'firstname' doesn't have a default value]  in C:\Inetpub\email\program\include\rcube_mdb2.php on line 627 (POST /index.php?_task=mail&_action=addcontact?_task=&_action=)
[13-Oct-2009 15:10:12 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (POST /index.php?_task=&_action=login)
[13-Oct-2009 15:10:13 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail)
[13-Oct-2009 15:10:13 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=getunread&_remote=1&_=1255432213453&_unlock=0)
[13-Oct-2009 15:10:19 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=settings&_action=folders)
[13-Oct-2009 15:10:30 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_mbox=INBOX)
[13-Oct-2009 15:10:30 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=getunread&_remote=1&_=1255432230687&_unlock=0)
[13-Oct-2009 15:10:31 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=compose&_mbox=INBOX)
[13-Oct-2009 15:10:32 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_id=47734ad46027eb5fe&_action=compose)
[13-Oct-2009 15:10:43 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (POST /index.php?_task=mail&_action=send)
[13-Oct-2009 15:10:43 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_mbox=INBOX&_page=1)
[13-Oct-2009 15:10:43 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=getunread&_remote=1&_=1255432243578&_unlock=0)
[13-Oct-2009 15:10:50 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (POST /index.php?_task=&_action=login)
[13-Oct-2009 15:10:50 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail)
[13-Oct-2009 15:10:51 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=getunread&_remote=1&_=1255432251078&_unlock=0)
[13-Oct-2009 15:10:53 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=check-recent&_t=1255432253031&_list=1&_quota=1&_remote=1&_=1255432253031&_unlock=1)
[13-Oct-2009 15:10:54 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=list&_mbox=%26BCcENQRABD0EPgQyBDgEOgQ4-&_page=1&_refresh=1&_remote=1&_=1255432254546&_unlock=1)
[13-Oct-2009 15:10:55 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=list&_mbox=INBOX&_page=1&_refresh=1&_remote=1&_=1255432255156&_unlock=1)
[13-Oct-2009 15:10:57 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=show&_uid=10&_mbox=INBOX)
[13-Oct-2009 15:10:57 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=show&_uid=10&_mbox=INBOX)
[13-Oct-2009 15:10:58 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=getunread&_remote=1&_=1255432257921&_unlock=0)
[13-Oct-2009 11:10:59] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: INSERT INTO contacts
         (user_id, changed, del, `name`, `email`)
         VALUES (2, now(), 0, 'Admins', 'pro@vek.local')]
[Native code: 1364]
[Native message: Field 'firstname' doesn't have a default value]


[13-Oct-2009 15:10:59 +0400]: DB Error: MDB2 Error: unknown error Query: _doQuery: [Error message: Could not execute statement] [Last executed query: INSERT INTO contacts (user_id, changed, del, `name`, `email`) VALUES (2, now(), 0, 'Admins', 'pro@vek.local')] [Native code: 1364] [Native message: Field 'firstname' doesn't have a default value]  in C:\Inetpub\email\program\include\rcube_mdb2.php on line 627 (POST /index.php?_task=mail&_action=addcontact?_task=&_action=)

SKaero

It would help if you said what wasn't working, but from looking at the error log I think your have this problem: http://www.roundcubeforum.net/general-discussion/5532-add-contact-plus-sign.html

(:Pro:)

Yes, for me this problem. When I try to add contact writes an error.

PS. I apologise, I use a translator.

SKaero

To fix it you need to go into your RoundCube database and add a blank default value to the firstname and surname columns in the contacts table.

(:Pro:)

о_О
If not difficultly write the step-by-step instruction =)
And in the following version this error will eliminate?

(:Pro:)


(:Pro:)

I see =) Have removed no null:P Have earned.

(:Pro:)

Ok. This error? The i try sent email.

Quote[13-Oct-2009 17:16:07 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (POST /index.php?_task=&_action=login)
[13-Oct-2009 17:16:07 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail)
[13-Oct-2009 17:16:08 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=getunread&_remote=1&_=1255439760136&_unlock=0)
[13-Oct-2009 17:16:14 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=compose&_to=admin%40vek.local)
[13-Oct-2009 17:16:14 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_id=186204ad47d9e1e091&_action=compose)
[13-Oct-2009 17:16:28 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (POST /index.php?_task=mail&_action=send)
[13-Oct-2009 13:16:28] Invalid response code received from server (-1):

[13-Oct-2009 17:16:28 +0400]: SMTP Error: SMTP error: Connection failed: Invalid response code received from server in C:\Inetpub\email\program\steps\mail\func.inc on line 1349 (POST /index.php?_task=mail&_action=send)
[13-Oct-2009 17:16:31 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (POST /index.php?_task=mail&_action=send)
[13-Oct-2009 17:16:31 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_mbox=INBOX&_page=1)
[13-Oct-2009 17:16:32 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=getunread&_remote=1&_=1255439784285&_unlock=0)
[13-Oct-2009 17:16:39 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (POST /index.php?_task=&_action=login)
[13-Oct-2009 17:16:39 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail)
[13-Oct-2009 17:16:39 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=getunread&_remote=1&_=1255439792014&_unlock=0)
[13-Oct-2009 17:16:48 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=check-recent&_t=1255439800341&_list=1&_quota=1&_remote=1&_=1255439800344&_unlock=1)
[13-Oct-2009 17:16:49 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=list&_mbox=%26BCcENQRABD0EPgQyBDgEOgQ4-&_page=1&_refresh=1&_remote=1&_=1255439801874&_unlock=1)
[13-Oct-2009 17:16:51 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=list&_mbox=INBOX&_page=1&_refresh=1&_remote=1&_=1255439803052&_unlock=1)
[13-Oct-2009 17:16:53 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=show&_uid=11&_mbox=INBOX)
[13-Oct-2009 17:16:53 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=show&_uid=11&_mbox=INBOX)
[13-Oct-2009 17:16:54 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=getunread&_remote=1&_=1255439806471&_unlock=0)

(:Pro:)


JohnDoh

it says "Open SSL not available" are you sure you have the openssl module installed for PHP? if not then try configuring your IMAP and SMTP connections so they are not using encryption.
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more...

(:Pro:)

I did not instal openSSL module in PHP.
How to me to customise that he did not demand the protected connection?
The mail server works without usage SSL.

(:Pro:)

Да, блин. Как мне вырубить чтоб roundcube не ломился по SSL нах! Нету у меня SSL!
р-р-р-р :mad:


Yes, a pancake. As to me to cut down that roundcube did not break on SSL нах! Is not present for me SSL!

(:Pro:)

Я разобрался.

// use this host for sending mails.
// to use SSL connection, set ssl://smtp.host.com
// if left blank, the PHP mail() function is used
// Use %h variable as replacement for user's IMAP hostname
$rcmail_config['smtp_server'] = ' ';

- need use php mail function for sending email without SSL.

php.ini settings:
[mail function]
; For Win32 only.
SMTP = mail.lamer.local
smtp_port = 25


ИМХО полный бред.

(:Pro:)

Chert. Now email sent, but error still present...

Quote[14-Oct-2009 12:37:53 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=list&_mbox=%26BCcENQRABD0EPgQyBDgEOgQ4-&_page=1&_refresh=1&_remote=1&_=1255509472921&_unlock=1)
[14-Oct-2009 12:37:54 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=list&_mbox=INBOX&_page=1&_refresh=1&_remote=1&_=1255509474062&_unlock=1)
[14-Oct-2009 12:37:55 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=compose&_mbox=INBOX)
[14-Oct-2009 12:37:55 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_id=303864ad58de319af0&_action=compose)
[14-Oct-2009 12:38:08 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (POST /index.php?_task=mail&_action=send)
[14-Oct-2009 12:38:08 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_mbox=INBOX&_page=1)
[14-Oct-2009 12:38:08 +0400]: IMAP Error: Open SSL not available; in C:\Inetpub\email\program\include\rcube_imap.php on line 0 (GET /index.php?_task=mail&_action=getunread&_remote=1&_=1255509488640&_unlock=0)

(:Pro:)

End then user login end has email... The foolish translator. Look a picture is better.