TYPO3 Mailingliste: nicht fragen - lesen!

Hi,

I have just installed a new Typo3 site based on the package from Web
Enabled Church. This is based on Typo3 4.1.5 and uses RealURL v1.2.1

The FE displays a whole servie of errors like:

Warning: mysql_fetch_assoc( supplied argument is not a valid MySQL
result resource in
/usr/local/home/httpd/vhtdocs/t3src/typo3_src-4.1.5/t3lib/class.t3lib_db.php
on line 796

Warning: mysql_free_result( supplied argument is not a valid MySQL
result resource in
/usr/local/home/httpd/vhtdocs/t3src/typo3_src-4.1.5/t3lib/class.t3lib_db.php
on line 823

When error reporting is enabled the errors seem to point to an issue
with RealURL:

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

debug_backtrace require // tslib_fe->intincscript // tslib_cobj->user
// tslib_cobj->calluserfunction // call_user_method //
tx_srfeuserregister_pi1->main // tx_srfeuserregister_pi1->init //
tx_srfeuserregister_marker->init //
tx_srfeuserregister_marker->addurlmarkers //
tx_srfeuserregister_url->get // tslib_cobj->gettypolink_url //
tslib_cobj->gettypolink // tslib_cobj->typolink //
t3lib_tstemplate->linkdata // t3lib_div::calluserfunction //
call_user_func_array // tx_realurl->encodespurl //
tx_realurl->encodespurl_encodecache // t3lib_db->exec_selectquery //
t3lib_db->debug

I am using MySQL 5.0.20a

The FE can be seen at www.development.saltforsermons.org.uk

I posted this issue to the WEC Forum and was advised to post here to
see if anyone had experienced this or knew where the error may be.

Thanks for any help,

Sandy Matheson
_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

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/...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"
_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

Dmitry,

Thanks for replying. Do you know of anything that might cause this? Is
it possible that this is not enabled in the MySQL setup or something
of that sort? If so what do I need to look for/change?

Many thanks for your help,

Sandy
_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

Hi!

Sandy Matheson wrote:
> Thanks for replying. Do you know of anything that might cause this? Is
> it possible that this is not enabled in the MySQL setup or something
> of that sort? If so what do I need to look for/change?

No idea Never encoutered such behavior from MySQL. May be check if you accidentally enabled DBAL extension...

--
Dmitry Dulepov
TYPO3 core team
Web: http://typo3bloke.net/
Skype: callto:liels_bugs
"Nothing is impossible. There are only limits to our knowledge"
_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

Check this:
http://dev.mysql.com/doc/refman/5.0/...iguration.html

2008/1/5, Dmitry Dulepov [typo3] <dmitry (AT) typo3 (DOT) org>:
>
> Hi!
>
> Sandy Matheson wrote:
> > Thanks for replying. Do you know of anything that might cause this? Is
> > it possible that this is not enabled in the MySQL setup or something
> > of that sort? If so what do I need to look for/change?
>
> No idea Never encoutered such behavior from MySQL. May be check if you
> accidentally enabled DBAL extension...
>
> --
> Dmitry Dulepov
> TYPO3 core team
> Web: http://typo3bloke.net/
> Skype: callto:liels_bugs
> "Nothing is impossible. There are only limits to our knowledge"
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english (AT) lists (DOT) netfielders.de
> http://lists.netfielders.de/cgi-bin/.../typo3-english
>
_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english

Thanks for all the help.

This led me to investigate MySQL more and I found out that we are
actually using MySQL 3.23 not MySQL5 (what confused me was the
phpinfo() in the install tool said we were on MySQL Api v5.0.20a which
is apparently the client version not the server version).

I have now downgraded to RealURL 1.1.4 pending an upgrade of our MySQL
version.

Sandy
_______________________________________________
TYPO3-english mailing list
TYPO3-english (AT) lists (DOT) netfielders.de
http://lists.netfielders.de/cgi-bin/.../typo3-english