⚠ 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

need some suggestions onusage



niru

niru
  • profile picture
  • Member

Posted 02 March 2019 - 08:27 AM

I have already  built 75% of my CodeIgniter application using conventional MVC methods, I came to know about groceryCRUD during reporting needs, which is great saves time in CRUD operational code, now I want to use groceryCRUD everywhere but challenges like same column name(id->primarykey) i may have to change data model etc.. pls suggest if there is any workaround or is it worth to code everything again?(at least future performance).


niru

niru
  • profile picture
  • Member

Posted 02 March 2019 - 08:29 AM

also pls share your experience of going with groceryCRUD Community and pro versions (issues/bugs/challenges).Thanks


niru

niru
  • profile picture
  • Member

Posted 02 March 2019 - 09:58 AM

this is the error

 

Error Number: 1052

Column 'id' in where clause is ambiguous

SELECT `user`.*, j9705bffe.comp_name AS s9705bffe FROM `user` LEFT JOIN `company_detail` as `j9705bffe` ON `j9705bffe`.`id` = `user`.`compid` WHERE `id` = '56' LIMIT 10

Filename: C:/Users/Niru/Dropbox/niranaya/system/database/DB_driver.php

Line Number: 691