please help after i update 3.1.1 to 3.1.2 my update_batch not working
Code:
$data = [
['sl_id' => 49, 'sl_move' => 1],
['sl_id' => 48, 'sl_move' => 2]
];
// error this update_batch line : Undefined index: sl_id
if( ! $this->db->update_batch($this->table, $data, 'sl_id'))
{
//FALSE
}
else
{
//TRUE
}
error sql syntax the following
Code:
Error Number: 1064
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 'THEN '49' WHEN `sl_id` = THEN '48' ELSE `sl_id` END, `sl_move` = CASE WHEN `sl' at line 2
UPDATE `tbl_slide` SET `sl_id` = CASE WHEN `sl_id` = THEN '49' WHEN `sl_id` = THEN '48' ELSE `sl_id` END, `sl_move` = CASE WHEN `sl_id` = THEN '1' WHEN `sl_id` = THEN '2' ELSE `sl_move` END WHERE `sl_id` IN(,)
Filename: C:/wamp/www/CodeIgniter_Project/system/database/DB_driver.php
Line Number: 691
if i restore to version 3.1.1 it work but after update it give error above i had no idea