1. Home
  2. Community
  3. General Questions
  4. CT preview 5 bug

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

CT preview 5 bug

General Questions 916 This topic was started by ,


avatar
cosmin 269
From: -
CT preview 5 bug

Query: SELECT module_id, module_name FROM esselbach_ct_modules WHERE module_group = '1' OR module_group = '0' ORDER BY module_position
Error: 1054 Unknown column 'module_position' in 'order clause'

when entering cadmin.
after upgrading from preview 4 without errors.

Notice

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

Responses to this topic

1 Re: CT preview 5 bug
avatar
Administrator
1340
From: Vienna, Austria
CT preview 5 bug

Found the problem. The upgrade script is still looking in cadmin/install for the SQL upgrade scripts. However, Preview 5 is storing the SQL files in each module directory.
1 Re: CT preview 5 bug
avatar
Administrator
1340
From: Vienna, Austria
CT preview 5 bug

Look like the cupgrade script did not run the upgrade sql files properly. I thought that was fixed Slightly Frowning Face

Run the following SQL commands in phpMyAdmin to rebuild the modules table:

DROP TABLE esselbach_ct_modules;   



CREATE TABLE esselbach_ct_modules (

                 module_id smallint(4) NOT NULL auto_increment,

            module_name varchar(255) NOT NULL,

                module_group smallint(4) NOT NULL default '1',

             module_position int(11) NOT NULL default '1',   

             module_editadmin varchar(255) NOT NULL,                 

             module_postip varchar(16) NOT NULL default '::1', 

             module_editip varchar(16) NOT NULL default '::1',                        

             PRIMARY KEY  (module_id)

          );

               

  INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('1', 'core', '1', '1', 'cupgrade', '::1', '::1');

        INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('2', 'content', '1', '2', 'cupgrade', '::1', '::1');

     INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('3', 'users', '1', '3', 'cupgrade', '::1', '::1'); 

      INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('4', 'templates', '1', '4', 'cupgrade', '::1', '::1'); 

  INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('5', 'blocks', '1', '5', 'cupgrade', '::1', '::1');

      INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('6', 'filetypes', '1', '6', 'cupgrade', '::1', '::1');

   INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('7', 'modules', '1', '7', 'cupgrade', '::1', '::1');   

  INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('8', 'stats', '1', '8', 'cupgrade', '::1', '::1');   

    INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('9', 'news', '2', '1', 'cupgrade', '::1', '::1');     

   INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('10', 'import', '2', '2', 'cupgrade', '::1', '::1');     

        INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('11', 'contacts', '2', '3', 'cupgrade', '::1', '::1');     

      INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('12', 'mailinglists', '2', '4', 'cupgrade', '::1', '::1'); 

      INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('13', 'articles', '2', '5', 'cupgrade', '::1', '::1'); 

  INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('14', 'knowledgebase', '3', '1', 'cupgrade', '::1', '::1');     

 INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('15', 'tickets', '3', '2', 'cupgrade', '::1', '::1');     

       INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('16', 'compatdb', '3', '3', 'cupgrade', '::1', '::1'); 

  INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('17', 'files', '4', '1', 'cupgrade', '::1', '::1');     

 INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('18', 'glossary', '4', '2', 'cupgrade', '::1', '::1');     

      INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('19', 'links', '4', '3', 'cupgrade', '::1', '::1'); 

     INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('20', 'acquire', '4', '4', 'cupgrade', '::1', '::1'); 

   INSERT INTO esselbach_ct_modules (module_id, module_name, module_group, module_position, module_editadmin, module_postip, module_editip) VALUES ('21', 'online', '0', '9', 'cupgrade', '::1', '::1');

Notice

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