Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

  1. Index
  2. » Archives
  3. » mysql error?

#1 2006-01-01 09:33:54

squaredeye
Member
From: Greenville, SC
Registered: 2005-07-31
Posts: 1,495
Website

mysql error?

Can someone help me decipher this?
I know this may be plugin related, but basically on a local install, I am not getting the use of txp:article_image at all.

The error below only occurs when wet_thumbfilter is on, but I thought it was possible it was indicative of a larger/broader issue?
<code>
I get this error in debugging mode: tag_error <txp:wet_thumbfilter section=“home” wraptag=“ul” break=“li” /> -> 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 ’18,19,20,5,6,7,8,9,10,11,12,13,14,15,16 and thumbnail <> ‘0’‘ at line 1
select * from txp_image where id = 17,18,19,20,5,6,7,8,9,10,11,12,13,14,15,16 and thumbnail <> ‘0’ on line 61
</code>

Your help, or anyone else’s would be much appreciated.

Thanks,

Matthew


Offline

#2 2006-01-01 09:55:22

Mary
Sock Enthusiast
Registered: 2004-06-27
Posts: 6,236

Re: mysql error?

…thought it was possible it was indicative of a larger/broader issue?

Nope. It appears you’re trying to use the id attribute in a way not supported by the plugin.

Offline

#3 2006-01-01 10:06:14

squaredeye
Member
From: Greenville, SC
Registered: 2005-07-31
Posts: 1,495
Website

Re: mysql error?

Mary,
Thanks. Why is the article_image not working? It seems like these issues are linked?
The output I get from the article_image tag is this:
<code>
<img src=“17,18,19,20,5,6,7,8,9,10,11,12,13,14,15,16” alt=”“ />
</code>

AND! I have an excuse to be up this early (he’s four and half months old!)
What are you doing up! :)

Matthew


Offline

#4 2006-01-01 10:11:34

Mary
Sock Enthusiast
Registered: 2004-06-27
Posts: 6,236

Re: mysql error?

I don’t think Robert’s plugin supports multiple article images, but you’d have to ask him.

Offline

#5 2006-01-01 10:19:33

squaredeye
Member
From: Greenville, SC
Registered: 2005-07-31
Posts: 1,495
Website

Re: mysql error?

Mary,
aha! You were right! Go figure, just this once you were right :) …or maybe for the gabillionth time!!!

Thanks,
I keep on the plugin thread then. Have a good canadian morning.

Matthew


Offline

#6 2006-01-02 06:04:49

wet
Developer Emeritus
From: Schoerfling, Austria
Registered: 2005-06-06
Posts: 3,330
Website Mastodon

Re: mysql error?

> mary wrote:

I don’t think Robert’s plugin supports multiple article images, but you’d have to ask him.

It does now. wet_thumbfilter learns a new trick every new year….

Offline

  1. Index
  2. » Archives
  3. » mysql error?

Board footer

Powered by FluxBB