1. Home
  2. Community
  3. Troubleshooting and Problems
  4. Cannot Post Comments

This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

Cannot Post Comments

Troubleshooting and Problems 156 This topic was started by ,


avatar
wright 42
From: -
Cannot Post Comments

When I try to comment on an article I get this error...

$query = $database -> dbquery( "SELECT file_id, file_author, file_name, file_version, file_seo, file_description, file_status, file_teaser, file_date, file_rating, file_votes, file_comments, file_thread FROM " . DB_PREFIX . "esselbach_ct_files WHERE (file_date LIKE '%" . $archive_year . "-" . $archive_month . "%') AND " . $file_status . " AND (file_website = '0' OR file_website = '" . $preferences[ 'current_website' ] . "')" . $files_expire_sql . " ORDER BY file_date" );

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic

1 Re: Cannot Post Comments
avatar
Editor
0
From: -
Open /cadmin/articles/admindomassarticlecommentsdelete.php in an editor and replace:

$database -> dbquery( "DELETE FROM " . DB_PREFIX . "esselbach_ct_articlecomments WHERE articlecomment_id IN (" . $input_comments_sql . ")" );


with:

$database -> dbquery( "DELETE FROM " . DB_PREFIX . "esselbach_ct_articlescomments WHERE articlecomment_id IN (" . $input_comments_sql . ")" );
1 Re: Cannot Post Comments
avatar
232
From: -
I just got this while trying to delete article comments inside admincp?


The MySQL database of this Contentteller Content Management System installation has encountered the following problem:
The MySQL database server has returned 1146: Table 'msfnorg_ct.esselbach_ct_articlecomments' doesn't exist while executing DELETE FROM esselbach_ct_articlecomments WHERE articlecomment_id IN (8,7)


and it shows comments on frontend like this:

[ Print | -2 comment(s) ]
1 Re: Cannot Post Comments
avatar
OP 42
From: -
Thank you...
1 Re: Cannot Post Comments
avatar
Editor
0
From: -
Open /modules/articles/articlesdocomments.php in an editor and replace:

$query = $database -> dbquery( "SELECT UNIX_TIMESTAMP(articlecomment_date) FROM " . DB_PREFIX . "esselbach_ct_articlescomments WHERE " . $search_sql . " ORDER BY articlescomment_date DESC LIMIT 1" );


with:

$query = $database -> dbquery( "SELECT UNIX_TIMESTAMP(articlecomment_date) FROM " . DB_PREFIX . "esselbach_ct_articlescomments WHERE " . $search_sql . " ORDER BY articlecomment_date DESC LIMIT 1" );
1 Re: Cannot Post Comments
avatar
OP 42
From: -
Sorry this is the error...

Contentteller

The MySQL database of this Contentteller Content Management System installation has encountered the following problem:
The MySQL database server has returned 1054: Unknown column 'articlescomment_date' in 'order clause' while executing SELECT UNIX_TIMESTAMP(articlecomment_date) FROM legionesselbach_ct_articlescomments WHERE articlecomment_postip = '124.168.127.142' ORDER BY articlescomment_date DESC LIMIT 1

Please try it in a few minutes again. We apologize for any inconvenience.

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.