The Error appeared after upgrading from OJS 3.3.0-8 to OJS 3.3.0-10 LTS

Hi Everyone;

I bring up this experience;

I have an OLD OJS DATABASE dated November 2019;

I extracted it and converted it from OJS 3.3.0-8 to OJS 3.3.0.10 LTS.

In the section My Database;

For the trial and error of the upgrade, I used a XAMPP platfrom from a local server.

Here are the changes that occurred as a result of our decision to move our publication website from http://domain.com/publication to http://domain.com/;

As I began to implement the changes, I discovered that our database was broken;

I Saw this in the entity:
Problem #1.) First Issues:

http: http://domain.com/publication; ( I tried to search this and I got 300 Matches)
http://domain.com/publication; ( I tried to search this and I got 1200 Matches)
http://domain.com/domain.com; ( I tried to search this and I got 100 Matches)
https://domain.com/publication ( I tried to search this and I got 100 Matches)

So, I replaced this to our localhost. http://localhost/www/domain.com/ it total of change 1700 matches in one link.

and the result for importing to the database is this:

--
-- Indexes for table `referrals`
--
ALTER TABLE `referrals`
  ADD PRIMARY KEY (`referral_id`),
  ADD UNIQUE KEY `referral_article_id` (`submission_id`,`url`)

MySQL said: Documentation

#1062 - Duplicate entry '231-http://localhost/www/domian.com/index.php/ijgc/article/vie' for key 'referral_article_id'
Screenshot_3

Problem #2.) Files Directory from OJS 3.3.0-8 at it’s work already but when I upgraded and change the entity above mention, the HTTP Error Upload was pop Up even in the Galley area.
Localhost: C:\xampp\htdocs\www\donain\files (in OJS 3.3.0-8 it works) after Upgraded to OJS 3.3.0-10 LTS was showed up the HTTP Error.

This setup, was installed in XAMPP Platform.

Problem #3.) after the changes of the URL in the database I encountered this error in my importing database: Http Error When Uploading a File in this Version ojs-3.3.0-8 - #10 by OJS_Darryl

Problem #4.) Page is not Working (Blank Page):
Error Show on DEBUG:

Blockquote Fatal error : Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘0’ for key ‘PRIMARY’ in C:\xampp\htdocs\www\philair-1.ph\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:115 Stack trace: #0 C:\xampp\htdocs\www\philair-1.ph\lib\pkp\lib\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php(115): PDOStatement->execute(NULL) #1 C:\xampp\htdocs\www\philair-1.ph\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(489): Doctrine\DBAL\Driver\PDOStatement->execute() #2 C:\xampp\htdocs\www\philair-1.ph\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(‘INSERT INTO con…’, Array) #3 C:\xampp\htdocs\www\philair-1.ph\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php(631): Illuminate\Database\Connection->runQueryCallback(‘INSERT INTO con…’, Array, Object(Closure)) #4 C:\xampp\htdocs\www\philair-1.ph\lib\pkp\lib\ven in C:\xampp\htdocs\www\philair-1.ph\lib\pkp\lib\vendor\laravel\framework\src\Illuminate\Database\Connection.php on line 671

Error LOG: Http Error When Uploading a File in this Version ojs-3.3.0-8 - #12 by 11128

Problem #5.) Exporting XML File in DOI I got this Error:

Warning: shell_exec() has been disabled for security reasons in /home/webroot/public_html/lib/pkp/classes/core/PKPString.inc.php on line 336

Warning: Cannot modify header information - headers already sent by (output started at /home/webroot/public_html/lib/pkp/classes/core/PKPString.inc.php:336) in /home/webroot/public_html/lib/pkp/classes/file/FileManager.inc.php on line 273

Warning: Cannot modify header information - headers already sent by (output started at /home/webroot/public_html/lib/pkp/classes/core/PKPString.inc.php:336) in /home/webroot/public_html/lib/pkp/classes/file/FileManager.inc.php on line 274

Warning: Cannot modify header information - headers already sent by (output started at /home/webroot/public_html/lib/pkp/classes/core/PKPString.inc.php:336) in /home/webroot/public_html/lib/pkp/classes/file/FileManager.inc.php on line 275

Warning: Cannot modify header information - headers already sent by (output started at /home/webroot/public_html/lib/pkp/classes/core/PKPString.inc.php:336) in /home/webroot/public_html/lib/pkp/classes/file/FileManager.inc.php on line 276

Warning: Cannot modify header information - headers already sent by (output started at /home/webroot/public_html/lib/pkp/classes/core/PKPString.inc.php:336) in /home/webroot/public_html/lib/pkp/classes/file/FileManager.inc.php on line 277

Warning: Cannot modify header information - headers already sent by (output started at /home/webroot/public_html/lib/pkp/classes/core/PKPString.inc.php:336) in /home/webroot/public_html/lib/pkp/classes/file/FileManager.inc.php on line 278
_1651121506 1651121506 Darryl Nuyda webmaster@philair.ph Philippine Association of Institutions for Research, Inc. JPAIR Multidisciplinary Research jpair 2244-0445 2012-3981 01 06 2020 39 1 10.7719/jpair.v39i1

Problem #6.) When I go to the Journal Website I got this Error:

