Exclusive eBooks, Software Solutions, Quality Guaranteed
 
Web NukeBiz
Welcome to NukeBiz · Members
Amazon
show cart or checkout0 items
Cart Value: 0.00

Forums » DragonflyCMS Projects » Storez » [solved] Storez upgrade to 9.5.0 SQL error
[solved] Storez upgrade to 9.5.0 SQL error
A comprehensive shopping cart solution.
Topic initiation via Bugger.

Post new topic    Reply to topic    Printer Friendly Page     Forum Index »  eCommerce » Storez

View previous topic :: View next topic  
Author Message
layingback
Nice Poster
Nice Poster

Offline Offline
Joined: Feb 26, 2007
Posts: 77

PostPosted: Wed Jan 18, 2012 1:55 pm
Post subject: [solved] Storez upgrade to 9.5.0 SQL error

Upgrading from 9.4.1

CMS Warning line 75: On /admin.php?op=modules&upgrade=21 While executing query "ALTER TABLE cms_cart_brands CHANGE creation_date creation_date DATETIME NOT NULL DEFAULT ''" the following error occured: Invalid default value for 'creation_date' In: /****/****/public_html/includes/classes/installer.php on line: 115

Also the similar UPDATE commands which precede these did action either.

I manually updated date values in phpMyAdmin as workaround, but reporting for benefit of others.

MySQL 5.0.92-community-log (client: 5.0.92) PHP 5.3.8 DF 9.2.1

Initiated by Bugger (Original Entry) - Comments Here Please.


layingback's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux/2.2.8/5.1.73/5.4.21/9.4.0
Back to top
View user's profile Visit poster's website
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Wed Jan 18, 2012 2:50 pm
Post subject: Re: Storez upgrade to 9.5.0 SQL error

I tested this upgrade originally, and again now - same result, no problem.

The default value 1000-01-01 00:00:00 is correct, especially so for strict compliance.

MySQL 5.0.92

dev.mysql.com/doc/refm...etime.html

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Thu Jan 19, 2012 8:43 am
Post subject: Re: Storez upgrade to 9.5.0 SQL error

Update your DF version - 9.2.1 is three years out of date.

You won't have issues with v9.3.2.

_________________
DonationsPro for vBulletin, SMF, MyBB, DragonflyCMS


Phoenix's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Back to top
View user's profile Visit poster's website ICQ Number Yahoo Messenger Photo Gallery
Display posts from previous:   
Post new topic    Reply to topic    Printer Friendly Page    Forum Index »  eCommerce » Storez
Page 1 of 1
All times are GMT + 9.5 Hours



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum