You are here:  » Backup not working


Backup not working

Submitted by marco@flapper on Fri, 2016-09-23 08:18 in

Hi,
Can't make a backup of the settings. I get:

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /.../pt_4/includes/database.php

Can it be related to that I have some optional fields?

Submitted by support on Fri, 2016-09-23 08:41

Hello Marco,

I know that you have been working with the script for several years so it may be related to custom fields, however since 14/06A the backup process was modified to include all fields by way of table definition queries instead of a coded field list.

Please could you run the process with database debug mode enabled by changing line 6 of config.advanced.php as follows;

  $config_databaseDebugMode = TRUE;

Then run the backup process again and let me know what is displayed and that should indicate the problem...

Thanks,
David.
--
PriceTapestry.com

Submitted by marco@flapper on Fri, 2016-09-23 09:47

I ran it again and I guess I see what is going wrong:

[SELECT * FROM `pt_4_voucherfeeds`][Table '....pt_4_voucherfeeds' doesn't exist]
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /.../pt_4/includes/database.php on line 38

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /.../pt_4/includes/database.php on line 43

Warning: Cannot modify header information - headers already sent by (output started at /.../pt_4/includes/database.php:33) in /.../pt_4/admin/database_tool.php on line 200

Warning: Cannot modify header information - headers already sent by (output started at /.../pt_4/includes/database.php:33) in /.../pt_4/admin/database_tool.php on line 202

I deselected Voucher Codes, Voucher Code Feeds and Automation Tool and there is a backup file. I didn't import it yet, but it looks ok. Do you think it will work?

Submitted by support on Fri, 2016-09-23 10:29

Hi Marco,

I know you're working on upgrading various installations and the output would indicate that it is the latest version of the Database Tool running against an older database. De-selecting the new tables should work fine if restoring to a new 15/09A installation but I would suggest making sure that the restore procedure has worked fine before deleting anything, that way you can revert easily in case of any problem...

Cheers,
David.
--
PriceTapestry.com