Time : 06:45:22 SQLSTATE[23000]: Integrity constraint violation: 1052 Champ: 'lastmodifieddate' dans order clause est ambigu Raw SQL : select count(p_users.userid) as totalnew_users from p_users,p_usertypes where p_users.usertypeid=p_usertypes.usertypeid and p_users.userid>1 order by lastmodifieddate desc Time : 06:44:58 SQLSTATE[23000]: Integrity constraint violation: 1052 Champ: 'status' dans order clause est ambigu Raw SQL : select count(p_users.userid) as totalnew_users from p_users,p_usertypes where p_users.usertypeid=p_usertypes.usertypeid and p_users.userid>1 order by status desc Time : 06:33:59 SQLSTATE[23000]: Integrity constraint violation: 1052 Champ: 'status' dans order clause est ambigu Raw SQL : select count(p_users.userid) as totalnew_users from p_users,p_usertypes where p_users.usertypeid=p_usertypes.usertypeid and p_users.userid>1 order by status desc Time : 06:33:54 SQLSTATE[23000]: Integrity constraint violation: 1052 Champ: 'status' dans order clause est ambigu Raw SQL : select count(p_users.userid) as totalnew_users from p_users,p_usertypes where p_users.usertypeid=p_usertypes.usertypeid and p_users.userid>1 order by status desc Time : 05:44:14 SQLSTATE[42000]: Syntax error or access violation: 1064 Erreur de syntaxe près de 'and LOWER(usertype) like ? order by usertype asc' à la ligne 1 Raw SQL : select count(p_usertypes.usertypeid) as totalrecords from p_usertypes and LOWER(usertype) like :usertype order by usertype asc