page not found

[GoogleCodeExporter]

after entering an auth item I am redirected to:

/yii-rights/index.php?r=rights/authItem/update&name=test123

which gives the Yii 404 error.

Original issue reported on code.google.com by xgar...@gmail.com on 20 Jul 2010 at 6:57

[GoogleCodeExporter]

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

• Changed state: Started
• Added labels: Priority-Low
• Removed labels: Priority-Medium

[GoogleCodeExporter]

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

• Added labels: Type-Other
• Removed labels: Type-Defect

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

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

[GoogleCodeExporter]

Original comment by cni...@live.com on 2 Aug 2010 at 8:44

• Changed state: Done