[Fixed 7.3][7.2.2] Database backup adds empty queries to the files

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » Bug Reports
» Fixed Bugs » [Fixed 7.3][7.2.2] Database backup adds empty queries to the files

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

Top Posters (30 Days)

Ruben	51
Gizmo	24
DennyP	24
Dunny	15
SteveS	14
AllenAyres	12
SD	10
dbremer	10
drkknght00	9
doug	8

Latest Photos

Basildon Town Centre looking from the rounderbout

Topic Options

#200777 - 11/06/07 07:04 AM

[Fixed 7.3][7.2.2] Database backup adds empty queries to the files

Yarp™

Registered: 08/30/06
Posts: 1513
Loc: Breda, NL

This line:

Code:

$backuptext .= ";\n\n";

Should be moved up in the

Code:

if (!$crow) {

section.

This prevents empty lines with a ; to get into the sql file exported when a table has over 500 rows. I had errors about "empty sql statements" when trying to import tables with the original exported files. Worked fine after I applied my fix.

_________________________

Top

Express Hosting

Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."

#200782 - 11/06/07 11:53 AM

Re: [7.2.2] Database backup adds empty queries to the files [Re: Yarp™]

Rick

Post-a-holic

Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA

Thanks Yarpie $;\)$

Top

#200818 - 11/06/07 11:11 PM

Re: [7.2.2] Database backup adds empty queries to the files [Re: Rick]

AllenAyres Offline

Registered: 12/29/03
Posts: 1995
Loc: Texas

Yes, this caused me issues a few times having to manually import a backup file $\:\)$

_________________________
- Allen
- ThreadsDev | PraiseCafe

Top

#200824 - 11/07/07 06:25 AM

Re: [7.2.2] Database backup adds empty queries to the files [Re: AllenAyres]

Yarp™

Registered: 08/30/06
Posts: 1513
Loc: Breda, NL

Originally Posted By: AllenAyres

Yes, this caused me issues a few times having to manually import a backup file $\:\)$

Take a guess what I was doing when finding this bug $\:\)$

It would be nice also to be able to add a DROP TABLE IF EXISTS to the files, optional or not. Saves you dropping all those tables manually when you try a couple of imports.

_________________________

Top