It seems that this fixed it: mysqldump midgard > dbfile mysqladmin drop midgard mysqladmin create midgard mysql midgard < dbfile
are there any problems with this method I should know about? Tarjei Tarjei Huse wrote: > > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
