Error No 1054
Contents |
Download Documentation Documentation Screencasts
Error 1054 Group Policy
Support General Support Community Forums Bug Tracker Contact Us Extensions Partners Community Forums Board
Error 1054 Unknown Column In 'field List'
index Change font size Search FAQ Register Login Information The requested topic does not exist. Board index The team • Delete all board cookies • All times are UTC error 1054 joomla - 6 hours Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group Protected by Anti-Spam ACP Get Social Follow us on the social media web sites. Newsletter Subscribe to our newsletters and be informed of new releases and other OpenCart events. Subscribe here Contact Us OpenCart Limited, Unit 16, 26/F, Tuen Mun Central Square, 22 Hoi Wing Road, Tuen Mun, Hong Kong +852 24990996 Send email via our contact form Copyright © 2012 OpenCart - All rights reserved Hosted by A2 Hosting
here for a quick overview of the site Help Center Detailed answers to error 1054 (42s22) unknown column 'password' in 'field list' any questions you might have Meta Discuss the workings and policies error 1054 in mysql of this site About Us Learn more about Stack Overflow the company Business Learn more error 1054 sql about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack http://forum.opencart.com/viewtopic.php?f=20&t=110065 Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up A Database Error Occurred Error Number: 1054 Unknown column… in 'field list' up vote 0 down vote favorite I can't get my head round this... Controller: public function http://stackoverflow.com/questions/19823666/a-database-error-occurred-error-number-1054-unknown-column-in-field-list update() { $string = 'xml/gzip'; $xml = simplexml_load_file("compress.zlib://$string"); foreach ($xml->merchant as $merchant) { $merchant_name = $merchant['name']; $merchant_id = $merchant['id']; $data1 = array( 'merchant_id' => $merchant_id, 'merchant_name' => $merchant_name ); $this->load->model('Administration_model'); $this->Administration_model->insert_merchants($data1); } } Model: public function insert_merchants($data1) { $this->db->insert('merchants', $data1); } The foreach loop in my controller is running data from an xml spreadsheet, and as the error says - the values '911' and 'website.com' SHOULD be the inserted values... So why is it determining 'website.com' as a 'field list'? Error: A Database Error Occurred Error Number: 1054 Unknown column 'website.com' in 'field list' INSERT INTO `merchants` (`merchant_id`, `merchant_name`) VALUES (911, website.com) Would it have anything to do with the fact that merchant_id is a primary column and this is technically a duplicate entry... And if so, any tips on how to add "ON DUPLICATE KEY..." functionality? mysql codeigniter insert-update mysql-error-1054 share|improve this question edited Nov 6 '13 at 22:04 lserni 29.6k52758 aske
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us http://stackoverflow.com/questions/17606193/opencart-error-no-1054-when-moving-servers Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community http://www.ukbusinessforums.co.uk/threads/opencart-error-1054-mysql-issue.294394/ Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Opencart Error No: 1054 when moving servers up vote 0 down vote favorite I am moving an installation of Opencart from one server to another and I am getting an error: Error: Unknown column 'store_id' in 'where clause' Error No: 1054 SELECT * FROM error 1054 setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC I put the installation on the local instance to test and everything works fine however when I move it to the server I get the above. There is not an update to the software and all DB/paths are correct as I have another opencart installation which was moved at the same time and that one works. I have checked that store_id exists in setting. Any suggestions? php opencart share|improve this question asked error 1054 (42s22) Jul 12 '13 at 1:31 puks1978 1,53042658 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted Either the table hasn't copied over correctly, or you're using a more up to date version of OpenCart with an older version of a database. Try to re-upload your setting table from your local working version share|improve this answer answered Jul 12 '13 at 1:38 Jay Gilford 12.8k42547 Table copied over correctly. I tried 3 times 1 with the original dump and twice with the local version. I am using the same version DB as my local however my PHP on the server. Locally I am using PHP 5.4.8 and on the server 5.4.14. Will that matter considering the other migration works? –puks1978 Jul 12 '13 at 2:01 Highly unlikely to be honest. If you run EXPLAIN setting via console/PHPMyAdmin what does it show for both tables (add to your original question if they differ). The only other thing I can think of is that the DB credentials are wrong and you're using an incorrect database to the one you think you are –Jay Gilford Jul 12 '13 at 2:04 Both were the same but you were right. For some reason when the migration happened the site that wasn't working was trying to connect to the DB of the site that was working...sorry for wasting you time –puks1978 Jul 12 '13 at 2:12 Ah. You need to edit your config.php and admin/config.php
More... Forums Forums Quick Links Recent Posts UKBF CONTENT Blogs Blogs Quick Links Blogs Home Page All Blogs Members Members Quick Links Notable Members Registered Members Current Visitors Recent Activity Directory Directory Quick Links Directory Home New Listings Marketplace Rules & Help Membership Meet the Team Menu UK Business Forums Home > Forums > Technology > IT & Internet > Dismiss Notice Hey Guest, make sure to follow us on Twitter! Say hi and we'll be sure to follow back! Follow @ukbizforums OpenCart Error 1054 MySQL Issue Discussion in 'IT & Internet' started by NetwiseHosting, Apr 18, 2013. NetwiseHosting UKBF Enthusiast Full Member - Verified Business Posts: 621 Likes: 137 Hi All, I hope you are well. A quick issue with a friends website - I haven't been able to shine any light on the issue even with a dig around on the Open Cart forums, so I was wondering if you may be able to assist. In short, he has an Open Cart shop which was upgraded from version 1.5.1 to 1.5.5.1 - all went relatively smoothly, but he is now getting the following error message in the admin panel when he navigates to System > Settings > Edit Notice: Error: Unknown column 'name' in 'order clause' Error No: 1054 SELECT * FROM customer_group ORDER BY name ASC in /system/database/mysql.php on line 50 If you could offer any assistance it would be very much appreciated - beer tokens up for grabs. All the best, Matthew www.netwisehosting.co.uk | High-value, low-cost UK Dedicated Server and Colocation solutions. > Discover more about our private London Data Centres. > Looking for Server Hosting? Check out our latest offers here. Posted: Apr 18, 2013 By: NetwiseHosting Member since: Jun 16, 2009 #1 Subbynet UKBF Legend Moderator Posts: 6,066 Likes: 1,101 Is there a field called "name" in the customer_group table? If not, I think you need to add one. Posted: Apr 18, 2013 By: Subbynet Member since: Aug 1, 2005 #2 Thanks x 1 List NetwiseHosting UKBF Enthusiast Full Member - Verified Business Posts: 621 Likes: 137 Hi Martin, Fixed! Thank you very much - I will pass on the good news now. All the best, Matthew www.netwisehosting.co.uk | High-value, low-cost UK Dedicated Server and Colocation solutions. > Discover more about our private London Data Centres. > Looking for Server Hosting? Check out our latest offers here. Posted: Apr 18, 2013 By: NetwiseHosting Member since: Jun 16, 2009 #3 Thanks x 1 List Subbynet UKBF Legend Moderator Posts: 6,066 Likes: 1,101 Good stuff... Glad to be of service. Feel free to send beer tokens haha Posted: Apr 18, 2013 By: Subbynet Member si