Hey guys,
I just deleted another 60 or so spam tickets. It's a pretty manual
process which requires three (3!) clicks per spam ticket. Any trac
gurus on this list that know how to secure a trac install? E.g. to
combat spam -- captcha, mod_security? I'm not sure what people run
nowadays.
Feedback appreciated!
Till
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
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/dev/
BT/aba52c80
Hi,
Here is the japanese translation for 0.4,
updated only labels.inc file.
---
Taka
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/TW/tRCC7F2H/0.4-ja-labels.tar.gz
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80
Hi,
attached (or rather detached) is the updated Lithuanian translation for
RoundCube.
By the way, are there any plans to support more than one plural forms,
e.g. by employing gettext?
Regards,
Rimas
--- 8< --- detachments --- 8< ---
The following attachments have been detached and are available for viewing.
http://detached.gigo.com/rc/sq/uvXd4uZY/Roundcube_lt.zip
Only click these links if you trust the sender, as well as this message.
--- 8< --- detachments --- 8< ---
_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80