1. Beat
  2. Newbie area
  3. Sunday, 14 July 2013
  4.  Subscribe via email
Hello,

As I want to include some comment funtionality on my site, I've downloaded the CComment Core. I was already a little bit wondering, why only a release candidate is available for download, but well...

So after installing the component I observe the following:

The ccomment dashboard only gives me a sql error message:
Unknown column 'userid' in 'field list' SQL=SELECT COUNT('*') as count, COUNT(DISTINCT userid) as users, COUNT(DISTINCT ip) as ip, DATE(date) as date FROM scom_comment WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date GROUP BY DATE(date)

My pages where the comment function should appear fail with the error message
Error: 1054 - Unknown column 'contentid' in 'where clause' SQL=SELECT COUNT(*) FROM scom_comment WHERE contentid='13' AND component='com_content' AND published=1

Looks like something is wrong with the database installation, when installed completely from scratch.

So at the moment the component is pretty much useless :(

Cheerio

Beat
Responses (5)


There are %s replies to this question. If you want to see them you need a valid subscription.
If you have a valid subscription, please login now.
Visit store now

Last questions

Questions on new installation...
Working on getting this set up... https://eastend2024.joepolecheck.com/rumma...
3 Replies
Posted on Wednesday, 17 April 2024
  • Resolved
  • New
  • Changes to the Submission form
    Can you make changes to the Submission form? There are a few fields I'd like to ...
    0 Replies
    Posted on Thursday, 18 April 2024
  • New
  • Error received? Class "XMLReader" not fo
    Just installed the Pro version of Hotspots, but am getting an error when I try t...
    1 Replies
    Posted on Wednesday, 17 April 2024
  • Resolved
  • New
  • Links aus Veranstaltungsübersicht funktionieren ni
    Nach der Migration von Joomla 3.10 auf Joomla 5.0.3 treten folgende Probleme auf...
    2 Replies
    Posted on Monday, 08 April 2024
    Custom Hotspot Marker fails to load
    I just updated from Joomla 3 to Joomla 4.3.4 and Hotspots 6.0.12. I decided to e...
    0 Replies
    Posted on Tuesday, 09 April 2024