FullSiteTreeSort problem (Urgent Nicolaas)

25 views
Skip to first unread message
Josua

unread,
Jun 21, 2012, 4:44:20 AM6/21/12
to silverstrip...@googlegroups.com
Hi Nicolaas!

With the latest trunk version I can not do a build:
[User Error] Couldn't run query: ALTER TABLE "ProductVariation" ADD "FullName" mediumtext character set utf8 collate utf8_general_ci, ADD "FullSiteTreeSort" varchar(110) character set utf8 collate utf8_general_ci, ADD index "FullName" (FullName), ADD index "FullSiteTreeSort" (FullSiteTreeSort), CHANGE "Price" "Price" decimal(9,2) not null default 0 BLOB/TEXT column 'FullName' used in key specification without a key length

Thanks,
Regards,
Jose
--------------------------------------
Environment Builder
http://127.0.0.1/
dev→ build
Building database ss_commerce2 using MySQL 5.5.20-log

Creating database tables
TrackBackPing
TrackBackURL
BootstrapCarouselSlide
PageComment
CheckoutPage_StepDescription
EcommerceDBConfig
OrderEmailRecord
Order
OrderAttribute
Field OrderAttribute.CalculatedTotal: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
OrderModifier_Descriptor
EcommerceCountry
EcommerceRegion
OrderAddress
OrderStatusLog
OrderStep
EcommerceCurrency
EcommerceCurrencyFormat
ComplexPriceObject
Field ComplexPriceObject.NewPrice: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field ComplexPriceObject.Reduction: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
DiscountCouponOption
Field DiscountCouponOption.MaximumDiscount: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field DiscountCouponOption.DiscountAbsolute: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field DiscountCouponOption.DiscountPercentage: changed to decimal(4,2) not null default 0 (from decimal(4,2) not null default 0.00)
Field DiscountCouponOption.MinimumOrderSubTotalValue: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
EcommerceProductTag
ProductAttributeType
ProductAttributeValue
ProductVariation
Field ProductVariation.Price: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field ProductVariation.FullName: created as mediumtext character set utf8 collate utf8_general_ci
Field ProductVariation.FullSiteTreeSort: created as varchar(110) character set utf8 collate utf8_general_ci
Index ProductVariation.FullName: created as (FullName)
Index ProductVariation.FullSiteTreeSort: created as (FullSiteTreeSort)
Field ProductVariation_versions.Price: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field ProductVariation_versions.FullName: created as mediumtext character set utf8 collate utf8_general_ci
Field ProductVariation_versions.FullSiteTreeSort: created as varchar(110) character set utf8 collate utf8_general_ci
Index ProductVariation_versions.FullName: created as (FullName)
Index ProductVariation_versions.FullSiteTreeSort: created as (FullSiteTreeSort)
GSTTaxModifierOptions
ForumCategory
ForumThread
ForumThread_Subscription
Post
Payment
Field Payment.AmountAmount: changed to decimal(19,4) not null default 0 (from decimal(19,4) not null default 0.0000)
RecurringPayment
Field RecurringPayment.AmountAmount: changed to decimal(19,4) not null default 0 (from decimal(19,4) not null default 0.0000)
SiteConfig
SiteTree
Email_BounceRecord
QueuedEmail
File
Group
LoginAttempt
Member
MemberPassword
Permission
PermissionRole
PermissionRoleCode
Widget
WidgetArea
S3File
OrderItem
OrderModifier
Field OrderModifier.TableValue: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Product_OrderItem
CombinationProduct_OrderItem
IncludedProduct_OrderItem
ProductVariation_OrderItem
FlatTaxModifier
Field FlatTaxModifier.TaxableAmount: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
SimpleShippingModifier
SubTotalModifier
RecommendedProductsModifier
AnyPriceRoundUpDonationModifier
Field AnyPriceRoundUpDonationModifier.ModifierTotalExcludingDonation: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field AnyPriceRoundUpDonationModifier.SubTotal: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field AnyPriceRoundUpDonationModifier.OtherValue: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
CombinationProductModifier
DiscountCouponModifier
Field DiscountCouponModifier.SubTotalAmount: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
GSTTaxModifier
Field GSTTaxModifier.RawTableValue: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
BillingAddress
ShippingAddress
OrderStatusLog_Submitted
Field OrderStatusLog_Submitted.Total: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field OrderStatusLog_Submitted.SubTotal: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
OrderStatusLog_Cancel
OrderStatusLog_Dispatch
OrderStatusLog_PaymentCheck
OrderStatusLog_Archived
ElectronicDelivery_OrderLog
OrderStatusLog_DispatchElectronicOrder
OrderStatusLog_DispatchPhysicalOrder
OrderStep_Created
OrderStep_Submitted
OrderStep_SentInvoice
OrderStep_Paid
OrderStep_Confirmed
OrderStep_SentReceipt
OrderStep_Sent
OrderStep_Archived
ElectronicDelivery_OrderStep
EcommercePaymentExtension
ChequePayment
DPSPayment
EwayXMLPayment
PayPalPayment
PaystationHostedPayment
PaystationPayment
WorldpayPayment
PayPalExpressCheckoutPayment
DirectCreditPayment
DPSRecurringPayment
Field DPSRecurringPayment.AuthAmount: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Page
BlogEntry
BlogTree
AccountPage
CartPage
Product
Field Product.Price: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field Product.Weight: changed to decimal(9,4) not null default 0 (from decimal(9,4) not null default 0.0000)
Field Product.FullName: created as mediumtext character set utf8 collate utf8_general_ci
Field Product_Live.Price: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field Product_Live.Weight: changed to decimal(9,4) not null default 0 (from decimal(9,4) not null default 0.0000)
Field Product_Live.FullName: created as mediumtext character set utf8 collate utf8_general_ci
Field Product_versions.Price: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field Product_versions.Weight: changed to decimal(9,4) not null default 0 (from decimal(9,4) not null default 0.0000)
Field Product_versions.FullName: created as mediumtext character set utf8 collate utf8_general_ci
ProductGroup
Forum
ForumHolder
MainPage
ErrorPage
RedirectorPage
VirtualPage
BlogHolder
CheckoutPage
OrderConfirmationPage
AnyPriceProductPage
Field AnyPriceProductPage.MinimumAmount: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field AnyPriceProductPage.MaximumAmount: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field AnyPriceProductPage_Live.MinimumAmount: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field AnyPriceProductPage_Live.MaximumAmount: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field AnyPriceProductPage_versions.MinimumAmount: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field AnyPriceProductPage_versions.MaximumAmount: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
CombinationProduct
Field CombinationProduct.NewPrice: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field CombinationProduct_Live.NewPrice: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
Field CombinationProduct_versions.NewPrice: changed to decimal(9,2) not null default 0 (from decimal(9,2) not null default 0.00)
PriceListPage
ProductGroupWithTags
FLV
MP3
Post_Attachment
Image
Folder
Product_Image
Image_Cached
ArchiveWidget
BlogManagementWidget
RSSWidget
SubscribeRSSWidget
TagCloudWidget
CartWidget
CurrencyWidget
LatestBlogs
S3Image
S3Image_Cached
[User Error] Couldn't run query: ALTER TABLE "ProductVariation" ADD "FullName" mediumtext character set utf8 collate utf8_general_ci, ADD "FullSiteTreeSort" varchar(110) character set utf8 collate utf8_general_ci, ADD index "FullName" (FullName), ADD index "FullSiteTreeSort" (FullSiteTreeSort), CHANGE "Price" "Price" decimal(9,2) not null default 0 BLOB/TEXT column 'FullName' used in key specification without a key length
GET /dev/build?flush=all

