aC forum: Error when updating / changing an email address http://www.activecollab.com/forums/topic/34/ Recent posts on topic: Error when updating / changing an email address en-us Sun, 23 Nov 2008 11:36:57 UTC http://www.activecollab.com/forums/post/635/#post635 http://www.activecollab.com/forums/post/635/#post635 Post #2 by shaunw shaunw Hello Clonk I used youe walk around for the "Failed to import database construction..." error ... and it worked like a charm... however i think we both forgot to run the mysql_initial_data.php file that loads all the options. I ran the queries on that page and everything worked fine.

* dont forget to replace all " <?= $table_prefix ?> " with " ac_ " or whatever prefix you used for the tables.

mysql_initial_data.php:
INSERT INTO `<?= $table_prefix ?>config_options` (`id`, `name`, `cast_function`, `value`) VALUES (1, 'project logs per page', 'intval', '10');;
INSERT INTO `<?= $table_prefix ?>config_options` (`id`, `name`, `cast_function`, `value`) VALUES (2, 'messages per page', 'intval', '5');;
INSERT INTO `<?= $table_prefix ?>config_options` (`id`, `name`, `cast_function`, `value`) VALUES (3, 'max_avatar_width', 'intval', '50');;
INSERT INTO `<?= $table_prefix ?>config_options` (`id`, `name`, `cast_function`, `value`) VALUES (4, 'max_avatar_height', 'intval', '50');;
INSERT INTO `<?= $table_prefix ?>config_options` (`id`, `name`, `cast_function`, `value`) VALUES (5, 'max_avatar_size', 'intval', '20');;
INSERT INTO `<?= $table_prefix ?>config_options` (`id`, `name`, `cast_function`, `value`) VALUES (6, 'logs per project', 'intval', '5');;
INSERT INTO `<?= $table_prefix ?>config_options` (`id`, `name`, `cast_function`, `value`) VALUES (7, 'service name', 'trim', 'activeCollab');;
INSERT INTO `<?= $table_prefix ?>config_options` (`id`, `name`, `cast_function`, `value`) VALUES (8, 'service email', 'trim', 'taus@ilija.biz');;
INSERT INTO `<?= $table_prefix ?>config_options` (`id`, `name`, `cast_function`, `value`) VALUES (9, 'max_logo_width', 'intval', '50');;
INSERT INTO `<?= $table_prefix ?>config_options` (`id`, `name`, `cast_function`, `value`) VALUES (10, 'max_logo_height', 'intval', '50');;
INSERT INTO `<?= $table_prefix ?>config_options` (`id`, `name`, `cast_function`, `value`) VALUES (11, 'max_logo_size', 'intval', '20');;
INSERT INTO `<?= $table_prefix ?>config_options` (`id`, `name`, `cast_function`, `value`) VALUES (12, 'site_name', '', 'activeCollab');;

INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (1, 'zip', 'archive.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (2, 'rar', 'archive.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (3, 'bz', 'archive.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (4, 'bz2', 'archive.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (5, 'gz', 'archive.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (6, 'ace', 'archive.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (7, 'mp3', 'audio.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (8, 'wma', 'audio.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (9, 'ogg', 'audio.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (10, 'doc', 'doc.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (11, 'xsl', 'doc.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (12, 'gif', 'image.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (13, 'jpg', 'image.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (14, 'jpeg', 'image.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (15, 'png', 'image.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (16, 'mov', 'mov.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (17, 'pdf', 'pdf.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (18, 'psd', 'psd.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (19, 'rm', 'rm.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (20, 'svg', 'svg.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (21, 'swf', 'swf.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (22, 'avi', 'video.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (23, 'mpeg', 'video.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (24, 'mpg', 'video.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (25, 'qt', 'mov.png');;
INSERT INTO `<?= $table_prefix ?>file_types` (`id`, `extension`, `icon`) VALUES (26, 'vob', 'video.png');;

INSERT INTO `<?= $table_prefix ?>im_types` (`id`, `name`, `icon`) VALUES (1, 'ICQ', 'icq.gif');;
INSERT INTO `<?= $table_prefix ?>im_types` (`id`, `name`, `icon`) VALUES (2, 'AIM', 'aim.gif');;
INSERT INTO `<?= $table_prefix ?>im_types` (`id`, `name`, `icon`) VALUES (3, 'MSN', 'msn.gif');;
INSERT INTO `<?= $table_prefix ?>im_types` (`id`, `name`, `icon`) VALUES (4, 'Yahoo!', 'yahoo.gif');;

]]> Tue, 11 Jul 2006 15:19:04 UTC http://www.activecollab.com/forums/post/122/#post122 http://www.activecollab.com/forums/post/122/#post122 Post #1 by clonk clonk On this page:

http://activecollab.orajen.local/index.php?c=account&a=edit_profile&active_project=1

When I attempt to edit my email address and hit submit I recieve this error:

Warning: Invalid argument supplied for foreach() in C:\Inetpub\activeCollab\application\controllers\AccountController.class.php on line 85

Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\activeCollab\application\controllers\AccountController.class.php:85) in C:\Inetpub\activeCollab\environment\functions\general.php on line 242

The email address does infact update though. email address and display name were the only 2 fields with values. The email address was properly formed.

]]> Fri, 07 Jul 2006 21:28:58 UTC