Aori Nevo

Hi asimjaved,

That hack is old and probably will only work for much earlier versions of the plugin. Let me see what all needs to be changed to get it to work again.

Regards,
Aori Nevo

Beer is much appreciated ??

Fixed in v4.0.7

Thank you for bringing this to our attention.

Hi mrcharlesmy,

Disregard my last message. It seems that you have to force the database upgrade in Database.php as was done here https://www.ads-software.com/support/topic/warnings-on-activate?replies=3.

Regards,
Aori Nevo

The errors you are experiencing, or others like them, may persist even after manually adding the required tables.

Such issues in the past were related to the hosting provider and/or a multisite installation of WordPress. This might be the case here. If you are willing to add me as a user to your site, I can try to troubleshoot further. You can send login credentials through here https://www.angradebook.com/contact-us/.

If you would like to try to add the tables and options manually, a description of the relevant database items follows. There are 4 tables that need to be added to the wordpress database and two options that need to be added to wp_options.

TABLES:
1) an_gradebook_courses
id int(11) NOT NULL AUTO_INCREMENT,
name MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
school TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
semester TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
year int(11) NOT NULL,
PRIMARY KEY (id)

2) an_gradebook_users
id int(11) NOT NULL AUTO_INCREMENT,
uid int(11) NOT NULL,
gbid int(11) NOT NULL,
role VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT “student”,
PRIMARY KEY (id)

3) an_gradebook_assignments
id int(11) NOT NULL AUTO_INCREMENT,
gbid int(11) NOT NULL,
assign_order int(11) NOT NULL,
assign_name mediumtext NOT NULL,
assign_category mediumtext NOT NULL,
assign_visibility VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT “Students”,
assign_date DATE NOT NULL DEFAULT “0000-00-00”,
assign_due DATE NOT NULL DEFAULT “0000-00-00”,
PRIMARY KEY (id)

4) an_gradebook_cells
id int(11) NOT NULL AUTO_INCREMENT,
uid int(11) NOT NULL,
gbid int(11) NOT NULL,
amid int(11) NOT NULL,
assign_order int(11) NOT NULL,
assign_points_earned decimal(7,2) NOT NULL,
PRIMARY KEY (id)

we_options
1) an_gradebook_db_version 3.2
2) an_gradebook_settings a:3:
{s:6:”editor”;s:4:”true”;s:6:”author”;s:4:”true”;s:13:”administrator”;b:1;}

Who is your hosting provider?

Are you able to check what tables have been added to the wordpress database? This is usually done through phpmyadmin.

Since it is a fresh install, I recommend uninstalling the plugin completely and then reinstall. Let us see if the problem persists.

Looks like you are missing the an_gradebook_courses table. The plugin creates this table for you on install. Are you upgrading from an older version or is this a fresh install?

Click on the last xhr request from an-gradebook and the window the displays the content select the Preview tab. Send me a screenshot.

Hi mrcharlesmy,

I can’t reproduce the error on my end.

Can you send more screenshots with the network tab selected? Perhaps an ajax call is failing.

Regards,
Aori Nevo

Hi jturet,

This warning is usually attributed to a missing an options name/value in the wp_options table, most likely the an_gradebook_settings option.

To troubleshoot, uncomment line 7 in plugins/an-gradebook/database/Database.php. That is, replace

//add_action('plugins_loaded', array($this,'an_gradebook_upgrade_db'));

with

add_action('plugins_loaded', array($this,'an_gradebook_upgrade_db'));

Reload your page and navigate to your gradebook. If the error is gone, then you didn’t have the an_gradebook_settings option in your wp_options table. The above fixes this issue.

Now edit Database.php again, commenting out line 7.

Regards,
Aori Nevo

This was added in v4.0.2.

Hi Juseco1994,

We have not added an import function, but we are working on it.

Regards,
Aori Nevo

Hi juseco1994,

With the exception of adding a column for student averages and a row for assignment averages, you should be able to do this. Are you Having issues with the plugin?

Regards,
Aori Nevo

Hi spencer876,

This might be an issue that arises when you are using a legacy web server that does not support PUT requests.

To test that this is actually the case, edit the plugin’s Course.php file located under the an-gradebook directory (an-gradebook/database/Course.php). Set the $an_gradebook_develop variable to true.

Now edit an-gradebook-app.js, also located under the an-gradebook directory (an-gradebook/an-gradebook-app.js), and replace these two lines

require(['jquery','app/router/GradeBookRouter','bootstrap'],
	function($,GradeBookRouter,bootstrap){

with

require(['jquery','app/router/GradeBookRouter','bootstrap','backbone'],
	function($,GradeBookRouter,bootstrap,Backbone){
	       Backbone.emulateHTTP = true;

Now try to enter grades as before. If the grades persist on page refresh, then your web server does not support PUT requests and this provides a fix.

Regards,
Aori Nevo