過去の記事 -2009年07月の一覧
-
mySQL error with query SELECT DISTINCT(i.inumber) as itemid, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, UNIX_TIMESTAMP(i.itime) as timestamp, i.itime, i.imore as more, m.mnumber as authorid, i.icat as catid, i.iclosed as closed, c.cname as category FROM nucleus_item as i, nucleus_member as m, nucleus_category as c, nucleus_blog as b LEFT JOIN nucleus_plug_multiple_categories as p ON i.inumber=p.item_id WHERE i.iauthor=m.mnumber and i.icat=c.catid and i.idraft=0 and i.iblog=43 and ((i.inumber=p.item_id and (p.categories REGEXP "(^|,)213(,|$)" or i.icat=213)) or (p.item_id IS NULL and i.icat=213)) and i.itime>="2009-07-22 00:00:00" and i.itime<"2009-07-23 00:00:00" and b.bnumber = c.cblog ORDER BY i.itime DESC LIMIT 0,200: Unknown column 'i.inumber' in 'on clause'
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/web/public_html.blog/admin/libs/BLOG.php on line 173
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/web/public_html.blog/admin/libs/BLOG.php on line 213
Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /home/web/public_html.blog/admin/libs/BLOG.php on line 222