- Dev - Roundcube mailing lists

10/25/05 CVS, error in rcube_db.inc for mysql?
by Walter Francis 27 Oct '05

27 Oct '05

Under advisement for another bug, I just pulled the cvs today and now on all the email screens, I have the following: DB Error in /home/httpd/html/roundcube/program/include/rcube_db.inc (148): DB Error: syntax error<br /><b>DB Error in /home/httpd/html/roundcube/program/include/rcub e_db.inc (148): DB Error: syntax error<br /><b>DB Error in /home/httpd/html/roundcube/program/include/rcub e_db.inc (148): DB Error: syntax error And folders don't appear to be loading right.. I tried dropping all tables and running the mysql script again, but it didn't help. Also had another weird error about fopen on bugs.inc line 67 which I 'fixed' by putting in the full path instead of the variable that was there, not sure what the deal with that was. -- Walter Francis http://khayts.us http://theblackmoor.net http://unlimitedphoto.com Powered by Fedora Core 3

5 7

Re: PHP Warning: Invalid argument supplied for foreach() in /srv/www/htdocs/roundcube-webmail/program/include/rcube_ima p.inc on line 304
by Sören Meyer 27 Oct '05

27 Oct '05

Hello Does anyone seen this message? mfg.

1 0

Re: Problem with DB connection in 0.1-20051021
by Bastian Widmer 27 Oct '05

27 Oct '05

Hi David > if you use safe_mode both rights and onwership matters, specially if you > install the new version through a different user (not the user who runs > the web server) I changed the ownership to the user who runns the webserver (for testing purposes) i got the same errormessage > > > [26-Oct-2005 22:46:56 +0200] DB Error: DB Error: not found in > > /roundcube_2005_10_21/program/include/rcube_db.inc on line 63 > > [26-Oct-2005 22:46:56] PHP Fatal error: Call to undefined method > > DB_Error::query() in > > /roundcube_2005_10_21/program/include/rcube_db.inc on line 124 > > what do you have in /roundcube_2005_10_21/program/lib/DB/ ? In this direcory i have the files out of the acctual roundcube .tar-file I run out of ideas how to fix the problem... Does someone know what specaly changed between the two releases 20051007 and 20051021 it must be something essential i think... Greetings Bastian

2 1

2 " features " ?
by Adrian Snyman 27 Oct '05

27 Oct '05

Hi, we are currently evaluating Roundcube (no surprise) ... The 2 things I don't see, which would be great are: 1) Signature for user (under preferences maybe ?) 2) Read Receipt/Delivery Receipt request Are these in the pipeline ? -- Regards, Adrian Snyman Tel: (083)647-5299 JabberID: MadX(a)jabberafrica.org /* Disclaimer - These opiini^H^H damn! ^H^H ^Q ^[ .. :w :q :wq :wq! ^d X^? exit X Q ^C ^c ^? :quitbye CtrlAltDel ~~q :~q logout save/quit :!QUIT ^[zz ^[ZZZZZZ ^H man vi ^@ ^L ^[c ^# ^E ^X ^I ^T ? help helpquit ^D ^d man help ^C exit ?Quit ?q CtrlShftDel "Hey, what does this button d..." */ ================== The views expressed in this email are, unless otherwise stated, those of the author and not those of Supply Chain Services or its management. The information in this e-mail is confidential and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this, is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data transmitted electronically and to preserve the confidentiality thereof, no liability or responsibility whatsoever is accepted if information or data is, for whatever reason, corrupted or does not reach its intended destination.

5 5

Re: Problem with DB connection in 0.1-20051021
by Bastian Widmer 27 Oct '05

27 Oct '05

2005/10/27, Ander Otxoa Gilo <ander.otxoa(a)el202.net>: > > Check config directory files the db.inc.php and the main.inc.php should be well configured...

1 0

Directory Information
by S. William Schulz 27 Oct '05

27 Oct '05

Has anyone done any work towards integrating directory type services, e.g. LDAP lookups for address books, etc?

5 7

Re: Slow startup question
by Robert Landes 27 Oct '05

27 Oct '05

Anyway, Which IMAP Server are you using? From my experience "dovecot" is faster than any IMAP server, ESPECIALLY if it comes to huge mailboxes, because it uses per mailbox "index database files". You might give it a try, if you have got the possibility. Regards, Robert -----Original Message----- From: Walter Francis [mailto:wally@theblackmoor.net] Sent: Wednesday, October 26, 2005 4:26 PM To: dev(a)lists.roundcube.net Subject: Re: Slow startup question On Wed, 26 Oct 2005 16:04:22 +0200, Thomas Bruederli <roundcube(a)gmail.com> wrote: > Actually RoundCube does not "count" messages but ask the server for the > number of messages. This is called twice: ALL and UNREAD. These requests > to the server take some time and we already has requests to skip this on > login and do it in the background. > > Unsubscribing should help because only subscribed folders are listed and > requested for message count. > > Don't know why the CVS version runs slower than the latest build... Yes, unsubscribing from my larger 'archive' folders did the trick, it's very fast to login now, as I probably have perhaps 15,000 messages in my 'current' folders vs 80,000ish in my archive folders. It *seemed* it was slower in the 102505 CVS than the 102105 release, but might have been my imagination. Cheers

