DB Error: Unknown column 'primary_contact' in 'where clause

Due to failed the update from 3.1.1.4 to the latest version. now we are dancing problem. Some options are working and some are not working.

Authors’ names are not showing and even not going to the article pages.
here is below some errors

Screenshot 2020-08-11 at 5.34.34 AM.png

DB Error: Unknown column ‘primary_contact’ in ‘where clause’

ethod Application::getName() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/install/form/InstallForm.inc.php on line 149

Deprecated: Non-static method Application::getName() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/install/form/InstallForm.inc.php on line 151

Deprecated: Non-static method Application::getName() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/install/form/InstallForm.inc.php on line 153

Deprecated: Non-static method VersionCheck::getCurrentCodeVersion() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/install/form/MaintenanceForm.inc.php on line 37

Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 369

Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592

Hi @Rohaan123,

It sounds like you tried to upgrade to OJS 3.2.1-1 but ran into some problems. Did you go back to OJS 3.1.1-4, or are you still working with version 3.2.1-1?

Regards,
Alec Smecher
Public Knowledge Project Team

I go back to the OJs 3.1.4 but when I restore the OJS 3.1.4 then many plugins not working and even not. display some data related to authors names, users name, and references,

citation plugin, sword, custom block manager plugin, and many more not working.

I think upgrading destroy the database.

any solution for them

Now, we cannot record the file for the next copy right level.

here is some error log

[11-Aug-2020 17:37:35 UTC] PHP Notice: Undefined index: date_status_modified in /home//public_html/lib/pkp/classes/submission/SubmissionDAO.inc.php on line 109
[11-Aug-2020 17:37:35 UTC] PHP Notice: Undefined index: language in /home//public_html/lib/pkp/classes/submission/SubmissionDAO.inc.php on line 112
[11-Aug-2020 17:37:35 UTC] PHP Notice: Undefined index: citations in /home//public_html/lib/pkp/classes/submission/SubmissionDAO.inc.php on line 113
[11-Aug-2020 17:37:35 UTC] PHP Notice: Undefined index: setting_type in /home//public_html/lib/pkp/classes/db/DAO.inc.php on line 589
[11-Aug-2020 17:37:35 UTC] PHP Notice: Undefined index: setting_type in /home//public_html/lib/pkp/classes/db/DAO.inc.php on line 589
[11-Aug-2020 17:37:35 UTC] PHP Notice: Undefined index: setting_type in /home//public_html/lib/pkp/classes/db/DAO.inc.php on line 589
[11-Aug-2020 17:37:35 UTC] PHP Notice: Undefined index: setting_type in /home//public_html/lib/pkp/classes/db/DAO.inc.php on line 589
[11-Aug-2020 17:37:35 UTC] PHP Notice: Undefined index: setting_type in /home//public_html/lib/pkp/classes/db/DAO.inc.php on line 589
[11-Aug-2020 17:37:35 UTC] PHP Notice: Undefined index: setting_type in /home/d/public_html/lib/pkp/classes/db/DAO.inc.php on line 589
[11-Aug-2020 17:37:35 UTC] PHP Notice: Undefined index: citations in /home/d/public_html/classes/article/ArticleDAO.inc.php on line 83
[11-Aug-2020 17:37:35 UTC] PHP Notice: Undefined index: pages in /home//public_html/classes/article/ArticleDAO.inc.php on line 84
[11-Aug-2020 17:37:35 UTC] PHP Notice: Undefined index: hide_author in /home//public_html/classes/article/ArticleDAO.inc.php on line 85

Hi @Rohaan123,

Yes, attempting to upgrade will modify the database heavily. If you want to go back to OJS 3.1.1-4, you’ll need to restore your database from backup.

Regards,
Alec Smecher
Public Knowledge Project Team

