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

Upgrading CComment to 6.1.7 and "Download ID
Hi Support, We are using CComment and today upgraded to 6.1.7. From the Joomla...
1 Replies
Posted on Wednesday, 10 August 2022
  • New
  • What is Tiles apps ?
    In Joomla there are many applications inside, I used Compojoom, I found it to me...
    0 Replies
    Posted on Tuesday, 09 August 2022
  • New
  • What is Tiles apps ?
    In Joomla there are many applications inside, I used Compojoom, I found it to me...
    0 Replies
    Posted on Tuesday, 09 August 2022
  • New
  • CComment - Submit comment throwing error
    I upgraded Joomla to Version 4 and re-installed CComment. Comments and settings ...
    7 Replies
    Posted on Tuesday, 29 March 2022
  • Resolved
  • Paypal Zahlungsabwicklung
    Seit kurzem funktioniert leider die Zahlung per paypal nichtmehr so wie sie soll...
    2 Replies
    Posted on Sunday, 26 June 2022