4 3

[PATCH] sorting subjects
by Jasper Slits 27 Oct '05

27 Oct '05

Hi, The attached patch makes Roundcube's subject sorting behave the same way as Mozilla Thunderbird does. When the mail is sorted by subject, the reply & forward identifiers (Fwd:,Re:,Fw: etc) are ignored. Old behaviour (sorted by subject): 'Announcement of new release' 'Courier-IMAP problem when opening new mail' 'Mysql 5 final released' 'Re: announcement of new release' New behaviour (sorted by subject): 'Announcement of new release' 'Re: Announcement of new release' 'Courier-IMAP problem when opening new mail' 'Mysql 5 final released' Maybe the identifiers should be configured per language? jasper --- ../roundcube2/program/lib/imap.inc 2005-10-24 12:13:36.000000000 +0200 +++ program/lib/imap.inc 2005-10-25 15:10:28.731941456 +0200 @@ -1365,8 +1365,15 @@ } function iil_SortHeaders($a, $field, $flag){ + + /* + Strip replies & forward identifiers when sorting the subjects + */ + + $stripArr = ($field=='subject')? array('Re: ','Fwd: ','Fw: ',"\"") : array("\""); + if (empty($field)) $field="uid"; $field=strtolower($field); if ($field=="date"||$field=='internaldate') $field="timestamp"; if (empty($flag)) $flag="ASC"; @@ -1385,9 +1392,9 @@ reset($a); while (list($key, $val)=each($a)){ $data=$a[$key]->$field; - if (is_string($data)) $data=strtoupper(str_replace("\"", "", $data)); + if (is_string($data)) $data=strtoupper(str_ireplace($stripArr, "", $data)); $index[$key]=$data; } // sort index

4 5

Addressbook import and others feature.
by J. Shawn Kondel 27 Oct '05

27 Oct '05

Just curious, Is there a plan for addressbook csv file import to Roundcube addressbook in the roadmap? Shawn

2 1

new features
by Henrique Meira 27 Oct '05

27 Oct '05

