Codeigniter Error Number 1142
Contents |
Me? Password forgot password? This is an archived forum and may no longer be relevant. The active forums are here. Advanced Search Update error - Error Number: 1142 - database permission franxx Posted: 11 October 2011 03:40 AM Joined: 2007-10-2833 posts This question error number 1054 in codeigniter may be related to a resolved thread. Try to upgrade from ee213 to ee221. It error number 1146 in codeigniter failed. The notice is: A Database Error Occurred Error Number: 1142 There seems to be a solution: "After giving the ‘Manage Indexes’ permission error number 1064 codeigniter to my MySQL user, it seems I was able to upgrade successfully. Now I’m unable to login and have encountered another error." I use phpMyAdmin to manage the database. I don't find, where to Manage Indexes. The error number 1048 codeigniter mysql-documentation about permissions is a little to complicated ... Perhaps someone could give me a hint? Frank Kevin Smith Posted: 11 October 2011 03:20 PM [ # 1 ] Joined: 2008-01-314784 posts Hi Frank, Please work with your host to enable the Manage Indexes permission on your MySQL server. We're not actually able to assist with that sort of thing due to the wide range of configurations that hosts use for the setups. Once
Error Number 1062 Codeigniter
you have the correct permission setup on your MySQL server, please make sure you clear your database and restore the database backup before trying your upgrade again. chris thacker Posted: 01 November 2011 05:11 PM [ # 2 ] Joined: 2003-02-2693 posts this just happened to me for the first time too. i not only had to restore my database but recopy over my original config.php file. the update process modified the "app_version" to 214 within it. i was afraid that rerunning the update process on a 1.6.x database wouldn't be complete or work at all if the update process thought it was on 2.1.4. this is the first time i've seen this issue with any EE updates. is this ‘modify indexes' permission a new requirement? seems like enough people are having the exact same problem and the update instructions perhaps should be modified to prepare us for this. thanks Robin Sowell Posted: 03 November 2011 12:00 PM [ # 3 ] Joined: 2002-05-2012713 posts Morning Chris- I thought index permission had always been required, but took a quick look at the 1.x docs and it wasn't in there. It is fairly rarely used, particularly when compared to the others. But still, definitely needed (and in the 2.x doc's requirements). That said, I'm thinking either a user note or a ‘core' no
here for a quick overview of the site Help Center Detailed answers to any questions
Codeigniter Error 500
you might have Meta Discuss the workings and policies of this codeigniter error 404 page not found site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers codeigniter error message 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 https://ellislab.com/forums/archive/viewthread/201767 community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Codeigniter error session DB up vote 12 down vote favorite 2 After upgrade Codeigniter to version 3.0 I get error DB after trying call any controller: Error Number: 1064 You have an error http://stackoverflow.com/questions/26960544/codeigniter-error-session-db in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `id` = 'd1d384b0ceed0bd72fa210337acc666aab1a04e5'' at line 2 SELECT `data` WHERE `id` = 'd1d384b0ceed0bd72fa210337acc666aab1a04e5' Filename: libraries/Session/drivers/Session_database_driver.php When I reload page, I get that again with a other generated hash session. How to fix? In config.php I set session store: $config['sess_driver'] = 'database'; I looked at file where is a error(line 138): public function read($session_id) { if ($this->_get_lock($session_id) !== FALSE) { // Needed by write() to detect session_regenerate_id() calls $this->_session_id = $session_id; $this->_db ->select('data') ->from($this->_config['save_path']) ->where('id', $session_id); if ($this->_config['match_ip']) { $this->_db->where('ip_address', $_SERVER['REMOTE_ADDR']); } if (($result = $this->_db->get()->row()) === NULL) // Line 138 { $this->_fingerprint = md5(''); return ''; } $this->_fingerprint = md5(rtrim($result->data)); $this->_row_exists = TRUE; return $result->data; } $this->_fingerprint = md5(''); return ''; } php codeigniter share|improve this question edited Nov 16 '14 at 18:42 asked Nov 16 '14 at 18:32 Danil 7516 the correct syntax i
does not exist. error number Board index The team • Delete all board cookies • All times are UTC Quick Links Anti-spam Policy Terms & codeigniter error number Conditions Privacy Policy Resources Forums Documentation Contact Us e: info@phplist.com Twitter RSS Boring Bit phpList is a registered limited company UK Company No. 07582966 VAT Registration 122 0788 37 © phpList 2013 Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group The phpList forums are now closed, and only available for reference. Discussion continues at discuss.phplist.org
Connectors More MySQL.com Downloads Developer Zone Section Menu: Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL Cluster NDB 7.5 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.7 Frequently Asked Questions Errors, Error Codes, and Common Problems Sources of Error Information Types of Error Values Server Error Codes and Messages Client Error Codes and Messages Problems and Common Errors How to Determine What Is Causing a Problem Common Errors When Using MySQL Programs Access denied Can't connect to [local] MySQL server Lost connection to MySQL server Client does not support authentication protocol Password Fails When Entered Interactively Host 'host_name' is blocked Too many connections Out of memory MySQL server has gone away Packet Too Large Communication Errors and Aborted Connections The table is full Can't create/write to file Commands out of sync Ignoring user Table 'tbl_name' doesn't exist Can't initialize character set File Not Found and Similar Errors Table-Corruption Issues Administration-Related Issues Problems with File Permissions How to Reset the Root Password What to Do If MySQL Keeps Crashing How MySQL Handles a Full Disk Where MySQL Stores Temporary Files How to Protect or Change the MySQL Unix Socket File Time Zone Problems Query-Related Issues Case Sensitivity in String Searches Problems Using DATE Columns Problems with NULL Values Problems with Column Aliases Rollback Failure for Nontransactional Tables Deleting Rows from Related Tables Solving Problems with No Matching Rows Problems with Floating-Point Values Optimizer-Related Issues Table Definition-Related Issues Problems with ALTER TABLE TEMPORARY Table Problems Known Issues in MySQL Restrictions and Limits Indexes MySQL Glossary