[dadki]

Can you help / explain to me why I get this error here often?

Code:

On /Jokes/mode=next/jid=2295/cid=7/ad=desc.html
While executing query "SELECT * FROM cms_jokes_jokes WHERE cid=7 AND active=1 ORDER BY desc, jid desc"

the following error occured: 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 'desc, jid desc' at line 1

In: /home/myhost/domains/mydomain.com/public_html/modules/Jokes/index.php on line: 215

Guest information:
User id:
Username:
Admin: No
IP: 66.249.##.###
Host: crawl-66-249-65-111.googlebot.com

[greenday2k]

ORDER BY ????? desc, jid desc

MYSQL thinks that you´re trying to sort something.

Your need a parameter or a valid column name to sort.

Maybe that function works only with registred users, try to replicate it with out logging.

Declare a default value for the first parameter (if no defined)

[dadki]

greenday2k wrote:

ORDER BY ????? desc, jid desc

MYSQL thinks that you´re trying to sort something.

Your need a parameter or a valid column name to sort.

Maybe that function works only with registred users, try to replicate it with out logging.

Declare a default value for the first parameter (if no defined)

Content (text) which is in the module appears to also unregistered user .. only thing you have to be registered to comment