Installer breaks on me. Can I somehow manually install activeCollab?
Page: 1
Ilija Studen
on Mar 29. 2007. 3:14 pm
Q: Installer breaks on me. Can I somehow manually install activeCollab?
A: Yes, you can. Here are the instructions:
1. Create a new database for activeCollab.
2. Get consturction.sql and initial_data.sql SQL files and execute them (construction first, initial second).
2. Use empty_config.php (in /config), rename it to config.php and set properties. Note that in this case table prefix need to be 'pm_'. Also, PRODUCT_VERSION should '0.7.1'.
3. On first run you should be able to create administrator account and owner company.
A: Yes, you can. Here are the instructions:
1. Create a new database for activeCollab.
2. Get consturction.sql and initial_data.sql SQL files and execute them (construction first, initial second).
2. Use empty_config.php (in /config), rename it to config.php and set properties. Note that in this case table prefix need to be 'pm_'. Also, PRODUCT_VERSION should '0.7.1'.
3. On first run you should be able to create administrator account and owner company.
activeCollab team member
Ilija Studen
on Apr 23. 2007. 4:29 am
It looks like that. My other sites hosted on the same server are down too. Sorry :'(
activeCollab team member
Holy hell I am SUCH a SQL/PHP newbie.
1. Which directory do I put these files in so I can "execute them"??
2. "Use empty_config.php (in /config), rename it to config.php and set properties. Note that in this case table prefix need to be 'pm_'. Also, PRODUCT_VERSION should '0.7.1'."
What?
1. Which directory do I put these files in so I can "execute them"??
2. "Use empty_config.php (in /config), rename it to config.php and set properties. Note that in this case table prefix need to be 'pm_'. Also, PRODUCT_VERSION should '0.7.1'."
What?
Ilija Studen
on May 20. 2007. 8:45 am
Hi Jessica,
1. You can put SQL files anywhere on you disk. Most probably you will be using phpMyAdmin to import SQL files. Simply select Import tab and in File to import section select SQL file from this and submit form. Note that you need to import construction.sql and after that initial_data.sql
2. In /config folder there are two important files - config.php (main config) and empty_config.php (dummy config file, used as a template when you need to manually set configuration). Basically you:
* delete config.php
* rename empty_config.php to config.php
* open it in any text editors
* change the values inside
Have fun!
1. You can put SQL files anywhere on you disk. Most probably you will be using phpMyAdmin to import SQL files. Simply select Import tab and in File to import section select SQL file from this and submit form. Note that you need to import construction.sql and after that initial_data.sql
2. In /config folder there are two important files - config.php (main config) and empty_config.php (dummy config file, used as a template when you need to manually set configuration). Basically you:
* delete config.php
* rename empty_config.php to config.php
* open it in any text editors
* change the values inside
Have fun!
activeCollab team member
I contacted my tech support team that hosts my website and they said the following:
"It appears that there is an error in their SQL file used to create the database.
I tried their manual process and got-
ERROR 1064 at line 19: 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 default \'\',
"
Any ideas?
"It appears that there is an error in their SQL file used to create the database.
I tried their manual process and got-
ERROR 1064 at line 19: 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 default \'\',
"
Any ideas?
Ilija Studen
on May 26. 2007. 8:49 am
Can you ask them what version of MySQL they host? Requirement for activeCollab is MySQL 4.1 with InnoDB support.
activeCollab team member
Hi Ilija
RE: step 2(b) - there is no 'PRODUCT_VERSION' in the empty.config.php. Need to manually add that whole line.
That is:
define('PRODUCT_VERSION', '0.7.1'); // for the newbs :)
I am having issues with accessing http://www.activecollab.com/versions.xml (think coz I am behind a firewall) :( Think I'll either have to hack that code out or download the XML file somewhere and read from it... bit pointless thoughm if it is an RSS feed of some sort. Oh well {:)
RE: step 2(b) - there is no 'PRODUCT_VERSION' in the empty.config.php. Need to manually add that whole line.
That is:
define('PRODUCT_VERSION', '0.7.1'); // for the newbs :)
I am having issues with accessing http://www.activecollab.com/versions.xml (think coz I am behind a firewall) :( Think I'll either have to hack that code out or download the XML file somewhere and read from it... bit pointless thoughm if it is an RSS feed of some sort. Oh well {:)
Ilija Studen
on Sep 14. 2007. 5:29 am
brisnicki, just disable update check in configuration and activeCollab will not try to read versions.xml any more.
activeCollab team member
Topic is locked. If you have something important to say about issues discussed on this page please write at hi@a51dev.com.



