CodeIgniter Forums
Error 1146 when using transaction to update database - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: Error 1146 when using transaction to update database (/thread-52757.html)



Error 1146 when using transaction to update database - El Forum - 06-25-2012

[eluser]misakitran[/eluser]
I have set dbprefix="myprefix_".
Connecting to database and processing database by Active Record Class are right.
But when i use transactions to update database, I have error 1146 :
Code:
Table 'myprefix.myprefix_users' doesn't exist

UPDATE `myprefix_users` SET `email` = '[email protected]', `descriptions` = '', `block` = 0, `activation` = 1 WHERE `id` = '3'

Why having double dbprefix ?
Please help me ! Thanks !


Error 1146 when using transaction to update database - El Forum - 06-25-2012

[eluser]misakitran[/eluser]
Ohh..I am sorry ! I have caught my error in program. Thanks all !