Admin unable to add news items from frontend

skb · 11.08.2005, 07:18

I've just created a new mambo site using 4.5.2 (fantastico install through SiteGround).

I am unable to add news items from the front end "Submit News", even as Admin. I get the message " You are not authorized to view this resource. You need to login" and it logs me out.

Edit: I'm unable to edit existing items from the front end either...

I have create several users with different access levels but all get same msg.

Through the backend, it's fine.

I've amended the config to CHMOD files & directories to 755 (should the files be 777?). Not sure if this is the right thing to do, but I'm getting desperate

Suggestions?

Sue

denisp · 11.08.2005, 09:13

try to take a look in the DB. the table is this one: #_users.
here you'll the fileds about the administrator. Make sure the value "block" is on zero...

skb · 11.08.2005, 10:03

Thanks denisp,

went into the (very scary) phpMyAdmin and had a look. The value for "block" is set to 0.

Checked all three users (with different levels) and all are value 0 too.

denisp · 11.08.2005, 13:01

well, i paste my table users. it works fine. it has only the admin value and the anonymous one.
you should export your table and compare it with mine...

Code:

CREATE TABLE `urb_users` (
  `id` mediumint(8) NOT NULL default '0',
  `user_active` tinyint(1) default '1',
  `username` varchar(25) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `usertype` varchar(25) NOT NULL default '',
  `block` tinyint(4) NOT NULL default '0',
  `sendEmail` tinyint(4) default '1',
  `gid` tinyint(3) unsigned NOT NULL default '1',
  `registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `user_session_time` int(11) NOT NULL default '0',
  `user_session_page` smallint(5) NOT NULL default '0',
  `user_lastvisit` int(11) NOT NULL default '0',
  `user_regdate` int(11) NOT NULL default '0',
  `user_level` tinyint(4) default '0',
  `user_posts` mediumint(8) unsigned NOT NULL default '0',
  `user_timezone` decimal(5,2) NOT NULL default '0.00',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) default NULL,
  `user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_last_privmsg` int(11) NOT NULL default '0',
  `user_emailtime` int(11) default NULL,
  `user_viewemail` tinyint(1) default NULL,
  `user_attachsig` tinyint(1) default NULL,
  `user_allowhtml` tinyint(1) default '1',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmile` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) NOT NULL default '1',
  `user_allow_pm` tinyint(1) NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) NOT NULL default '1',
  `user_notify` tinyint(1) NOT NULL default '1',
  `user_notify_pm` tinyint(1) NOT NULL default '0',
  `user_popup_pm` tinyint(1) NOT NULL default '0',
  `user_rank` int(11) default '0',
  `user_avatar` varchar(100) default NULL,
  `user_avatar_type` tinyint(4) NOT NULL default '0',
  `email` varchar(255) default NULL,
  `user_icq` varchar(15) default NULL,
  `user_website` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_from_flag` varchar(25) default NULL,
  `user_sig` text,
  `user_sig_bbcode_uid` varchar(10) default NULL,
  `user_aim` varchar(255) default NULL,
  `user_yim` varchar(255) default NULL,
  `user_msnm` varchar(255) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_interests` varchar(255) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  PRIMARY KEY  (`id`),
  KEY `user_session_time` (`user_session_time`),
  KEY `usertype` (`usertype`)
) TYPE=MyISAM;

#
# Dump dei dati per la tabella `urb_users`
#

INSERT INTO `urb_users` VALUES (-1, 0, 'Anonymous', '', '', '', 0, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 0, '0.00', NULL, '', '', 0, 0, 0, NULL, 0, 0, 0, 1, 1, 1, 0, 1, 0, 1, 0, NULL, '', 0, '', '', '', '', NULL, '', NULL, '', '', '', '', '', '', '');
INSERT INTO `urb_users` VALUES (62, 1, 'admin', '**password cripted**', 'Administrator', 'Superadministrator', 0, 1, 25, '2005-08-03 12:39:38', '2005-08-10 11:15:37', 1123159094, -10, 1123158715, 1123065578, 0, 0, '0.00', 1, 'english', 'd M Y H:i', 0, 0, 1123158715, NULL, 0, 1, 0, 1, 1, 1, 1, 1, 0, 1, 1, 0, NULL, 0, '**admin email**', '', '', '', 'blank.gif', '', '', '', '', '', '', '', '', NULL);

skb · 12.08.2005, 03:14

Ran site in debug mode and discovered MambelFish was giving lots of errors.

Uninstalled MF and all runs fine now. Of course, now I have a new problem.....