Hello everyone,
i try to get sessions working with rivet 3.2.8, tcl 8.6.17, apache
httpd 2.4.65, tcllib 2.0
This is my simple test page session-test.rvt
####################start
<?
package require sqlite3
package require Session
package require DIO
::DIO::handle Sqlite DIO -db "/.../rivet-sqlite.db"
Session SESSION -debugMode 0
SESSION activate
#set current_user [SESSION fetch global user_name]
#if {[::rivet::var exists username]} {
# set l_user [::rivet::var get username]
# SESSION store global user_name $l_user
#} else {
# set l_user ""
#}
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
<style>
html { color-scheme: light dark; }
body { width: 35em; margin: 0 auto; }
font-family: Tahoma, Verdana, Arial, sans-serif; }
</style>
</head>
<body>
<div>User:<? #puts $current_user ?></div>
<p>Welcome to xyz the next thing <br/>Session id: <? puts [SESSION id] ?\
</p>
</body>
</html>
###################################end
The session works, until i let the session idle, if it tries to
refresh the session i get this exception:
Got 'near "WHERE": syntax error' executing 'UPDATE rivet_session SET
WHERE 1 = 1 AND session_id = '4662D98DF8C0E99F79EF68C925F2Exxx' AND
ip_address = 'yyy''
while executing
"$this update $arrayName {*}$args"
(object "::DIO" method "::DIO::Database::store" body line 21)
invoked from within
"$dioObject store a -table $sessionTable -keyfield $kf"
(object "::request::SESSION" method "::Session::id" body line 70)
invoked from within
"id"
(object "::request::SESSION" method "::Session::activate" body line 9)
invoked from within
"SESSION activate"
(in namespace eval "::request" script line 8)
invoked from within
"namespace eval ::request $script"
("::try" body line 12)
Can someone help me to fix this?
Is this an error with my setup or with rivet itselve?
Unfortunally i am not able to file a bug report, as the bug software
shows me "new bugs for rivet have been disabled".
Thank you!
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]