Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
2 registered (Ruben Rocha, Thelockman), 34 Guests and 19 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 07/04/06
Posts: 4044
Top Posters (30 Days)
Ruben Rocha 184
Gizmo 110
Rick 101
Thelockman 83
driv 41
AllenAyres 35
ntdoc 28
Sirdude 27
Ian 24
ScriptKeeper 18
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Topic Options
Rate This Topic
#200777 - 11/06/07 04:04 AM [Fixed 7.3][7.2.2] Database backup adds empty queries to the files
blaaskaak Offline

****

Registered: 08/30/06
Posts: 1299
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
#200782 - 11/06/07 08:53 AM Re: [7.2.2] Database backup adds empty queries to the files [Re: blaaskaak]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7904
Loc: Aberdeen, WA
Thanks Yarpie ;\)
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#200818 - 11/06/07 08:11 PM Re: [7.2.2] Database backup adds empty queries to the files [Re: Rick]
AllenAyres Moderator Offline

****

Registered: 12/29/03
Posts: 1639
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 03:25 AM Re: [7.2.2] Database backup adds empty queries to the files [Re: AllenAyres]
blaaskaak Offline

****

Registered: 08/30/06
Posts: 1299
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
#200912 - 11/08/07 05:07 PM Re: [7.2.2] Database backup adds empty queries to the files [Re: blaaskaak]
Sirdude Moderator Offline

*****

Registered: 04/19/07
Posts: 2081
Loc: SoCal, USA
/me takes Yarps fix and applies fix for 7.3 ;\)
_________________________


Top


Shout Box

Today's Birthdays
kimteague_5@msn.com, Trekkie, Trixie
Recent Topics
Inclusion of Locked/Closed thread capabilities
by QSS Tim
12/03/08 11:17 AM
Contact Page Problem
by David DelMonte
12/03/08 09:05 AM
FAQ bug,
by BreeOge
12/03/08 08:36 AM
I'm the Admin but.....
by David DelMonte
12/02/08 11:12 AM
Fatal error: Smarty::require_once
()

by ThreadsUser
12/02/08 08:17 AM
Forum Stats
4261 Members
33 Forums
30538 Topics
155004 Posts

Max Online: 978 @ 06/24/07 08:19 PM