update_batch is not working !

Hi there ,

I am facing a problem with update batch function

 it is showing the following query which is error !!

i am using the 3.1.2

Code:

UPDATE `sd_settings` SET

`s_setting` = CASE
WHEN `s_setting` =  THEN 'default_lang'
WHEN `s_setting` =  THEN 'reg_mode'
WHEN `s_setting` =  THEN 'site_offline'
WHEN `s_setting` =  THEN 'refresh'
WHEN `s_setting` =  THEN 'login_token'

ELSE `s_setting` END,

`s_value` = CASE
WHEN `s_setting` =  THEN 'ar'
WHEN `s_setting` =  THEN 'all'
WHEN `s_setting` =  THEN '0'
WHEN `s_setting` =  THEN '66'
WHEN `s_setting` =  THEN 'r34zn16'

ELSE `s_value` END
WHERE `s_setting` IN(,,,,)

can anyone help please ?

Do you see the same issue with 3.1.1?
There is a pull request on github that may help resolve this issue. Have a look at https://github.com/bcit-ci/CodeIgniter/pull/4929

Do you see the same issue with 3.1.1?
There is a pull request on github that may help resolve this issue. Have a look at https://github.com/bcit-ci/CodeIgniter/pull/4929

i do not know , i was using 3.1.0 and it is not there

I think I had the same problem when I went to 3.1.2. See here for my workaround. http://forum.codeigniter.com/thread-65919.html

I have the same problem. I had to downgrade to version 3.1.0

Hello,

Same problem here. You have to reverse the changes for 2 functions (update_batch and _update_batch) in the DB_query_builder file (system/database). Just copy / paste the functions of 3.1.1 version, it works for me.

Bye

Duplicate of https://forum.codeigniter.com/thread-66522.html