1

(5 replies, posted in Installation)

Hi Rod,
           no the problem is that the database schema has changed between when the chart of accounts was dumped and the latest versions of frontaccount. After yesterday I found some more problems. I think the best bet is to downgrade frontaccount to the same version of the chart of accounts, install and then upgrade. I notice though that the Australian service accounts have now disappeared from the website.

Cheers Paul

2

(5 replies, posted in Installation)

Hi Rod,
           sorry to take so long to respond. I have been side tracked looking at calendaring software. I am attempting to use the australian service accounts v2. These don't appear to have changed from the ones I initially tried and are still causing the same problem. The australian 0000 chart of accounts appear to also have not been changed.

However I think I now have an answer to the problem. Documented here for others with this problem.

Take the en_US-new.sql script that is sitting int he sql directory in the frontaccount directory tree, and copy across the create users table and insert data for users. Also copy across the inserts for the security roles.

The other thing that you need to do is to get a working user id. Open a mysql client as root (mysql -u root -p), use the database, and then copy the admin id across from the first company: insert into 9_users ( select * from 0_users where user_id="admin" );

It appears that between the creation of that accounts script and now the user table has changed due to a fundamental change in the way security is done.

Hopefully now it all works.

Cheers Paul

3

(5 replies, posted in Installation)

Hi,
     this is hard. I have got to the stage where i can install the training co and can create my company. I am creating my company by loading from the version 2 australian service script.

However when I logout and login again I get an error message

"Before software upgrade you have to include old $security_groups and $security_headings arrays from old config.php file to the new one.
Back"

This is on ubuntu 9.04 server. The FA directory tree is chown www-data:www-data and chmod 774

Any help gratefully received.

Cheers Paul