help im totally lost user functionality

[GoogleCodeExporter]

During the pre-release, please update your files with the latest svn before 
reporting a defect
-----

What steps will reproduce the problem?
1. Install cms
2. Open cms
3.

What is the expected output? What do you see instead?
I expect to see all the options in the menu bar I only see dashboard and 
navigation

What version of the product are you using? On what operating system?
CI-CMS 0.9.0.0 on WAMP XP

Please provide any additional information below.
Hi, I need to know how I can make a user with full permissions for all 
modules like an admin user. When I installed I didnt how to do this, so I 
did it manually in the database and I created a user with module = admin 
and level 4 ,but when I login I only see 2 options in the menu bar I dont 
see the pages option, any help appreciated, thanks in advance

Original issue reported on code.google.com by aelienpr...@gmail.com on 14 Sep 2009 at 5:47

[GoogleCodeExporter]

HI, try to follow "Edit" on user in http://{youre site}/admin/admins
select different module && save him :)

Original comment by michail1...@gmail.com on 14 Sep 2009 at 12:14

[GoogleCodeExporter]

Hi, thanks for the response.. but when I go to that url I get 

Unauthorized
Module: Admin
Sorry, you cannot edit in the admin module
Go back

I think it would be better if I create the admin user manually in the database, 
the 
problem is that I don't know what data should go in what table. I know I need 
to give 
that user the permissions needed, but where?

Thanks

Original comment by aelienpr...@gmail.com on 15 Sep 2009 at 3:52

[GoogleCodeExporter]

You can only add admins using the first username used which is the first super 
admin.

Original comment by heriniai...@gmail.com on 15 Sep 2009 at 4:41

[GoogleCodeExporter]

hello and thanks for the response, how can I know the credentials for that 
super admin? 
Is it stored at some config file? During installation I don't remember being 
ask for a 
username/psw for super admin user. I just thought of entering admin/admin as 
credentials but I only get the "Validating...." message and it just stays 
there..

Original comment by aelienpr...@gmail.com on 15 Sep 2009 at 5:28

[GoogleCodeExporter]

Ooops..

The super admin is the first username you logged in. If you use that, you can 
add 
others as admin of admins.

Original comment by heriniai...@gmail.com on 15 Sep 2009 at 6:45

[GoogleCodeExporter]

Yes but how can I know what username and password information for that super 
admin is? 
Where is it saved? is it at some config file or in a table in the database, 
thanks

Original comment by aelienpr...@gmail.com on 16 Sep 2009 at 3:09

[GoogleCodeExporter]

It is just the first username you used. 

When you install ci-cms, there is no admin at all. The first username you use 
is the
first admin. With that username you can add other members and other admins. 
It's not
in any config file. It is just registered as any user in the user table because 
you
were the one who created it.

Original comment by heriniai...@gmail.com on 16 Sep 2009 at 3:48

[GoogleCodeExporter]

Ok, thanks.. I'll delete my folder and database, checkout a new copy of the app 
and 
I'll be posting screenshots of the errors I get when installing and hope we can 
troubleshoot the user problem. Thanks

Original comment by aelienpr...@gmail.com on 16 Sep 2009 at 4:02

[GoogleCodeExporter]

=== step 1 error =========
ERROR: folder ./media/images not created. Please create it manually.
Folder ./media/images/o created
Folder ./media/images/m created
Folder ./media/images/s created
Folder ./media/files created
Folder ./media/captcha created

=== step 2 error =========
A Database Error Occurred
Error Number: 1366

Incorrect string value: '\xE7ais' for column 'name' at row 1

INSERT INTO `languages` (`code`, `name`) VALUES ('fr', 'Français')

changed: $data = array('code' => 'fr', 'name' => 'Français');
to: $data = array('code' => 'fr', 'name' => 'Francais');

=== step 4 error =========

A Database Error Occurred
Error Number: 1101

BLOB/TEXT column 'value' can't have a default value

CREATE TABLE IF NOT EXISTS `settings` ( `id` INT(11) UNSIGNED AUTO_INCREMENT, 
`name` VARCHAR(255) 
DEFAULT '0', `value` TEXT DEFAULT '', PRIMARY KEY `id` (`id`), KEY `name` 
(`name`) ) 
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

Solution: removed 'default' => ''

A Database Error Occurred
Error Number: 1364

Field 'g_info' doesn't have a default value

INSERT INTO groups (g_id, g_name, g_desc) VALUES ('0', 'Everybody', 'This is 
everybody who visits the 
site including non members')

Solution: set the 'g_info' and 'g_desc' as NULLABLE

=== step 5 error ========
A Database Error Occurred
Error Number: 1364

Field 'comments' doesn't have a default value

INSERT INTO `news` (`title`, `uri`, `lang`, `body`, `status`, `date`) 
VALUES ('Your first news', 'your-first-news-en', 'en', 'This news is supposed 
to be in English but I 
leave it in English now', 1, 1253078695)

Solution: make field `comments` as NULLABLE as well as other fields

================
screenshot 1.- The user I created at installation only have 2 menu items, 
nowhere to create a new 
page.
screenshot 2.- If I click "Navigation" I get "unauthorized".
screenshot 3.- I created another user and select module = "page" to see if I 
could create pages with 
that new user, but there is no place to add a password to that user, so when I 
try to login with it I 
can't.

Original comment by aelienpr...@gmail.com on 16 Sep 2009 at 5:55

Attachments:

• cicms1.JPG
• cicms2.JPG
• cicms3.JPG

[GoogleCodeExporter]

Hello,

Thanks for the fix you proposed. I'll insert them.

About the user. You have to to go Administrators (your Screenshot cicms3.JPG) 
then
you just write down your username (without password) or other people's username 
you
want to make administrator of module.

i.e. When your admin username is "Admin" then you just write 
username: Admin
module: Page
level: Can add etc...

After that you'll be able to add new pages as "Admin"

Original comment by heriniai...@gmail.com on 16 Sep 2009 at 6:13

[GoogleCodeExporter]

oh great! now I see the "Page" option in the menu and can add/edit them.

Thanks for all the help.

Original comment by aelienpr...@gmail.com on 16 Sep 2009 at 6:22

[GoogleCodeExporter]

Original comment by heriniai...@gmail.com on 24 Dec 2009 at 7:55

• Changed state: Verified