latest comments module not working

[wildgarden]

Hi, I've tried to find a solution to my problem but can't find anything current. I am using the latest CMSMS 1.0.4 installed and the latest comments module 1.8. I have comments displaying in my news detail page but when I enter anything in the fields it doesn't save. Also in the admin side I can't manage the options in the Comments. It doesn't go anywhere when I click the tabs. Is this happening for anyone else? I would appreciate any help and thank you in advance.

My link is http://www.jessicalim.info/cms/index.ph ... eturnid=56

[wildgarden]

*bumping*
i really need to get this working because a client needs it so i would appreciate any help thanks

[wildgarden]

i also noticed that i get an error in the Comments admin Fatal error:  Call to a member function on a non-object in ../cms/modules/Comments/action.defaultadmin.phpon line 46 and the line of code in question is

Code: Select all

if($dbresult->RecordCount() == 0){

I have no idea what this means. Can someone please point me in the right direction?

[Elijah Lofgren]

It seems like Comments did not install correctly.

I would try installing and uninstalling it.

In addition, check (using phpMyAdmin) and make sure the cms_comments table exists.

Hope this helps,

Elijah

[wildgarden]

thanks elijah. I've reinstalled module several times and still doesn't work. I tried looking for the cms_comments table in phpmyadmin and it doesn't appear to be there. any suggestions?

[Elijah Lofgren]

thanks elijah. I've reinstalled module several times and still doesn't work. I tried looking for the cms_comments table in phpmyadmin and it doesn't appear to be there. any suggestions?

Here is the SQL you can use to install Comments via phpMyAdmin:

Code: Select all

-- phpMyAdmin SQL Dump
-- version 2.8.2-Debian-0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Mar 26, 2007 at 12:01 AM
-- Server version: 5.0.24
-- PHP Version: 5.1.6
-- 
-- Database: `cmsmadesimple`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `cms_module_comments`
-- 

CREATE TABLE `cms_module_comments` (
  `comment_id` int(11) NOT NULL,
  `comment_data` text,
  `comment_date` datetime default NULL,
  `comment_author` varchar(255) default NULL,
  `author_email` varchar(255) default NULL,
  `author_website` varchar(255) default NULL,
  `page_id` varchar(255) default NULL,
  `module_name` varchar(50) default NULL,
  `active` tinyint(4) default NULL,
  `create_date` datetime default NULL,
  `modified_date` datetime default NULL,
  PRIMARY KEY  (`comment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `cms_module_comments`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `cms_module_comments_seq`
-- 

CREATE TABLE `cms_module_comments_seq` (
  `id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `cms_module_comments_seq`
-- 

INSERT INTO `cms_module_comments_seq` (`id`) VALUES (0);

[wildgarden]

Great- that did the trick! It's working beautifully! Thanks very much

[Elijah Lofgren]

Great.

I wonder why it wouldn't install... Quite strange. I'd probably file a bug about this if I had more time (need to study for test tomorrow and sleep).