#1 2016-03-23 17:40:37

adaliszk
Ionize Friend
From: Germany
Registered: 2010-09-20
Posts: 397
Website

Can't attach Extend Fields to Content Type's Field Group

mslbn wrote:

Hello;

I try to use Content Type which comes with 1.0.8

First I created a Content Type, named it Team Member

I added a new Field Group for Extend Fields

I click on "Add Extends to Group" so it showed me a popup, "Extend Fields" In this window I click "Create New Extend" and created extend fields for that Content Type

Everything is fine until here.

When I try to attach this Extend Fields to Field Group by drag and drop, it doesn't attach it and shows an php error;

 Fatal error: Call to a member function result_array() on boolean in /Users/username/www/projectdir/system/database/DB_driver.php on line 839

Webdeveloper, Programmer, Application developer, Ionize friend
@adaliszk

Offline

#2 2016-04-10 16:46:58

redefined
Member
Registered: 2016-04-10
Posts: 1

Re: Can't attach Extend Fields to Content Type's Field Group

Hi all,

I have the same issue. It is an Article content type. Below is the call stack.

error: Call to a member function result_array() on a non-object in /var/www/html/system/database/DB_driver.php on line 839 Call Stack: 0.0006 683656
1. {main}() /var/www/html/index.php:0 0.0012 771240
2. require_once('/var/www/html/system/core/CodeIgniter.php') /var/www/html/index.php:298 0.1184 10628208
3. call_user_func_array:{/var/www/html/system/core/CodeIgniter.php:339}() /var/www/html/system/core/CodeIgniter.php:339 0.1184 10628288
4. Content_type->link_extend_with_group() /var/www/html/system/core/CodeIgniter.php:339 0.1184 10628288
5. Content_type_model->link_extend_with_group() /var/www/html/application/controllers/admin/content_type.php:73 0.1184 10628720
6. Base_model->insert_ignore() /var/www/html/application/models/content_type_model.php:189 0.1184 10628816
7. Base_model->clean_data() /var/www/html/application/models/base_model.php:2946 0.1184 10629128
8. CI_DB_driver->list_fields() /var/www/html/application/models/base_model.php:3342

Offline

#3 2016-05-10 02:09:49

acapavia
Member
Registered: 2012-05-07
Posts: 7

Re: Can't attach Extend Fields to Content Type's Field Group

Same error trying to install database

[SQL]CREATE TABLE content_type_group_extend ( id_content_type_group int(11) unsigned NOT NULL, id_extend_field int(11) unsigned NOT NULL DEFAULT '0', ordering int(11) DEFAULT NULL, group varchar(50) DEFAULT NULL COMMENT 'Logical name of the group (tab)', PRIMARY KEY (id_content_type_group,id_extend_field) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group varchar(50) DEFAULT NULL COMMENT 'Logical name of the group (tab)', PRIMAR' at line 1

Thank you

Offline

#4 2016-06-14 18:07:08

fredericomarinho.com
Member
From: Juiz de Fora / Brazil
Registered: 2015-06-08
Posts: 40
Website

Re: Can't attach Extend Fields to Content Type's Field Group

@adamos42, what kind of field did you try to attach to the Field Group?


Frederico Marinho - Social Media and Web Developer
contato@fredericomarinho.com
fredericomarinho.com

Offline

#5 2016-06-14 23:28:19

adaliszk
Ionize Friend
From: Germany
Registered: 2010-09-20
Posts: 397
Website

Re: Can't attach Extend Fields to Content Type's Field Group

fredericomarinho.com wrote:

@adamos42, what kind of field did you try to attach to the Field Group?

The original problem was reported by @mslbn in the "how to section" so I moved the informations and deleted the original post, because this is the place. I did not test it this bug yet, but soon I will solve a few of the open ones.


Webdeveloper, Programmer, Application developer, Ionize friend
@adaliszk

Offline

#6 2016-10-10 02:01:02

fredericomarinho.com
Member
From: Juiz de Fora / Brazil
Registered: 2015-06-08
Posts: 40
Website

Re: Can't attach Extend Fields to Content Type's Field Group

That's the sql executed when the error happened:

SHOW COLUMNS FROM `content_type_group_extend`

There is no "content_type_group_extend" tablet in my database. @adamos42, could you find something here?


Frederico Marinho - Social Media and Web Developer
contato@fredericomarinho.com
fredericomarinho.com

Offline

#7 2016-10-10 03:16:30

fredericomarinho.com
Member
From: Juiz de Fora / Brazil
Registered: 2015-06-08
Posts: 40
Website

Re: Can't attach Extend Fields to Content Type's Field Group

Found it!
Just execute this sql:

CREATE TABLE content_type_group_extend (
        id_content_type_group int(11) unsigned NOT NULL,
        id_extend_field int(11) unsigned NOT NULL DEFAULT '0',
        ordering int(11) DEFAULT NULL,
        group varchar(50) DEFAULT NULL COMMENT 'Logical name of the group (tab)',
        PRIMARY KEY (id_content_type_group,id_extend_field)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

** It is not possible to create a field named group, so I created with another name (as "groupx") and after just changed it in phpmyadmin. Worked it!


Frederico Marinho - Social Media and Web Developer
contato@fredericomarinho.com
fredericomarinho.com

Offline

#8 2016-11-15 00:34:20

ccmksy
Member
From: Hong Kong
Registered: 2013-11-30
Posts: 48

Re: Can't attach Extend Fields to Content Type's Field Group

fredericomarinho.com wrote:

Found it!
Just execute this sql:

CREATE TABLE content_type_group_extend (
        id_content_type_group int(11) unsigned NOT NULL,
        id_extend_field int(11) unsigned NOT NULL DEFAULT '0',
        ordering int(11) DEFAULT NULL,
        group varchar(50) DEFAULT NULL COMMENT 'Logical name of the group (tab)',
        PRIMARY KEY (id_content_type_group,id_extend_field)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

** It is not possible to create a field named group, so I created with another name (as "groupx") and after just changed it in phpmyadmin. Worked it!


It also works for me. thanks!

Offline

What's Ionize ?

Ionize is an Open Source Content Management System created by webdesigners for webdesigners.

Created and maintained by Partikule and Toopixel, Ionize wants to be the easiest and most powerful CMS.

Can I help ?

Because talent is nothing without involvement, we are looking for motivated coders and webdesigners to join the project team.

Resources

Website : ionizecms.com
Documentation : doc.ionizecms.com

Development : Ionize on GitHub
Translations : Ionize Translations