Author Topic: Error error error =( help.  (Read 12849 times)

Offline (:Pro:)

  • Jr. Member
  • **
  • Posts: 53
Error error error =( help.
« on: October 13, 2009, 07:40:13 AM »
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=)

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Error error error =( help.
« Reply #1 on: October 13, 2009, 08:06:37 AM »
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

Offline (:Pro:)

  • Jr. Member
  • **
  • Posts: 53
Error error error =( help.
« Reply #2 on: October 13, 2009, 08:34:39 AM »
Yes, for me this problem. When I try to add contact writes an error.

PS. I apologise, I use a translator.

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Error error error =( help.
« Reply #3 on: October 13, 2009, 08:42:19 AM »
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.

Offline (:Pro:)

  • Jr. Member
  • **
  • Posts: 53
Error error error =( help.
« Reply #4 on: October 13, 2009, 08:47:56 AM »
о_О
If not difficultly write the step-by-step instruction =)
And in the following version this error will eliminate?

Offline (:Pro:)

  • Jr. Member
  • **
  • Posts: 53
Error error error =( help.
« Reply #5 on: October 13, 2009, 09:12:05 AM »
They and so the empty.

Offline (:Pro:)

  • Jr. Member
  • **
  • Posts: 53
Error error error =( help.
« Reply #6 on: October 13, 2009, 09:14:05 AM »
I see =) Have removed no null:P Have earned.

Offline (:Pro:)

  • Jr. Member
  • **
  • Posts: 53
Error error error =( help.
« Reply #7 on: October 13, 2009, 09:18:41 AM »
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)

Offline (:Pro:)

  • Jr. Member
  • **
  • Posts: 53
Error error error =( help.
« Reply #8 on: October 14, 2009, 02:27:01 AM »
:( help...

Offline JohnDoh

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2,845
Error error error =( help.
« Reply #9 on: October 14, 2009, 02:51:47 AM »
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…

Offline (:Pro:)

  • Jr. Member
  • **
  • Posts: 53
Error error error =( help.
« Reply #10 on: October 14, 2009, 03:04:52 AM »
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.

Offline (:Pro:)

  • Jr. Member
  • **
  • Posts: 53
Error error error =( help.
« Reply #11 on: October 14, 2009, 04:06:05 AM »
Да, блин. Как мне вырубить чтоб 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!

Offline (:Pro:)

  • Jr. Member
  • **
  • Posts: 53
Error error error =( help.
« Reply #12 on: October 14, 2009, 04:34:02 AM »
Я разобрался.

// 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


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

Offline (:Pro:)

  • Jr. Member
  • **
  • Posts: 53
Error error error =( help.
« Reply #13 on: October 14, 2009, 04:43:47 AM »
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)

Offline (:Pro:)

  • Jr. Member
  • **
  • Posts: 53
Error error error =( help.
« Reply #14 on: October 14, 2009, 05:24:17 AM »
End then user login end has email... The foolish translator. Look a picture is better.