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
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
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
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
[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
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