View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - SQL error "Unknown column 'disconnection' in 'where clause'" when attempt to delete connexions - ProjeQtOr
 
 

SQL error "Unknown column 'disconnection' in 'where clause'" when attempt to delete connexions

More
21 Nov 2014 13:55 - 24 Nov 2014 14:50 #1 by lfrugere
SQL error "Unknown column 'disconnection' in 'where clause'" when attempt to delete connexions was created by lfrugere
Hello Babynus,

As admin, i'm looking for cleaning application data.
On Administration panel, when attempt to delete past connexion (since x days), an alert appears :
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'disconnection' in 'where clause'

Thanks in advance,

Lionel.
Last edit: 24 Nov 2014 14:50 by protion.
The topic has been locked.
More
21 Nov 2014 20:26 #2 by babynus
Replied by babynus on topic SQL error "Unknown column 'disconnection' in 'where clause'" when attempt to delete connexions
Issue confirmed and recorded as TIcket #1587
Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
More
21 Nov 2014 20:36 #3 by babynus
Replied by babynus on topic SQL error "Unknown column 'disconnection' in 'where clause'" when attempt to delete connexions
Fixed :
In /tool/adminFunctionalities.php, replace line 70 with :
$clauseWhere="disconnectionDateTime<'" . $targetDate . "'";
Babynus
Administrator of ProjeQtOr web site
The topic has been locked.
Moderators: babynus, protion
Time to create page: 0.028 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form