168 replies to this topic

[azer]

with version 2.4 here are the error i get, with gzip selected

Quote

Notice: Undefined offset: -1 in v:\easyphp\www\ms2fr\shop\admin\includes\auto_backup_db.php on line 43

Notice: Undefined offset: -2 in v:\easyphp\www\ms2fr\shop\admin\includes\auto_backup_db.php on line 44

Notice: Undefined variable: at_backup_db in v:\easyphp\www\ms2fr\shop\admin\includes\auto_backup_db.php on line 74

Notice: Undefined variable: at_backupdb in v:\easyphp\www\ms2fr\shop\admin\includes\auto_backup_db.php on line 164

any ideas ?

[spooks]

There some odd errors, I`ve created Version 2.5 & modified code to improve comatibility, but I`ve no idea why you get the first ones & obviously can`t duplicate as I don`t have php4.

[azer]

well i got php 4 , mysql 4 and apache 1xx since for ms2 this is the requirement
for apache 2, mysql 5, and php 5  lots of querys have to be rewritten.

i have put the interval to 1 minutes but i can't see any messages of error and no creation of backup database

any advice for testing ?

[Jan Zonjee]

azer, on Jun 1 2008, 02:52 PM, said:

any advice for testing ?

Try to make one backup manually in your backup directory. I think the errors you mentioned above are caused by not having a single backup in there.

Perhaps then the contribution will work without problems.

[spooks]

azer, on Jun 1 2008, 01:52 PM, said:

well i got php 4 , mysql 4 and apache 1xx since for ms2 this is the requirement
for apache 2, mysql 5, and php 5  lots of querys have to be rewritten.

i have put the interval to 1 minutes but i can't see any messages of error and no creation of backup database

any advice for testing ?

If you do a temporary mod by adding: $at_backup_db = 'at_backupnow';

onto line 75, it will create a backup on every admin page load, so you could do that, get a few backups & see how things go from there.

[azer]

i did at line 75 what you said :

- now when i select gzip or false, i got a saved database each time i go to a page in admin
- if i select zip, i got a save in pure sql mode , with the message shown below, but i think it s not reveleant it s just that the variables not selected in admin configuration are not defined :

Quote

Notice: Undefined variable: zip in v:\easyphp\www\ms2fr\shop\admin\includes\auto_backup_db.php on line 167

Notice: Undefined variable: gzip in v:\easyphp\www\ms2fr\shop\admin\includes\auto_backup_db.php on line 167

line 168 is :

$database_saved =' Database Backup is completed' . ($zip ? ' and zipped.' : ($gzip ? ' and gzipped.' : '.'));

* notice-> even if at the beginning the backup folder was empty , the backup save files

* by the way the link here :

Quote

<a href="backups/'.$at_backup_file.

should be using : DIR_FS_BACKUP instead no ?

* last error sown :

Use of undefined constant SUCCESS_DATABASE_SAVING - assumed 'SUCCESS_DATABASE_SAVING' in v:\easyphp\www\ms2fr\shop\admin\includes\auto_backup_db.php on line 79

it s true i got written when the database saves itself only :

Quote

Avertissement SUCCESS_DATABASE_SAVING
Succès  Database Backup is completed and gzipped.: Check SQL

[spooks]

More variables want defing? I`ll be glad when php4 gets dropped altogether later this year.

To fix undefined variables just add  $zip = NULL;$gzip = NULL; to line 75

The program creates an uncompressed backup first, if you select zip it then attempts to zip that & deletes it on success.
If there is any failure in the zip operation the uncompressed backup wont be deleted.

If your saving to the wrong location its your config thats the error.

The file is saved to:  DIR_FS_BACKUP . $at_backup_file

$at_backup_file is set to the file name by the program, DIR_FS_BACKUP is set in your configure.php this is normally:
  define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');
So you casn see if DIR_FS_ADMIN is not set you`ll get your problem, its normall set to:
/catalog/admin/

Hope that improves matters

[azer]

* by the way the link here :

here is your code :

Quote

