Dev

dev@lists.roundcube.net

4296 discussions

Error "constraint violation" ....
by Christian Ista 19 Dec '05

19 Dec '05

Hello, This morning, I'm trying to access my webmail and surprise after connexion .... I have plenty off this error : DB Error in /home/cista/www/webmail/program/include/rcube_db.inc (283): DB Error: constraint violation Query: INSERT INTO messages (user_id, del, cache_key, idx, uid, subject, `from`, `to`, cc, date, size, headers) VALUES ('2', 0, 'INBOX.msg', '875', '2740', '', NULL, 'ml(a)cista.be', '', FROM_UNIXTIME(1134846156), '1378', 'O:14:\"iilbasicheader\":23:{s:2:\"id\";s:3:\"875\";s:3:\"uid\";s:4:\"2740\";s:7:\"subject\";s:0:\"\";s:4:\"from\";N;s:2:\"to\";s:11:\"ml(a)cista.be\";s:2:\"cc\";s:0:\"\";s:7:\"replyto\";s:0:\"\";s:11:\"in_reply_to\";s:0:\"\";s:4:\"date\";N;s:9:\"messageID\";s:7:\"mid:875\";s:4:\"size\";s:4:\"1378\";s:8:\"encoding\";s:0:\"\";s:5:\"ctype\";s:0:\"\";s:5:\"flags\";s:0:\"\";s:9:\"timestamp\";d:1134846156;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:\"17-Dec-2005 21:02:36\";s:8:\"is_reply\";N;}') [nativecode=1048 ** Column 'from' cannot be null] javascript:handleSend(); Envoyer Thanks,

2 1

Error on Login: Field 'preferences' doesn't have a default value
by Roland Müller 18 Dec '05

18 Dec '05

Hello, I am getting this query error on login: *DB Error in d:\webserver\roundcube\program\include\rcube_db.inc (283):* DB Error: unknown error Query: INSERT INTO users (created, last_login, username, mail_host, alias, language) VALUES (now(), now(), 'Roland', 'xmail.cc', '', 'de') [nativecode=1364 ** Field 'preferences' doesn't have a default value] *PHP Error in d:\webserver\roundcube\program\include\main.inc (448):* Failed to create new user I hope you can help me on this. Thanks in advance, Roland

1 1

Fresh installation on Windows: Corrupted HTML
by Roland Müller 17 Dec '05

17 Dec '05

Hello, I have installed RoundCube on Windows with MySQL 5.0 and PHP 5.1.1. Everything seems to be configured correctly. When I point my browser to the roundcube address, I am getting corrupted HTML. The HTML-source starts with: #login-form { margin-left: auto; margin-right: auto; margin-top: 50px; width: 350px; } .. As you can see, the <html>, <head> and some other tags are missing, so that the page cannot be rendered by any browser. After that style-definition, everything seems to be correct. Does anyone have an idea what's wrong and how I can fix this? Thank you in advance, Roland

1 0

Spam Assassin & public folders
by Nathan Monk 17 Dec '05

17 Dec '05

Hi all Two ideas that might find some traction. A button to make message as spam (cound invoke a the sa-learn command) and the second is a question is there a way to have a public folder also displayed? I have an IMAP Spam folder that users drag spam messages into. It would be grat to have this listed as well. Great software Nathan

1 0

webmail
by Andrew Croft 17 Dec '05

17 Dec '05

Hello, I make everything like on docs, and now my server show me this message: Fatal error: Call to undefined function preg_replace() in /var/www/localhost/htdocs/westernlux.com/program/include/main.inc on line 37 What is can be wrong? Thanks andrew

4 3

Fwd: Page Down, Page Up don't work
by Craig Webster 17 Dec '05

17 Dec '05

I think this one was meant for the list. Begin forwarded message: > From: Carey Drake <carey.drake(a)gmail.com> > Date: 17 December 2005 02:36:44 GMT > To: Craig Webster <craig(a)xeriom.net> > Subject: Re: [RoundCube Dev] Page Down, Page Up don't work > > On 12/16/05, Craig Webster <craig(a)xeriom.net> wrote: > On 16 Dec 2005, at 17:48, Thomas Bruederli wrote: > > This is because it's not a window or a frame but a DIV that > > scrolls. It depends on the browser you're using if it supports > > scrolling by keyboard and mouse scroll wheel. > > Can we perhaps capture these events with onClick and onKeypress > events? I'll have a go at doing this tomorrow if no one fancies a > try tonight. > > I had similar problems with Firefox 1.0.x, but FF 1.5 appears to > fix this. > > C. > Yours, Craig -- Craig Webster | t: +44 (0)131 516 8595 | e: craig(a)xeriom.net Xeriom.NET | f: +44 (0)709 287 1902 | w: http://xeriom.net

1 1

Page Down, Page Up don't work
by Martin Marques 16 Dec '05

16 Dec '05

Is something wrong with the message body box. When I select a message to see I can't scroll up or down with the page up and page down keys (arrows don't work else). I have to use the mouse scroll. Is this normal? 18:02:25 up 4 days, 9:57, 5 users, load average: 1.59, 1.57, 1.62 --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------

