1. Home
  2. Community
  3. General Questions
  4. Download tags

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

Download tags

General Questions 916 This topic was started by ,


avatar
cosmin 269
From: -
Download tags

http://www.file-portal.net/ess20/cadmin/index.php?action=managefilestags

Query: SELECT filetag_id, filetag_website, filetag_tag, filetag_count, filetag_date FROM esselbach_ct_filestags ORDER BY filetag_id DESC LIMIT 0,50
Error: 1054 Unknown column 'filetag_date' in 'field list'
I upgraded from Preview Release 2.

Notice

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

Responses to this topic

1 Re: Download tags
avatar
Administrator
1342
From: Austria
Download tags

Thanks Cosmin. The upgrade script is missing a few alterations due to a typo Slightly Frowning Face

Here all needed alterations to upgrade preview 2 to 3:

ALTER TABLE esselbach_ct_newsqueue ADD newsqueue_link varchar(255) default '' AFTER newsqueue_extendedstory;

ALTER TABLE esselbach_ct_newsrelated ADD newsrelated_description text AFTER newsrelated_seo;

ALTER TABLE esselbach_ct_newssearches ADD newssearch_website smallint(4) default '0' AFTER newssearch_id;

ALTER TABLE esselbach_ct_knowledgebasetags ADD knowledgebasetag_date datetime NOT NULL AFTER knowledgebasetag_count;

ALTER TABLE esselbach_ct_content ADD content_tags text AFTER content_keywords;

ALTER TABLE esselbach_ct_articlestags ADD articletag_date datetime NOT NULL AFTER articletag_count;

ALTER TABLE esselbach_ct_filestags ADD filetag_date datetime NOT NULL AFTER filetag_count;

Notice

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