Forum

[SOLVED] Backup and...
 
Notifications
Clear all

[SOLVED] Backup and Restore

18 Posts
2 Users
0 Reactions
12.4 K Views
(@ijack30)
Posts: 10
Active Member
Topic starter
 
[#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 ?


 
Posted : 19 Aug 2015 18H10
(@babynus)
Posts: 14952
Member 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)


 
Posted : 19 Aug 2015 19H31
(@ijack30)
Posts: 10
Active Member
Topic starter
 

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...)


 
Posted : 19 Aug 2015 19H45
(@babynus)
Posts: 14952
Member Admin
 

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


 
Posted : 19 Aug 2015 19H53
(@ijack30)
Posts: 10
Active Member
Topic starter
 

how can i do that ?


 
Posted : 19 Aug 2015 19H57
(@babynus)
Posts: 14952
Member Admin
 

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


 
Posted : 19 Aug 2015 20H29
(@ijack30)
Posts: 10
Active Member
Topic starter
 

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


 
Posted : 19 Aug 2015 20H48
(@babynus)
Posts: 14952
Member 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 ?


 
Posted : 19 Aug 2015 21H22
(@ijack30)
Posts: 10
Active Member
Topic starter
 

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


 
Posted : 19 Aug 2015 21H38
(@ijack30)
Posts: 10
Active Member
Topic starter
 

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

Capt7-2 on new server
Capt8 on old server


 
Posted : 19 Aug 2015 21H44
(@babynus)
Posts: 14952
Member 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/"


 
Posted : 19 Aug 2015 21H51
(@ijack30)
Posts: 10
Active Member
Topic starter
 

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


 
Posted : 19 Aug 2015 21H59
(@babynus)
Posts: 14952
Member 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) ?


 
Posted : 19 Aug 2015 22H12
(@ijack30)
Posts: 10
Active Member
Topic starter
 

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


 
Posted : 19 Aug 2015 22H16
(@babynus)
Posts: 14952
Member Admin
 

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


 
Posted : 19 Aug 2015 22H31
(@ijack30)
Posts: 10
Active Member
Topic starter
 

good idea.. but changes automaticly into ../files/attach/
if i change into config/parameters.php.. doesn't work !

I am disappointed :sick:


 
Posted : 19 Aug 2015 22H44
(@babynus)
Posts: 14952
Member Admin
 

I mismatched.
It is the other way round : attachment directory must be "../files/attach/"
but in attachment table, you must change subDirectory to replace all "" with "/".
Windows doesn't mind for directory separator : it sould be '' but windows accepts '/'.
Linux, on its side only accepts '/'.


 
Posted : 19 Aug 2015 23H02
(@ijack30)
Posts: 10
Active Member
Topic starter
 

I FOUND !!! but ... lost of job to change !

I did wrong attachment..

in table, I replaced as you told me
${attachmentDirectory}attachment_327 BY
${attachmentDirectory}/attachment_327/

But if name content accent.. we need to change, because accent are replaced by après fo après.....

so 1) change all for /
and change all name with accent. OUCH !!


 
Posted : 19 Aug 2015 23H20
Share:

Scroll to Top