J3 Issue ?
avatar GarryMoveOut
GarryMoveOut
28 Nov 2018

Steps to reproduce the issue

Install Joomla on apache with MySQL or PostgresSQL database.

Expected result

Table template_styles with column home with type tinyint.

Actual result

Table template_styles has a column home with type varchar(7)

-- Table: ****_template_styles

CREATE TABLE ****_template_styles
(
  id serial NOT NULL,
  template character varying(50) NOT NULL DEFAULT ''::character varying,
  client_id smallint NOT NULL DEFAULT 0,
  home character varying(7) NOT NULL DEFAULT '0'::character varying,
  title character varying(255) NOT NULL DEFAULT ''::character varying,
  params text NOT NULL,
  CONSTRAINT aa360_template_styles_pkey PRIMARY KEY (id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE *****_template_styles
  OWNER TO ****;

Some plug-ins won't work with varchar.

System information (as much as possible)

CentOS 7, Apache + PHP5.6 + PostgresSQL 9.6

Additional comments

Doc about table:
https://docs.joomla.org/Tables/template_styles

avatar GarryMoveOut GarryMoveOut - open - 28 Nov 2018
avatar joomla-cms-bot joomla-cms-bot - change - 28 Nov 2018
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 28 Nov 2018
avatar infograf768
infograf768 - comment - 29 Nov 2018

Never understood indeed why we have char(7) instead of tinyint(1) as the value is 0 or 1

avatar franz-wohlkoenig franz-wohlkoenig - change - 4 Mar 2019
Status New Discussion
avatar franz-wohlkoenig franz-wohlkoenig - change - 28 Mar 2019
Category Templates (site)
avatar franz-wohlkoenig franz-wohlkoenig - unlabeled - 4 Apr 2019
avatar franz-wohlkoenig franz-wohlkoenig - change - 4 Apr 2019
Labels Added: J3 Issue
avatar franz-wohlkoenig franz-wohlkoenig - labeled - 4 Apr 2019
avatar alikon
alikon - comment - 15 Apr 2019

please test #24595

avatar franz-wohlkoenig franz-wohlkoenig - change - 15 Apr 2019
Status Discussion Closed
Closed_Date 0000-00-00 00:00:00 2019-04-15 18:53:08
Closed_By franz-wohlkoenig
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 15 Apr 2019

Closed as having Pull Request.

avatar franz-wohlkoenig franz-wohlkoenig - close - 15 Apr 2019

Add a Comment

Login with GitHub to post a comment