Page 1 of 1
latest comments module not working
Posted: Tue Mar 20, 2007 8:18 am
by 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
Re: latest comments module not working
Posted: Wed Mar 21, 2007 10:44 pm
by wildgarden
*bumping*
i really need to get this working because a client needs it so i would appreciate any help thanks
Re: latest comments module not working
Posted: Mon Mar 26, 2007 12:23 am
by 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?
Re: latest comments module not working
Posted: Mon Mar 26, 2007 2:51 am
by 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
Re: latest comments module not working
Posted: Mon Mar 26, 2007 3:20 am
by 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?
Re: latest comments module not working
Posted: Mon Mar 26, 2007 5:02 am
by Elijah Lofgren
wildgarden wrote:
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);
Re: latest comments module not working
Posted: Mon Mar 26, 2007 5:42 am
by wildgarden
Great- that did the trick! It's working beautifully! Thanks very much
Re: latest comments module not working
Posted: Mon Mar 26, 2007 5:46 am
by 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).