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 8: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
Yarp #200782 11/06/2007 12:53 PM
Joined: Jun 2006
Posts: 9,243
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
Rick #200818 11/07/2007 12:11 AM
Joined: Dec 2003
Posts: 1,796
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
AllenAyres #200824 11/07/2007 7: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
Yarp #200912 11/08/2007 9:07 PM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
/me takes Yarps fix and applies fix for 7.3 wink


Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Disaster!!! Files became empty.. Please advise.
by Morgan - 07/27/2020 2:38 PM
Unable to Update Censor List
by BOTCuser - 07/22/2020 9:15 AM
7.7.4 error on rebuilders
by Ruben - 07/21/2020 3:06 PM
[STOCK] UBB.threads Group Image Pack
by isaac - 07/19/2020 9:03 PM
Who's Online Now
3 members (Ruben, Gizmo, 1 invisible), 69 guests, and 57 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
Powered by UBB.threads™ PHP Forum Software 7.7.5
(Snapshot build 20200804)