SQL on screen and I can't log in.

Ok... I copied and pasted the first chuck of SQL on the screen into phpmyadmin and "Your SQL query has been executed successfully ( Query took 0.0001 sec )". More than confusing!

This is what I copied and pasted...
#0 db->query(REPLACE INTO sys_session (session_id,date_created,last_updated,session_data,permanent) VALUES ('le0i7mprshb6afcfb0e3asnql6',NOW(),NOW(),'s|a:4:{s:2:\"id\";s:26:\"le0i7mprshb6afcfb0e3asnql6\";s:5:\"theme\";s:7:\"default\";s:8:\"language\";s:2:\"en\";s:6:\"module\";a:4:{s:4:\"name\";s:5:\"login\";s:5:\"title\";s:14:\"top_menu_login\";s:8:\"template\";s:14:\"module.tpl.htm\";s:9:\"startpage\";s:15:\"login/index.php\";}}','n')) called at [/usr/local/ispconfig/interface/lib/classes/session.inc.php:100] #1 session->write(le0i7mprshb6afcfb0e3asnql6, s|a:4:{s:2:"id";s:26:"le0i7mprshb6afcfb0e3asnql6";s:5:"theme";s:7:"default";s:8:"language";s:2:"en";s:6:"module";a:4:{s:4:"name";s:5:"login";s:5:"title";s:14:"top_menu_login";s:8:"template";s:14:"module.tpl.htm";s:9:"startpage";s:15:"login/index.php";}}) #2 session_write_close() called at [/usr/local/ispconfig/interface/lib/app.inc.php:124] #3 app->__destruct()

 

Aha! Copied, pasted, ran and...
#1054 - Unknown column 'permanent' in 'field list'

 

Till...

You are a star! Column added and it seems to work perfectly. YAY!

Vielen danke!

 

Dman... this is going to take more thought.
I went to add a client and got this...
#0 db->query(SELECT assigned_template_id, client_template_id FROM client_template_assigned WHERE client_id = 0) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:158] #1 db->queryAllRecords(SELECT assigned_template_id, client_template_id FROM client_template_assigned WHERE client_id = 0) called at [/usr/local/ispconfig/interface/web/client/client_edit.php:139] #2 page_action->onShowEnd() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:532] #3 tform_actions->onShow() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:70] #4 tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/client/client_edit.php:592]

... which looks like it needs a table called client_template_assigned and it doesn't seem to exist.