search

scoumbourdis / grocery-crud

Grocery CRUD is a PHP Codeigniter Framework library that creates a full functional CRUD system without the requirement of extra customisation to the JavaScripts or the CSS to do it so.
http://www.grocerycrud.com
GNU General Public License v3.0
1.01k stars 472 forks source link

Help me all ::: SQL syntax error, prefix bug #359

Closed dyazincahya closed 8 years ago

dyazincahya commented 8 years ago

how to fix "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.* FROM d_pages LIMIT 10' at line 1" ????

I use prefix table "d_" , and i use codeigniter 3.0.6 + grocery 1.5.4

Thanks before :)

Nihilistik commented 8 years ago

I gess u already fixed this or found a workaround. I link u here my solution: https://github.com/Nihilistik/Grocery_CRUD-CodeIgniter-dbprefix-bug/

This solves the problem with `'.* FROM d_pages LIMIT 10'

and with

SELECT d_'d_pages'.* FROM d_pages LIMIT 10

Hope it helps!

dyazincahya commented 8 years ago

yes, I have to fix it here :) https://github.com/scoumbourdis/grocery-crud/pull/360 . problem solved :)