Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.
Forgot Password?
Navigation
  1. Home
  2. Discussion Forum
  3. PHP-Fusion 9 Support
  4. System Administration - 9
  5. Database Backup Failure
Ask a Question

Database Backup Failure

Previously was working fine, yesterday and today now get these errors:

The webpage at http://www.frackemall.com/nebula/administration/db_backup.php?aid=c4bc549768f9c016 might be temporarily down or it may have moved permanently to a new web address.
ERR_INVALID_RESPONSE

As I stated, I've done backups before without a hitch....
if for example prefix (config.php) $db_prefix = 'fusion6w2gT_';
database prefix = fusion6w2gt_
incorrectly calculated

administration/db_backup.php
line 395 and 417

line 395
CodeDownload  
        if ((preg_match('/^(MyISAM|ISAM|HEAP|InnoDB)$/i', $row['Type'])) || (preg_match('/^(MyISAM|ISAM|HEAP|InnoDB)$/i',

                                                                                        $row['Engine'])) && (preg_match("/^".$prefix."/",

                                                                                                                        $row['Name']))

        ) {


this
CodeDownload  
        if ((preg_match('/^(MyISAM|ISAM|HEAP|InnoDB)$/i', $row['Type'])) || (preg_match('/^(MyISAM|ISAM|HEAP|InnoDB)$/i',

                                                                                        $row['Engine'])) && (preg_match("/^".$prefix."/i",

                                                                                                                        $row['Name']))

        ) {



And line 417
same

And..
line 308

CodeDownload  
    echo "function backupSelectCore(){for(i=0;i<document.backupform.elements['db_tables[]'].length;i++){document.backupform.elements['db_tables[]'].options[i].selected=(document.backupform.elements['db_tables[]'].options[i].text).match(/^$db_prefix/);}}\n";



this

CodeDownload  
    echo "function backupSelectCore(){for(i=0;i<document.backupform.elements['db_tables[]'].length;i++){document.backupform.elements['db_tables[]'].options[i].selected=(document.backupform.elements['db_tables[]'].options[i].text).match(/^$db_prefix/i);}}\n";

[quote]if for example prefix (config.php) $db_prefix = 'fusion6w2gT_';
database prefix = fusion6w2gt_
incorrectly calculated

administration/db_backup.php
line 395 and 417

line 395
[code] if ((preg_match('/^(MyISAM|ISAM|HEAP|InnoDB)$/i', $row['Type'])) || (preg_match('/^(MyISAM|ISAM|HEAP|InnoDB)$/i',
$row['Engine'])) && (preg_match("/^".$prefix."/",
$row['Name']))
) {

Thanks karrak, didn't work.. Just found out I'm running RC3 not RC4 like I thought. Still backing up through phpmyadmin :-)
UPDATE

Tried it yesterdayand the backup function worked fine. Leads me to believe that there was a server issue for 10 days....
But we got this: https://github.com/php-fusion/PHP-Fusion/issues/961

Need to fix or not?
Now it's not working????

The webpage at http://www.xxxxxxx.com/nebula/administration/db_backup.php?aid=ef36e406c4b424f6 might be temporarily down or it may have moved permanently to a new web address.
ERR_INVALID_RESPONSE

It worked fine one day, then it doesn't another, leads me to believe that there's a issue with timing at the server end. Now the other issue was someone else I think...

Didn't want to change out the db-backup.php file from rc4 with the one on github as they are quite different...
Moved to a new server, now get this error:

Fatal error: Class 'httpdownload' not found in /home/xxxxx/public_html/administration/db_backup.php on line 107
We fixed this on RC5, the solution provided by karrak is

Line 107 not httpdownload, it's \httpdownload

Quote

We fixed this on RC5, the solution provided by karrak is

Line 107 not httpdownload, it's \httpdownload
- by Chan




Changed line 107 from $object = new httpdownload;

to: $object = new \httpdownload;

No Change in outcome...
Oops my bad:

https://github.com/php-fusion/PHP-Fusion/blob/9.02/administration/db_backup.php#L114-L115

require_once INCLUDES."class.httpdownload.php";

$object = new \PHPFusion\httpdownload;

Quote

Oops my bad:

https://github.com/php-fusion/PHP-Fusion/blob/9.02/administration/db_backup.php#L114-L115

require_once INCLUDES."class.httpdownload.php";

$object = new \PHPFusion\httpdownload;
- by Chan


Thanks Chan, that worked fine....Your a lifesaver :D
Now when trying to back up, I get this error:


504 Gateway Time-out
nginx/1.11.4

Say What???? :-)

I also opens a ticket on my server site...
Hmmmmmmmmmmmmm......opened ticket with server company yesterday on the above error, today both sites backed up without a hitch. Musta been them then.....
Yes most likley a time-out error on php script.
At least they listened.. And it's fixed Falk... :Y
Thread Information
Author
daimonbok1
Posted In
System Administration - 9
Replies
15 posts
Views
3334 times
Last Post
Last updated on 4 years ago
Related Threads
.14 upgrade - no database upgrade option
Started by neltek neltek - 7 posts
I have forgettin the mysql database password which I putted the php-fusion on it .. how can I restor
Started by
H
 Hesham_3del - 5 posts
Where is "welcome" message in MySQL database
Started by
N
 NealWalters - 2 posts
Connecting to PHP-Fusion Database & Panel With Form To Post Data
Started by
T
 Trix - 2 posts
[SOLVED] Upgrade from 7.02.07 - No database upgrade available
Started by Routh Routh - 36 posts
"Table doesn't exist error". What is correct method to call new database and then reco
Started by
C
 captainx - 2 posts
Hot Questions
ikandi
Using Smileys - Forum Posts and Comments
ikandi - 1 post
daimonbok1
Database Backup Failure
daimonbok1 - 15 posts
daimonbok1
Missing link on Content Admin Menu
daimonbok1 - 9 posts
jjwichter
Septenary Theme error
jjwichter - 8 posts
Wanabo
Send mail via contact
Wanabo - 4 posts
djdandi
The problem with adding links on a page in the main menu.
djdandi - 5 posts
You can view all discussion threads in this forum.
You cannot set up a bounty in this discussion thread.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.
You cannot up or down-vote on the post in this discussion thread.
Users who participated in discussion: Falk, Chan, karrak, daimonbok1