Forum (FR)

[SOLVED] Backup and...
 
Notifications
Retirer tout

[SOLVED] Backup and Restore

18 Posts
2 Utilisateurs
0 Reactions
12.3 {numéro}K Vu
(@ijack30)
Posts: 10
Active Member
Début du sujet
 
[#2536]

I had a Windows serveur with Projeqtor.
I've just installed a ubuntu server. Saved Projeqtor database. Fine.
I saved /projeqtor/files/attach and /projeqtor/files/documents.
Restored these directories on Ubuntu server. Did "chown -R www-data" and "chmod -R 755"

But on a new server, can't access to attached documents ! I see files, but if try to download or reed.. nothing !!!
in general settings, Setting up ../files/attach/

Documents seem to be OK, but not for attached files
could you help me ?


 
Posté : 19 Août PM 18:088
(@babynus)
Posts: 14952
Membre Admin
 

Possibly you were on 4.x on Windows, and move to 5.0 on Ubuntu.
If it is this, you must respect the order :
- import database
- copy folders (/files/document and /files/attach)
- chmod and chown of folders
- then (and only then) connect to run db migration
(upgrade from V4.5 to V5.0 includes some renaming of attchments to fix an hostoric typo)


 
Posté : 19 Août PM 19:088
(@ijack30)
Posts: 10
Active Member
Début du sujet
 

Thanks for Reply

Old server were on V5.04. New onto 5.05

I've try to restore again BD (all files are restored) to make sure to respect order
I have same probleme.

I can see all attachment in project, but if I clik to read one, nothing appear.
On icon, I can verify link.. ( http://IPSERVER/projeqtor/tools/download.php?class=RIGHT Attachment...)


 
Posté : 19 Août PM 19:088
(@babynus)
Posts: 14952
Membre Admin
 

Can you open browser console and check error, or network console to see result of last http request.


 
Posté : 19 Août PM 19:088
(@ijack30)
Posts: 10
Active Member
Début du sujet
 

how can i do that ?


 
Posté : 19 Août PM 19:088
(@babynus)
Posts: 14952
Membre Admin
 

F12
You'll see the dev tabs (console, network and others)


 
Posté : 19 Août PM 20:088
(@ijack30)
Posts: 10
Active Member
Début du sujet
 

This is. I don't know if that can help

With Chrome, error is explicit.

formName=listForm'
Failed to load resource: the server responded with a status of 404 (Not Found)
=> 996ms

I saved another time ALL /Files/directory, and restore on a new server.
restore again BD
no change !

I don't understand..


 
Posté : 19 Août PM 20:088
(@babynus)
Posts: 14952
Membre Admin
 

Failed to load resource: the server responded with a status of 404 (Not Found)

What was the request that responded with 404 (Not found) ?
It is not the one your joined, as they both responded 200 (OK)

About request your showed, could you show response body ? (corps de la réponse)

Last, could you check existence of folder /files/attach/attachment_303 ? (pay attention, not attachement_303 but attachment_303)
Does this folder exist and contain the file you try to download ?


 
Posté : 19 Août PM 21:088
(@ijack30)
Posts: 10
Active Member
Début du sujet
 

here is for attachment 472

/files/attach/attachment_272 exist, ans PDF file is into it

Capt7 is strange.. On Windows server, a same action I can see
http://windowsserver/projeqtor/view/main,php


 
Posté : 19 Août PM 21:088
(@ijack30)
Posts: 10
Active Member
Début du sujet
 

No.. Sorry.. I don't know what i did...

Capt7-2 on new server
Capt8 on old server


 
Posté : 19 Août PM 21:088
(@babynus)
Posts: 14952
Membre Admin
 

The "initiateur" does not matter.
It just says which event generated the request.

But response seems empty.
Could you check :
1) log file (in ../files/logs) : is there any error logged
2) database, table attachment with id='272'.
"fileName" should be name of file you try to download.
"subDirectory" should be "${attachmentDirectory}attachment_272/"


 
Posté : 19 Août PM 21:088
(@ijack30)
Posts: 10
Active Member
Début du sujet
 

Log file

2015-08-19 13:42:11.417 ** ERROR ** download.php : ../files/attach/\attachment_472\Resistance tissus de Superior.pdf not found

Attach directory

admin@projeqtor:/var/www/projeqtor/files/attach/attachment_472$ ls -l
total 1264
-rwxr-xr-x 1 www-data root 1291579 mar 18 13:44 Resistance tissus de Superior.pdf

With Phpmyadmin
attachment table
Subdirectory = ${attachmentDirectory}attachment_472


 
Posté : 19 Août PM 21:088
(@babynus)
Posts: 14952
Membre Admin
 

Weird, but no magic.
There could be some bad conversion of file name.

Did you try to download existing file with only letters in name (no space or accentuated character or other character) ?


 
Posté : 19 Août PM 22:088
(@ijack30)
Posts: 10
Active Member
Début du sujet
 

YES

2015-08-19 14:14:42.348 ** ERROR ** download.php : ../files/attach/\attachment_481\2015-03-27_15-24.mp3 not found

there are no space, no accent... and doesn't work


 
Posté : 19 Août PM 22:088
(@babynus)
Posts: 14952
Membre Admin
 

Idea : change attachment directory to "..filesattach" (with linux folder separator)
... and try again.


 
Posté : 19 Août PM 22:088
Page 1 / 2
Share:
Retour en haut