I can’t install ojs. when i click install open journal system then show HTTP ERROR 500. my PHP 7.4.5 and use MySQLi I tried everything but can’t solve. Please help me

Software Support
1

I can’t install ojs. when i click install open journal system then show HTTP ERROR 500. my PHP 7.4.5 and use MySQLi I tried everything but can’t solve. Please help me

error-log:
24-Jul-2020 14:21:05 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 14:21:06 UTC] PHP Fatal error: Uncaught Exception: DB Error: Duplicate entry ‘atabek’ for key ‘users_username’ Query: INSERT INTO users
(username, password, email, url, phone, mailing_address, billing_address, country, locales, date_last_email, date_registered, date_validated, date_last_login, must_change_password, disabled, disabled_reason, auth_id, auth_str, inline_help, gossip)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, null, ‘2020-07-24 14:21:06’, null, ‘2020-07-24 14:21:06’, ?, ?, ?, ?, ?, ?, ?) in /home/k9doqcilp7jp/public_html/lib/pkp/classes/db/DAO.inc.php:703

2

Hi @ATABEK,

You’re probably trying to run the installation process over a database that’s not empty. Make sure your database is empty before you start the installation.

Regards,
Alec Smecher
Public Knowledge Project Team

3

My databese empty, Size just 0.16 MB. I create new host account and new database

4

Hi @ATABEK,

I’d suggest double-checking that it’s empty using a MySQL client (or PostgreSQL equivalent, depending which you’re using). Most hosts offer phpMyAdmin.

Regards,
Alec Smecher
Public Knowledge Project Team

5

Dear Alec,
I dropt all tables in my database and install again, The problem not solved

image

6

Hi @ATABEK,

Can you confirm that you’re still getting the same Duplicate entry ‘atabek’ for key ‘users_username’ error message when you try to install?

Regards,
Alec Smecher
Public Knowledge Project Team

7

Yes I confirm same username and pasword

8

Stack trace:
#0 /home/k9doqcilp7jp/public_html/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError(Object(ADODB_mysqli), ‘INSERT INTO ema…’)
#1 /home/k9doqcilp7jp/public_html/lib/pkp/classes/mail/EmailTemplateDAO.inc.php(270): DAO->update(‘INSERT INTO ema…’)
#2 /home/k9doqcilp7jp/public_html/lib/pkp/classes/mail/EmailTemplateDAO.inc.php(215): EmailTemplateDAO->installEmailTempla in /home/k9doqcilp7jp/public_html/lib/pkp/classes/db/DAO.inc.php on line 703

9

Hi @ATABEK,

That looks like a different error message – but the actual error message itself has been cut off. It should be in the line above what you’ve quoted.

Regards,
Alec Smecher
Public Knowledge Project Team

10

Its the same error

[24-Jul-2020 18:52:53 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:53 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:53 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:53 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:53 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:53 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:53 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:54 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:54 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:54 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:54 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:55 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:55 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:55 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:55 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:55 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:55 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:55 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:55 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:56 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:56 UTC] PHP Deprecated: Function get_magic_quotes_runtime() is deprecated in /home/k9doqcilp7jp/public_html/lib/pkp/lib/vendor/adodb/adodb-php/adodb-xmlschema.inc.php on line 1307
[24-Jul-2020 18:52:57 UTC] PHP Fatal error: Uncaught Exception: DB Error: Duplicate entry ‘iksad47@gmail.com’ for key ‘users_email’ Query: INSERT INTO users
(username, password, email, url, phone, mailing_address, billing_address, country, locales, date_last_email, date_registered, date_validated, date_last_login, must_change_password, disabled, disabled_reason, auth_id, auth_str, inline_help, gossip)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?, null, ‘2020-07-24 18:52:57’, null, ‘2020-07-24 18:52:57’, ?, ?, ?, ?, ?, ?, ?) in /home/k9doqcilp7jp/public_html/lib/pkp/classes/db/DAO.inc.php:703

11

Hi @ATABEK,

I suspect you’re looking in one database (to verify that it’s empty) but actually connecting your OJS to another that has some data already in it. Or perhaps trying to run the upgrade process twice at the same time. That error can only arise (as far as I can imagine it) from trying to install on top of a database that already has a partial installation in it.

Regards,
Alec Smecher
Public Knowledge Project Team