aC forum: Serious problem installing activeCollab http://www.activecollab.com/forums/topic/2942/ Recent posts on topic: Serious problem installing activeCollab en-us Fri, 21 Nov 2008 00:58:05 CST http://www.activecollab.com/forums/post/14395/#post14395 http://www.activecollab.com/forums/post/14395/#post14395 Post #11 by Castor33 Castor33
Ilija Studen:
It depends under which user PHP is running. 777 is the safest bet...


That did it! Thanks a lot man!

]]> Wed, 13 Aug 2008 13:35:22 CDT http://www.activecollab.com/forums/post/14394/#post14394 http://www.activecollab.com/forums/post/14394/#post14394 Post #10 by Ilija Studen Ilija Studen It depends under which user PHP is running. 777 is the safest bet...

]]> Wed, 13 Aug 2008 13:16:32 CDT http://www.activecollab.com/forums/post/14392/#post14392 http://www.activecollab.com/forums/post/14392/#post14392 Post #9 by Castor33 Castor33
Ilija Studen:
Make sure that /config folder is writable by PHP. Although installer says it is writable you should double check folder permissions. That is the most common cause of this type of error.


Will CHMOD 775 to/config fix this?

]]> Wed, 13 Aug 2008 13:02:27 CDT http://www.activecollab.com/forums/post/14389/#post14389 http://www.activecollab.com/forums/post/14389/#post14389 Post #8 by Ilija Studen Ilija Studen Make sure that /config folder is writable by PHP. Although installer says it is writable you should double check folder permissions. That is the most common cause of this type of error.

]]> Wed, 13 Aug 2008 11:45:40 CDT http://www.activecollab.com/forums/post/14388/#post14388 http://www.activecollab.com/forums/post/14388/#post14388 Post #7 by Castor33 Castor33 Ok. Our client finally upgraded their servers. I run the installer again and get this:

ok — Database connection has been established successfully
warning — InnoDB storage engine is not supported (recommended)
ok — Tables created in 'acdb'. (Executed queries: 27)
ok — Initial data imported into 'acdb'. (Executed queries: 8)
ok — Owner company created
ok — Administrator account created
error — Failed to write config data into config file

I've spoken with them and they'll enable InnoDB today. I'll give it another try, but what worries me is the "failed to write" error. The server is running PHP 4.3.9. Any ideas?

]]> Wed, 13 Aug 2008 11:11:40 CDT http://www.activecollab.com/forums/post/13704/#post13704 http://www.activecollab.com/forums/post/13704/#post13704 Post #6 by Ilija Studen Ilija Studen Please send your FTP and database connection parameters to support@a51dev.com and we'll install activeCollab for you.

Also, please tell us which user is owner of your license so we can get license file (there is no licenses attached to your profile).

]]> Fri, 04 Jul 2008 12:57:53 CDT http://www.activecollab.com/forums/post/13703/#post13703 http://www.activecollab.com/forums/post/13703/#post13703 Post #5 by Castor33 Castor33
Ilija Studen:
MySQL 4.0 does not support field collation. activeCollab installer should detect this and properly prepare queries, but from some reason it doesn't. To fix this open /public/installer/library/Installation.class.php and find this block of code (around like 228):

$mysql_version = mysql_get_server_info($this->database_connection);
if($mysql_version && version_compare($mysql_version, '4.1', '>=')) {
  $this->default_collation = 'utf8_unicode_ci';
  $this->default_charset = 'utf8';
  
  $constants['DB_CHARSET'] = 'utf8';
  
  @mysql_query("SET NAMES 'utf8'", $this->database_connection);
  
  $tpl->assign('default_collation', 'collate ' . $this->default_collation);
  $tpl->assign('table_collation', 'COLLATE=' . $this->default_collation);
  $tpl->assign('default_charset', 'DEFAULT CHARSET=' . $this->default_charset);
} else {
  $constants['DB_CHARSET'] = null;
  
  $tpl->assign('default_collation', '');
  $tpl->assign('table_collation', '');
  $tpl->assign('default_charset', '');
} // if


Replace it with:

