[PHPLIB] session errors From: Bruce Snyder (bws <email protected>)
Date: 12/10/99

I have a couple of problems that I cannot resolve. I believe that fixing
the first problem may in turn fix the second problem.

1. I am submitting a form to a MySQL database by way of a subclass I
wrote that extends DB_Sql. The data is stored in a database named
status_form in a table named simple_status_form. Upon clicking submit,
the page is redrawn with the following error at the bottom:
-----------------------------------------
Database error: Invalid SQL: update active_sessions set
val='RXhhbXBsZV9TZXNzaW9uOiR0aGlzLT5pbiA9ICcnOyAkdGhpcy0+cHQgPSBhcnJheSgpOyAkdGhpcy0+cHRbJ3MnXSA9ICcxJzsgJEdMT0JBTFNbJ3MnXSA9ICcwJzsg',
changed='19991209234045' where sid='e432248ff931c8c91c7d7f492db282eb'
and name='Example_Session'
MySQL Error: 1146 (Table 'status_form.active_sessions' doesn't exist)
Session halted.
-----------------------------------------
By the way, I haven't changed anything in local.inc at all. Sessions are
still using example_database and active_sessions table.
 
2. When the form is redrawn after clicking submit, all the fields still
contain the data that was just stored in the database. I'm apt to think
that the error above regarding "Session halted." explains this problem,
but I'm not sure.

Can anyone help me out here?

Thanks,
Bruce Snyder
-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.