[TYPO3] RealURL giving MySQL errors on new installation

Dmitry Dulepov [typo3] dmitry at typo3.org
Sat Jan 5 17:02:53 CET 2008


Hi!

Sandy Matheson wrote:
> ERROR	Unknown column 'SQL_NO_CACHE' in 'field list'
> 
> lastBuiltQuery	SELECT /*! SQL_NO_CACHE */ content
> FROM tx_realurl_urlencodecache
> WHERE
> url_hash='d2cb19e76cf82cad389dbc5574a8e3cc' AND tstamp>1199386733

It looks like your MySQL does not recognize SQL_NO_CACHE inside comment, which is weird. This is oficial functionality for MySQL and works fine with MySQL 4.1.x and 5.0.45 on my servers. 

References:

http://dev.mysql.com/doc/refman/5.0/en/query-cache-in-select.html
http://dev.mysql.com/doc/refman/5.0/en/comments.html

> I am using MySQL 5.0.20a

-- 
Dmitry Dulepov
TYPO3 core team
Web: http://typo3bloke.net/
Skype: callto:liels_bugs
"Nothing is impossible. There are only limits to our knowledge"


More information about the TYPO3-english mailing list