Hello fellow Symfony. I need to be able to maintain the session
user, because when you close the browser is lost. For this I stored in
a database.
sorry for my bad English, I speak Spanish
I'm using mysql and create the next table to be stored:
CREATE TABLE `session_storage` (
`session_id` varchar(255) collate latin1_general_ci NOT NULL,
`session_data` longtext collate latin1_general_ci NOT NULL,
`session_time` bigint(20) NOT NULL,
PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
COLLATE=latin1_general_ci;
In factories.yml I have the following:
all:
routing:
class: sfPatternRouting
param:
generate_shortest_url: true
extra_parameters_as_query_string: true
storage:
class: sfMySQLSessionStorage
param:
database: doctrine
db_table: session_storage
db_id_col: session_id
db_data_col: session_data
db_time_col: session_time
And I databases.yml:
all:
doctrine:
class: sfDoctrineDatabase
param:
dsn: mysql://root:@127.0.0.1:3306/flogger
The error strip is:
500 | Internal Server Error | sfDatabaseException
sfMySQLSessionStorage cannot create new record for id "" ().
I'm using Symfony 1.2.4.
Aca someone ask the same thing as not understanding resolved:
http://groups.google.com/group/symfony-users/browse_thread/thread/7b38d900aa3d64fd/b9707325289718d7
See if someone did it and can guide me about what happened or
about how you have to do it, but already more than a month ago that I
try
and do not leave me, and users complain that they have to be
log all the time.
Thanks!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---