Migrating from OJS 3.2 to 3.3

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

2 Likes

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
2 Likes

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?

1 Like

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?

1 Like

“the PDF file does not exist”

I see, that you find the solution.