DB Error: Unknown column 'i.last_modified' in 'field list'

Dear,
after a year I still have got a same problem. I post this problem on the https://pkp.sfu.ca/bugzilla/show_bug.cgi?id=8520 and https://pkp.sfu.ca/support/forum/viewtopic.php?f=8&t=13113&p=52026&hilit=DB+Error%3A+Unknown+column+‘last_modified’+in+‘field+list’#p52026 but I have got again problem. I have to publish new issue but received message “DB Error: Unknown column ‘last_modified’ in ‘field list’”.
I was upgrade OJS twice but and wrote all steps but now I cannot do that. I received that I have got OJS 2.4.7.1 but after upgrade I received error in database. Also, when I check on http://www.ijcrsee.com/dbscripts/xml/version.xml I received that I have got OJS 2.4.2. You can see on http://www.ijcrsee.com/index.php/ijcrsee/oai/?verb=ListRecords&metadataPrefix=oai_dc message about the error. Probably that I cannot upgrade database or I have to clear cash.
How to solve this problem and publish new issue? With old version I cannot do that.
Thank you in advancel
Lazar

Hi @Lazar_Stosic,

That error message suggests that the upgrade process failed, and without the output from the upgrade tool, we can’t be sure where it failed. Do you have any specific upgrade messages from the upgrade process?

If the upgrade fails, the solution is to restore from a backup made from before the upgrade, fix the problem based on the error message, and try the upgrade again. But if your installation has been running for a long time since the upgrade failed, that will be hard to do.

Regards,
Alec Smecher
Public Knowledge Project Team

Dear Alec Smecher,
thank you for answer. Upgrading was about 2 or 3 minute and I received that upgrade is successful. When I turn option -instal- to on and refresh the webpage I received the same situation. Version is OJS2.4.7.1 but when I want to publish the new issue I received the error “DB Error: Unknown column ‘last_modified’ in ‘field list’”. I didnt receive any message that I have a problem with upgrading. Do you have some suggestion what can I do? How to fix that and how to publish new issue? Where I can found error message? In admin I received that have OJS 2.4.7.1, when I start upgrade I dont receive any message. Only that upgraded is successfully finished.
I received:
‘‘OJS Upgrade
Upgrade of OJS to version 2.4.2.0 has completed successfully.
Don’t forget to set the “installed” setting in your config.inc.php configuration file back to On.
If you haven’t already registered and wish to receive news and updates, please register at http://pkp.sfu.ca/ojs/register. If you have questions or comments, please visit the support forum.’’

Sincerely, Lazar.

I found this error message:
[17-Dec-2015 23:02:29 Europe/Belgrade] ojs2 has produced an error
Message: WARNING: fopen(dbscripts/xml/indexes.xml): failed to open stream: No such file or directory
In file: /home/ijcadsee/public_html/lib/pkp/classes/file/FileWrapper.inc.php
At line: 71
Stacktrace:
Server info:
OS: Linux
PHP Version: 5.4.17
Apache Version: N/A
DB Driver: mysql
[17-Dec-2015 23:02:29 Europe/Belgrade] ojs2: You are trying to downgrade the product “abnt” from version [1.1.0.0] to version [1.0.0.0]. Downgrades are not supported.

[18-Dec-2015 17:02:12 Europe/Belgrade] ojs2 has produced an error
Message: WARNING: file_exists(): open_basedir restriction in effect. File(plugins/oaiMetadataFormats/README/READMEOaiMetad
ataFormatsPlugin.inc.php) is not within the allowed path(s): (/home/ijcadsee/:/tmp/:/var/tmp/)
In file: /home/ijcadsee/public_html/lib/pkp/classes/plugins/PluginRegistry.inc.php
At line: 230
Stacktrace:
Server info:
OS: Linux
PHP Version: 5.4.17
Apache Version: N/A
DB Driver: mysql
[18-Dec-2015 17:02:49 Europe/Belgrade] ojs2: DB Error: Unknown column ‘i.last_modified’ in ‘field list’

Also, you can see on the http://ijcrsee.com/phpinfo.php do I need to change something.
Maybe you can tell me is there some problem.
Lazar

Hi @Lazar_Stosic,

The file dbscripts/xml/indexes.xml should exist – I wonder if your code is not fully upgraded. How did you upgrade the code? If you didn’t try the “full package” upgrade process described in the upgrade documentation, I would suggest trying that.

Regards,
Alec Smecher
Public Knowledge Project Team

Dear Alec,
thank you for your answer. I was beck up earlier version and database because I have to publish new issue. I contacted our technical support - provider and they cannot help me. I did all version to upgrade but received the same. I must find someone who did this and to do upgrade together. Once I did but still receive that I have got OJS 2.4.2.
Thank you for your support.
Lazar

Hi @Lazar_Stosic,

The file dbscripts/xml/indexes.xml exists in the release .tar.gz file, so if it’s missing from your installation, it’s because of a problem during the files upgrade process. I’d suggest following the “full package upgrade” process described in the upgrade documentation in order to make sure that all files exist before running the upgrade script.

Regards,
Alec Smecher
Public Knowledge Project Team