Hello all, my name is Henrique Meira, from Brazil. I would like to work in this project. Right now, I would like to know if exist any work about filter messages, and whether there are need of any help or not. Translations to portuguese (brazilian) are showed with some characters truncated, such as 'ç' (cedilha), I think so that problem is charset definition. A problem: I try to install RoundCube in a machine with Apache 2, PHP 4.2.2, and I get some errors of fail on try load files, such as include/*, but the package put this directory (include) into a sub-directory of program directory, so, index.php file never will be found any include files... nobody have this problem? Last point: are there any possibility of the RoundCube to work on PHP 4.2.2 ? best regards, henrique.

2 3

RoundCube Dev mailing list information: Please read!
by B. Johannessen 26 Oct '05

26 Oct '05

RoundCube developers and users, seems it's time for a refresher crash course in how to work with the RoundCube Dev mailing list list-manager. * To subscribe to RoundCube Dev: Send a message with 'subscribe' in both subject and body to dev+subscribe(a)lists.roundcube.net and follow the directions in the confirmation message. * To unsubscribe from RoundCube Dev: Send a message with 'unsubscribe' in both subject and body to dev+unsubscribe(a)lists.roundcube.net and follow the directions in the confirmation message. * DO NOT SEND SUBSCRIPTION/UNSUBSCRIPTION REQUEST TO THE LIST ADDRESS! * To change your subscription preferences: Send a message with 'options' in both subject and body to: dev+options(a)lists.roundcube.net and follow the link in the reply message. Available subscription options are: - Set Reply-To: This will add a Reply-To: header field to the messages you receive from the list, directing replies back to the list instead of the message originator. Messages with a Reply-To: header field already present will not have it replaced. - Tag Subject: Add a [RoundCube Dev] tag to all Subject: header fields. Some people find this useful to (automatically of visually) sort mailing list messages. - Suspend Mailing: Stop sending list messages to this address. Use this if you want to temporarily halt your subscription (like when going on holiday) or if you want to be able to post from several addresses without having list messages sent to all of them. * If you have any trouble interacting with the list, you can always e-mail postmaster(a)maildialog.com. This address is unfiltered. Bob (list-mom)

1 0

unsubscribe
by Geert Vanderkelen 26 Oct '05

26 Oct '05

unsubscribe -- Geert Vanderkelen http://Kemuri.Org Email: geert(a)kemuri.org ICQ: 319391586 / AIM: GeertJanVdk / MSN: geert(a)kemuri.org Phone: +49.176 22 04 20 93 Skype: geertjanvdk

1 0

list configuration suggestion
by Adam D. Oliver 26 Oct '05

26 Oct '05

Perhaps a footer with unsubscribe instructions. Just noticing people posting to the list asking about unsubscribing. Adam

1 0

Re: RoundCube with mysqli
by Adam D. Oliver 26 Oct '05

26 Oct '05

I think I originally switched because the authentication being used by MySQL wasn't supported by the old mysql library. You could switch the authentication scheme, but since I have all my stuff running on mysqli, phpbb, joomla, and mambo before that, I didn't see any reason to stop using it. Roundcube made it very easy through its DB abstraction. Also, Roundcube uses mysql and not mysqli for MySQL be default. I didn't know if anybody else had tried it yet. Adam -----Original Message----- From: Joshua Layne [mailto:joshua@willowisp.net] Sent: Wednesday, October 26, 2005 1:36 PM To: RoundCube Dev Subject: Re: RoundCube with mysqli Is there any particular reason that we are using the mysqli driver? I know that with PHP 5.0.3, the 'mysql' driver works fine against a MySQL 4.1.10+ db - they fixed the backwards compatibility issue. I don't know about php4, and I suppose for those people who are on php5 (<5.0.3) they might need it... This wasn't particularly highly publicized, so not everyone is necessarily aware of it. I guess if the db abstraction is handling it, it doesn't matter. j. On Wed, 26 Oct 2005 12:36:23 -0400, "Adam D. Oliver" <Adam.Oliver(a)fblaw.com> wrote: > I'm running the 20051021 build on PHP 5 and MySQLi. Working fine so > far. I do not have a lot of people to test it. I had to make the > following changes. > > Insert the following after the mysql case ending on line 174 of > rcube_db.inc > > case 'mysqli': > return mysqli_insert_id($this->db_handle->connection); > > In db.inc.php make this change to line 21 > > $rcmail_config['db_dsnw'] = 'mysqli://user:pass@localhost/dbname'; > > If you have chrooted mysql and have to use TCP like me then remember to > change the host accordingly. > > $rcmail_config['db_dsnw'] = 'mysqli://user:pass@127.0.0.1/dbname'; > > > If this was already posted by somebody then never mind. :-) > > Adam

1 0

unsubscribe
by Mike Marley 26 Oct '05

26 Oct '05

1 0

RoundCube with mysqli
by Adam D. Oliver 26 Oct '05

26 Oct '05

I'm running the 20051021 build on PHP 5 and MySQLi. Working fine so far. I do not have a lot of people to test it. I had to make the following changes. Insert the following after the mysql case ending on line 174 of rcube_db.inc case 'mysqli': return mysqli_insert_id($this->db_handle->connection); In db.inc.php make this change to line 21 $rcmail_config['db_dsnw'] = 'mysqli://user:pass@localhost/dbname'; If you have chrooted mysql and have to use TCP like me then remember to change the host accordingly. $rcmail_config['db_dsnw'] = 'mysqli://user:pass@127.0.0.1/dbname'; If this was already posted by somebody then never mind. :-) Adam

3 2

Special characters
by Dennis Duggen 26 Oct '05

26 Oct '05

Hi list A few days ago i tried RoundCubeMail for the first time and must say. GREAT JOB! It is easy to handle and exactly what i was looking for. I tried to send a few test mail's, and everything works fine except the oldest computer problem since other languages than English were used. If i send some special characters like æøå ÆØÅ they are scrambled during send. The header is fine, it's only the body. Does someone already know how to fix the problem? What can i do to fix it? Dennis -- Airconditioners and computers have one thing in common: Once you open windows everything fails. -- Firefox - Safer, Faster, Better http://www.mozilla.org/products/firefox/

1 0

Sugestion
by leroma 26 Oct '05

26 Oct '05

Change the message status of a readed email to unreaded email. leroma (:) zoeirapura.cjb.net (:) Devo, não pago. Nego enquanto puder. http://kevan.org/brain.cgi?zoeirapura _______________________________________________________ Promoção Yahoo! Acesso Grátis: a cada hora navegada você acumula cupons e concorre a mais de 500 prêmios! Participe! http://yahoo.fbiz.com.br/

1 0

Re: Slow startup question
by Robert Landes 26 Oct '05

26 Oct '05

LOL? 80000 Mails? Nice job :-P -----Original Message----- From: Walter Francis [mailto:wally@theblackmoor.net] Sent: Wednesday, October 26, 2005 4:26 PM To: dev(a)lists.roundcube.net Subject: Re: Slow startup question On Wed, 26 Oct 2005 16:04:22 +0200, Thomas Bruederli <roundcube(a)gmail.com> wrote: > Actually RoundCube does not "count" messages but ask the server for the > number of messages. This is called twice: ALL and UNREAD. These requests > to the server take some time and we already has requests to skip this on > login and do it in the background. > > Unsubscribing should help because only subscribed folders are listed and > requested for message count. > > Don't know why the CVS version runs slower than the latest build... Yes, unsubscribing from my larger 'archive' folders did the trick, it's very fast to login now, as I probably have perhaps 15,000 messages in my 'current' folders vs 80,000ish in my archive folders. It *seemed* it was slower in the 102505 CVS than the 102105 release, but might have been my imagination. Cheers

3 2

Having problem with Roundcubemail dealing with PMDF IMAP server
by J. Shawn Kondel 26 Oct '05

26 Oct '05

I installed Roundcubemail on my Gentoo box last week and was able to get it to work until this issue dealing with PMDF IMAP server running on OpenVMS server. I was able to log in to Roundcubemail using my VMS username and password, and I was able to view my INBOX and some other folders for the first time. However, when I composed a new email, I was able to see that email gets copied to Sent folder after the delivery, but when I went back to view my INBOX folder, it shows empty while loading status stay constant. I logged out and tried to log back in by reentering my username and password, only this time I wasn't successfully able to log in and an error message will display after it timeout. Maximum execution time of 120 seconds exceeded in /var/www/localhost/htdocs/roundcubemail/program/lib/imap.inc on line 104 I downloaded the latest CVS version and I get this message instead. Maximum execution time of 120 seconds exceeded in /var/www/localhost/htdocs/roundcubemail/program/lib/imap.inc on line 105 BTW it works great with MS Exchange server with IMAP running. Webmail server Gentoo Linux 2005.1 with latest update apache-2.0.54-r31 mysql-5.0.13_rc php-5.0.5-r1 Roundcube Build 0.1-20051021 IMAP server OpenVMS 7.1 PDMF with IMAP enabled Shawn

1 0

(no subject)
by Mathieu Wicke 26 Oct '05

26 Oct '05

1 0

Re: problem
by Bijan Kani 26 Oct '05

26 Oct '05

Hi, help. I am trying roundcube webmail under MS Windows (2003 server) with no luck. I have attached the error message pic. Regards Bijan

3 2

Re: problem
by Bijan Kani 26 Oct '05

26 Oct '05

Help, Security is set low and cookies are allowed and I am still getting the error message. Bijan -----Original message----- From: Brian Steere dianoga7(a)3dgo.net Date: Tue, 25 Oct 2005 23:44:32 +0100 To: bijan(a)cyberlinkuk.com Subject: Re: [RoundCube Dev] problem > IE in 2003 server is configured by default in a High Security > mode...thus, it won't accept cookies. In the tools->options there is a > setting for allowing cookies. Without them Roundcube will not function > correctly > > ~Dianoga > > Bijan Kani wrote: > > Hi, > > > > help. > > > > I am trying roundcube webmail under MS Windows (2003 server) with no luck. > > I have attached the error message pic. > > > > Regards > > > > Bijan > > > > > > > > > > ------------------------------------------------------------------------ > > >

1 0

Slow startup question
by wally 26 Oct '05

26 Oct '05

I've just installed RoundCube a few days ago, and it seems the latest CVS is slower than the last release of 102105, is it doing more folder counting? If so, I would like to put a suggestion in for a caching of folder sizes with a background update, something to that effect, to make initial login and Inbox viewing faster. I have 750M of email in my imap account, one mailing list 'archive' of 56k emails. I should likely move the folder elsewhere, as it'd probably improve performance, but it'd be good for Roundcube to initially process faster. Also perhaps an option not to count messages in folders at all. That would definately make things faster, or as suggested above, a delayed count. I'm going to try unsubscribing from my old archive files and see if that improves performance for now. Great work guys, it works amazingly well, but perhaps you're being very modest with the versioning.. :) And it's beautiful too. Cheers.

3 2

Problem with message body fetching
by Mark cartwright 26 Oct '05

26 Oct '05

removing old IMAP folders (fresh account) seemed to fix the other problem I was having with body displays (did not display on double-click). however, I'm not seeing a different problem that seems to have something to do with fetching bodies off the mail server. Below is what I have for my body, no matter the actual contents: 1 FETCH ( And nothing else. I havn't had a chance yet to get into the code to see where the fetch routines are, so thought I'd post this here in case someone might have a quick idea. This problem is true both with the build on the web site (0.1-20051021) as well as today's current CVS (although with the CVS version I also get an odd error about a syntax error in program/include/rcube_db.inc, although it doesn't seem to actually break anything). Thanks

1 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Dev