eclaration of ReviewerForm::fetch() should be compatible with Form::fetch($request, $template = NULL, $display = false) in /home/dhuavritv7p2/public_html/lib/pkp/controllers/grid/users/reviewer/form/ReviewerForm.inc.php on line 19
[11-Aug-2020 17:51:57 UTC] PHP Strict Standards: Declaration of ReviewerForm::initData() should be compatible with Form::initData() in /home/dhuavritv7p2/public_html/lib/pkp/controllers/grid/users/reviewer/form/ReviewerForm.inc.php on line 19
[11-Aug-2020 17:51:57 UTC] PHP Strict Standards: Declaration of ReviewerForm::execute() should be compatible with Form::execute() in /home/dhuavritv7p2/public_html/lib/pkp/controllers/grid/users/reviewer/form/ReviewerForm.inc.php on line 19
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::isPost() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/validation/FormValidatorPost.inc.php on line 38
[11-Aug-2020 17:51:57 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 396

Hi @Rohaan123,

Those are all cosmetic warnings, and shouldn’t cause the system to stop working. (Many of these are cleaned up in more recent releases.)

Regards,
Alec Smecher
Public Knowledge Project Team

Already try to do get back up but failed. During backup, we got these errors. is there any other way?

I did not get your point. would you please elaborate more.

Hi @Rohaan123,

The warnings in your message above are just warnings, they won’t stop the system from working. If you’re having trouble with the system, it’s not caused by these warnings. If you’re still having trouble, describe what’s happening, and also check further back in your log file for something that’s not a Warning – look for the word Error.

Regards,
Alec Smecher
Public Knowledge Project Team

Please check we have still the same issue.
now the system not goes to the next step. The same situation, when assign to the reviewer and other anyone.

Screenshot 2020-08-13 at 1.37.30 AM

Declaration of EditorDecisionForm::fetch() should be compatible with Form::fetch($request, $template = NULL, $display = false) in /home/dhuavritv7p2/public_html/lib/pkp/classes/controllers/modals/editorDecision/form/EditorDecisionForm.inc.php on line 21
[12-Aug-2020 17:45:25 UTC] PHP Strict Standards: Declaration of EditorDecisionWithEmailForm::initData() should be compatible with Form::initData() in /home/dhuavritv7p2/public_html/lib/pkp/controllers/modals/editorDecision/form/EditorDecisionWithEmailForm.inc.php on line 18
[12-Aug-2020 17:45:25 UTC] PHP Strict Standards: Declaration of PromoteForm::initData() should be compatible with EditorDecisionWithEmailForm::initData($args, $request, $actionLabels) in /home/dhuavritv7p2/public_html/lib/pkp/controllers/modals/editorDecision/form/PromoteForm.inc.php on line 21
[12-Aug-2020 17:45:25 UTC] PHP Strict Standards: Declaration of PromoteForm::execute() should be compatible with Form::execute() in /home/dhuavritv7p2/public_html/lib/pkp/controllers/modals/editorDecision/form/PromoteForm.inc.php on line 21
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::getUserVar() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/Form.inc.php on line 388
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 592
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::isPost() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/form/validation/FormValidatorPost.inc.php on line 38
[12-Aug-2020 17:45:25 UTC] PHP Deprecated: Non-static method PKPRequest::_checkThis() should not be called statically, assuming $this from incompatible context in /home/dhuavritv7p2/public_html/lib/pkp/classes/core/PKPRequest.inc.php on line 396
[12-Aug-2020 17:45:25 UTC] ojs2: DB Error: Unknown column ‘language’ in 'field list

Hi @Rohaan123,

The relevant error is:

DB Error: Unknown column ‘language’ in 'field list

Are you still working with a database that was partially upgraded to a newer OJS (but failed)? If so, you’ll have numerous schema problems like this.

Regards,
Alec Smecher
Public Knowledge Project Team

yes i’m still working on it because we have not backup for database.

I solve the problem by add the all users and authors names. and i deleted some generic plugin and put back again.

the pervious have been solves. but now in admin side we cannot process the file for the next step, cannot add reviewers. and send email to the authors.

See above, i shared the latest error log.

Hi @Rohaan123,

Your database structure is currently somewhere between OJS 3.1.1-4 and 3.2.1-1, and unless you captured the error message you encountered when you first tried to upgrade, you won’t know exactly how much of it got adapted to the new structure. The only easy way to resolve this is to reload from a backup. If that’s not possible, I’m afraid I can’t walk you through this step by step. Essentially you’ll need to compare the data structures in your broken database against what’s supposed to be there in a clean OJS 3.1.2-1 installation. The upgrade process is scripted in dbscripts/xml/upgrade.xml, if you need to review the sequences the changes are made in.

Regards,
Alec Smecher
Public Knowledge Project Team

thank you very much.

so what you recommend, can we delete dbscripts/xml/upgrade.xml. or make changes in it.

DB Error: Unknown column ‘u.first_name’ in ‘field list’

hi i got the error when i go to submission in admin penal.