Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
1 Registered (1 invisible), 20 Guests and 18 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Gizmo 11670
Rick 7543
Ian 4099
Mark S 3969
ntdoc 3101
Sirdude 2041
jgeoff 1876
David Dreezer 1748
driv 1552
AllenAyres 1519
Latest Photos
Carrie - So Very
Testing
Test Photo
4TH of July at the river!
Test shots from D300 part 3
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: 1209
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 Online   content

*****

Registered: 06/04/06
Posts: 7543
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: 1519
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: 1209
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: 2041
Loc: SoCal, USA
/me takes Yarps fix and applies fix for 7.3 ;\)
_________________________

A taxpayer voting for Obama is like a chicken voting for Colonel Sanders.

Top


Shout Box

Recent Topics
Import UBB classic from to UBB threads runs on a new server
by Hari Varma
Today at 06:30 AM
Import UBB classic 6.7.2 to UBB threads 7.3.1
by MrVasu
Today at 12:44 AM
File Attachment problem
by Murphdog
Yesterday at 07:44 PM
group_foumperms.php Hangs
by mmem700
Yesterday at 05:58 AM
What causes this message to pop up?
by Larry Miller
Yesterday at 04:13 AM
Forum Stats
4010 Members
33 Forums
30825 Topics
156535 Posts

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