⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Mysql error with this specific table name



lordlaw

lordlaw
  • profile picture
  • Member

Posted 18 January 2016 - 07:29 AM

my code

 

$crud->set_relation('RoleTypeId', 'type_role', 'Title');

 

then i got this

 

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 ' type_role.Title as s4fe56881 FROM `type_role` ORDER BY `s4fe56881`' at line 1

SELECT type_role., type_role.Title as s4fe56881 FROM `type_role` ORDER BY `s4fe56881`

Filename: models/Grocery_crud_model.php

Line Number: 278

 

 

any advice?

 

 

Thanks


Amit Shah

Amit Shah
  • profile picture
  • Member

Posted 18 January 2016 - 20:52 PM

please paste the complete code ... it might be something else that may be causing the issue