+- 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: Sessions database problem. (/showthread.php?tid=8166)
Sessions database problem. - El Forum - 05-07-2008
[eluser]Cambo[/eluser]
Hi Everyone
I am getting this error when I try to use the database option with sessions:
Quote:Error Number: 1146
Table 'web42db1.ci_sessions' doesn't exist
INSERT INTO ci_sessions (session_id, session_start, session_last_activity, session_ip_address, session_user_agent) VALUES ('9785d39eabc4b62d91539e028df01f3e', 1210218498, 1210218498, '127.0.0.1', 'Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.1')
I have searched the forums and can't find an answer.
I HAVE created the table in the database, and if I go into MySQL directly and "show tables;" it is there.
Any ideas where to look?
ps. I have set logging to 4, but where are the logs? I tried to set the log path but it doesn't appear to work ( or I am doing it wrong)
Thanks
Sessions database problem. - El Forum - 05-07-2008
[eluser]Cambo[/eluser]
Arrrghhh! OK, problem solved. The /config/database.php had the wrong database name. (Damn stupid mistake)
I would still like to know where the logs are though??
Thanks
Sessions database problem. - El Forum - 05-08-2008
[eluser]Seppo[/eluser]
By default the logs are in system/logs - They are created using the date from today. You should set writting permission to that folder.
Sessions database problem. - El Forum - 05-08-2008
[eluser]Cambo[/eluser]
[quote author="Seppo" date="1210263032"] You should set writting permission to that folder.[/quote]
That's why I couldn't find them, no write permissions.
Fixed.
Thanks Seppo.