hey there,
had the same problem here...
removing everything that was duplicate i ended up here:
# Database schema transformations executed (total queries: 44)
-- <?php echo $table_prefix ?> og_
-- <?php echo $default_charset ?> DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
-- <?php echo $default_collation ?> collate utf8_unicode_ci
-- <?php echo $engine ?> InnoDB
ALTER TABLE `<?php echo $table_prefix?>project_webpages` MODIFY COLUMN `description` text <?php echo $default_collation ?>;
ALTER TABLE `<?php echo $table_prefix ?>project_tasks` MODIFY COLUMN `from_template_id` int(10) NOT NULL default '0';
ALTER TABLE `<?php echo $table_prefix ?>project_milestones` MODIFY COLUMN `from_template_id` int(10) NOT NULL default '0';
ALTER TABLE `<?php echo $table_prefix ?>project_file_revisions` MODIFY COLUMN `type_string` varchar(255) <?php echo $default_collation ?> NOT NULL default '';
UPDATE `<?php echo $table_prefix?>project_events` `pe` SET
`start`=ADDDATE(`start`, INTERVAL (SELECT CONCAT('\'',-1*FLOOR(`timezone`),':',FLOOR(abs(`timezone`)%1)*60,'\'') FROM `<?php echo $table_prefix?>users` `u` WHERE `u`.`id` = `pe`.`created_by_id`) HOUR_MINUTE),
`duration`=ADDDATE(`duration`, INTERVAL (SELECT CONCAT('\'',-1*FLOOR(`timezone`),':',FLOOR(abs(`timezone`)%1)*60,'\'') FROM `<?php echo $table_prefix?>users` `u` WHERE `u`.`id` = `pe`.`created_by_id`) HOUR_MINUTE);
CREATE TABLE IF NOT EXISTS `<?php echo $table_prefix ?>reports` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(255) <?php echo $default_collation ?> NOT NULL,
`description` varchar(255) <?php echo $default_collation ?> NOT NULL,
`object_type` varchar(255) <?php echo $default_collation ?> NOT NULL,
`order_by` varchar(255) <?php echo $default_collation ?> NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=<?php echo $engine ?> <?php echo $default_charset ?>;
CREATE TABLE IF NOT EXISTS `<?php echo $table_prefix ?>report_columns` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`report_id` int(10) NOT NULL,
`custom_property_id` int(10) NOT NULL,
`field_name` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=<?php echo $engine ?> <?php echo $default_charset ?>;
CREATE TABLE IF NOT EXISTS `<?php echo $table_prefix ?>report_conditions` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`report_id` int(10) NOT NULL,
`custom_property_id` int(10) NOT NULL,
`field_name` varchar(255) <?php echo $default_collation ?> NOT NULL,
`condition` varchar(255) <?php echo $default_collation ?> NOT NULL,
`value` varchar(255) <?php echo $default_collation ?> NOT NULL,
`is_parametrizable` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=<?php echo $engine ?> <?php echo $default_charset ?>;
UPDATE `<?php echo $table_prefix ?>user_ws_config_options` SET `default_value` = '' WHERE `category_name` = 'general' AND `name` = 'localization';
UPDATE `<?php echo $table_prefix ?>user_ws_config_options` SET `default_value` = 1 WHERE `category_name` = 'general' AND `name` = 'rememberGUIState';
ALTER TABLE `<?php echo $table_prefix ?>custom_property_values` MODIFY COLUMN `value` text <?php echo $default_collation ?> NOT NULL;
-- larger contact fields
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `firstname` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `lastname` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `middlename` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `department` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `job_title` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `w_city` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `w_state` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `w_zipcode` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `w_country` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `w_phone_number` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `w_phone_number2` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `w_fax_number` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `w_assistant_number` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `w_callback_number` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `h_city` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `h_state` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `h_zipcode` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `h_country` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `h_phone_number` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `h_phone_number2` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `h_fax_number` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `h_mobile_number` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `h_pager_number` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `o_city` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `o_state` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `o_zipcode` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `o_country` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `o_phone_number` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `o_phone_number2` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>contacts` MODIFY COLUMN `o_fax_number` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>companies` MODIFY COLUMN `phone_number` varchar(50) <?php echo $default_collation ?> default NULL;
ALTER TABLE `<?php echo $table_prefix ?>companies` MODIFY COLUMN `fax_number` varchar(50) <?php echo $default_collation ?> default NULL;
it said it worked but i still dont get any content...
sad thing is i didnt do a database dump because the lastu update went that smoothly :S
I now only get the op lines:
Welcome back soomon (Logout) : Administration | Account | Help
and the bottom line:
© 2009 by soomon. All rights reserved
Powered by OpenGoo 1.4. 0.207s. 6.18MB
what to do now??
thanks & greets,
soomon