Line 525 in C:\wamp\www\sapphire\core\model\MySQLDatabase.php
Source

516 	}
517 	
518 	function databaseError($msg, $errorLevel = E_USER_ERROR) {
519 		// try to extract and format query
520 		if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
521 			$formatter = new SQLFormatter();
522 			$msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
523 		}
524 		
525 		user_error($msg, $errorLevel);
526 	}
527 	
528 	/**
529 	 * Return a boolean type-formatted string
530 	 * 
531 	 * @param array $values Contains a tokenised list of info about this data type

Trace

    Couldn't run query: ALTER TABLE "ProductVariation" ADD "FullName" mediumtext character set utf8 collate utf8_general_ci, ADD "FullSiteTreeSort" varchar(110) character set utf8 collate utf8_general_ci, ADD index "FullName" (FullName), ADD index "FullSiteTreeSort" (FullSiteTreeSort), CHANGE "Price" "Price" decimal(9,2) not null default 0 BLOB/TEXT column 'FullName' used in key specification without a key length
    Line 525 of MySQLDatabase.php
    MySQLDatabase->databaseError(Couldn't run query: ALTER TABLE "ProductVariation" ADD "FullName" mediumtext character set utf8 collate utf8_general_ci, ADD "FullSiteTreeSort" varchar(110) character set utf8 collate utf8_general_ci, ADD index "FullName" (FullName), ADD index "FullSiteTreeSort" (FullSiteTreeSort), CHANGE "Price" "Price" decimal(9,2) not null default 0 | BLOB/TEXT column 'FullName' used in key specification without a key length,256)
    Line 123 of MySQLDatabase.php
    MySQLDatabase->query(ALTER TABLE "ProductVariation" ADD "FullName" mediumtext character set utf8 collate utf8_general_ci, ADD "FullSiteTreeSort" varchar(110) character set utf8 collate utf8_general_ci, ADD index "FullName" (FullName), ADD index "FullSiteTreeSort" (FullSiteTreeSort), CHANGE "Price" "Price" decimal(9,2) not null default 0)
    Line 250 of MySQLDatabase.php
    MySQLDatabase->alterTable(ProductVariation,Array,Array,Array,Array,,)
    Line 186 of Database.php
    SS_Database->endSchemaUpdate()
    Line 217 of DatabaseAdmin.php
    DatabaseAdmin->doBuild(,1)
    Line 106 of DatabaseAdmin.php
    DatabaseAdmin->build(SS_HTTPRequest)
    Line 193 of Controller.php
    Controller->handleAction(SS_HTTPRequest)
    Line 143 of RequestHandler.php
    RequestHandler->handleRequest(SS_HTTPRequest)
    Line 147 of Controller.php
    Controller->handleRequest(SS_HTTPRequest)
    Line 134 of DevelopmentAdmin.php
    DevelopmentAdmin->build(SS_HTTPRequest)
    Line 143 of RequestHandler.php
    RequestHandler->handleRequest(SS_HTTPRequest)
    Line 147 of Controller.php
    Controller->handleRequest(SS_HTTPRequest)
    Line 282 of Director.php
    Director::handleRequest(SS_HTTPRequest,Session)
    Line 125 of Director.php
    Director::direct(/dev/build)
    Line 127 of main.php
Nicolaas Thiemen Francken - Sunny Side Up

unread,
Jun 21, 2012, 4:51:17 AM6/21/12
to silverstrip...@googlegroups.com
Sorry, fixing this now!!!
Josua

unread,
Jun 21, 2012, 6:03:05 AM6/21/12
to silverstrip...@googlegroups.com, n...@sunnysideup.co.nz
Thanks Nicolaas!

El jueves, 21 de junio de 2012 10:51:17 UTC+2, Nicolaas Thiemen Francken - Sunny Side Up escribió: