Welcome Guest, Not a member yet? Register   Sign In
Error when session table is updated
#4

[eluser]LuckyFella73[/eluser]
I did a table export to compare with the Userguide table template:

Code:
CREATE TABLE `jaz_sessions` (
  `session_id` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '0',
  `ip_address` varchar(45) COLLATE utf8_bin NOT NULL DEFAULT '0',
  `user_agent` varchar(150) COLLATE utf8_bin NOT NULL,
  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
  `user_data` text COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

I don't know what happend to me - I could swear I defined
utf8_unicode while I have utf8_bin as COLLATE.. never happend
to me before. I guess that was the problem?

Sorry I didn't checkthat before - I guess I did the mistake when
setting up the database COLLATE because I allways take session tables
from older projects (export/import) having COLLATE set to utf8_unicode.
But when setting the DB itself to utf8_bin I guess the tabel COLLAT is
overwritten ..

I will re-setup the DB and table - in case I get the same error I'll post
that here.

Thanks for you help anyway!


Messages In This Thread
Error when session table is updated - by El Forum - 06-20-2012, 08:40 AM
Error when session table is updated - by El Forum - 06-20-2012, 08:55 AM
Error when session table is updated - by El Forum - 06-20-2012, 09:08 AM
Error when session table is updated - by El Forum - 06-20-2012, 09:34 AM
Error when session table is updated - by El Forum - 06-20-2012, 10:47 AM
Error when session table is updated - by El Forum - 06-20-2012, 10:55 AM
Error when session table is updated - by El Forum - 06-20-2012, 11:03 AM
Error when session table is updated - by El Forum - 06-20-2012, 11:09 AM
Error when session table is updated - by El Forum - 06-20-2012, 11:11 AM
Error when session table is updated - by El Forum - 06-20-2012, 01:11 PM



Theme © iAndrew 2016 - Forum software by © MyBB