$mysql_version = mysql_get_server_info($this->database_connection);

$constants['DB_CHARSET'] = null;
  
$tpl->assign('default_collation', '');
$tpl->assign('table_collation', '');
$tpl->assign('default_charset', '');


and run installer again. Please let me know how it went.

PS: If upgrade to MySQL5 is an option please consider it. While activeCollab will work on earlier versions having latest stable version of DB is always a good thing.



Allright, this is the error I now get:

* ok — Database connection has been established successfully
* ok — InnoDB storage engine is supported

* error — SQL error: CREATE TABLE `acx_time_reports` ( `id` smallint(5) unsigned NOT NULL auto_increment, `name` varchar(50) collate utf8_unicode_ci NOT NULL, `group_name` varchar(50) collate utf8_unicode_ci NOT NULL, `is_default` tinyint(1) unsigned NOT NULL, `user_filter` enum('anyone','logged_user','company','selected') collate utf8_unicode_ci NOT NULL default 'anyone', `user_filter_data` text collate utf8_unicode_ci, `billable_filter` enum('all','billable','not_billable','billable_billed','billable_not_billed') collate utf8_unicode_ci NOT NULL default 'all', `date_filter` enum('all','today','last_week','this_week','last_month','this_month','selected_date','selected_range') collate utf8_unicode_ci NOT NULL default 'all', `date_from` date default NULL, `date_to` date default NULL, `sum_by_user` tinyint(1) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB

* error — Failed to import database construction. MySQL said: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate utf8_unicode_ci NOT NULL, `group_name` varchar(50) co


Could it be related to en encoding method used by the MySQL server?

]]> Fri, 04 Jul 2008 12:47:05 CDT http://www.activecollab.com/forums/post/13700/#post13700 http://www.activecollab.com/forums/post/13700/#post13700 Post #4 by Ilija Studen Ilija Studen MySQL 4.0 does not support field collation. activeCollab installer should detect this and properly prepare queries, but from some reason it doesn't. To fix this open /public/installer/library/Installation.class.php and find this block of code (around like 228):

$mysql_version = mysql_get_server_info($this->database_connection);
if($mysql_version && version_compare($mysql_version, '4.1', '>=')) {
  $this->default_collation = 'utf8_unicode_ci';
  $this->default_charset = 'utf8';
  
  $constants['DB_CHARSET'] = 'utf8';
  
  @mysql_query("SET NAMES 'utf8'", $this->database_connection);
  
  $tpl->assign('default_collation', 'collate ' . $this->default_collation);
  $tpl->assign('table_collation', 'COLLATE=' . $this->default_collation);
  $tpl->assign('default_charset', 'DEFAULT CHARSET=' . $this->default_charset);
} else {
  $constants['DB_CHARSET'] = null;
  
  $tpl->assign('default_collation', '');
  $tpl->assign('table_collation', '');
  $tpl->assign('default_charset', '');
} // if


Replace it with:

$mysql_version = mysql_get_server_info($this->database_connection);

$constants['DB_CHARSET'] = null;
  
$tpl->assign('default_collation', '');
$tpl->assign('table_collation', '');
$tpl->assign('default_charset', '');


and run installer again. Please let me know how it went.

PS: If upgrade to MySQL5 is an option please consider it. While activeCollab will work on earlier versions having latest stable version of DB is always a good thing.

]]> Fri, 04 Jul 2008 06:30:25 CDT http://www.activecollab.com/forums/post/13699/#post13699 http://www.activecollab.com/forums/post/13699/#post13699 Post #3 by Castor33 Castor33
Ilija Studen:
What version of MySQL are you using? You can see it in your phpMyAdmin (outlined on the screenshot attached to this message).


The server's running 4.0.27-standard.

]]> Fri, 04 Jul 2008 06:25:47 CDT http://www.activecollab.com/forums/post/13691/#post13691 http://www.activecollab.com/forums/post/13691/#post13691 Post #2 by Ilija Studen Ilija Studen What version of MySQL are you using? You can see it in your phpMyAdmin (outlined on the screenshot attached to this message).

]]> Fri, 04 Jul 2008 02:08:58 CDT