All topics related to the use and administration of RoundCube Webmail.

jana1972 | 1 Oct 2011 10:46

Re: [RCU] Roundcube upgrade problem


 I tried to upgrade to the latest version but it did not finish properly. 
 I received this error 

 Your configuration files are now up-to-date! 
 WARNING: Database schema needs to be updated! 
 Missing columns in table 'contacts': words 

 Open /home/roundcube/SQL/mysql.update.sql and execute all queries below the comment 
with 
 the currently installed version number. 
 MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement] 
 [Last executed query: PREPARE 
 mdb2_statement_mysql_206ebea3942ba0794abf09aeec52fe83c1a87f81d FROM 'UPDATE 
 contacts SET changed=now(), `vcard`=\'BEGIN:VCARD\\r\\nVERSION:3.0\\r\\nN: 

Blak;lan;;;\\r\\nFN:LADA\\r\\nEMAIL;type=INTERNET:export@...\\r\\nEND:VCARD\', 
 `name`=\'LADA\', `email`=\'export@...\',
`firstname`=\'ladislav\', `surname`=\' 
Bank\', 
 `words`=\' lada export@... lan Bank\' WHERE contact_id=? AND
user_id=? AND 
 del<>1'] 
 [Native code: 1054] 
 [Native message: Unknown column 'words' in 'field list'] 

 

 Can anyone help? 
 Thanks

(Continue reading)

headers

Tobias Hachmer | 1 Oct 2011 13:14

[RCU] Upgrade Problem from 0.5.2 to 0.6

Hello list,

when I execute ./bin/installto.sh I get following error:

Done.
Your configuration files are now up-to-date!
PHP Fatal error:  Call to undefined method rcube_mdb2::list_cols() in 
/var/www/test/installer/rcube_install.php on line 364
All done.

Any suggestions to solve this issue?

Regards,

Tobias
--

-- 
List info: http://lists.roundcube.net/users/
BT/d79c1da0

headers

Egbert Jan van den Bussche | 1 Oct 2011 23:04

[RCU] update question

I've noticed that RC made a big leap forward recently. But since we run
on Ubuntu 10.04 LTS servers, we still have the RC version in the repo of
that Ubuntu release. I think it is 0.4...
Is it possible that the latest version will be made available in some
backport repo? Or is this the wrong place to ask?

Egbert Jan, NL
HCC!Hobbynet

--

-- 
List info: http://lists.roundcube.net/users/
BT/d79c1da0

headers

Niccolò Belli | 2 Oct 2011 00:57

Re: [RCU] update question

Il 01/10/2011 23:04, Egbert Jan van den Bussche ha scritto:
> Is it possible that the latest version will be made available in some
> backport repo? Or is this the wrong place to ask?

Debian already had 0.5.4 in squeeze-backports and 0.6 will follow soon.
I don't know of ubuntu, but you can always use pinning and 
squeeze-backports...

Cheers,
Niccolò
--

-- 
List info: http://lists.roundcube.net/users/
BT/d79c1da0

headers

Alberto Mijares | 3 Oct 2011 00:35

[RCU] Password Plugin - PAM Driver fails

Hi list,

I have roundcube working fine on FreeBSD.

Recently enabled the password plugin with the PAM driver. Once
authenticated with my own account, a try to change my password but it
fails.

The log says:

[02-Oct-2011 17:39:36 -0430]: PHP Error: Password plugin: PAM
authentication failed for user amijares:  in
/usr/local/www/roundcube/plugins/password/drivers/pam.php on line 24
(POST /?_task=settings&_action=plugin.password-save?_task=&_action=)

I read the README and installed the pecl-pam module for PHP too.

Can't find any further information. Could anybody help me or give me some clue.

Thanks in advance

Regards

Alberto Mijares
--

-- 
List info: http://lists.roundcube.net/users/
BT/d79c1da0

headers

mailing-o7tR/nIX9VglQMARD/awdg@public.gmane.org | 3 Oct 2011 10:18

[RCU] Trash problem with 0.6

Hello, since the upgrade from 0.5.3 to 0.6 I have a problem when some 
users try to delete messages in their INBOX. The error is:

"UID COPY: Client tried to access nonexistent namespace. (Mailbox name 
should probably be prefixed with: INBOX.)."

