Recent posts in this topic
Staff
Ilija Studen
on Jul 11. 2006. 8:55 am
Not recommended. SVN code has some parts that does not work (yet).
activeCollab Team Member
Staff
Ilija Studen
on Jul 11. 2006. 10:20 am
I had a choice when I was making 0.6:
1. to use SVN code and remove things that are new but incomplete or broken.
2. to use existing alpha package and replace files that are changed and don't break anything
I went for #2 because we needed to fix those installation problems ASAP and keep all the functions of alpha - for easy update etc. Sorry, future releases will be in sync with the repository, this one just needed to be available ASAP and not to break many things.
1. to use SVN code and remove things that are new but incomplete or broken.
2. to use existing alpha package and replace files that are changed and don't break anything
I went for #2 because we needed to fix those installation problems ASAP and keep all the functions of alpha - for easy update etc. Sorry, future releases will be in sync with the repository, this one just needed to be available ASAP and not to break many things.
activeCollab Team Member
It's OK, I just wouldn't like to go through the same process over and over again :) A oneliner in the shell is always a better solution :)
Installing this on a Windows 2000 box with WAMP (Apache 2, PHP 5, MySQL 5) and still get the following error on step 5:
* Connected to database as root@localhost
* Database 'collabDB' found
* 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 '<?= $default_charset ?>' at line 15
Click "Finish" and I get this on the next page:
Failed to load website. Owner company not found
Update: MySQL console is showing server version 5.0.22-community-nt
* Connected to database as root@localhost
* Database 'collabDB' found
* 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 '<?= $default_charset ?>' at line 15
Click "Finish" and I get this on the next page:
Failed to load website. Owner company not found
Update: MySQL console is showing server version 5.0.22-community-nt
Ilija Studen:For all of you who want to upgrade, please follow this routine:
1. Backup old files and data from database. Make two backups of DB data: structure + data and only data. First you'll need if something goes wrong and you need to revert back to alpha. Second you'll need to import in step 6.
2. Drop all activeCollab tables from database. Remember to backup first!
3. Upload 0.6 and rewrite old files with new ones.
4. Run the installer, same thing as the first time.
5. Select all tables and empty them. There is option in PHPMyAdmin or run TRUNCATE on all tables.
6. Import data from DB backup. Just the data, installer created the structure.
7. It shoud work. Go back to login screen.
That should do the trick. If anything goes wrong restore old files and data in database and we'll see what can be done.
Just updated successfully by following the steps above. Very simple and quick. I have not done much with PHP and MySQL personally, but this has been a breeze compared to what I thought it would involve.
chrislee:Just updated successfully by following the steps above. Very simple and quick. I have not done much with PHP and MySQL personally, but this has been a breeze compared to what I thought it would involve.
Please also post your server environment that you used for your succesfull install in this thread.
thanks
nils
I did have a bit of a problem with the update procedure. The procedure itself was fine, but some of the data had to be massaged. Specifically, as part of the backup of the data, several of the date fields were exported as NULL (i.e. completed_on for tasks that hadn't been completed yet), and importing that data back in produced a bunch of errors (i.e. field X cannot be NULL).
Environment is TextDrive shared hosting - the environment is good, all the latest components. I was using CocoaMySQL-SBG to import/export the data.
After massaging the NULLs, everything 'looks' ok, but I haven't done a detailed analysis.
Environment is TextDrive shared hosting - the environment is good, all the latest components. I was using CocoaMySQL-SBG to import/export the data.
After massaging the NULLs, everything 'looks' ok, but I haven't done a detailed analysis.
jflint:Installing this on a Windows 2000 box with WAMP (Apache 2, PHP 5, MySQL 5) and still get the following error on step 5:
* Connected to database as root@localhost
* Database 'collabDB' found
* 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 '<?= $default_charset ?>' at line 15
Click "Finish" and I get this on the next page:
Failed to load website. Owner company not found
Update: MySQL console is showing server version 5.0.22-community-nt
You probably have Short Tags disabled in php.ini, guess Ilija missed this one...
Staff
Ilija Studen
on Jul 11. 2006. 5:41 pm
Yes, I did. I don't know why because all other templates in that directory are OK. Gues Dreamweaver didn't like that one :)
Download the 0.6 community preview and try again. That template has been updated.
Download the 0.6 community preview and try again. That template has been updated.
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.
