https://bugzilla.wikimedia.org/show_bug.cgi?id=19948
--- Comment #8 from Aneta <[email protected]> 2010-01-11 08:52:27 UTC --- 1) The access rights of user for schemas (public and wiki) are correct. 2) EXEC: CREATE TEMPORARY TABLE smw_tmp_unusedprops ( title text ); OK (La consulta se ejecutó con éxito sin resutado en 16 ms.) EXEC: DELETE smw_tmp_unusedprops.* FROM smw_tmp_unusedprops, smw_rels2 INNER JOIN smw_ids ON p_id=smw_id WHERE title=smw_title AND smw_iw='' ERROR: error de sintaxis en o cerca de «smw_tmp_unusedprops» LINE 1: DELETE smw_tmp_unusedprops.* FROM smw_tmp_unusedprops, smw_r... ^ ********** Error ********** ERROR: error de sintaxis en o cerca de «smw_tmp_unusedprops» Estado SQL:42601 Caracter: 8 ---- 3) I have modified the request. EXEC: select * FROM smw_tmp_unusedprops where title in (select smw_title from smw_tmp_unusedprops, smw_rels2 INNER JOIN smw_ids ON p_id=smw_id WHERE title=smw_title AND smw_iw='') OK (empty result - my "smw_rels2" is empty but smw_ids is not) -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
