Error Number 1064 Expressionengine
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 Us Learn more about Stack Overflow the company Business Learn more jinstaller install sql error db function failed with error number 1064 about hiring developers or posting ads with us ExpressionEngine® Answers Questions Tags Users Badges Unanswered
Mysql Error Number 1064
Ask Question _ ExpressionEngine® Answers is a question and answer site for administrators, end users, developers and designers for ExpressionEngine® CMS. Join them; it error number 1064 codeigniter 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 Yup, you're right. I was logged in, which showed the variable it didn't recognize. Once I logged out, the error was gone. Thanks! –Allison S. Aug 15 '13 at 20:14 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a
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: ---------- Error Number: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the http://expressionengine.stackexchange.com/questions/12737/error-number-1064-expressionengine-1-7-3-chrome-bug 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 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 https://devot-ee.com/add-ons/support/illuminated/viewthread/7237 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 1.2 and done some testing afterwards. It turns out it doesn't just need the pages module to be activated but also needs at least one page to have been created. You might want to update Illuminated so it doesnt depend so much on that and in the meantime put a note in the module docs. Anyhow, its working now. Thank you for your quick and useful response. Have a great day
upgrade path. Click here to read more. Features powerful Admin & Reporting Customers & Orders Products & Inventory Control Promotions & Sales Themes http://www.brilliantretail.com/forum/viewreply/1731/ & Templating Tour demo store Showcase customers Resources support & docs Community Support Forum Developer Documents User Guide Frequently Asked Questions Services consulting Download View on Github https://boldminded.com/support/ticket/382 BrilliantRetail Community Forum HomeSupport QuestionsInstallation IssuesThread you must login to post Email Password Fresh install error (ee 2.7.2 - br 1.5.0.0) Roy Lodder Posted: 09 error number December 2013 09:26 AM [ Ignore ] Newbie Total Posts: 2 Joined 2011-10-05 I get an error when I try to install br 1.5.0.0 on an fresh install of EE version 2.7.2. Anyone else that got this error? ------------------------ A Database Error Occurred Error Number: 1064 You have an error in your SQL syntax; check the error number 1064 manual that corresponds to your MySQL server version for the right syntax to use near ‘`exp_br_password_reset' at line 1 DROP TABLE IF EXISTS `exp_br_password_reset Filename: path/to/eecms/system/codeigniter/system/database/DB_driver.php Line Number: 330 ------------------------ EDIT: when I press "back" on the error screen I get this error.------------------------ A Database Error Occurred Error Number: 1146 Table ‘eecms.exp_br_store' doesn't exist SELECT `s`.*, `c`.`code` as currency, `c`.`currency_id`, `c`.`marker` as currency_marker FROM (`exp_br_store` s) JOIN `exp_br_currencies` c ON `c`.`currency_id` = `s`.`currency_id` Filename: path/to/eecms/system/codeigniter/system/database/DB_driver.php Line Number: 330 David P. Dexter Posted: 09 December 2013 11:56 AM [ Ignore ] [ # 1 ] Administrator Total Posts: 827 Joined 2010-07-22 I've posted an update which will resolve your issues. (version 1.5.1) Happy Monday… David Signature David Dexter | Technical Director | Get BrilliantRetail Now! Roy Lodder Posted: 09 December 2013 02:46 PM [ Ignore ] [ # 2 ] Newbie Total Posts: 2 Joined 2011-10-05 It works! Thanks for your fast support/solution. Best Roy ‹‹ Updated
Question -- Severity -- TrivialCriticalBlocker Search Publisher for EE3 is currently in the works. Please do not email or tweet asking when it will be finished. It is a large refactor to take advantage of the new architecture in EE3, which takes time. The goal is to release it in 2016. Publisher is the only BoldMinded add-on that is currently being worked on for EE3. All other add-ons will be evaluated when Publisher is complete. Thank you for your patience. Ticket: Error with query for sites Status Resolved Add-on / Version Snippet Sync Severity Critical EE Version 24 Pierre Bayartz Mar 06, 2013 Hi, I'm getting more and more in trouble with your extension called "snippetsync". I get the following error with channel ratings from devdemon: {"error":"Error Number: 1064<\/p>\n\nYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`.`title`, `exp_`ct`.`url_title`, `exp_`ch`.`channel_title`, `exp_`cr`.`rating`,' at line 1<\/p>\n\nSELECT `exp_`ct`.`title`, `exp_`ct`.`url_title`, `exp_`ch`.`channel_title`, `exp_`cr`.`rating`, `exp_`cr`.`rating_status`, `exp_`cr`.`rating_date`, `exp_`cr`.`rating_author_id`, `exp_`cr`.`rating_id`, `exp_`mb`.`screen_name` AS rating_author_screen_name, `site_name`, `site_id`\nFROM (`exp_channel_ratings` cr, `exp_sites`)\nLEFT JOIN `exp_members` mb ON `mb`.`member_id` = `cr`.`rating_author_id`\nLEFT JOIN `exp_channel_titles` ct ON `ct`.`entry_id` = `cr`.`entry_id`\nLEFT JOIN `exp_channels` ch ON `ch`.`channel_id` = `cr`.`channel_id`\nWHERE `cr`.`site_id` = '1'\nAND `cr`.`collection_id` = '1'\nAND `cr`.`rating_type` = 1\nAND `cr`.`field_id` = 0\nLIMIT 15<\/p>\n\nFilename: third_party\/snippet_sync\/ext.snippet_sync.php<\/p>\n\nLine Number: 63<\/p>"} Can you help me please? Thanks and best regards Pierre Bayartz #1 BoldMinded (Brian) Mar 06, 2013 I have a feeling its not Snippet Sync that is the issue. That error is on