Geeklog Forums

11/26/05 13:27:35 - 1054: Unknown column 'gl_comments.sid' in 'on clause'. SQL in question: SELECT gl_users.username,gl_users.fullname,gl_stories.sid,gl_comments.title,comment,pid,cid,gl_comments.uid,gl_comments.sid AS qid,type as comment_type,UNIX_TIMESTAMP(gl_comments.date) as day,'comment' as type FROM gl_comments,gl_users LEFT JOIN gl_stories ON ((gl_stories.sid = gl_comments.sid) AND (gl_stories.perm_anon >= 2) AND (tid IN ('General','GeekLog'))) WHERE  gl_users.uid = gl_comments.uid AND (gl_stories.draft_flag = 0) AND (gl_stories.date <= NOW()) AND (comment LIKE '%zurich%' OR gl_comments.title LIKE '%zurich%') AND ((gl_stories.perm_anon IS NOT NULL)) ORDER BY gl_comments.date DESC LIMIT 0,10
11/26/05 13:34:40 - 1054: Unknown column 'gl_comments.sid' in 'on clause'. SQL in question: SELECT gl_users.username,gl_users.fullname,gl_stories.sid,gl_comments.title,comment,pid,cid,gl_comments.uid,gl_comments.sid AS qid,type as comment_type,UNIX_TIMESTAMP(gl_comments.date) as day,'comment' as type FROM gl_comments,gl_users LEFT JOIN gl_stories ON ((gl_stories.sid = gl_comments.sid)) WHERE  gl_users.uid = gl_comments.uid AND (gl_stories.draft_flag = 0) AND (gl_stories.date <= NOW()) AND (comment LIKE '%test%' OR gl_comments.title LIKE '%test%') AND ((gl_stories.owner_id IS NOT NULL AND gl_stories.perm_owner IS NOT NULL) OR (gl_stories.group_id IS NOT NULL AND gl_stories.perm_group IS NOT NULL) OR (gl_stories.perm_members IS NOT NULL)) ORDER BY gl_comments.date DESC LIMIT 0,10

 

--
-- Table structure for table `gl_comments`
--

CREATE TABLE `gl_comments` (
  `cid` int(10) unsigned NOT NULL auto_increment,
  `type` varchar(30) NOT NULL default 'article',
  `sid` varchar(40) NOT NULL default '',
  `date` datetime default NULL,
  `title` varchar(128) default NULL,
  `comment` text,
  `score` tinyint(4) NOT NULL default '0',
  `reason` tinyint(4) NOT NULL default '0',
  `pid` int(10) unsigned NOT NULL default '0',
  `lft` mediumint(10) unsigned NOT NULL default '0',
  `rht` mediumint(10) unsigned NOT NULL default '0',
  `indent` mediumint(10) unsigned NOT NULL default '0',
  `uid` mediumint(8) NOT NULL default '1',
  `ipaddress` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`cid`),
  KEY `comments_sid` (`sid`),
  KEY `comments_uid` (`uid`),
  KEY `comments_lft` (`lft`),
  KEY `comments_rht` (`rht`),
  KEY `comments_date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

 

  //$this->comment_results = $this->_searchComments();

 

<ol>
<li>Change the default password for the Admin account.</li>
<li>Remove the install directory (you won't need it any more).</li>
</ol>','','2005-11-22 09:33:37','1','0','0','html',1,2,6,3,2,2,2)
12/02/05 12:02:50 - 1054: Unknown column 'security' in 'field list'. SQL in question: REPLACE INTO gl_stories (sid,uid,tid,title,introtext,related,date,show_topic_icon,commentcode,trackbackcode,postmode,frontpage,owner_id,group_id,perm_owner,perm_group,perm_members,perm_anon) VALUES (security-reminder,2,'GeekLog','Are you secure?','<p>This is a reminder to secure your site once you have Geeklog up and running. What you should do:</p>

 

$sql = " FROM {$_TABLES['comments']},{$_TABLES['users']} ";



 

$sql = " FROM {$_TABLES['users']},{$_TABLES['comments']} ";



 

SELECT * FROM table1
   LEFT JOIN table2 ON <something>
   LEFT JOIN table3 ON table1.id = table3.id