phpBB România

Cod: Selectaţi tot

Couldn't get file info for this category

DEBUG MODE

SQL Error : 1146 Table 'ph.phpbb_pa_comments' doesn't exist

SELECT f1.*, f1.file_id, r.votes_file, IF(COUNT(r.rate_point)>0,AVG(r.rate_point),0) AS rating, COUNT(r.votes_file) AS total_votes, u.user_id, u.username, COUNT(c.file_id) AS total_comments FROM phpbb_pa_files AS f1 LEFT JOIN phpbb_pa_votes AS r ON f1.file_id = r.votes_file LEFT JOIN phpbb_users AS u ON f1.user_id = u.user_id LEFT JOIN phpbb_pa_comments AS c ON f1.file_id = c.file_id LEFT JOIN phpbb_pa_cat AS cat ON f1.file_catid = cat.cat_id WHERE f1.file_pin = 1 AND f1.file_approved = 1 AND f1.file_catid = 4 GROUP BY f1.file_id ORDER BY file_time DESC
Line : 908
File : E:\wamp\www\pafiledb\includes\functions_pafiledb.php

Cod: Selectaţi tot

INSERT INTO `phpbb_pa_cat` VALUES (1, 'My Category', '', 0, 'a:0:{}', 0, 0, -1, -1, -1, -1, -1, -1, -1, -1, 1, 1, 'test file name', 1184273220, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),

CREATE TABLE `phpbb_pa_comments` (
  `comments_id` int(10) NOT NULL auto_increment,
  `file_id` int(10) NOT NULL default '0',
  `comments_text` text NOT NULL,
  `comments_title` text NOT NULL,
  `comments_time` int(50) NOT NULL default '0',
  `comment_bbcode_uid` varchar(10) default NULL,
  `poster_id` mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (`comments_id`),
  KEY `comments_id` (`comments_id`),
  FULLTEXT KEY `comment_bbcode_uid` (`comment_bbcode_uid`)
);