? J3 Issue
avatar softarius
softarius
24 May 2019

0004-getTableColumns-for-another-schema.txt

Steps to reproduce the issue

  • install Joomla with PostgreSQl driver.
  • create a new schema (for example 'test')
  • create a new table in this schema
CREATE TABLE test.customer (
  id SERIAL,
  name VARCHAR(100),
  PRIMARY KEY(id)
) 
WITH (oids = false);
  • in code call getTableColumns for this table
$db = JFactory::getDBO();
$custfields=$db->getTableColumns('test.customer'); 

Expected result

Array with fields of table

Actual result

Empty array

System information (as much as possible)

PostgreSQL Joomla driver using (important!)
Any operation system (Windows or Linux for me)
Joomla 3.9.6 (or staging)
PostgreSQL 10 (or other)

Additional comments

A fixed this bag (see attached patch)

avatar softarius softarius - open - 24 May 2019
avatar joomla-cms-bot joomla-cms-bot - labeled - 24 May 2019
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 24 May 2019

Please "System information (as much as possible)"

avatar softarius
softarius - comment - 24 May 2019

System information (as much as possible)

  • PostgreSQL Joomla driver using (important!)
  • Any operation system (Windows or Linux for me)
  • Joomla 3.9.6 (or staging)
  • PostgreSQL 10 (or other)

This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24998.
avatar softarius softarius - change - 24 May 2019
The description was changed
avatar softarius softarius - edited - 24 May 2019
avatar alikon
alikon - comment - 24 May 2019

you have already the solution so then
please submit a pr is easy: https://docs.joomla.org/Using_the_Github_UI_to_Make_Pull_Requests

avatar franz-wohlkoenig franz-wohlkoenig - change - 24 May 2019
Labels Added: J3 Issue
avatar franz-wohlkoenig franz-wohlkoenig - labeled - 24 May 2019
avatar softarius
softarius - comment - 24 May 2019

Yes. Done.
PR #24999


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24998.

avatar richard67
richard67 - comment - 24 May 2019

Then you can close this issue because there is a PR.

avatar joomla-cms-bot joomla-cms-bot - change - 24 May 2019
Status New Closed
Closed_Date 0000-00-00 00:00:00 2019-05-24 09:21:51
Closed_By joomla-cms-bot
avatar joomla-cms-bot joomla-cms-bot - close - 24 May 2019
avatar alikon alikon - change - 24 May 2019
Closed_By joomla-cms-bot alikon
Labels
avatar joomla-cms-bot
joomla-cms-bot - comment - 24 May 2019

Set to "closed" on behalf of @alikon by The JTracker Application at issues.joomla.org/joomla-cms/24998

avatar alikon
alikon - comment - 24 May 2019

closing as we have a pr for testing #24999


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24998.

Add a Comment

Login with GitHub to post a comment