I’m attempting to resolve this problem; this is the first time I’ve encountered this error. Previously, our website page was only available as an extension on the main website; however, the company has opted to convert the main website to the ojs for the time being. After converting the main website to ojs, an error occurred, and I attempted to read and understand some of the issues raised.
Note that the files_dirshould not be in the web root, or you risk malicious users attempting to upload and execute scripts on the server. See docs/README.md for details on securing your installation.
Regards,
Alec Smecher
Public Knowledge Project Team
I read the docs/README.me. something confused on me. the file directory will point on this location like this https://domainname.com/files, which is on my understanding is equivalent of the webroot setup. /home/userrootcpanel/public_html/files or /home/userrootcpanel/files.
i tried to put our domain on the file_dir = htpps://domainname.com/files but the error is the same.
Right now my journals website was stock on this error
Having your files directory available through the web server e.g. at https://domainname.com/files is exactly what you want to avoid. The files directory should not be accessible through the web server.
The files_dir setting in config.inc.php should be a path (e.g. /home/userrootcpanel/ojs_files). It should not be a URL (e.g. https://anything).
Regards,
Alec Smecher
Public Knowledge Project Team
I’m attempting to migrate my database from XAMPP to Our Web Server. I attempted to upload the database ojs 3.3.8.0-8, which serves as a backup. I did not proceed with the upgrade because I had some issues with 3.3.8.0-9 on my end, and I also did not receive a response to my new subject.
I got an error when I go to the Journal Page of our publication site:
Blockquote
Fatal error : Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘philairp_newBetaGenCorei12.s.context_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /home/philairph2022/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78 Stack trace: #0 /home/philairph2022/public_html/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(78): PDO->prepare(‘select s.* fr…’, Array) #1 /home/philairph2022/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Doctrine\DBAL\Driver\PDOConnection->prepare(Object(Illuminate\Database\Query\Expression)) #2 /home/philairph2022/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Data in /home/philairph2022/public_html/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
in my localhost xampp I did not ecounter on this, but when I tried to our web server the error shown.
I have the same problem - HTTP Error
But I noticed one feature. A file up to 100KB in size is loaded without errors. The file is larger already with an error.
PHP, php ini are configured correctly. All rights are set to maximum for uploading files
But the problem was not solved.
Sorry for my English.
I wanted to share a solution regarding the recent error encountered in the LTS version of OJS. I recommend upgrading to the latest version, as this should resolve the issue.
As always, please remember to back up your database before proceeding with any upgrades.
Cuando yo tengo este problema de error, es porque el nombre del archivo tiene acentos o espacios en blanco. Cuando quito los acentos o los espacios en blanco, se carga bien el archivo.