Dev

dev@lists.roundcube.net

2 participants
4318 discussions

using RoundCube with PostgreSQL
by Bennett, Steve 14 Oct '05

14 Oct '05

Hi list, I've just started playing with RoundCube, looks great so far..! I can't see a list archive, so maybe some of this has already been discussed, but I'm seeing some issues using RoundCube with a pgsql database: Some of the queries use backticks to quote column names - pgsql uses double quotes. Given that "default" is a bit of a tricky name to use for a column, is it worth renaming it, rather than doing lots of tricky code to make sure the quotes are right for the database? The same probably goes for column names like "language" and "reply-to". My install of PostgreSQL (v8.0.1) doesn't have a function named unix_timestamp(). I hacked one up as: CREATE OR REPLACE FUNCTION unix_timestamp(TIMESTAMP WITH TIME ZONE) RETURNS INTEGER AS ' BEGIN RETURN round(EXTRACT( EPOCH FROM $1 )); END; ' LANGUAGE 'plpgsql'; I get errors if I leave caching enabled - I've just turned it off for now, but I'm guessing that the serialised data contains something that pgsql doesn't like. Amongst the spam and assorted junk that is my inbox, I have a message with no Date header. RoundCube generated errors for that too. The following seems to do the trick: --- program/include/main.inc.orig +++ program/include/main.inc @@ -890,7 +890,9 @@ { global $CONFIG, $sess_user_lang; - if (is_numeric($date)) + if ($date == "") + return ""; + elseif (is_numeric($date)) $ts = $date; else $ts = strtotime($date); Cheers, Steve Bennett

5 4

Timeouts
by Kevin Willock 14 Oct '05

14 Oct '05

What is the maximum size that this app can open? I keep getting timeouts on mailboxes > 50megs (or it loads but just a white screen appears) Any thoughts? rc is running on the same machine as the mail server. -k

2 1

May have found a bug
by Jeffrey Lee 14 Oct '05

14 Oct '05

PHP 5.0.4 Apache 2 The function "function rcube_xml_command($command, $str_attrib, $a_attrib=NULL)" is not working correctly on php 5. It never orders any of the matches in $str_attrib. For example, at one point $str_attrib is [file="/includes/header.html" /], this never produces a result in $regs. Now, I am no expert but I do not think this is working properly. The errors associated with this are as follows: Warning: preg_match_all: internal pcre_fullinfo() error -3 in /var/ www/reflex8.com/roundcube/program/include/main.inc on line 503 [file="/includes/header.html" /] [Array] [2] [include] Warning: preg_match_all: internal pcre_fullinfo() error -3 in /var/ www/reflex8.com/roundcube/program/include/main.inc on line 503 [name="loginform" form="form" /] [Array] [2] [object] Warning: preg_match_all: internal pcre_fullinfo() error -3 in /var/ www/reflex8.com/roundcube/program/include/main.inc on line 503 [name="login" /] [Array] [2] [label] Lines 503 - 510 are below 503: preg_match_all('/\s*([-_a-z]+)=["]([^"]+)["]?/i', stripslashes ($str_attrib), $regs, PREG_SET_ORDER); 504: 505: // convert attributes to an associative array (name => value) 506: if ($regs) 507: foreach ($regs as $attr) 508: $attrib[strtolower($attr[1])] = $attr[2]; 509: else if ($a_attrib) 510: $attrib = $a_attrib; Thanks for any help! Jeff

1 1

About search engine
by garaged 14 Oct '05

14 Oct '05

Hi Again me, I pretty much solved every issue I had with RC (1 not completly), now I would like to know if there is any advance on a search engine. I may halp if there's work to do, or even start if there isnt. Great work ! i liked Roundcube a lot Max -- -----BEGIN GEEK CODE BLOCK----- Version: 3.12 GS/S d- s: a-29 C++(+++) ULAHI+++ P+ L++>+++ E--- W++ N* o-- K- w++++ O- M-- V-- PS+ PE Y-- PGP++ t- 5- X+ R tv++ b+ DI+++ D- G++ e++ h+ r+ z** ------END GEEK CODE BLOCK------

