Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
By oneupweb
#545
Each time I try to run a backup of my CATS information I get the following errors: [19-Nov-2008 11:30:20] PHP Warning: filesize() [<a href='function.filesize'>function.filesize</a>]: stat failed for attachments/site_1/0xxx/9816346be1cfbeb82f5178c8249681a5//Afile.pdf in C:\wamp\www\cats.server.com\lib\FileCompressor.php on line 459

When I look at line 459 I see the following code: $uncompressedLength = filesize($filename);, but have no idea what I should be doing to fix this. It happens on more than one attachment and seems to be for very small attachments, not large ones.
Any ideas?
User avatar
By RussH
#548
Hiya - and welcome!

I won't pretend to know why this is happening - but is this from the backup option in the administrators menu, or via the command-line backup script?

The installation instructions say;
3) CLI / On demand backups CATS can generate a backup from the command line on Unix systems. If the Unix zip utility is installed, then you can execute:

php scripts/makeBackup.php 1

from the CATS root directory to generate a backup in scrips/backup/catsbackup.bak.

This, combined with a script to rotate backups which was executed from cron, could yield automated backups.
- so I'd check that the web interface is calling the same script by trying it at a command line - and also check that zip is installed (within Unix / Cygwin)
By oneupweb
#551
Thanks for the reply. I have decided to just work around this backup by backing up the MySQL database and the attachments folder seperately. I'm not a programmer and have spent way too much time on this already. I was only trying to use the built in backup utility from the web interface and it just doesn't work. It will be easier to just copy this information through an automated backup job anyway.
By montievv
#561
i get the same error. my database size is above 1 GB. Attachments size is way beyond. What I have figured is that this happens when your db and attachments are too big to handle. Basically it creates the catsbackup.sql and catsbackup.sql.n files but cant make zip utility combine attachments

still trying to upgrade from 0.7.1 to 0.9.1 but no success. and there is no command line backup in 0.7.1

When i try to create a catsbackup.back file on my own (catsbackup.sql becomes database, catsbackup.sql.n files go into db folder and attachments remains as is), I get the following error:

Query Error -- Please Report This Bug!

MySQL Query Failed: Table 'cats09.attachment' doesn't exist

PLEASE HELP!!! I am not programmer but am good with Linux. I promise to help others in this community. For any small issues (installation, etc.) please mail me. As long as I can ssh into your machine, I will help you guys free of cost.

montievv@gmail.com
User avatar
By RussH
#566
as you say - if you're a linux user and have webmin installed, just schedule a sql backup job in the gui.

As you've said - I'm no programmer either, but I'll put it on my lis t- I'm sure I can amend that script not to try and zip the file - otherwise, I'll tar the file instead.

It's essential to keep these synchronized to ensur[…]

Export part in Job Order order search

Same problem as mine. Maybe you're right, I'll che[…]

The error message you're encountering indicates th[…]

Errors restoring mysqldump backup

doesnot work for me