Mysql Error Error Number 1146 Expressionengine
forgot password? This is an archived forum and may no longer be relevant. The active forums are here. Advanced Search Database Error Occurred Error Number: 1146 strudel Posted: 18 October 2013 05:08 PM Joined: 2009-02-24181 posts Hi, I'm working on a new site, using a fresh install of 2.7.2. Everything's been going swimmingly (sort of), until now I went to edit some custom fields. When I click on a field name to do an edit, I get the following: A Database Error Occurred Error Number: 1146 Table 'my_database_name.exp_grid_columns' doesn't exist SELECT * FROM (`exp_grid_columns`) WHERE `field_id` IN (11) AND `content_type` = 'channel' ORDER BY `col_order` Filename: models/grid_model.php Line Number: 631 Using phpmyadmin, I see that there is in fact no "exp_grid_columns" table in the database. So what does that mean? Should I just create a table with that name? Not actually sure what's involved with that…. I saw a bunch of 1146 error codes relating to the Comment module in the Forum, but this doesn't seem to have anything to do with that (I even tried installing the Comment module). I'm not really a MySQL person, so I'm not sure where to go from here. Any ideas? Thanks in advance! ©2002–2016, EllisLab, Inc.Privacy Policy, Terms of Service built on ExpressionEnginereturn to the top twitter PixelBuzz eNews
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 Extension, Module ArchivedForum (read-only) DevDemon does not actively monitor this forum (but you can still get help from other EE users). Zoo Flexible Admin ExpressionEngine 2 Back to this add-on's main page View Other Add-ons From DevDemon Zoo Flexible Admin>Thread You must be logged in to post. [RESOLVED] Table does not exist General Macker99 Posted: 12 April 2011 01:37 PM Hi I just upgrade to 1.1 and my control panel is broken. I just see the https://ellislab.com/forums/archive/viewthread/238493 following error. I have no access to the control panel at all Error Number: 1146 Table exp_ndg_flexible_admin_menus' doesn't exist SELECT `startpage`, `hide_sidebar` FROM (`exp_ndg_flexible_admin_menus`) WHERE `group_id` = ‘1' AND `site_id` = ‘1' Filename: ...\ee-admin-new\codeigniter\system\database\DB_driver.php Line Number: 330 NicoDG Posted: 12 April 2011 01:46 PM # 1 To regain access, you can replace the ndg flexible admin folder in the third party folder with the old version. Then go to your accessories and disable the flexible https://devot-ee.com/add-ons/support/zoo-flexible-admin/viewreply/3995 admin accessory, do not remove the module if you want to keep your menus. Then replace the folder with the new one, go to the flexible admin module page, this will update the module. Then go to extensions overview and activate the flexible admin extension. Macker99 Posted: 12 April 2011 01:58 PM # 2 Thanks for the quick response I replaced the folder but i am now getting the following error Unable to load the following extension file: ext.ndg_flexible_admin.php NicoDG Posted: 12 April 2011 02:03 PM # 3 do you have access to your mysql table, otherwise you can de-activate it in the table exp_extensions in the row ndg_flexible_admin by settings enabled to "n" If you want me to have a look, you can mail me cp login and ftp at nico at hiredguns dot be Macker99 Posted: 12 April 2011 02:17 PM # 4 thanks i edit the database table and set the values to no. What should I do next to reinstall? NicoDG Posted: 12 April 2011 02:22 PM # 5 go to the module page where you can edit the tree, it should force the module to update and insert the required table fields that are missing. If you can then edit and save a tree, check "hide sidebar" for example to check if it's working. I
here for a quick overview of the site Help Center Detailed answers to any questions you http://stackoverflow.com/questions/29997668/codeigniter-error-number-1146-table-doesnt-exist-after-execute-a-create-ta 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 http://www.brilliantretail.com/forum/viewreply/1731/ 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 mysql error of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up CodeIgniter - Error Number: 1146 (Table doesn't exist after execute a “CREATE TABLE” command) up vote 1 down vote favorite I've posted yesterday an issue with an mySQL update syntax on CodeIgniter in here: CodeIgniter mysql error error - MySQL Error 1064 (Update table1 inner join table2(...)) But now after I solved that problem, another one come up. Now the update query doesn't know the new created table. But if I change to a select statement, it works smoothly. For that reason I've decided to post the full script. Code: load->database(); $query_tbaux='CREATE TABLE IF NOT EXISTS STUDY_LIST_AUX AS ( SELECT DISTINCT p.pat_id, p.pat_custom1 age, p.pat_name, p.pat_sex, s.study_iuid, p.pat_birthdate, s.accession_no, s.study_datetime date_s, s.study_desc, s.mods_in_study, s.pk, c.institution, s.study_block, s.study_urgent, \'0000-00-00 00:00:00\' AS \'report_date\', \'{null}\' AS \'report_status\', s.study_tipo, s.study_src, s.study_consulta FROM study s INNER JOIN patient p ON s.patient_fk = p.pk INNER JOIN series c ON c.study_fk = s.pk INNER JOIN rel_users_hosp u ON u.hosp_id = c.institution WHERE s.study_datetime >= \'2015-04-26 00:00:00\' AND s.study_datetime <= \'2015-04-30 23:59:59\' AND s.study_iuid IS NOT NULL AND u.user_id = \'admin\' )'; if ($this->db->query($query_tbaux)) { echo "Q True!
"; $data = array( 'STUDY_LIST_AUX.report_date' => "DATE_FORMAT(study_report.report_date,'%Y-%m-%d %h:%i:%s')", 'STUDY_LIST_AUX.report_status' => 'study_report.report_status', ); $this->db->update('STUDY_LIST_AUX, study_report', $data, array('STUDY_LIST_AUX.study_iuid'=>'study_report.study_iuid')); } el
upgrade path. Click here to read more. Features powerful Admin & Reporting Customers & Orders Products & Inventory Control Promotions & Sales Themes & 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 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 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 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 R