I'm trying to upgrade our 0.3.1 installation to 0.4.2.
When I execute the following SQL upgrade lines, I get the errors that
follow them:
mysql> ALTER TABLE `contacts` ADD CONSTRAINT `user_id_fk_contacts`
FOREIGN KEY (`user_id`)
-> REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ERROR 1452 (23000): Cannot add or update a child row: a foreign key
constraint fails (`pis_roundcube/#sql-36e8_638`, CONSTRAINT
`user_id_fk_contacts` FOREIGN KEY (`user_id`) REFERENCES `users`
(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE)
mysql> ALTER TABLE `identities` ADD CONSTRAINT `user_id_fk_identities`
FOREIGN KEY (`user_id`)
-> REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
ERROR 1452 (23000): Cannot add or update a child row: a foreign key
constraint fails (`pis_roundcube/#sql-36e8_638`, CONSTRAINT
`user_id_fk_identities` FOREIGN KEY (`user_id`) REFERENCES `users`
(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE)
The first 2 ALTER TABLE commands work OK, and I've verified all tables
have been changed to InnoDB. Any ideas on how to get this to work?
Alternately, is there a good way to import data from an existing older
roundcube MySQL database into a fresh, up-to-date one?
Thanks!
- John
--
-------------------------------------------------------------------
John May : President http://www.pointinspace.com/
Point In Space Internet Solutions jmay(a)pointinspace.com
Twitter: http://twitter.com/pointinspace/
Facebook: http://www.facebook.com/PointInSpace/
Professional FileMaker Pro, MySQL, PHP & Lasso Hosting
on shared, virtual and hardware dedicated servers
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Dear all,
My RC use PLAIN mechanism for IMAP athentication. And it use default
(non-SSL) IMAP port 143.
While log in, I captured the information by WireShark then I could see the
usename and password, warped in a HTTP POST.
If I change to use SSL with IMAP,
$rcmail_config['default_host'] = 'ssl://mail.mysite.com';
$rcmail_config['default_port'] = 993;
I still can capture my Username/ Password. So I think the SSL authentication
is just from RC to IMAP server. Not from my PC to RC server.
I know if I'm using HTTPS, the information send from my PC to HTTP server
will be encrypted.
Is there anyway to encrypt the login session from my PC to the RC server,
except using HTTPS? I mean the encryption supported inside RC login page.
Many thanks/ Minh.
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi friends,
i need to insert an message before the user text on e-mail, this insert must
have webmail user full name, server date and hour and my companhy logo, i
really dunno how to do this, can someone help me?
thanks a lot
Harlei
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hi,
I just installed version 0.5 beta and when i want to add new
folder for subscription RC respons with an error.
Unfortunately the
folder is not Subscribed
Thenks
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
--
Scott Berry
MCP and A Plus Certified
Hello there,
My name is Scott Berry and I am totally blind. I am setting up Round
Cube the latest stable version. When I go in to my roundcube installer
it tells me that date.timezone is not set. Here is the steps I took
to set it:
1. I opened php.ini.
2. I found the date.timezone = directive and added America/Chicago.
so my directive looks like this:
date.timezone = America/Chicago
Is this good enough or am I missing something? Thanks for all the help.
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hello,
it's not posible for me to save the following e-mail-adress in the
adressbook and it's not posible to send a mail to this address:
Schmidt-K.(a)gmx.de
O.K. I'm honest - I've changed to letters (for this mailing). ;-)
Best regards from germany
Ulli Heist
P.S.: Is a working bookmark-tool available?
--
http://heist.hobby-site.org/witze
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hello Roundcube users
We're happy to announce that a new major release of Roundcube is now
available for testing. As usual it contains many bugfixes (thanks to
all the reporters and contributers) and brings more stability and
speedup as well as some new features such as Internationalized Domain
Name (IDNA) support, support for shared/global IMAP folders and
support for SMTP Delivery Status Notifications. Plus some minor
changes to the message list UI and many improvements under the hood.
Download the 0.5-beta release now from http://roundcube.net/download
and test it in your local environments. Any bug reports and
suggestions for improvements are welcome.
Along with the new features again new texts are waiting to be
translated. All non-english natives are kindly requested to help us
translate Roundcube. Go to http://translator.roundcube.net, select
your language and fill in the missing labels and messages. Completed
files can be posted to our dev mailing list.
As you can see on the translator page, there are several translations
with less than 50% completeness status. We'll have to remove them from
future releases if they're not kept up-to-date.
Thanks for using Roundcube and for contributing to this great project!
Best regards,
Thomas
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hello,
I would like to ask if there is any way to set auto logout after some time
of user inactivity?
I've tried to set *keep_alive to greater value than session_timeout, but
this doesn't work.
Many thanks in advance
Regards,
Radovan
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e
Hello,
I am a subscriber of Roundcube webmail. I have recently configured roundcube with vpopmail on qmail. Unfortunately, I am facing one problem which the roundcube's password plugin. How will I configure roundcube's password plugin with vpopmail?
Below is my problem's detailed info :
1. I have configured vpopmail with mysql on qmail.
2. I have activated vpopmail's password plugin
But,
When I create new domain on vpopmail, that domain name creates following format on mysql. Example : test.com = test_com
I have configured the password plugin by below query.
UPDATE %d SET pw_passwd=%c, pw_clear_passwd=%p WHERE pw_name=%l LIMIT 1';
above %d is domain part of user. E.g test.com, but my created table name is=
test_com
How can I fix this problem pls????
_______________________________________________
List info: http://lists.roundcube.net/users/
BT/9b404e9e