Textpattern Support Forum

maverick wrote:

The conflict I’m having is with zem_event (not zem_link)

That’s what I meant to say. Sorry to say, but as I cannot reproduce this conflict I am rather clueless on how to help any further. May someone with a Mac could try to chime in and duplicate this.

No, any jQuery will be fine.

wet schrieb:

bq. MySQL: 3.23.49.

DBMS Jurassic Park…

Please grab a SQL entry field (phpMyAdmin or anything else) and issue these three queries:

select * from textpattern where 1=1 order by Posted asc limit 20

select * from textpattern where 1=1 order by Posted asc limit 20 offset 0

select * from textpattern where 1=1 order by Posted asc limit 0,20

Please report back which one succeeds or fails.

The first and third succeed, the second fails.

wet schrieb:

Try this:

1 In the plugin screen, edit wet_peex.
2. Find this line

$articles = safe_rows('*', 'textpattern', "$search order by $sort_sql limit $limit offset $offset");

and replace it with

$articles = safe_rows('*', 'textpattern', "$search order by $sort_sql limit $offset,$limit");

3. Open the URL which revealed the SQL syntax error. You should receive a well-formed XML document.

That solved my problem, everything works great now! Thank you very much!
Und eine tiefe Verneigung vor dem Können! :-)

I could eventually help you if you I saw the HTML source of the whole content > write screen (not just the article but the whole browser window). Post it either here, or better yet at a pastebin service.