ikhsan3adi / absensi-sekolah-qr-code

Sistem absensi siswa dan guru berbasis QR Code menggunakan CodeIgniter 4 🔥
https://youtube.com/watch?v=E1ho6wRBIUs
GNU General Public License v3.0
211 stars 75 forks source link

[BUG] Error generate qr siswa #136

Open KingWeeL opened 1 month ago

KingWeeL commented 1 month ago

Screenshot 2024-08-06 222813 { "title": "CodeIgniter\Database\Exceptions\DatabaseException", "type": "CodeIgniter\Database\Exceptions\DatabaseException", "code": 500, "message": "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 '= '12'' at line 4", "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\vendor\codeigniter4\framework\system\Database\BaseConnection.php", "line": 676, "trace": [ { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php", "line": 308, "function": "query", "class": "mysqli", "type": "->", "args": [ "SELECT \nFROM tb_kelas\nLEFT JOIN tb_jurusan ON tb_kelas.id_jurusan = tb_jurusan.id\nWHERE .id = '12'", 0 ] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\vendor\codeigniter4\framework\system\Database\BaseConnection.php", "line": 722, "function": "execute", "class": "CodeIgniter\Database\MySQLi\Connection", "type": "->", "args": [ "SELECT \nFROM tb_kelas\nLEFT JOIN tb_jurusan ON tb_kelas.id_jurusan = tb_jurusan.id\nWHERE .id = '12'" ] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\vendor\codeigniter4\framework\system\Database\BaseConnection.php", "line": 636, "function": "simpleQuery", "class": "CodeIgniter\Database\BaseConnection", "type": "->", "args": [ "SELECT \nFROM tb_kelas\nLEFT JOIN tb_jurusan ON tb_kelas.id_jurusan = tb_jurusan.id\nWHERE .id = '12'" ] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\vendor\codeigniter4\framework\system\Database\BaseBuilder.php", "line": 1629, "function": "query", "class": "CodeIgniter\Database\BaseConnection", "type": "->", "args": [ "SELECT \nFROM tb_kelas\nLEFT JOIN tb_jurusan ON tb_kelas.id_jurusan = tb_jurusan.id\nWHERE .id = :.id:", { ".id": [ "12", true ] }, false ] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\vendor\codeigniter4\framework\system\Model.php", "line": 207, "function": "get", "class": "CodeIgniter\Database\BaseBuilder", "type": "->", "args": [] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\vendor\codeigniter4\framework\system\BaseModel.php", "line": 610, "function": "doFind", "class": "CodeIgniter\Model", "type": "->", "args": [ true, "12" ] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\app\Controllers\Admin\QRGenerator.php", "line": 335, "function": "find", "class": "CodeIgniter\BaseModel", "type": "->", "args": [ "12" ] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\app\Controllers\Admin\QRGenerator.php", "line": 91, "function": "getKelasJurusanSlug", "class": "App\Controllers\Admin\QRGenerator", "type": "->", "args": [ "12" ] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\vendor\codeigniter4\framework\system\CodeIgniter.php", "line": 933, "function": "generateQrSiswa", "class": "App\Controllers\Admin\QRGenerator", "type": "->", "args": [] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\vendor\codeigniter4\framework\system\CodeIgniter.php", "line": 509, "function": "runController", "class": "CodeIgniter\CodeIgniter", "type": "->", "args": [ {} ] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\vendor\codeigniter4\framework\system\CodeIgniter.php", "line": 355, "function": "handleRequest", "class": "CodeIgniter\CodeIgniter", "type": "->", "args": [ null, { "handler": "file", "backupHandler": "dummy", "storePath": "C:\xampp\htdocs\absensi-sekolah-qr-code\writable\cache/", "cacheQueryString": false, "prefix": "", "ttl": 60, "reservedCharacters": "{}()/\@:", "file": { "storePath": "C:\xampp\htdocs\absensi-sekolah-qr-code\writable\cache/", "mode": 416 }, "memcached": { "host": "127.0.0.1", "port": 11211, "weight": 1, "raw": false }, "redis": { "host": "127.0.0.1", "password": null, "port": 6379, "timeout": 0, "database": 0 }, "validHandlers": { "dummy": "CodeIgniter\Cache\Handlers\DummyHandler", "file": "CodeIgniter\Cache\Handlers\FileHandler", "memcached": "CodeIgniter\Cache\Handlers\MemcachedHandler", "predis": "CodeIgniter\Cache\Handlers\PredisHandler", "redis": "CodeIgniter\Cache\Handlers\RedisHandler", "wincache": "CodeIgniter\Cache\Handlers\WincacheHandler" } }, false ] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\vendor\codeigniter4\framework\system\Boot.php", "line": 312, "function": "run", "class": "CodeIgniter\CodeIgniter", "type": "->", "args": [] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\vendor\codeigniter4\framework\system\Boot.php", "line": 67, "function": "runCodeIgniter", "class": "CodeIgniter\Boot", "type": "::", "args": [ {} ] }, { "file": "C:\xampp\htdocs\absensi-sekolah-qr-code\public\index.php", "line": 56, "function": "bootWeb", "class": "CodeIgniter\Boot", "type": "::", "args": [ { "systemDirectory": "C:\xampp\htdocs\absensi-sekolah-qr-code\app\Config/../../vendor/codeigniter4/framework/system", "appDirectory": "C:\xampp\htdocs\absensi-sekolah-qr-code\app\Config/..", "writableDirectory": "C:\xampp\htdocs\absensi-sekolah-qr-code\app\Config/../../writable", "testsDirectory": "C:\xampp\htdocs\absensi-sekolah-qr-code\app\Config/../../tests", "viewDirectory": "C:\xampp\htdocs\absensi-sekolah-qr-code\app\Config/../Views" } ] } ] }

reactmore commented 1 month ago

Versi branch terupdate ?

KingWeeL commented 1 month ago

Versi branch terupdate ?

iya