Dev August 2006

dev@lists.roundcube.net

59 participants
66 discussions

Re: Ticket #1332930 (Feature Requests)
by Tobias 'tri' Richter 04 Oct '06

04 Oct '06

Hi guys, I found roundcubemail a few weeks ago and found it really great. I was a long time Horde-Imp User but roundecubemail is much faster, nicer and easier. But the first thing i miss was a "better" adressbook. I talked about this to thomas and he pointed me to the Ticket #1332930. Then i have included a lot fields into the database table and made this fields available under the adressbook. The fields i added now are all fields with are needed for vcard 2.1 support (export and import can then be done easier). But the problem now is, that the "right side" for each contact is a long list and maybe not everybody needs the field "tel work 2" for example. i will put my updates tomorrow to svn - but then i have to think about a nice and fast solution for users that they can change what fields they what to see for here contacts and which fields should be faded out. maybe this can be done like the folder settings under settings or maybe there is a better solution... i hope you can follow me - my english is not the best ;) - you can see it in svn tomorrow. roundecubemail is really good - thank you all. -- Best regards Tobias 'tri' Richter Visit me at: http://tobias.datenwerkstatt-richter.de/

18 56

I'm implementing tags!
by Joe Auricchio 23 Sep '06

23 Sep '06

Hi! I'm fed up with the fact that there are, to my knowledge, no webmail systems that support tags/labels (with the notable exception of GMail). So I'm going to do something about it. I'm going to add tags to Roundcube! =] I intend to read tags from, and store them as, IMAP Flags. The result should be somewhat interoperable with Thunderbird and Pine. (I've never used Pine, so I won't be able to test interop; I'm not a Thunderbird user but I have installed it and played with its tagging.) Now to the nitty-gritty. The plan, so far, is: - clean up the way flags are handled in rcube_imap.inc and lib/ imap.inc. They're up-cased, and "SEEN", "DELETED", etc are magical. I believe a better way to do this is to preserve flag case all the way through, and use "\Seen", "\Deleted", etc as IMAP does, including the backslash. Dealing with the backslash can mean some icky-looking code, but it shouldn't be a big problem. - add API for working with arbitrary tags. I think I'll start with steps/mail/mark.inc. I need to investigate exactly what this file is and when it gets called, though. - UI for tags. Not sure whether to clone GMail or what. Input would be especially appreciated here, I have a little UI-fu but I'm not a designer. I'll report my progress in this forum thread -> http:// roundcubeforum.net/forum/index.php?topic=340.0 I welcome all questions, comments, suggestions, corrections, and flames! -joe

5 6

Ticket #1483986 (Bugs) Session expires
by Martin Marques 08 Sep '06

08 Sep '06