4 4

trash can and messages count not updating on delete
by Shaun Lloyd 16 Dec '05

16 Dec '05

l deleted contents on inbox/sent folder then deleted trash folder. However the trash (count) still showed a number and the messages count top right still showed a count as well.

1 0

Major updates - testing required
by Thomas Bruederli 16 Dec '05

16 Dec '05

Hi everybody After two days of intensive coding (now my girlfriend is offended) I finally rebuilt the caching mechanism which caused many problems and performance issues. Therefore a new database table (messages) was created. There also have been minor changes to the database so please check the SQL scripts. Together with the new caching process, server side sorting was also implemented. When showing the message list, only one page is retrieved from the server and cached.The message cache is complete, after every page has been loaded once. After that, RC attempts just to synchronize the changes. Even if the cache is not complete the loading time should decrease since there's only the message index transmitted and already cached headers will not be reloaded. For further development I will try to start a child process to fetch all message headers in the background but not making the interface wait for it. The new caching implementation is not tested well and that's why I would like the experienced RoundCube administrators and developers to try out the latest CVS. Because the public CVS repository updates several hours or days later, I added a snapshot here: http://prdownloads.sourceforge.net/roundcubemail/roundcubemail-cvs-20051203… I also reworked the database class and tested RoundCube with MySQL, SQLite and Postgres. All initial SQL scripts have been updated and RC should now work correctly with Postgres. Probably there could be some optimization with Postgres but I'm not very familiar with it. For all Postgres users out there, please test RoundCube and don't hesitate to post bugs or suggestions here. Last but not least, I have included the patch for signatures (thanks Craig) and added a drop-down with a charset selection when composing a message. I know that there are still some issues with character encoding especially when getting things over XMLHTTP. Well, that's it for the moment. Next I'll take care of the message searching functionality and after that I think we're ready for an official Beta release. Thanks for your patience! Thomas P.S. The MDB2 implementation is currently broken and the library is not included in the package.

21 42

Patch for default from_domain (via server variable)
by Shane R. Spencer 16 Dec '05

16 Dec '05

My users unfortunately would be sending email as username@localhost for a good 10 years before they read my email saying "Set up your identity so you don't look like an idiot". Either way I developed a small patch that creates the global config variable "from_domain" and is set to the servers variable MAILDOMAIN as in this example: <VirtualHost *> .. SetEnv MAILDOMAIN mydomain.com .. </VirtualHost> this modifies only the email portion of the identity creation functions, if no MAILDOMAIN it will revert to the default behaviour. Is this just a fixup in what would be a large patchset for better vhost setups? hopefully.

3 2

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Dev