#1 2014-05-04 17:20:22

daniel
Member
Registered: 2014-02-28
Posts: 71

ionize 1.0.6 user creation -> only Super-Admin can login

Hi,

i tried a fresh install of ionize 1.0.6 and after creating a new user (editor) in the backend and trying to login, i receive:

Error Number: 1054

Unknown column 'id_user' in 'where clause'

SELECT rule.* FROM (rule) WHERE `id_role` = '3' AND `id_user` = 0

Filename: models/base_model.php

Line Number: 497

There is no row 'id_user' in the table 'rule'

After that, the site does not work anymore - i have to restart the browser.

-> New users are working only, if they are Super-Admins

should i change the query to ask the user_id from 'user' or should i add a row 'user_id' in 'rule'?





Edit: application/models/rule_model.php Line 47 ...

public function get_from_role($role)
	{
		$where = array(
			'id_role' => $role['id_role']/*,
			'id_user' => 0*/
		);

		$rules = $this->get_list($where);

		return $rules;
	}

worked for me ...

Last edited by daniel (2014-05-04 18:22:48)

Offline

#2 2014-05-05 18:15:47

ukyo
Community Manager
From: Marmaris - Turkey
Registered: 2010-05-19
Posts: 734
Website

Re: ionize 1.0.6 user creation -> only Super-Admin can login

Will be fixed for 1.0.6.1, You can run a sql query from phpmyadmin for fix it :

ALTER TABLE rule add id_user int(11) unsigned NOT NULL DEFAULT 0;

<ion:ukyo from="Turkey" />
Ionize CMS Türkçe Dil Çeviri Dosyaları | My Github Repositories
Please send your first message to a forum section, not forum users or administration.

Offline

#3 2014-05-05 21:56:36

daniel
Member
Registered: 2014-02-28
Posts: 71

Re: ionize 1.0.6 user creation -> only Super-Admin can login

Ok thanks,

will the column id_user be used in 1.6.0 or it is somewhat for 1.6.1?

Offline

#4 2014-05-06 00:49:52

ukyo
Community Manager
From: Marmaris - Turkey
Registered: 2010-05-19
Posts: 734
Website

Re: ionize 1.0.6 user creation -> only Super-Admin can login

used in 1.0.6 but forgetted to add it to installer, for upgrade from older version to 1.0.6 is ok. this problem is appear for fresh 1.0.6 installations.


<ion:ukyo from="Turkey" />
Ionize CMS Türkçe Dil Çeviri Dosyaları | My Github Repositories
Please send your first message to a forum section, not forum users or administration.

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