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
-~----------~----~----~----~------~----~------~--~---

Reply via email to