hiya
i have nohahs classifieds installed on my system, however it seems to have gone missing, with all my adverts?
when i go into it it says the following
SELECT n.id AS id, n.cid AS cid, n.firstCid AS firstCid, n.title AS title, n.creationtime AS creationtime, n.active AS active, n.clicked AS clicked, n.responded AS responded, n.ownerId AS ownerId, n.expEmailSent AS expEmailSent, n.expirationTime AS expirationTime, n.renewalNum AS renewalNum, n.picture AS picture, n.keepPrivate AS keepPrivate, n.col_0 AS col_0, n.col_1 AS col_1, n.col_2 AS col_2, n.col_3 AS col_3, n.col_4 AS col_4, n.col_5 AS col_5, n.col_6 AS col_6, n.col_7 AS col_7, n.col_8 AS col_8, n.col_9 AS col_9, c.wholeName AS cName FROM classifieds_advertisement AS n, classifieds_classifiedscategory AS c WHERE cid='1' AND c.id=n.cid AND n.active='1' ORDER BY creationtime DESC LIMIT 0, 100000
Got error 28 from table handler
Any Idea's?
thanks
i have nohahs classifieds installed on my system, however it seems to have gone missing, with all my adverts?
when i go into it it says the following
SELECT n.id AS id, n.cid AS cid, n.firstCid AS firstCid, n.title AS title, n.creationtime AS creationtime, n.active AS active, n.clicked AS clicked, n.responded AS responded, n.ownerId AS ownerId, n.expEmailSent AS expEmailSent, n.expirationTime AS expirationTime, n.renewalNum AS renewalNum, n.picture AS picture, n.keepPrivate AS keepPrivate, n.col_0 AS col_0, n.col_1 AS col_1, n.col_2 AS col_2, n.col_3 AS col_3, n.col_4 AS col_4, n.col_5 AS col_5, n.col_6 AS col_6, n.col_7 AS col_7, n.col_8 AS col_8, n.col_9 AS col_9, c.wholeName AS cName FROM classifieds_advertisement AS n, classifieds_classifiedscategory AS c WHERE cid='1' AND c.id=n.cid AND n.active='1' ORDER BY creationtime DESC LIMIT 0, 100000
Got error 28 from table handler
Any Idea's?
thanks
Comment