crash after patching to Sugar 4

[janislanka]

So, i just upgraded versions to 4 and it kept asking me about the timezone. And when clickign save, it just kept showing the same thing. Then goign somewhere else this message appears:

Error filling in user array: Query Failed:SELECT id, first_name, last_name, user_name from users WHERE is_group=0 order by user_name asc::MySQL error 1054: Unknown column 'is_group' in 'where clause'

I'm in a big trouble! help!

[janislanka]

I did a SQL manually and this is error now:

Sugar CRM 3.5.1d Files May Only Be Used With A Sugar CRM 3.5.1 Database.

help!?

[andrewb]

Do you have a database backup to do everything from scratch?
Sugar says you may only use upgrade wizard when upgrading. Manual does not work.
For the timezone thing, most of the times you need to logoff, close and open your browser and login again. Also check the timezone fix from the admin menu.

This message:
Sugar CRM 3.5.1d Files May Only Be Used With A Sugar CRM 3.5.1 Database.
says that your database is already 4.0 but files are still 3.5, so this needs to be fixed. Backup can help you to roll back and do it again.

[janislanka]

what if I manually change files? It will also not work?

Also, I couln't do anything after the frist error started to appear.

Error filling in user array: Query Failed:SELECT id, first_name, last_name, user_name from users WHERE is_group=0 order by user_name asc::MySQL error 1054: Unknown column 'is_group' in 'where clause'

Any link i clicked, it was the same error. So, i couldn't use repair functions or anything.

LATER NOTE:
I just but my DB back and it now shows the old error:

Error filling in user array: Query Failed:SELECT id, first_name, last_name, user_name from users WHERE is_group=0 order by user_name asc::MySQL error 1054: Unknown column 'is_group' in 'where clause'

What to do?

[janislanka]

ok, i solved the issue!
I manually upgraded MySQL db and then put a clean installation of sugar 4 files. Then reffered to the previous db and it works!