edit delete option disappearing in module

Comments

• admin

  February 2016 edited 3:31AM

  You need to include the "id" field so that the table knows what id to edit
• methakon

  February 2016 edited 3:31AM

  it is already their my table structure is like this
  CREATE TABLE `package_type` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `sample_image` varchar(255) NOT NULL,
  `box` enum('orange','blue','pink') NOT NULL,
  `is_disabled` tinyint(1) NOT NULL DEFAULT '0',
  `is_deleated` tinyint(1) NOT NULL DEFAULT '0',
  `modified_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `post_date` datetime NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  ALTER TABLE `package_type`
  ADD PRIMARY KEY (`id`);
  
  ALTER TABLE `package_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=0;
• methakon

  February 2016 edited 3:31AM

  ok i got it the issue is resolve by using
  $this->db->select('id,name,image,box,sample_image', FALSE);
• marcus_at_localhost

  August 2018

  If using table_headers in Simple Module config you need to add the ID/Primary Key column to show EDIT/DELETE!

  $config['modules']['tests'] = array(
      'module_name'    => 'Test',
      'module_uri'     => 'tests',
      'model_name'     => 'Tests_model',
      'table_headers'  => [
          'id'    => 'ID',  // IMPORTANT to show EDIT|DELETE
          'title' => 'Title',
      ]
  );
  
• marko_mo

  September 2019

  Perfect! "ID" worked for me. Thanks!