1. Home
  2. Community
  3. Troubleshooting and Problems
  4. Files Archive error

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

Files Archive error

Troubleshooting and Problems 156 This topic was started by ,


avatar
testtest22 8
From: -
Files Archive error

Click contentteller.php/files_archive/200901.html

return:

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 'file_comments.file_thread' in 'field list' while executing 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 esselbach_ct_files WHERE (file_date LIKE '%2009-01%') AND (file_status = '0' OR file_status = '1' OR file_status = '2' OR file_status = '3' OR file_status = '4') AND (file_website = '0' OR file_website = '1') ORDER BY file_date

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


PS:Contentteller® Community Edition 1.0.2

Notice

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

Responses to this topic

1 Re: Files Archive error
avatar
OP 8
From: -
I see. There is a small typo in the SQL query.

Open modules/files/filesarchivemonth.php in an editor and find:

 $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" );


Then replace this line with:

     $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" );


Thank you.
1 Re: Files Archive error
avatar
Editor
0
From: -
I see. There is a small typo in the SQL query.

Open modules/files/filesarchivemonth.php in an editor and find:

     $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" );


Then replace this line with:

     $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.