Textpattern CMS

#1 2012-09-03 17:19:35

JeremyCherfas

Member

Registered: 2012-09-01

Posts: 18

White and Wild theme gives MySQL error

I just installed White and Wild, on a recommendation, and received a couple of error messages. One was about sortdir and sortby being deprecated; I managed to find and solve those.

Now I am left with one error:

Tag error: <txp:article_custom limit=“5” section=“article” sort=“Posted” sort=“desc” listform=“waw_recent” offset=“1” /> -> Textpattern Error: 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 limit 1, 5’ at line 1 while parsing form “waw_home” on page “waw_default”

Can’t seem to find anything about limit.

Advice, please.

Thanks

Jeremy

#2 2012-09-03 18:43:46

Gocom

Developer Emeritus

From: Helsinki, Finland

Registered: 2006-07-14

Posts: 4,533

Website

Re: White and Wild theme gives MySQL error

You have set the article_custom tag’s sort attribute as desc. The following:

sort="Posted" sort="desc"

Should be combined to:

sort="Posted desc"

Last edited by Gocom (2012-09-03 18:44:29)

---

Rah | GitHub

#3 2012-09-03 20:14:51

JeremyCherfas

Member

Registered: 2012-09-01

Posts: 18

Re: White and Wild theme gives MySQL error

That did it! Thanks.

Jeremy