Hi,
When I try:
SELECT * FROM `article`,person WHERE article.topic IN
(17,24,33,38,84,87,91,130,140,141,34,53,132,133,134,135,166,54,55,56,98) AND
author=person.id AND (article.up=0 OR 1=0) AND (article.sitegroup in (0,2) AND
person.sitegroup in (0, 2)) ORDER BY article.created DESC LIMIT 0, 30
I get:
MySQL said:
Can't find record in 'article'
BUT: This query:
SELECT autor FROM `article` WHERE article.topic IN
(17,24,33,38,84,87,91,130,140,141,34,53,132,133,134,135,166,54,55,56,98) LIMIT
0, 30
returns 289 records.
Funny enough, this query: SELECT author FROM `article` WHERE article.topic IN
(17,24,33,38,84,87,91,130,140,141,34,53,132,133,134,135,166,54,55,56,98)
returns 289 recods (as it shoudl do),
When I do:
SELECT author FROM `article` WHERE article.topic IN
(17,24,33,38,84,87,91,130,140,141,34,53,132,133,134,135,166,54,55,56,98) limit
53;
I get: ERROR 1032: Can't find record in 'article'
When I do
SELECT author FROM `article` WHERE article.topic IN
(17,24,33,38,84,87,91,130,140,141,34,53,132,133,134,135,166,54,55,56,98) limit
52;
I get 52 rows in set (0.00 sec)
HOW CAN I clean this up???
Tarjei
This is from my logs:
1 Query SELECT id,up FROM topic WHERE up=17 AND
(sitegroup in (0, 2) OR 0<>0) ORDER BY up,id
1 Query SELECT id,up FROM topic WHERE up IN
(24,33,34,53,54,55,56,98) AND (sitegroup in (0, 2) OR 0<>0)
ORDER BY up,id
1 Query SELECT id,up FROM topic WHERE up IN
(38,84,87,91,130,140,141,132,133,134,135,166) AND (sitegroup
in (0, 2) OR 0<>0) ORDER BY up,id
1 Query SELECT article.id AS id,article.name AS
name,title,abstract,content,author,Concat(firstname,If(f
irstname=''||lastname='','',' '),lastname) AS authorname,article.topic AS
topic,Date_format(article.created,'%d.%m.%Y') AS date,Date
_format(article.created,'%D %b. %Y') AS adate,Date_format(article.created,'%D %M
%Y') AS aldate,url,icon,extra1,extra2,extra3,articl
e.score AS score,type,Unix_Timestamp(article.created) AS created,article.creator
AS creator,Unix_Timestamp(revised) AS revised,revis
or,revision,Unix_Timestamp(locked) AS locked,locker,Unix_Timestamp(approved) AS
approved,approver,article.sitegroup FROM article,per
son WHERE (article.topic IN
(17,24,33,38,84,87,91,130,140,141,34,53,132,133,134,135,166,54,55,56,98) AND
author=person.id AND (artic
le.up=0 OR 1=0)) AND (article.sitegroup in (0,2) AND person.sitegroup in (0, 2))
ORDER BY article.created DESC
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
