Gradebook tabs misalignment

[Keon Bobb]

All info under all tabs in Gradebook are misaligned and overlap each other.

SchoolTool versions

schooltool 2.8.4
schooltool.cando 2.8.2
schooltool.gradebook 2.8.4.1
schooltool.intervention 2.7.1
schooltool.lyceum.journal 2.8.2.1

[Douglas Cerna (replaceafill)]

A couple of questions:

1. Are you running SchoolTool on Ubuntu 14.04?

2. What's the ouput of:

$ apt-cache policy libjs-jquery

3. It seems like a problem with the JavaScript code that adjusts those widths. Check the JavaScript console of your web browser and paste any errors here.

[Keon Bobb (keon-bobb)]

1. It was upgraded to 16.04 LTS

2. Output Below

libjs-jquery:
  Installed: 1.11.3+dfsg-4
  Candidate: 1.11.3+dfsg-4
  Version table:
 *** 1.11.3+dfsg-4 500
        500 http://tt.archive.ubuntu.com/ubuntu xenial/main i386 Packages
        100 /var/lib/dpkg/status

3. The issue happens to all our Schooltool users. We're using different browsers also. Chrome, firefox, and IE.

[Douglas Cerna (replaceafill)]

Right. Unfortunately SchoolTool is not supported in anything different than 14.04 at this point. The problem you're having is caused by the JavaScript code only working with jQuery 1.7.2

[Keon Bobb (keon-bobb)]

Since it cannot work on 16.04, i'm trying to migrate the database to another server. I've followed the instructions at http://book.schooltool.org/database.html but i'm getting a partial restore with a lot of data missing, i also cannot access schooltool folder to backup blobs. Is there another way to do this?

[Gediminas Paulauskas (menesis)]

To move everything to another server, you only need to copy /var/lib/schooltool/Data.fs and the /var/lib/schooltool/blobs/ directory. Cannot access? Prefix the command with sudo.

Example:
sudo tar cJf schooltool-data.tar.xz /var/lib/schooltool/Data.fs /var/lib/schooltool/blobs

# copy to another server, for example
scp schooltool-data.tar.xz another-server:/path

# login to another server, extract
tar xJf schooltool-data.tar.xz
# delete old data
sudo rm -rf /var/lib/schooltool
# move new data
sudo mv var/lib/schooltool /var/lib/
sudo chown schooltool.schooltool /var/lib/schooltool

Remember to stop schooltool before and start after changing data.

[Keon Bobb (keon-bobb)]

Thanks for the help everyone, the solution worked for the migration but now no there are no accounts listed under their rightful group. Teachers, students, etc. Is there any way to automate this?

[Keon Bobb (keon-bobb)]

guys we have an older export .xls file from a couple months back. This is the most up to date export we have. If we import this, will we lose the most recent data that wasn't backed up?