1054 - Unknown column 'cc_transactionid' in 'field list'
select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified, cc_transactionid from orders where orders_id = '2'
When checking in phpMyAdmin it seems that the field "cc_transactionid" doesn't exist in the table orders. Can I simply add it to the table? In that case I need the layout of it?
Thanks in advance
kristofferseninvestMember Since 04 Jul 2012
Offline Last Active Jul 24 2012 01:45 PM
- Group Members
- Active Posts 0
- Profile Views 297
- Age Age Unknown
- Birthday Birthday Unknown
kristofferseninvest hasn't added any friends yet.
No latest visitors to show