Expressionengine Error Number 1064
Contents |
up log in tour help Tour Start 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 jinstaller install sql error db function failed with error number 1064 Us Learn more about Stack Overflow the company Business Learn more about hiring
Mysql Error Number 1064
developers or posting ads with us ExpressionEngine® Answers Questions Tags Users Badges Unanswered Ask Question _ ExpressionEngine® Answers is a error number 1064 codeigniter question and answer site for administrators, end users, developers and designers for ExpressionEngine® CMS. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Error Number: 1064, ExpressionEngine 1.7.3 Chrome Bug up vote 1 down vote favorite I am getting the following error in Chrome for my site: MySQL ERROR: Error Number: 1064 Description: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'd code on line 341'' at line 1 Query: SELECT cat_name FROM exp_categories WHERE cat_id ='Notice: Undefined variable: catID in /www/eh17535/public_html/cp/core/core.functions.php(672) : eval()'d code on line 341' I am only getting this in Chrome, IE and firefox work fine. Can anyone help me? Thanks, Allison error ee1 debugging share|improve this question asked Aug 14 '13 at 17:03 Allison S. 162 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote By definition, a server-side error (like the MySQL error you describe) cannot be happening in one browser but not another. So my guess is that you're simply viewing the specific page on which it is happening with Chrome, and viewing a different page in Firefox and IE. (Or, another possibility - you're logged-in in Chrome, but not the others, and the error is triggered by code that is only running for logged-in users.) My guess - you have a custom add-on or PHP in a specific template that's running a query which triggers the error. Search your templates for $catID to find the culprit. share|improve this answer answered Aug 14 '13 at 20:11 Derek Hogue♦ 16.4k21538 Yu
Fieldtypes Modules Plugins Submit an Add-on Extras Articles Buy Store Credit Hooks AcademEE Awards Developers EE Config Variables For a more accurate search, use quotation marks. Add-ons (All) Add-ons (All) Add-ons (EE2) Add-ons (EE3) Everything Articles/News Hooks search Fieldtype Developer Supported Illuminated ExpressionEngine 2 Back to this add-on's main page View Other Add-ons From Isaac Raway Illuminated>Thread You must be logged in to post. [Resolved] Error Number: 1064 Bug (Resolved) elsuertudo Posted: 20 September 2012 01:45 PM Here's one for you: http://expressionengine.stackexchange.com/questions/12737/error-number-1064-expressionengine-1-7-3-chrome-bug ---------- Error Number: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)' at line 3 SELECT `entry_id`, `url_title` FROM (`ee_channel_titles`) WHERE `entry_id` IN () Filename: third_party/illuminated/ft.illuminated.php Line Number: 144 ---------- What other info can I give you to resolve this? Basically I https://devot-ee.com/add-ons/support/illuminated/viewthread/7237 just created some fields, put some plain filler text in (no HTML) and saved. I'm on a local development server at the moment. MetaSushi Posted: 20 September 2012 10:18 PM # 1 Developer You should be able to fix this error for now by turning on the Pages module. This feature is provided to allow for use of tokens such as {page_url:123} to get the full URL to page ID 123. This of course only works if Pages or Structure is installed. I will update the fieldtype to note fail when these modules are not available. MetaSushi Posted: 20 September 2012 10:23 PM # 2 Developer I wasn't able to recreate this locally, but I've just uploaded a new build - 1.2 - that should fix the issue. Please let me know if this new build, activating the Pages module, fixes your issue! elsuertudo Posted: 21 September 2012 05:05 AM # 3 Actually I've had the pages module on from the start but I had no pages created yet. I've installed Illuminated
here for http://stackoverflow.com/questions/18706479/error-number-1064-in-codeigniter 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 error number developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; error number 1064 it only takes a minute: Sign up Error Number: 1064 in codeigniter up vote 0 down vote favorite 1 I am getting this error when ever i am uploading a file and storing details in the database using codeigniter here is my controller public function sugsn_up() { if ( $this->session->userdata('login_state') == FALSE ) $this->load->view('faculty/facultylog1_view'); else { $config['upload_path'] = './suggestion/'; $config['allowed_types'] = 'pdf|doc|docx|txt'; $config['max_size'] = '10000000'; $emp_id=$this->session->userdata('emp_id'); $this->load->library('upload', $config); $tname='subject_master'; $res['sub']=$this->faculty_model->return_rec($tname); $tname='course_master'; $res['crse']=$this->faculty_model->return_rec($tname); if ( ! $this->upload->do_upload()) { $error = array('error' => $this->upload->display_errors()); $this->load->view('faculty/up_sugsn', $error,$res); } else { $data = array('upload_data' => $this->upload->data()); $path=base_url().'attendence/'.$data['upload_data']['file_name']; $sdata=array('sug_id'=>NULL, 'emp_id'=>$emp_id, 'sug_name'=>$_POST['sugsn_name'], 'course_id'=> $_POST['cid'], 'sub_id'=> $_POST['sid'], 'link'=>$path ); $this->faculty_model->sugsn_up($sdata); $this->load->view('faculty/upload_success', $data); } } } and this is my model public function sugsn_up($sdata) { $this->db-