Closed GoogleCodeExporter closed 9 years ago
Could you provide me with all the necessary steps to reproduce this problem and
I will look into it.
Original comment by cni...@live.com
on 20 Jul 2010 at 9:45
Tested this briefly and seemed to work fine on my test installation.
Resolved to index.php?r=rights/authItem/update&name=test123 which worked fine.
Which operating system are you running on?
Original comment by cni...@live.com
on 20 Jul 2010 at 9:52
XP.. using XAMPP.
Here's the application log message:
exception 'CHttpException' with message 'The requested page does not
exist.' in
C:\xampp\htdocs\yii-rights\protected\modules\rights\controllers\AuthItemControll
er.php:254
Stack trace:
#0
C:\xampp\htdocs\yii-rights\protected\modules\rights\controllers\AuthItemControll
er.php(100):
AuthItemController->loadModel()
#1 C:\xampp\htdocs\yii-rights\framework\web\actions\CInlineAction.php(32):
AuthItemController->actionUpdate()
#2 C:\xampp\htdocs\yii-rights\framework\web\CController.php(300):
CInlineAction->run()
#3 C:\xampp\htdocs\yii-rights\framework\web\filters\CFilterChain.php(129):
CController->runAction(Object(CInlineAction))
#4 C:\xampp\htdocs\yii-rights\framework\web\filters\CFilter.php(41):
CFilterChain->run()
#5 C:\xampp\htdocs\yii-rights\framework\web\CController.php(999):
CFilter->filter(Object(CFilterChain))
#6 C:\xampp\htdocs\yii-rights\framework\web\filters\CInlineFilter.php(59):
CController->filterAccessControl(Object(CFilterChain))
#7 C:\xampp\htdocs\yii-rights\framework\web\filters\CFilterChain.php(126):
CInlineFilter->filter(Object(CFilterChain))
#8 C:\xampp\htdocs\yii-rights\framework\web\CController.php(283):
CFilterChain->run()
#9 C:\xampp\htdocs\yii-rights\framework\web\CController.php(257):
CController->runActionWithFilters(Object(CInlineAction), Array)
#10 C:\xampp\htdocs\yii-rights\framework\web\CWebApplication.php(320):
CController->run('update')
#11 C:\xampp\htdocs\yii-rights\framework\web\CWebApplication.php(120):
CWebApplication->runController('rights/authItem...')
#12 C:\xampp\htdocs\yii-rights\framework\base\CApplication.php(135):
CWebApplication->processRequest()
#13 C:\xampp\htdocs\yii-rights\index.php(12): CApplication->run()
#14 {main}
REQUEST_URI=/yii-rights/index.php?r=rights/authItem/update&name=test123
does the &test123 part of the URL need to have an entry in the database to
work? Or is this page to write the form data into the database?
Original comment by xgar...@gmail.com
on 21 Jul 2010 at 9:32
Yes, it means that it cannot find the respect model (with the name test123)
which it needs in order display it.
This would happen if your database connection is not working properly or there
was something wrong with your db tables.
Did you run the database schema from the data folder on your installation's
database as mentioned in the quick install instructions?
Original comment by cni...@live.com
on 21 Jul 2010 at 1:22
yep, ran schema. DB looks like this export:
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 21, 2010 at 07:18 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `rights`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_authassignment`
--
CREATE TABLE IF NOT EXISTS `tbl_authassignment` (
`itemname` varchar(64) NOT NULL,
`userid` varchar(64) NOT NULL,
`bizrule` text,
`data` text,
PRIMARY KEY (`itemname`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbl_authassignment`
--
INSERT INTO `tbl_authassignment` (`itemname`, `userid`, `bizrule`, `data`)
VALUES
('admin', '1', NULL, 'N;');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_authitem`
--
CREATE TABLE IF NOT EXISTS `tbl_authitem` (
`name` varchar(64) NOT NULL,
`type` int(11) NOT NULL,
`description` text,
`bizrule` text,
`data` text,
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbl_authitem`
--
INSERT INTO `tbl_authitem` (`name`, `type`, `description`, `bizrule`, `data`)
VALUES
('admin', 2, NULL, NULL, 'N;'),
('guest', 2, NULL, NULL, 'N;');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_authitemchild`
--
CREATE TABLE IF NOT EXISTS `tbl_authitemchild` (
`parent` varchar(64) NOT NULL,
`child` varchar(64) NOT NULL,
PRIMARY KEY (`parent`,`child`),
KEY `child` (`child`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `tbl_authitemchild`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_users`
--
CREATE TABLE IF NOT EXISTS `tbl_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(20) NOT NULL,
`password` varchar(128) NOT NULL,
`email` varchar(128) NOT NULL,
`activkey` varchar(128) NOT NULL DEFAULT '',
`createtime` int(10) NOT NULL DEFAULT '0',
`lastvisit` int(10) NOT NULL DEFAULT '0',
`superuser` int(1) NOT NULL DEFAULT '0',
`status` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`),
KEY `status` (`status`),
KEY `superuser` (`superuser`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `tbl_users`
--
INSERT INTO `tbl_users` (`id`, `username`, `password`, `email`, `activkey`,
`createtime`, `lastvisit`, `superuser`, `status`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'webmaster@example.com',
'9a24eff8c15a6a141ece27eb6947da0f', 1261146094, 1279703649, 1, 1),
(2, 'demo', 'fe01ce2a7fbac8fafaed7c982a04e229', 'demo@example.com',
'099f825543f7850cc038b90aaff39fac', 1261146094, 1261146094, 0, 1),
(3, 'dude', '5f4dcc3b5aa765d61d8327deb882cf99', 'dude@example.com',
'6c98079ecc34c094c4cac0aed5f845ee', 1279727457, 1279727457, 0, 1);
--
-- Constraints for dumped tables
--
--
-- Constraints for table `tbl_authassignment`
--
ALTER TABLE `tbl_authassignment`
ADD CONSTRAINT `tbl_authassignment_ibfk_1` FOREIGN KEY (`itemname`) REFERENCES `tbl_authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `tbl_authitemchild`
--
ALTER TABLE `tbl_authitemchild`
ADD CONSTRAINT `tbl_authitemchild_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `tbl_authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `tbl_authitemchild_ibfk_2` FOREIGN KEY (`child`) REFERENCES `tbl_authitem` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
---------------
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
I can use my users on the assignments screen, but nothing on the others. Is
there something I could enter into the DB to see if it shows up on one of the
screens?
I'm using yii-user on this test, maybe that is causing a problem?
Original comment by xgar...@gmail.com
on 21 Jul 2010 at 6:24
I don't see your test123 in the database, so an error probably occurred when
creating the entry. Weird, I haven't seen a problem like this before...
I have no idea if yii-user affects the module. You could of course try to
install it on a similar installation that doesn't use yii-user to see if it
makes any difference.
Original comment by cni...@live.com
on 21 Jul 2010 at 8:48
Getting the same problem with a fresh install.
I tried hardcoding values into
$sql="INSERT INTO {$this->itemTable} (name,type,description,bizrule,data)
VALUES (:name,:type,:description,:bizrule,:data)"; (line 427 of
CDbAuthManager.php)
to see if the function was being called - nothing was inserted. Must be
something odd on my system. Will wait to see if anyone else reports this.
Original comment by xgar...@gmail.com
on 23 Jul 2010 at 3:20
I just noticed that you're running PHP 5.3.1. Try downgrading to 5.3.0 and see
if that helps. Let me know how it turns out.
Original comment by cni...@live.com
on 26 Jul 2010 at 9:38
Any news on this issue? May I close it or is it a potential issue with the
module?
Original comment by cni...@live.com
on 1 Aug 2010 at 2:30
Installed the latest version and this problem has gone. Noticed that this:
'authManager'=>array(
'class'=>'CDbAuthManager',
'connectionID'=>'db',
),
was missing from previous config files so I must have missed that in the docs.
Original comment by xgar...@gmail.com
on 1 Aug 2010 at 9:11
Original comment by cni...@live.com
on 2 Aug 2010 at 8:44
Original issue reported on code.google.com by
xgar...@gmail.com
on 20 Jul 2010 at 6:57