Installer breaks on me. Can I somehow manually install activeCollab?

This topic is locked, no new messages can be posted
avatar Ilija Studen Staff Mar 29. 2007. 10:14 am #1
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.
Follow @activecollab and activeCollab on Facebook.
avatar Apr 22. 2007. 10:07 pm #2
seems like yer SVN is busted just when i need it :/
avatar Ilija Studen Staff Apr 22. 2007. 11:29 pm #3
It looks like that. My other sites hosted on the same server are down too. Sorry :'(
Follow @activecollab and activeCollab on Facebook.
avatar May 19. 2007. 9:53 pm #4
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?
avatar Ilija Studen Staff May 20. 2007. 3:45 am #5
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!
Follow @activecollab and activeCollab on Facebook.
avatar May 25. 2007. 3:46 pm #6
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?
avatar Ilija Studen Staff May 26. 2007. 3:49 am #7
Can you ask them what version of MySQL they host? Requirement for activeCollab is MySQL 4.1 with InnoDB support.
Follow @activecollab and activeCollab on Facebook.
avatar brisnicki Sep 13. 2007. 8:08 pm #8
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 {:)
avatar Ilija Studen Staff Sep 14. 2007. 12:29 am #9
brisnicki, just disable update check in configuration and activeCollab will not try to read versions.xml any more.
Follow @activecollab and activeCollab on Facebook.

Topic is locked

If you have something important to say about the issues discussed in this post please write at hi@a51dev.com.