I am having several problems after attempting to upgrade from OJS 2.4.8.0 to OJS 3.0.0.
First, I attempted to use the first (non-Git) method of upgrading, but met with this error: My first experience and problems with Local installation of OJS 3.
Secondly, I attempted to use Git to clone OJS to a new subdomain (publications.sps.org.mt) but was unable to complete the upgrade due to duplicate table and entry errors (even after restoring the backup taken before anything was started).
Thirdly, I created a new database, imported the backup into it via phpmyadmin, and then attempted the upgrade using this database. It seemed to have worked, and the submissions page was now accessible. However… when I then attempted to view submissions, I could only see those submissions which my user account had submitted (as Editor), and when I attempted to go to the “Users” page I was met with this loading screen: http://puu.sh/r2gUN/81e62b29c3.png which never loads. The “Active” page is empty. http://puu.sh/r2h9p/8b2514d7b8.png
What can I do?
SOLUTION:
; Database connection character set
; Must be set to “Off” if not supported by the database server
; If enabled, must be the same character set as “client_charset”
; (although the actual name may differ slightly depending on the server)
connection_charset = utf8 (was set to Off)
; Database storage character set
; Must be set to “Off” if not supported by the database server
database_charset = utf8 (was set to Off)