Environment Builder (formerly db/build)
http://www.thirteen.co.nz/

dev? build
Building Database thirteen_Thirteen

Creating database tables

PageComment
Order
OrderAttribute
OrderStatusLog
ProductVariation
Payment
SiteTree
Email_BounceRecord
QueuedEmail
File
Group
LoginAttempt
Member
MemberPassword
Permission
Widget
WidgetArea
OrderItem
OrderModifier
Product_OrderItem
ProductVariation_OrderItem
SimpleShippingModifier
TaxModifier
WeightShippingModifier
ChequePayment
DPSPayment
EwayXMLPayment
PayPalPayment
PaystationHostedPayment
WorldpayPayment
Page
GhostPage
AccountPage
CheckoutPage
Product
ProductGroup
ErrorPage
RedirectorPage
VirtualPage
Image
Folder
Product_Image
Image_Cached
Creating database records

PageComment
Order
The 'SimpleShippingModifier' and 'TaxModifier' objects have been successfully created and linked to the appropriate orders present in the 'Order' table

[User Error] Couldn't run query: ALTER TABLE `Order` CHANGE COLUMN `hasShippingCost` `_obsolete_hasShippingCost` tinyint(1) Duplicate column name '_obsolete_hasShippingCost'
GET /dev/build/?flush=1

Line 401 in /home/thirteen/public_html/sapphire/core/model/MySQLDatabase.php

Source

392 	}
393 	
394 	function databaseError($msg, $errorLevel = E_USER_ERROR) {
395 		// try to extract and format query
396 		if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
397 			$formatter = new SQLFormatter();
398 			$msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
399 		}
400 		
401 		user_error($msg, $errorLevel);
402 	}
403 }
404 
405 /**
406  * A result-set from a MySQL database.
407  * @package sapphire
Trace

Couldn't run query: ALTER TABLE `Order` CHANGE COLUMN `hasShippingCost` `_obsolete_hasShippingCost` tinyint(1) Duplicate column name '_obsolete_hasShippingCost' 
Line 401 of MySQLDatabase.php
MySQLDatabase->databaseError(Couldn't run query: ALTER TABLE `Order` CHANGE COLUMN `hasShippingCost` `_obsolete_hasShippingCost` tinyint(1) | Duplicate column name '_obsolete_hasShippingCost',256) 
Line 102 of MySQLDatabase.php
MySQLDatabase->query(ALTER TABLE `Order` CHANGE COLUMN `hasShippingCost` `_obsolete_hasShippingCost` tinyint(1),256) 
Line 120 of DB.php
DB::query(ALTER TABLE `Order` CHANGE COLUMN `hasShippingCost` `_obsolete_hasShippingCost` tinyint(1)) 
Line 720 of Order.php
Order->requireDefaultRecords() 
Line 212 of DatabaseAdmin.php
DatabaseAdmin->doBuild(,1) 
Line 98 of DatabaseAdmin.php
DatabaseAdmin->build() 
Line 136 of DevelopmentAdmin.php
DevelopmentAdmin->build(HTTPRequest) 
Line 129 of RequestHandler.php
RequestHandler->handleRequest(HTTPRequest) 
Line 119 of Controller.php
Controller->handleRequest(HTTPRequest) 
Line 280 of Director.php
Director::handleRequest(HTTPRequest,Session) 
Line 121 of Director.php
Director::direct(/dev/build/) 
Line 118 of main.php