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 » [fixed] Order Status
[fixed] Order Status
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
Rusty_
Nice Poster
Nice Poster

Offline Offline
Joined: Aug 20, 2008
Posts: 7

PostPosted: Fri May 21, 2010 1:14 pm
Post subject: [fixed] Order Status

Receive a database error when trying to update an order status on 9.4.1


CMS Warning line 75: On /admin.php?op=Storez While executing query "SELECT payMethodName, payMethodData, billEmail, transactionid FROM cms_cart_orders WHERE orderID='2'" the following error occured: Unknown column 'transactionid' in 'field list' In: /home/*****/public_html/modules/Storez/admin/orders.php on line: 480

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


Rusty_'s server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
Linux / 2.2.6 / 5.0.45 / 5.2.4 / Dragonfly (9.2.1)
Back to top
View user's profile
FrankS
New Poster
New Poster

Offline Offline
Joined: Feb 03, 2011
Posts: 2

PostPosted: Thu Feb 17, 2011 9:20 pm
Post subject: Re: Order Status

I am having the same problem, is there a fix for this?

Thanks


FrankS's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
windows
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Fri Feb 18, 2011 12:31 am
Post subject: Re: Order Status

That field was added back in v9.4.0 - it should have been added to the database table when you upgraded the module through admin modules edit.

If not, it is:

transactionid VARCHAR(64) DEFAULT NULL

_________________
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
FrankS
New Poster
New Poster

Offline Offline
Joined: Feb 03, 2011
Posts: 2

PostPosted: Fri Feb 18, 2011 2:04 am
Post subject: Re: Order Status

Thanks for the support Phoenix, do I run this as a sql import? This was a fresh install I also get an error when I click on the coupon admin link.


FrankS's server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS)
windows
Back to top
View user's profile
Phoenix
Chairman
Chairman

Offline Offline
Joined: Mar 17, 2004
Posts: 1543
Location: Netizen
PostPosted: Fri Feb 18, 2011 4:35 am
Post subject: Re: Order Status

Click the SQL tab at the top of phpmyadmin for your db and run this command:

ALTER TABLE cms_cart_orders ADD transactionid VARCHAR( 64 ) DEFAULT NULL

Coupons is only partially completed so it won't work yet.

_________________
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