Author Topic: some problems with identities, error log and plugins  (Read 3895 times)

Offline rmc2000

  • Jr. Member
  • **
  • Posts: 40
some problems with identities, error log and plugins
« on: April 28, 2008, 09:35:19 AM »
Informations:

I use last stable version of roundcube 0.1.1

My PHP version is 5

I use hmailserver 4.4.1

I test with internet explorer 7 without special plugins

My log errors have: [25-Apr-2008 16:21:30 -0300] DB Error: MDB2 Error: unknown error Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE MDB2_STATEMENT_mysql_466339d2012e3c3037ebb3ae95269cc6a9e7058d4 USING @0, @1, @2] [Native code: 1364] [Native message: Field 'organization' doesn't have a default value] in C:\Domains\nameofmydomain.com.br\wwwroot\webmail\program\include\rcube_mdb2.inc on line 529

And i need know some thinks like:

1 - how to i can force roundcube to create identities of my users at first login time.

2 - how i can add a mark as read and mark as unread message feature

3 - exist any change password plugin to add to last version of roundcube?

Please helpme!

Thanks

Offline evb

  • Jr. Member
  • **
  • Posts: 34
Field 'organization' doesn't have a default value
« Reply #1 on: May 14, 2008, 04:01:19 PM »
I have the same problem.

Did you find a solution or the cause of this error?

Offline rmc2000

  • Jr. Member
  • **
  • Posts: 40
some problems with identities, error log and plugins
« Reply #2 on: May 14, 2008, 04:26:29 PM »
Hi i not find the solution!

And this problem is very sux!

nobody help

Offline evb

  • Jr. Member
  • **
  • Posts: 34
Field 'organization' doesn't have a default value
« Reply #3 on: May 14, 2008, 04:55:09 PM »
I did find another thread : http://www.roundcubeforum.net/showthread.php?t=536&highlight=organization

I adapted the tables and added default values when it where strings and null allowed when text/blob fields.
Or you can do like the poster, putting these fields null allowed.

So now, I see no sql errors anymore, but I can't go further then my login screen. I see a successfull IMAP login in the log files of my hmailserver, but that's it... :(

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
some problems with identities, error log and plugins
« Reply #4 on: May 15, 2008, 12:24:04 AM »
What do you have in db.inc.php $rcmail_config['db_backend']? I had trouble with 'mdb2' pear. Try if changing to 'db' does the trick.

-Roland
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline evb

  • Jr. Member
  • **
  • Posts: 34
some problems with identities, error log and plugins
« Reply #5 on: May 15, 2008, 02:51:17 AM »
I changed it to 'db' but no luck.
Same problem, when I type the login and the password, I'm returned to the login screen again.
I see a IMAP login in my hmailserver logs, but directly I see also a logout...
(there is also a thread about this). Don't know if this is the cause....

There are other threads talking about session issues, with the php session.auto_start = 0, but also no luck...

Offline rmc2000

  • Jr. Member
  • **
  • Posts: 40
some problems with identities, error log and plugins
« Reply #6 on: May 15, 2008, 11:56:44 AM »
i try change to db too but continue not working! any identitie are create at first time login!

:(