$messageStack->add_session($database_saved.': <a href="backups/'.$at_backup_file.'" target="_blank"><blink><b>Check SQL</b></blink></a>', 'success');

as you can see the DIR_FS_BACKUP is not use, instead you use :

href="backups/'.$at_backup_file.'

hope you understand what i mean

*

Quote

If there is any failure in the zip operation the uncompressed backup wont be deleted.

clever :-)

*

Quote

I`ll be glad when php4 gets dropped altogether later this year.

well i dont know for ms3 requirement but i think its going on with what you say...

* what about last error shown, it can give us info, since you define the SUCCESS_DATABASE_SAVING variable, how it can be undefined, that means that
the website never reach the line you got setup:

define('SUCCESS_DATABASE_SAVING', 'ATTENTION: Making a Auto-Backup of your Database ... ( ' . ($hr_dif ? $hr_dif . ' Hrs ' : '') . $mn_dif  . ' minutes since last backup ).');

Quote

Use of undefined constant SUCCESS_DATABASE_SAVING - assumed 'SUCCESS_DATABASE_SAVING' in v:\easyphp\www\ms2fr\shop\admin\includes\auto_backup_db.php on line 79

[spooks]

Sorry, a little language issue there mayby, I thought you were talking about an earlier point.

azer, on Jun 1 2008, 05:24 PM, said:

* by the way the link here :

here is your code :
as you can see the DIR_FS_BACKUP is not use, instead you use :

href="backups/'.$at_backup_file.'

hope you understand what i mean

I'm not sure if this is a osC version issue, I`m using 2.2rc1. So that code gives correct link like:
http://www.mysite.co.uk/catalog/admin/back...06011749.sql.gz

if it was set to: <a href="'.DIR_FS_BACKUP.$at_backup_file.'"
it would give a link of:
http://www.mysite.co.uk/home/uname/public_...06011753.sql.gz

which would be no good.

azer, on Jun 1 2008, 05:24 PM, said:

* what about last error shown, it can give us info, since you define the SUCCESS_DATABASE_SAVING variable, how it can be undefined, that means that
the website never reach the line you got setup:

define('SUCCESS_DATABASE_SAVING', 'ATTENTION: Making a Auto-Backup of your Database ... ( ' . ($hr_dif ? $hr_dif . ' Hrs ' : '') . $mn_dif  . ' minutes since last backup ).');

This is only occuring with the temporary mod I asked you to do, if you remove the '$at_backup_db = 'at_backupnow' from line 75, the normal timing will work again, and so the define will be done. You should not get your initial errors as you know have backup files for it to work with.

[navyhost]

Hi guys,

This is a great mod to have, I only wish I had it installed yesterday after a database issue and of course my latest back up was 3 days old.

Any how I installed this mod today (Auto Backup Install V2.5) and it doesn't appear to be creating backups.

