Previous Thread
Next Thread
Print Thread
Hop To
[Fixed 7.3][7.2.2] Database backup adds empty queries to the files #200777 11/06/2007 7:04 AM
Joined: Aug 2006
Posts: 1,356
Yarpâ„¢ Offline OP
veteran
OP Offline
veteran
Joined: Aug 2006
Posts: 1,356
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.


[Linked Image from siemons.org]
Re: [7.2.2] Database backup adds empty queries to the files [Re: Yarpâ„¢] #200782 11/06/2007 11:53 AM
Joined: Jun 2006
Posts: 9,243
Rick Offline
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Thanks Yarpie wink

Re: [7.2.2] Database backup adds empty queries to the files [Re: Rick] #200818 11/06/2007 11:11 PM
Joined: Dec 2003
Posts: 1,796
AllenAyres Offline
Pooh-Bah
Offline
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Yes, this caused me issues a few times having to manually import a backup file smile


- Allen
- ThreadsDev | PraiseCafe
Re: [7.2.2] Database backup adds empty queries to the files [Re: AllenAyres] #200824 11/07/2007 6:25 AM
Joined: Aug 2006
Posts: 1,356
Yarpâ„¢ Offline OP
veteran
OP Offline
veteran
Joined: Aug 2006
Posts: 1,356
Originally Posted by AllenAyres
Yes, this caused me issues a few times having to manually import a backup file smile


Take a guess what I was doing when finding this bug smile

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.


[Linked Image from siemons.org]
Re: [7.2.2] Database backup adds empty queries to the files [Re: Yarpâ„¢] #200912 11/08/2007 8:07 PM
Joined: Apr 2007
Posts: 3,938
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,938
/me takes Yarps fix and applies fix for 7.3 wink


Link Copied to Clipboard
Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Subscriptions Question
by Ruben - 01/14/2020 12:11 PM
Page won't load after 7.7.3 Update
by Jim0421 - 01/08/2020 11:11 AM
Ubb 7.7.3 winkey emoji shortcut issue
by Ruben - 01/07/2020 4:04 PM
testing winkey emoji shortcut
by Ruben - 01/06/2020 2:36 PM
Very strange problem
by Baldeagle - 01/05/2020 1:22 PM
Who's Online Now
0 members (), 71 guests, and 381 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20200106)