Warning: Cannot modify header information - headers already sent by (output started at /home/webroot/public_html/plugins/blocks/keywordCloud/KeywordCloudBlockPlugin.inc.php:1) in /home/webroot/public_html/lib/pkp/classes/template/PKPTemplateManager.inc.php on line 1180

Screenshot_2

Problem #7: Administration → Distribution

I got this Error:

https://domian.com/index.php/jpair/management/settings/distribution

Fatal error: Uncaught Error: Call to undefined function bindtextdomain() in /home/webroot/public_html/lib/pkp/lib/vendor/sokil/php-isocodes/src/AbstractDatabase.php:87 Stack trace: #0 /home/webroot/public_html/lib/pkp/lib/vendor/sokil/php-isocodes/src/AbstractDatabase.php(46): Sokil\IsoCodes\AbstractDatabase->bindGettextDomain() #1 /home/webroot/public_html/lib/pkp/lib/vendor/sokil/php-isocodes/src/IsoCodesFactory.php(110): Sokil\IsoCodes\AbstractDatabase->__construct(NULL) #2 /home/webroot/public_html/lib/pkp/classes/components/forms/context/PKPPaymentSettingsForm.inc.php(41): Sokil\IsoCodes\IsoCodesFactory->getCurrencies() #3 /home/webroot/public_html/lib/pkp/pages/management/ManagementHandler.inc.php(294): PKP\components\forms\context\PKPPaymentSettingsForm->__construct(‘https://domain…’, Array, Object(Journal)) #4 /home/webroot/public_html/pages/management/SettingsHandler.inc.php(57): ManagementHandler->distribution(Array, Object(Request)) #5 /home/webroot/public_html/lib/p in /home/webroot/public_html/lib/pkp/lib/vendor/sokil/php-isocodes/src/AbstractDatabase.php on line 87

Please Help

-regards

Darryl

Dear @OJS_Darryl

Let me answer some parts of it :
Problem 1 to 4
You can search in this forum regarding fixing some integrity errors on your database

Problem #5
You should enable PHP to run the shell_exec() function, read more detail about the instruction here.

Problem #6
You can ignore this since it does not have any drawback on OJS. if you still want to get rid of this, you can disable the KeywordCloud plugin.

#Problem 7
You need to install the getttext extension in PHP by executing this :
apt install php7.x-gettext

7.x refer to the version of PHP that you are currently using.
make sure you reload your webserver after it is installed.

Regards
Hendra
OJT Team

1 Like

Hello Hendra,

for the problem #1-4 I’m searching in this forum.

for problem 5 & 6 - I got it and solve this Issue. thanks for the suggestion.

for Problem 7 I am just worried cause I install the fileinfo and gettext to the php extension in our server. but when restart the apache it put to off/uninstall. I tried to install this using putty but the problem is the same when I restart the apache.

Regards;

Darryl

Hi @OJS_Darryl

You should create a phpinfo file and make sure it is installed on the PHP that used by OJS. Remember the command line PHP version may be different with the ones that is used by webserver.

Regards
Hendra

Hi @navotera;

thanks for reply;

I am successfully installed this two(2) extension using the Putty - login to root. with this tutorial : how to install Php Extension

Screenshot_5

Screenshot_6

However, the result is page is not working in my domain.com; i don’t know why;

it say " This site can’t be reached" the domain.com is refused to connect;

-regards
Darryl

Hi Everyone;

MY CASE HAS BEEN RESOLVED! thanks to @navotera’s assistance (for suggesting the enabling the php extension).

What should I do? I’m not sure how to explain it here.

First, I review my previous and current databases, then I reinstall OJS-3.3.0-8 and verify to my DBASE. I noticed that the more extra links there are, such as in Problem #1 Issues, the more errors there are.

http: http://domain.com/publication; I did not modify this URL; perhaps it is an entity of the email log.
http://domain.com/publication; ( Yes, this is the one I changed, and there is no error displayed (no duplicate id))
http://domain.com/domain.com; ( I did not modify this URL; perhaps it is an entity of the email log.)
https://domain.com/publication ( I did not modify this URL; perhaps it is an entity of the email log.)

As a result, the answer is that the database was successfully uploaded. Our OJS has now been upgraded to OJS-3.3.0-10 LTS with no errors.

from issue #2 to issue #7 I decided to rebuild our server, reinstall the webroot, and install Apache 4. and the php extensions (file info and gettext);

I believe the HTTP Error uploading the file is a problem with Easy Apache 3, so I need to upgrade to Easy Apache 4.

Additional, php7.3 version is not available on easy apache 4, but it’s okay no problem cause my ojs is doing well even php 7.4 is available in the apache 4.

I recommend that you upgrade from Apache 3 to Apache 4.

Also, be wary of other plugins that aren’t OJS compliant. Why? When I install ojs-3.3.0-8 to verify the database, I also check the system plugins that are required. ‘Generic and Block’ is checked.

Thank you for taking the time to read and consider this TOPIC.

-Regards
Darryl

1 Like

Glad it works as expected.

Happy to share our knowledge.

Regards
OJT team

1 Like

This topic was automatically closed after 4 days. New replies are no longer allowed.