I left the settings as is. I checked the admin to see if it created a new back up (it didn't) I than went into the FTP to see if it created a backup and it hasn't.

I have been doing a bunch of work in the admin area. Could this be the problem?

After running auto_backup_setup.php I deleted it, should I have?


thanks for the assistance.

[spooks]

navyhost, on Jun 3 2008, 08:17 PM, said:

Hi guys,

This is a great mod to have, I only wish I had it installed yesterday after a database issue and of course my latest back up was 3 days old.

Any how I installed this mod today (Auto Backup Install V2.5) and it doesn't appear to be creating backups.

I left the settings as is. I checked the admin to see if it created a new back up (it didn't) I than went into the FTP to see if it created a backup and it hasn't.

I have been doing a bunch of work in the admin area. Could this be the problem?

After running auto_backup_setup.php I deleted it, should I have?


thanks for the assistance.

Have you made the changes to application_top.php ?

What are your software versions?

It should make the first backup strait away, there are still some issues with php4 though.

[navyhost]

spooks, on Jun 3 2008, 08:40 PM, said:

Have you made the changes to application_top.php ?

What are your software versions?

It should make the first backup strait away, there are still some issues with php4 though.

Hi Sam,

Thank you for the hand.

To be honest I am not 100 % sure which version we are running, is there a prefered file I should look at to see the version I am using? I know it is milestone 2 +.


The application_top was updated with
if (tep_session_is_registered('admin')) require(DIR_WS_INCLUDES .'auto_backup_db.php');


I used the cpanel protected directory to log into the admin, this wouldn't cause a problem would it?

My PHP version is 5.2.6

[spooks]

navyhost, on Jun 3 2008, 09:53 PM, said:

Hi Sam,

Thank you for the hand.

To be honest I am not 100 % sure which version we are running, is there a prefered file I should look at to see the version I am using? I know it is milestone 2 +.


The application_top was updated with
if (tep_session_is_registered('admin')) require(DIR_WS_INCLUDES .'auto_backup_db.php');


I used the cpanel protected directory to log into the admin, this wouldn't cause a problem would it?

My PHP version is 5.2.6

It should work fine with your versions.

That could be the cpanel log in,  its looking for an admin session, if you hav`ent created one it wont run, if thats a problem just modify the application_top code to:
require(DIR_WS_INCLUDES .'auto_backup_db.php');

[navyhost]

spooks, on Jun 3 2008, 09:22 PM, said:

It should work fine with your versions.

That could be the cpanel log in,  its looking for an admin session, if you hav`ent created one it wont run, if thats a problem just modify the application_top code to:
require(DIR_WS_INCLUDES .'auto_backup_db.php');

You the man! That did the trick. It backed up instantly.

thanks!

If you decide to update the mod instructions with this, I noticed a minor spelling error.

When you go to admin/configuration/auto backup

Auto Backup Interval
Alter the automatic dBase backup interval in minites.

Should be a u.

thanks again and great mod!

[spooks]

I`ve now put up V2.6 which should hopfully be OK with your PHP4, if you try it let me know if its all OK.

[azer]

hi first let me thank you for the effort of providing a contribution compatible ith php4 !

i installed version 2.6, since even when puting the interval  to 1 mn doesnt save, i again tested with
$at_backup_db = 'at_backupnow';

now i can see a difference :

- if there was no database in backup folder, one NOT gziped (pure sql) is saved, then other are gzip since i selected gzip from admin option
- at first time the mesage is shown : ATTENTION: Making the first Auto-Backup of your Database
- but for other times , its a blanck message ( maybe because of the $at_backup_db = 'at_backupnow'; trick)

any idea why it doesnt save every Minutes when i put one minutes in

[dca]

Hello,

I have installed the latest version (2.6) but am not really sure what I am missing....I dont see any backups happening automatically.

After running auto backup setup, it says all is OK and directory is writable etc, but I dont see any backups happenning.

Anything else I need to configure ?

My admin/backups directory has several backup files, some gzip or some without gzip format.

Anyone ?


dca

spooks, on Jun 4 2008, 07:22 PM, said:

I`ve now put up V2.6 which should hopfully be OK with your PHP4, if you try it let me know if its all OK.

[spooks]

azer, on Jun 5 2008, 01:07 AM, said:

hi first let me thank you for the effort of providing a contribution compatible ith php4 !

i installed version 2.6, since even when puting the interval  to 1 mn doesnt save, i again tested with
$at_backup_db = 'at_backupnow';

now i can see a difference :

- if there was no database in backup folder, one NOT gziped (pure sql) is saved, then other are gzip since i selected gzip from admin option
- at first time the mesage is shown : ATTENTION: Making the first Auto-Backup of your Database
- but for other times , its a blanck message ( maybe because of the $at_backup_db = 'at_backupnow'; trick)

any idea why it doesnt save every Minutes when i put one minutes in

That`s anoying, still bugs with PHP4! Adding $at_backup_db = 'at_backupnow'; bypasses the timer functions, one you have some backups for the program to 'see' remove that line and things should be OK. The backup only occurs on a page load, so if you set interval to 1 minute, they will only occur every minite of you navigate between admin pages at least one a minite.

[dca]

Hello,

For this contribution to start making the first backup, is it necessary to do anything ?

dca

[spooks]

No, It should do strait away. What version of PHP do you have?