Radicore Forum: Bug Reports » Unexpected "Query was empty" Error Due to Space / Newline

Home » RADICORE development » Bug Reports » Unexpected "Query was empty" Error Due to Space / Newline

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unexpected "Query was empty" Error Due to Space / Newline [message #4606]

Sun, 26 October 2014 09:33

kong
Messages: 90
Registered: December 2011

Member

When calling executeQuery($query) function with $query containing spaces and/or newlines after the last ";" in $query string, the function will return "Query was empty" error. To make the function more user friendly, especially in cases when $query contains multiple sql statements, propose to add a line in executeQuery function as follows:

Code: [Select all] [Show/ hide]

...

$DML->setRowLocks($this->row_locks);
	
$query = trim($query); // added this line to solve unexpected "Query was empty" error

$result = $DML->multiQuery($this->dbname_server, $this->tablename, $query);
		
...

Report message to a moderator