Database Error when searching for 'year'.
Anonymoose
✭✭
Only happens when searching for the word year. Other searches continue to work without a problem. Vanilla 2.0
Fatal Error in Gdn_Database.Query();
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* from GDN__TBL_ s, GDN_Role Role join GDN_UserRole UserRole on Role.RoleID = Us' at line 1
select *, * from GDN__TBL_ s, GDN_Role Role join GDN_UserRole UserRole on Role.RoleID = UserRole.RoleID where UserRole.UserID = :UserRoleUserID order by s.DateInserted desc limit 20
The error occurred on or near: /home/site1/html/library/database/class.database.php
275:
276: if (!is_object($PDOStatement)) {
277: trigger_error(ErrorMessage('PDO Statement failed to prepare', $this->ClassName, 'Query', $this->GetPDOErrorMessage($this->Connection()->errorInfo())), E_USER_ERROR);
278: } else if ($PDOStatement->execute($InputParameters) === FALSE) {
279: trigger_error(ErrorMessage($this->GetPDOErrorMessage($PDOStatement->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
280: }
281: } else {
282: $PDOStatement = $this->Connection()->query($Sql);
283: }
PS: Happy New Year!
0
Comments
Problem solved. Looks like the server was running out of disk space.