1 0

Hello
by Dan Phiffer 14 Oct '05

14 Oct '05

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hey great work guys, this looks like a really promising project. Is there a list archive by any chance? Also: what is the operation to get the sqlite.initial.sql goodies into a database? Thanks, - -Dan -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (Darwin) iD8DBQFDTw0ydpF1ItYG3u4RAqdqAJ9dql1ecGSJqJLidMvqD9HltIngmgCeLWn3 QS8hts0+Ez3mnxnlazdZN2w= =tcEk -----END PGP SIGNATURE-----

3 3

Help..With setting up Roundcube.....Permission Issues??? / Where???
by Jason 14 Oct '05

14 Oct '05

Hello! I'm having issues with the webmail, I want to know if it's some permission related issue. The buttons in the mail interface like Send / Compose / Delete / etc... will not excute or anything. So I'm thinking it is Permission related just like with the images not showing which I fixed by setting the permissions correctly... Now I'm trying to figure out where excatly these buttons are located in the webpackage so I can set permissions on these folders. I can't pin point the location with the link that these command / buttons show.. Please help me out ;-) Nice job by the way!! Best sleek looking webmail interface!! Cheers! Jason gisjason(a)gmail.com ---- please reply to this email I'm not subscribed to this mailing list.....

1 0

Fwd: Re: won't delete?
by Jon Anhold 14 Oct '05

14 Oct '05

Ah ha, that was it. Thanks Ross! -------- Original Message -------- Subject: Re: won't delete? Date: Fri, 14 Oct 2005 8:54:30 +1000 From: Ross Poulton <ross(a)rossp.org> To: dev(a)lists.roundcube.net Jon, I haven't yet seen a reply to this so here you go - in your config/main.inc.php, ensure that $rcmail_config['trash_mbox'] is set correctly, in my case (Courier imapd) it has to be set to 'INBOX.Trash'. If this folder doesn't exist, the system will be unable to delete messages, so they won't dissappear. Deleting in RoundCube actually moves messages to the folder specified above. On the 'todo' list is a way to empty trash / purge messages / etc. HTH. Ross On Thu, 13 Oct 2005 11:10:35 -0400 (EDT), "Jon Anhold" <jon(a)anhold.com> wrote: > Hi all. > > I'm running RoundCube on Debian Woody against Dovecot.. It looks great, > except it doesn't actually delete messages. Is this a known bug? > > Thanks, > > -j

1 0

unsubscribe
by David Gerding 14 Oct '05

14 Oct '05

unsubscribe

1 0

UTF-8 for I18N
by HIROSHIMA Naoki 14 Oct '05

14 Oct '05

Hello, Like many of other people, I found this today, installed without any hassle, and just worked great with BincIMAP's IMAPdir. Thanks a lot for your great work! Now, my question is, do you have any plan to go with UTF-8 soon? L10N shouldn't be primary issue but I18N. People can somehow live without L10N as long as it works. But it will never work for some people without I18N. For instance, I don't care the language of UI but roundcube doesn't handle Japanese in subject and body properly at all. If it would use UTF-8 rather than any of SBCS, it would be very easy to hack and contribute so that many languages could be easily supported by people around world, I supposed :-) Thanks, -- Hiroshima

1 0

MySQL folder caching
by shaun walbridge 13 Oct '05

13 Oct '05

Something that is worth mentioning in the documentation is that MySQL is configured on many machines to default to a maximum query size (max_allowed_packet) of 1M. With approximately 1600 messages in my inbox, the attempt to generate a cache of the INBOX folder (a 1.2 MB query) threw unknown errors: DB Error: unknown error in /www/roundcubemail/program/include/rcube_db.inc on line 124 The resolution is simple enough: In the [mysqld] section of my.cnf, change the max_allowed_packet to a larger value: set-variable = max_allowed_packet=16M cheers, Shaun Walbridge

1 0

Jump to page:

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Dev