Admin Panel All options gone -- Plz help

[Unknown]

Hello,

I selected the option from admin panel "user can't post new entry" but after that all options are gone. I can just see Frontpage, Back to Weblog and Logout options. Please help me!

Thanks

[Guest]

You must now use a tool like phpMyAdmin and edit the serendipity_authors table. Edit the row of your user account and set the "right_publish" column to "1".

Best regards,
Garvin

[Guest]

it's already 1!?!?

[garvinhicking]

Are you sure about that, did you look at the right column?

In which panel exactly did you change the "user can't post new entry" option? In the personal preferences of your user, or in the Manager users section, or in the Manage groups section?

Regards,
Garvin

[Guest]

Yup! I am 100% sure.

From personal preferences!

[garvinhicking]

Can you paste a SQL dump of your serendipity_authors and serendipity_authorgroups table here?

When you login, look at the top right corner - does it say there in which groups you are? Maybe when you entered the personal preferences you unchecked the multi-select dropdown of all authorsgroups and now you're not in any group anymore.

Regards,
Garvin

[Guest]

Can you paste a SQL dump of your serendipity_authors and serendipity_authorgroups table here?

When you login, look at the top right corner -does it say there in which groups you are? Maybe when you entered the personal preferences you unchecked the multi-select dropdown of all authorsgroups and now you're not in any group anymore.

Regards,
Garvin

Code: Select all

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Dec 15, 2005 at 04:56 AM
-- Server version: 4.0.25
-- PHP Version: 4.3.11
-- 
-- Database: `qwebnet2_tutdb`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `serendipity_authors`
-- 

CREATE TABLE `serendipity_authors` (
  `realname` varchar(255) NOT NULL default '',
  `username` varchar(20) default NULL,
  `password` varchar(32) default NULL,
  `authorid` int(11) NOT NULL auto_increment,
  `mail_comments` int(1) default '1',
  `mail_trackbacks` int(1) default '1',
  `email` varchar(128) NOT NULL default '',
  `userlevel` int(4) unsigned NOT NULL default '0',
  `right_publish` int(1) default '1',
  PRIMARY KEY  (`authorid`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `serendipity_authors`
-- 

INSERT INTO `serendipity_authors` VALUES ('', 'n00b', '6325ae85d932504df0319223a2d5e7e7', 1, 1, 1, 'zeshanm@gmail.com', 255, 1);
INSERT INTO `serendipity_authors` VALUES ('', NULL, NULL, 2, 1, 1, '', 0, 1);

Code: Select all

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Dec 15, 2005 at 04:59 AM
-- Server version: 4.0.25
-- PHP Version: 4.3.11
-- 
-- Database: `qwebnet2_tutdb`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `serendipity_authorgroups`
-- 

CREATE TABLE `serendipity_authorgroups` (
  `groupid` int(10) unsigned NOT NULL default '0',
  `authorid` int(10) unsigned NOT NULL default '0',
  KEY `authorgroup_idxA` (`groupid`),
  KEY `authorgroup_idxB` (`authorid`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `serendipity_authorgroups`
-- 

INSERT INTO `serendipity_authorgroups` VALUES (3, 1);

I am in an admin group. After my nick (Adminstrator) is there.[/code]

[Guest]

anyone?

[Guest]

ok i selected the option forbid creating entries something like that from personal setting.

any solution?

[garvinhicking]

Well, according to the DB everything should be in order...I don't really know what the problem is, if this is the right database you dumped...

I can only help you if you give me FTP access and a login to your blog, then I could have a look at what's happening...

I'm gone for the weekend, so I can only help you after that...

Best regards,
Garvin

[ernst]

I've installed PostgreSQL on my localhost and have been 'playing' with themes for several days (learning). Everything went fine until today when I also selected 'user can't post new entry'. My intent was to keep posting to myself - just disable other users. I presume that was wrong now. But, when I saved that option, all I got was and Admin page with three options:
Frontpage
Back to Weblog
Logout

I also abbreviated my user name: It said this is what would appear on my posts. This did funtion: I could see my posts with the new user name.

I've used pgadmin3 to verify the 'right_publish' column did have a value of '1' the authors table - which it did have.

Is there a resolution? Else, I'll re-install s9y, modify style.css and a plugin as I'm still just testing..

If this isn't a bug, shouldn't the administration always be 'forced' to be able to 'post'?

Thanks for any replies.

Ernst

[garvinhicking]

What you need to do is to browse the 'serendipity_config' table and check the value "no_create". For your userid, it must be set to "0". You can reset this to grant yourself access again.

Best regards,
Garvin

[ernst]

Thanks for your reply Garvin.

The serendipity_config table, with their listed columns (3) and values, are :

Col-Name Value
------------- --------
name -blank-
value -blank-
authorid 0

I'm guessing the blank values should have id's in them. Just want to check on that before I re-install the DB.

BTW: My installed user-id is giden which is the owner of the DB. I changed my display name, Robert Giden, to Ernst (middle name). Is 'giden' the values I should put in the 'name' and 'value' fields?

Regards,

Ernst

[garvinhicking]

You must actually browse through the available rows of the table, because the "columns" are reverse-mapped to "rows" in our case, for easier abstraction and not needing to add new columns.

So 3 columns should be okay, but you should have many rows. Look for them with sQL like:

Code: Select all

SELECT * from serendipity_config where name = 'no_create'

Regards,
Garvin

[ernst]

Garvin,

It now works. Thanks.

FYI: I'm running s9y on PostgreSQL. My Ubuntu distribution, for some reason, did not allow phpPgAdmin (using Synaptic) to run, even after it was 'successfully' installed.. However, it did install pgadmin3 okay.

The value of 'no_create' in serendipity_config was listed as 'true' (not '1'). I found this strange as the field was defined as text, not boolean. I changed the value to 'false' and it worked.

Regards from Colton, Washington state. USA (pop. 350)

Ernst