Missing journal sections

Software Support
1

Hi again!

I have another issue with the journal section. Apparently the sections of the journal are stored in the database but not shown in the view. Like this:

It can be seen that the configuration is saved and can be modified but no information is displayed in the edit view except for checkboxs

can someone help me?
Thanks :smile: !

Julieta

2

Hi @julietavuan,

This seems like it might be locale-related. Are you working on a new translation or something similar?

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hi Alec! No, iā€™m not workink on a new translation or any thing like it, i just want to see the information of the section journal in OJS 3.0 but i couldnā€™t.

If you see on the screenshot i have a journal on es_ES but in the view it doesntā€™ show the info.

when i use var_dump() to see that is happening here:

and

this sis the result:

any ideas?

Julieta

4

Hi @julietavuan,

I wonder if this isnā€™t due to the incomplete upgrade weā€™re discussing on the other thread. Letā€™s try resolving that first.

Regards,
Alec Smecher
Public Knowledge Project Team

5

Hi Alec, it could be that, but the thing is that i didnā€™t have an ā€œerrorā€ upgrading (at list not an errorā€¦). I had some PHP Notice, e.g.:

PHP Notice: unserialize(): Error at offset 59 of 3177 bytes in /home/user/ojs-3.0.0/lib/pkp/classes/db/DAO.inc.php on line 347

but not an Error.
Another partner made the upgrading and he didnā€™t have this problem, and we use the same database.
What can i do?

6

Hi @julietavuan,

The last step of the upgrade process is to change the version number in the database ā€“ if the database version isnā€™t updated, then the upgrade process didnā€™t complete.

Those unserialize warnings probably suggest that your database locale set somehow changed; make sure the configuration options for this are the same in your old and new config.inc.php configuration files.

Regards,
Alec Smecher
Public Knowledge Project Team

7

Hi Alec, Iā€™m going to see both config.inc.php configuration files and try to upgrade againā€¦
I hope to achieve this time
Thanks!
Julieta

8

HI Alec, i have this error at the moment:

What can i do?
Julieta

9

It sounds like in one config.inc.php file, the character encoding settings are unset and defaulting to MySQLā€™s ā€œLatin1 (swedish)ā€ default, and in the other config.inc.php file the character encodings are set to UTF8.

What were the settings before the upgrade, and what are the settings now?

10

Hi ctgraham, yes you were right. Now i return to the:

PHP Notice: unserialize(): Error at offset 234 of 1109 bytes in /var/www/html/ojs-3/lib/pkp/classes/db/DAO.inc.php on line 347

Notice: unserialize(): Error at offset 234 of 1109 bytes in /var/www/html/ojs-3/lib/pkp/classes/db/DAO.inc.php on line 347
PHP Notice: unserialize(): Error at offset 39 of 263 bytes in /var/www/html/ojs-3/lib/pkp/classes/db/DAO.inc.php on line 347

Notice: unserialize(): Error at offset 39 of 263 bytes in /var/www/html/ojs-3/lib/pkp/classes/db/DAO.inc.php on line 347
PHP Notice: unserialize(): Error at offset 242 of 1375 bytes in /var/www/html/ojs-3/lib/pkp/classes/db/DAO.inc.php on line 347

what Alec said is:

The last step of the upgrade process is to change the version number in
the database ā€“ if the database version isnā€™t updated, then the upgrade
process didnā€™t complete.

Iā€™m using the tutorial to install OJS 3.0.0 and the database that i have in 2.4.8 and then i use:
" php tools/upgrade.php upgrade "
. How can i update the database?

Julieta

11

The process php tools/upgrade.php upgrade is correct to update the database.

  1. Be sure to completely erase the database and files_dir for any partial upgrades that you may have started.
  2. Then take a backup of your original 2.4.8 database and restore it as the new 3.x database.
  3. Take a backup copy of the 2.4.8 data files (files_dir) and restore it as the new 3.x. files_dir
  4. Ensure your config.inc.php character encoding settings are compatible from the 2.x config.inc.php to the 3.x config.inc.php.
  5. Run the database upgrade php.
12

Thanks ctgraham! Iā€™m going to try it!
Hope it works!
:smile:

Julieta