[Riješeno] search- ne radi!

Autor komir, 06. Ožujak 2011, 21:00

0 Članovi i 1 Gost pregledava ovu temu.

komir

Prestao mi je raditi search stranice. Probao sam sve žive tražilice ali uvijek isti error
500 - No valid database connection:Table '************.jos_ksads_ads' doesn't exist SQL=SELECT DISTINCT p.id, p.ad_name as title, FROM_UNIXTIME( p.date_created, '%Y-%m-%d' ) AS created, p.ad_desc AS text, c.id, c.cat_name, c.gid, c.aid, CONCAT('index.php?option=com_ksadvertiser&task=viewad&id=', p.id) as href, CONCAT('Kleinanzeigen/', c.cat_name) as section, '2' as browsernav , CONCAT_WS(' ',LOWER(p.ad_ident), LOWER(p.ad_name), LOWER(p.ad_desc), LOWER(p.ad_intro), LOWER(p.ad_state), LOWER(p.ad_address), LOWER(p.ad_location), LOWER(p.ad_delivery), LOWER(p.contact_name), LOWER(p.contact_email), LOWER(p.meta)) AS whole_text FROM jos_ksads_ads as p INNER JOIN jos_ksads_cats AS c ON c.id = p.catid WHERE ((p.ad_ident LIKE '%zagreb%' OR p.ad_name LIKE '%zagreb%' OR p.ad_desc LIKE '%zagreb%' OR p.ad_intro LIKE '%zagreb%' OR p.ad_state LIKE '%zagreb%' OR p.ad_address LIKE '%zagreb%' OR p.ad_location LIKE '%zagreb%' OR p.ad_delivery LIKE '%zagreb%' OR (p.contact_name LIKE '%zagreb%' AND ad_boxnumber = 0) OR p.contact_email LIKE '%zagreb%' OR p.meta LIKE '%zagreb%')) OR (p.phonetic LIKE '%zagreb%' AND ad_boxnumber = 0) AND p.published='1' AND (c.gid =0 OR c.gid <= 0) AND (c.aid =0 OR c.aid <= 0) ORDER BY p.date_created DESC
Neznam što se događa?

Apartmani
Izrada web stranica Domidona IT
Prirodni vrcani  med
Profesionalni Hrvatski SSD Hosting

wooer

Po poruci koja ti se javlja evidentno je da u bazi fali tablica jos_ksads_ads. Pretpostavljam da si pobrisao neku komponentu za oglase ali ne i pripadajući search plugin.
Pogledaj u popisu pluginova (search filter) da li ima neki koji bi nazivom podsjećao na taj ksads pa ga odjavi ili pobriši.
UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity
Documentation & Translation Team Member

komir

To je to, plugin kiss ads, hvala
Izrada web stranica Domidona IT
Prirodni vrcani  med
Profesionalni Hrvatski SSD Hosting