[solved] SQLSTATE[HY093] while Froxlor update

[thoddi]

Hello,

 

I tried to updade my Froxlor today, but it ended in an error while running the update-skript.

 

Previous version was 0.9.31-dev1, new version is 0.9.31.2 on Debian Squeeze.

 

The update-skript will return:

 

Updating from 0.9.31-dev1 to 0.9.31-dev2[OK]
Adding new phpfpm-ipcdir setting

A database error occured

SQLSTATE[HY093]: Invalid parameter number: no parameters were bound

#0 /var/www/froxlor/lib/classes/database/class.Database.php(72): PDOStatement->execute(Array)
#1 /var/www/froxlor/install/updates/froxlor/0.9/update_0.9.inc.php(2444): Database::pexecute(Object(PDOStatement), Array)
#2 /var/www/froxlor/install/updatesql.php(46): include_once('/var/www/froxlo...')
#3 /var/www/froxlor/admin_updates.php(78): include_once('/var/www/froxlo...')
#4 {main}

The logfile:

|CODE HY093
|MSG SQLSTATE[HY093]: Invalid parameter number: no parameters were bound
|FILE /var/www/froxlor/lib/classes/database/class.Database.php
|LINE 72
|TRACE
#0 /var/www/froxlor/lib/classes/database/class.Database.php(72): PDOStatement->execute(Array)
#1 /var/www/froxlor/install/updates/froxlor/0.9/update_0.9.inc.php(2444): Database::pexecute(Object(PDOStatement), Array)
#2 /var/www/froxlor/install/updatesql.php(46): include_once('/var/www/froxlo...')
#3 /var/www/froxlor/admin_updates.php(78): include_once('/var/www/froxlo...')
#4 {main}

What could I do now?

 

Thanks

[d00p]

Known issue, fixed in GIT already, temp. fix in file install/updates/froxlor/0.9/update_0.9.inc.php ->
 

2433	 	-  if ($settings['system']['webserver'] == 'apache2') {
2434	 	-    $params['value'] = '/var/lib/apache2/fastcgi/';
2435	 	-  } elseif ($settings['system']['webserver'] == 'lighttpd') {
 	2433	+  // set default for apache (which will suite in most cases)
 	2434	+  $params['value'] = '/var/lib/apache2/fastcgi/';
 	2435	+  if ($settings['system']['webserver'] == 'lighttpd') {

[thoddi]

Works perfectly now, thank you!