Warning: error_log(/home/sciinn/public_html/logs/error.log) [function.error-log]: failed to open stream: Permission denied in /home/sciinn/public_html/lib/error.php on line 132
Critical User Error on SCI-INNType : User Error Date/time : 2010-09-04 15:04:47 Message :

Can't execute query

        SELECT
                     *
        FROM
                     news n,
                     news_categories c,
                     news_to_news_categories nc
        LEFT JOIN
					 users
        ON
					 (users.users_id = n.news_authors_id)
        WHERE
                     n.news_id = nc.news_id
        AND
                     c.news_categories_id = nc.news_categories_id
		 AND n.news_status IN ('3') AND nc.news_categories_id = '1' AND n.news_publication_date <= '2010-09-04' AND n.news_expiry_date > '2010-09-04' GROUP BY n.news_id ORDER BY news_publication_date DESC LIMIT 0, 2

MySQL Error: Unknown column 'n.news_authors_id' in 'on clause'

Script : /home/sciinn/public_html/lib/dbase.class.php Linenumber : 226 Variables : this = Object , query = SELECT * FROM news n, news_categories c, news_to_news_categories nc LEFT JOIN users ON (users.users_id = n.news_authors_id) WHERE n.news_id = nc.news_id AND c.news_categories_id = nc.news_categories_id AND n.news_status IN ('3') AND nc.news_categories_id = '1' AND n.news_publication_date <= '2010-09-04' AND n.news_expiry_date > '2010-09-04' GROUP BY n.news_id ORDER BY news_publication_date DESC LIMIT 0, 2 , show = , time = , transaction = , error_text =

Can't execute query

        SELECT
                     *
        FROM
                     news n,
                     news_categories c,
                     news_to_news_categories nc
        LEFT JOIN
					 users
        ON
					 (users.users_id = n.news_authors_id)
        WHERE
                     n.news_id = nc.news_id
        AND
                     c.news_categories_id = nc.news_categories_id
		 AND n.news_status IN ('3') AND nc.news_categories_id = '1' AND n.news_publication_date <= '2010-09-04' AND n.news_expiry_date > '2010-09-04' GROUP BY n.news_id ORDER BY news_publication_date DESC LIMIT 0, 2

MySQL Error: Unknown column 'n.news_authors_id' in 'on clause'

, SCI-INN - Hoofdpagina

Hoofdpagina


 

Welkom op de website van SCI-INN

Stichting SCI-INN
p/a Mevrouw Carla Meek
Bigtelaar 2

4891  CP  RIJSBERGEN

Telefoon: 076-596 32 23

Contactpersonen: Carla Meek en Peter Kuijpers

Bereikbaar alle werkdagen na 13.00 uur
e-mail: carlamee@planet.nl

 

Stichting Sociaal Cultureel Instituut Indonesië - Nederland is opgericht op 9 juni 1972 en is ingeschreven bij de KvK onder nummer 41150284.

Wilt u de SCI-INN steunen dan kunt u uw donatie storten op onze rekening: 32.05.61.747.

 

In verband met tijdelijke onderbezetting kunnen enkele pagina's niet actueel zijn. Deze welkomstpagina bevat echter alle actuele gegevens.