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!

Anonymoose

Problem solved. Looks like the server was running out of disk space.