I just added this ticket. Am I the only one with this problem or do I have "expired buddies". :-) I can't find error messages anywhere, so I'm kind of lost. :-( Any ideas on how to debug this? P.D.: I'm "At revision 327". -- --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------

5 12

Attachments not showing in message
by Todd Gehring 03 Sep '06

03 Sep '06

I recently installed the latest relase (beta) and everything is working great, except, when I attach some documents (Excel .xls, for example), the attachment is sent fine, but when I copy myself and read the message I sent, it does not appear in the message - so I can't click on it or download it to verify my message. However, the fact that there is an attachment is tracked on the message list - there is a little attachment icon and attachment size on the message list summary. I tried retrieving the email from another email client and it does show the attachement fine... I tried the same exercise (email attachment, copy myself) with a .pdf document and there was no problem. So, I'm not sure what the pattern is - if it has to do with file size, type, etc. Both were relatively small attachments (<100K). Any ideas? Thanks. Todd

2 1

Ticket #1327068 (Bugs) Opening large message fails
by Stefan Novak 31 Aug '06

31 Aug '06

Hello List... Whats the status of the Bug. Has anyone other the same problem? For me this is a big problem... mfg Stefan PS: Sorry for my bad english

1 0

Small bug in spell checker
by Aurélien Pocheville 30 Aug '06

30 Aug '06

Hi, I just upgraded to latest svn (rev 329 I think) and I noticed a small bug in the spell checking. I you click twice on the spell check _icon_ (the one on the very top, not the textual one), a graphical bug appears with a double bar on top of edit box. In fact, it is creating another editbox, and if you click a third time, a third editbox is created (they are very small), and so on... I managed to have a ten of them. I you click on the "resume editing" text, everything is coming back to normal. I think that the solution to this would be to have the top icon to also have the same behavior as the textual one, that is switch between "check/resume". Regards, -- Aurelien Pocheville PhD Student IBISC-CNRS Engineer IIE 2003 aurelien.pocheville(a)haptique.com http://www.haptique.com/ Tel : 33 1 69 47 06 05 Fax : 33 1 69 47 06 03 University of Evry Val d'Essonne 40 rue du Pelvoux - CE 1455 91020 EVRY CEDEX

1 0

Re: IMAP SORT
by Andrew Fladmark 30 Aug '06

30 Aug '06

On Wed, 30 Aug 2006 15:55:42 -0700, Joe Auricchio <jauricchio.lists(a)gmail.com> wrote: > Hi Andrew, > >> RoundCube then resorts to sorting the messages itself... I guess >> the question is.. why is Roundcube sending "s SORT (DATE)..."? >> What is this 's'? > > The 's' is a tag. All commands sent from the client to the server > start with a tag specified by the client. All responses to that > command will have the same tag, so the client can keep track of which > command the server is responding to. In this case, RC is using the > unimaginative tag 's' to designate its sort commands. > > RFC 3501 says it better: > http://www.apps.ietf.org/rfc/rfc3501.html#sec-2.2.1 > > The 's' is valid syntax, so it's not causing the BAD response. Hope > this helps direct your investigation =] > > -joe Thanks Joe! Forgive my ignorance. I've done some more testing and it seems that the issue is the fact that RoundCube is not including UID in the command its sending to my IMAP server. RoundCube is sending: s SORT (DATE) US-ASCII ALL UNDELETED This returns an error, but when I alter the command and test as: s UID SORT (DATE) US-ASCII ALL UNDELETED It works perfectly. I notice in the imap library code we now have a parameter which controls whether or not UID sort should be used... Does anyone have any ideas why it wouldn't be set true? Is there something I need to change or should it be autodetected? Thanks as always for the help! Andrew

1 0

IMAP SORT
by Andrew Fladmark 30 Aug '06

30 Aug '06

Hi! I know the topic of IMAP sorting has sort of died down, but I'm still having a problem with it. I'm using hMailServer on Windows. Here's what appears to be happening in the IMAP conversation: "RECEIVED: cp01 CAPABILITY" "SENT: * CAPABILITY IMAP4 IMAP4rev1 QUOTA SORT[nl]cp01 OK CAPABILITY completed[nl]" "RECEIVED: a001 LOGIN my(a)email.com "password"" "SENT: a001 OK LOGIN completed[nl]" "RECEIVED: sel1 SELECT "INBOX"" "SENT: * 44 EXISTS[nl]* 0 RECENT[nl]* FLAGS (\Deleted \Seen \Draft \Answered \Flagged)[nl]* OK [UIDVALIDITY 0][nl]* OK [PERMANENTFLAGS (\Deleted \Seen \Draft \Answered \Flagged)][nl]sel1 OK [READ-WRITE] SELECT completed[nl]" "RECEIVED: srch1 SEARCH ALL UNDELETED" "SENT: * SEARCH 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 33 34 35 36 37 38 39 40 41 42 43 44[nl]srch1 OK Search completed[nl]" "RECEIVED: s SORT (DATE) US-ASCII ALL UNDELETED" "SENT: s BAD Unknown or NULL command[nl]" RoundCube then resorts to sorting the messages itself... I guess the question is.. why is Roundcube sending "s SORT (DATE)..."? What is this 's'? Is anyone else having this problem? I looked in the code at imap.inc and I think the related code is around line 653: $command = 's '. $is_uid .'SORT ('.$field.') '.$encoding.' ALL'."$add\r\n"; Any help getting this resolved would be greately appreciated! Andrew

2 1

Problem with message parsing with >= r326
by Jim Pingle 30 Aug '06

30 Aug '06

Since SVN rev 326, I've had problems on one of my Roundcube setups (of course it's the one that's always the most problematic, the BincIMAP/Apache 1.3/PHP5 server) With 325, I would see headers but no body on most messages. With 326 I see the body but no headers. I'm also getting an SQL error in the log. I increased the length of the error that gets printed so it would show the whole thing: [29-Aug-2006 11:52:22 -0400] DB Error: DB Error: syntax error Query: INSERT INTO messages (user_id, del, cache_key, created, idx, uid, subject, `from`, `to`, cc, date, size, headers, structure) VALUES ('2', 0, 'INBOX.msg', now(), '823', '4812', '', '', '', '', FROM_UNIXTIME(), 779, 'O:14:\"iilBasicHeader\":23:{s:2:\"id\";s:3:\"823\";s:3:\"uid\";s:4:\"4812\";s:7:\"subject\";s:0:\"\";s:4:\"from\";N;s:2:\"to\";N;s:2:\"cc\";N;s:7:\"replyto\";N;s:11:\"in_reply_to\";N;s:4:\"date\";N;s:9:\"messageID\";N;s:4:\"size\";s:3:\"779\";s:8:\"encoding\";N;s:5:\"ctype\";N;s:5:\"flags\";s:0:\"\";s:9:\"timestamp\";N;s:1:\"f\";N;s:4:\"seen\";b:0;s:7:\"deleted\";b:0;s:6:\"recent\";b:0;s:8:\"answered\";b:0;s:4:\"junk\";N;s:12:\"internaldate\";s:20:\"29-Aug-2006 04:05:35\";s:8:\"is_reply\";N;}', NULL) [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 779, 'O:14:\"iilBasicHeader\":23:{s:2:\"id\";s:3:\"823\";s:3:\"uid\";s:4:\"48' at line 3] in /usr/home/webmail/roundcubemail/program/include/rcube_db.inc on line 479 I have caching disabled in the config, yet it appears to be attempting to write to the cache. It looks like the information isn't getting into the headers at all. The SQL insert is choking because FROM_UNIXTIME() needs an argument but it's getting an empty string. I'm using the most current version now (327) and the same problem is still there. On another server (using Courier IMAP, Apache 2, PHP5), it's working just fine. I'm sure that BincIMAP is partially to blame, and I wish I could drop it but the server's current setup makes it difficult. Any ideas?

2 2

RC & SQL Server
by WOODS John 30 Aug '06

30 Aug '06

Whilst on the subject of different databases some of you may be interested in a port to MS SQL Server that I have made. The attached zip contains four files: mssql.initial.sql This is the TSQL code for creating the DB objects insert_id.txt This modifies the insert_id function in the rcube_db.inc file to allow for retrieval of the last identity value (@@IDENTITY) made to the database. unixtimestamp.txt This modifies the unixtimestamp function in the rcube_db.inc file now_function.txt This is a new function that is required to place the now() mysql function or getdate() mssql function in SQL query strings. For this to work all occurrences of the string "now()" in the project have to be replaced with a call to this function. Please let me know whether any of you can make use this port. John Woods

2 1

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Dev August 2006