[Paul M]

Originally Posted by Zorobz

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT articlepost.*, article.categoryid FROM vb3_articlepost
									  INNER JOIN vb3_article AS article ON (article.articleid = articlepost.articleid)
									  WHERE articlepost.postid=17
mysql error: Unknown table 'articlepost'

mysql error number: 1051

getting error when trying to edit a comment... any ideas pleasE?

Originally Posted by Qwest

same error here

It's an error in the script. Find the following code in the article.php (line 680 ish)

PHP Code:

    // get comment
    $comment = $DB_site->query_first("SELECT articlepost.*, article.categoryid FROM " . TABLE_PREFIX . "articlepost
                                      INNER JOIN " . TABLE_PREFIX . "article AS article ON (article.articleid = articlepost.articleid)
                                      WHERE articlepost.postid=$id"); 


and replace it with this ;

PHP Code:

    // get comment
    $comment = $DB_site->query_first("SELECT articlepost.*, article.categoryid FROM " . TABLE_PREFIX . "articlepost as articlepost
                                      INNER JOIN " . TABLE_PREFIX . "article AS article ON (article.articleid = articlepost.articleid)
                                      WHERE articlepost.postid=$id");