+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Error 1146 when using transaction to update database (/showthread.php?tid=52757)
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 !