This appens only on mailbox that have INBOX as namespace, I use Dovecot 
2.0.x as IMAP server so when it is configured as:

namespace {
   inbox = yes
   location =
   prefix = INBOX.
   separator = .
   type = private
}

On servers without namespace configured I have no trouble (always 
Dovecot as IMAP server)

I can fix the error simply by Settings, Special Folders, "Save". When I 
save settings the trash icon appears in the folder list and the trash works.

--

-- 
List info: http://lists.roundcube.net/users/
BT/d79c1da0

headers

jana1972 | 3 Oct 2011 16:56

[RCU] Structure of Contacts table in the latest Roundcube

Can anyone send me a structure of Contacts table in version 0.6

I upgraded to that version but have a problem with contacts.

During updating I received the error

WARNING: Database schema needs to be updated!

Missing columns in table 'contacts': words

Open /home/roundcube/SQL/mysql.update.sql and execute all queries below

the comment with

the currently installed version number.

MDB2 Error: no such field (-19): _doQuery: [Error message: Could not

execute statement]

[Last executed query: PREPARE

mdb2_statement_mysql_206ebea3942ba0794abf09aeec52fe83c1a87f81d FROM

'UPDATE

contacts SET changed=now(),

`vcard`=\'BEGIN:VCARD\\r\\nVERSION:3.0\\r\\nN:

Blak;lan;;;\\r\\nFN:LADA\\r\\nEMAIL;type=INTERNET: export-hpIqsD4AKlfQT0dZR+AlfA@public.gmane.org\\r\\n

END:VCARD\',

`name`=\'LADA\', `email`=\ 'export-hpIqsD4AKlfQT0dZR+AlfA@public.gmane.org\' , `firstname`=\'ladislav\',

`surname`=\' Bank\',

`words`=\' lada export-hpIqsD4AKlfQT0dZR+AlfA@public.gmane.org lan Bank\' WHERE contact_id=? AND

user_id=? AND

del<>1']

[Native code: 1054]

[Native message: Unknown column 'words' in 'field list']

Thanks for help

--

-- 
List info: http://lists.roundcube.net/users/
BT/d79c1da0

headers

Luciano Andino | 3 Oct 2011 18:06

Re: [RCU] Structure of Contacts table in the latest Roundcube

2011/10/3 <jana1972-aRb0bU7PRFPrBKCeMvbIDA@public.gmane.org>

Can anyone send me a structure of Contacts table in version 0.6

I upgraded to that version but have a problem with contacts.

Same happened to me, added that error of session expired

During updating I received the error

WARNING: Database schema needs to be updated!

Missing columns in table 'contacts': words

Open /home/roundcube/SQL/mysql.update.sql and execute all queries below

the comment with

the currently installed version number.

MDB2 Error: no such field (-19): _doQuery: [Error message: Could not

execute statement]

[Last executed query: PREPARE

mdb2_statement_mysql_206ebea3942ba0794abf09aeec52fe83c1a87f81d FROM

'UPDATE

contacts SET changed=now(),

`vcard`=\'BEGIN:VCARD\\r\\nVERSION:3.0\\r\\nN:

Blak;lan;;;\\r\\nFN:LADA\\r\\nEMAIL;type=INTERNET: export-hpIqsD4AKlfQT0dZR+AlfA@public.gmane.org\\r\\n

END:VCARD\',

`name`=\'LADA\', `email`=\ 'export <at> google.com\' , `firstname`=\'ladislav\',

`surname`=\' Bank\',

`words`=\' lada export-hpIqsD4AKlfQT0dZR+AlfA@public.gmane.org lan Bank\' WHERE contact_id=? AND

user_id=? AND

del<>1']

[Native code: 1054]

[Native message: Unknown column 'words' in 'field list']

Thanks for help

--
List info: http://lists.roundcube.net/users/
BT/d8b50aa5

--
Saludos!!

Luciano Andino
GNU/Linux user #185103
Santa Fe - Argentina
-----------------------------------------------

--

-- 
List info: http://lists.roundcube.net/users/
BT/d79c1da0

headers

jana1972 | 3 Oct 2011 20:13

Re: [RCU] Structure of Contacts table in the latest Roundcube

I solved the problem 
I opened 
/home/roundcube/SQL/mysql.update.sql and executed 
ALTER TABLE `contacts` ADD `words` TEXT NULL AFTER `vcard`;
ALTER TABLE `contacts` CHANGE `vcard` `vcard` LONGTEXT /*!40101 CHARACTER 
SET utf8 */ NULL DEFAULT NULL;
ALTER TABLE `contactgroupmembers` ADD INDEX 
`contactgroupmembers_contact_index` (`contact_id`);

TRUNCATE TABLE `messages`;
TRUNCATE TABLE `cache`;

Now it seems to work GREAT!

> 2011/10/3 <jana1972@...>
> 
> > **
> >   Can anyone send me a structure of Contacts  table in version 0.6 I
> >   upgraded to that version but have a problem with contacts.
> >
> 
> Same happened to me, added  that error of session expired
> 
> 
> 
> >    During updating I received the error
> >
> >
> >    WARNING: Database schema needs to be updated!
> >    Missing columns in table 'contacts': words
> >
> >    Open /home/roundcube/SQL/mysql.update.sql and execute all queries
> >    below
> >   the comment with
> >    the currently installed version number.
> >    MDB2 Error: no such field (-19): _doQuery: [Error message: Could
> >    not
> >   execute statement]
> >    [Last executed query: PREPARE
> >    mdb2_statement_mysql_206ebea3942ba0794abf09aeec52fe83c1a87f81d
> >    FROM
> >   'UPDATE
> >    contacts SET changed=now(),
> >   `vcard`=\'BEGIN:VCARD\\r\\nVERSION:3.0\\r\\nN:
> >    Blak;lan;;;\\r\\nFN:LADA\\r\\nEMAIL;type=INTERNET: 
> >    *export@...
> > \\r\\n*
> >   END:VCARD\',
> >    `name`=\'LADA\', `email`=\  *'export@...\'*  ,
> > `firstname`=\'ladislav\',
> >   `surname`=\' Bank\',
> >    `words`=\' lada  *export@...*   lan Bank\' WHERE
> >    contact_id=?
> > AND
> >   user_id=? AND
> >    del<>1']
> >    [Native code: 1054]
> >    [Native message: Unknown column 'words' in 'field list']
> >
> >
> >    Thanks for help
> >
> >
> >
> > --
> > List info: http://lists.roundcube.net/users/
> > BT/d8b50aa5
> >
> >
> 
> 
> -- 
> Saludos!!
> 
> Luciano Andino
> GNU/Linux user #185103
> Santa Fe - Argentina
> -----------------------------------------------
> 

--

-- 
List info: http://lists.roundcube.net/users/
BT/d79c1da0

headers

Claudio Kuenzler | 3 Oct 2011 20:20

Re: [RCU] Structure of Contacts table in the latest Roundcube

Just fyi, this is the normal upgrade procedure - you always have to run the sql queries manually when you upgrade to another major version.

On Mon, Oct 3, 2011 at 8:13 PM, <jana1972-aRb0bU7PRFPrBKCeMvbIDA@public.gmane.org> wrote:

I solved the problem
I opened
/home/roundcube/SQL/mysql.update.sql and executed
ALTER TABLE `contacts` ADD `words` TEXT NULL AFTER `vcard`;
ALTER TABLE `contacts` CHANGE `vcard` `vcard` LONGTEXT /*!40101 CHARACTER
SET utf8 */ NULL DEFAULT NULL;
ALTER TABLE `contactgroupmembers` ADD INDEX
`contactgroupmembers_contact_index` (`contact_id`);

TRUNCATE TABLE `messages`;
TRUNCATE TABLE `cache`;

Now it seems to work GREAT!

> 2011/10/3 <jana1972 <at> centrum.cz>
>
> > **
> > Can anyone send me a structure of Contacts table in version 0.6 I
> > upgraded to that version but have a problem with contacts.
> >
>
> Same happened to me, added that error of session expired
>
>
>
> > During updating I received the error
> >
> >
> > WARNING: Database schema needs to be updated!
> > Missing columns in table 'contacts': words
> >
> > Open /home/roundcube/SQL/mysql.update.sql and execute all queries
> > below
> > the comment with
> > the currently installed version number.
> > MDB2 Error: no such field (-19): _doQuery: [Error message: Could
> > not
> > execute statement]
> > [Last executed query: PREPARE
> > mdb2_statement_mysql_206ebea3942ba0794abf09aeec52fe83c1a87f81d
> > FROM
> > 'UPDATE
> > contacts SET changed=now(),
> > `vcard`=\'BEGIN:VCARD\\r\\nVERSION:3.0\\r\\nN:
> > Blak;lan;;;\\r\\nFN:LADA\\r\\nEMAIL;type=INTERNET:

> > *export <at> google.com
> > \\r\\n*
> > END:VCARD\',
> > `name`=\'LADA\', `email`=\ *'export-hpIqsD4AKlfQT0dZR+AlfA@public.gmane.org\'* ,
> > `firstname`=\'ladislav\',
> > `surname`=\' Bank\',

> > `words`=\' lada *export-hpIqsD4AKlfQT0dZR+AlfA@public.gmane.org* lan Bank\' WHERE
> > contact_id=?
> > AND
> > user_id=? AND
> > del<>1']
> > [Native code: 1054]
> > [Native message: Unknown column 'words' in 'field list']
> >
> >
> > Thanks for help
> >
> >
> >
> > --
> > List info: http://lists.roundcube.net/users/
> > BT/d8b50aa5
> >
> >
>
>
> --
> Saludos!!
>
> Luciano Andino
> GNU/Linux user #185103
> Santa Fe - Argentina
> -----------------------------------------------
>

--
List info: http://lists.roundcube.net/users/

BT/e21360c6

--

-- 
List info: http://lists.roundcube.net/users/
BT/d79c1da0

Mon	Tue	Wed	Thu	Fri	Sat	Sun

					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30
31

32	May 2013
57	April 2013
71	March 2013
62	February 2013
144	January 2013
122	December 2012
95	November 2012
78	October 2012
127	September 2012
50	August 2012
47	July 2012
50	June 2012
137	May 2012
229	April 2012
134	March 2012
52	February 2012
50	January 2012
101	December 2011
19	November 2011
74	October 2011
66	September 2011
40	August 2011
17	July 2011
20	June 2011
48	May 2011
53	April 2011
57	March 2011
52	February 2011
39	January 2011
60	December 2010
22	November 2010
65	October 2010
56	September 2010
81	August 2010
42	July 2010
44	June 2010
42	May 2010
71	April 2010
53	March 2010
67	February 2010
51	January 2010
40	December 2009
40	November 2009
49	October 2009
68	September 2009
35	August 2009
90	July 2009
49	June 2009
43	May 2009
45	April 2009
19	March 2009
39	February 2009
60	January 2009
46	December 2008
55	November 2008
63	October 2008
34	September 2008
6	August 2008
1	June 2008
3	April 2008
1	March 2008
2	February 2008
1	December 2007
3	July 2007
1	January 2007
1	September 2006
6	March 2006
8	February 2006