DB problem

Comments

• admin

  January 2014 edited 3:56PM

  Fuel assumes that the field is "id". To fix you'll need to do a select with an alias for ID in your list_items method:
  function list_items($limit = NULL, $offset = NULL, $col = 'name', $order = 'desc', $just_count = FALSE) { $this->db->select('coursesID as id, column1, column2, column3...etc'); $data = parent::list_items($limit, $offset, $col, $order, $just_count = FALSE); return $data; }
  Also, did you set the $key_field property on your model to coursesID?
• toquis

  January 2014 edited 3:56PM

  Thank you for your answer. Sorry if my following question are dumb.
  
  But where do I have to set the $key_field?
  
  I did what you told me about the alias, and the main page of the module was not displaying errors. But when I clicked on create it's the same database error
  
  Then I set public $key_field = array('coursesID'); above the model's construct function. Finally the create page is working. But now the main page display the same php error that I mentioned.
• admin

  January 2014 edited 3:56PM

  To debug the query you can uncomment line 294 in the base_module_model.php file. That's the query that gets run to display the list view.
  
  Also, I'd set the $key_field to just 'coursesID' not wrapped in an array unless you have a compound key
• toquis

  January 2014 edited 3:56PM

  Thank you so much for the answers in all my questions. It's been really helpful, I really appreciate it.