I’m in the process of migrating to a new server and new OJS version
My OJS is working, but I’m having problems to export the database. I created a SQL dump and then when I want to import in the new server with mysql -u ojs -p ojs < ojs.sql, it says
ERROR 1215 (HY000) at line 1902: Cannot add foreign key constraint
How can you bypass that? I have access to the original server, where I have around 30 published articles and local backups.
Hello @pachadotdev
it worked! but now the site can’t find the pdf files, and I even tried by re-uploading one
example
https://ojs.lenguasradicales.cl/index.php/lr/article/view/21
https://ojs.lenguasradicales.cl/index.php/lr/article/view/21/20
Can you check files_dir in config.inc.php?
[files]
; Complete path to directory to store uploaded files
; (This directory should not be directly web-accessible)
; Windows users should use forward slashes
files_dir = files
thanks, it’s pointing to /var/www/ojs-files, where I have all the PDF documents organized
it was working with OJS 3.2
have you check permissions adn owner:group?
I have this, because I set chmod -R before
/var/www$ ls -la
total 16
drwxr-xr-x 4 root root 4096 Aug 23 05:15 .
drwxr-xr-x 14 root root 4096 Aug 23 02:23 ..
drwxr-xr-x 22 www-data www-data 4096 Aug 23 15:49 ojs-files
drwxr-xr-x 19 www-data www-data 4096 Aug 23 05:17 ojs.lenguasradicales.cl
What does your error_log say, when you try open a PDF?
“the PDF file does not exist”
I see, that you find the solution.