In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Viewing Issue Simple Details Jump to Notes ] Wiki ] View Advanced ] Issue History ] Print ]
ID Category Type Reproducibility Date Submitted Last Update
0000956 [In-Portal CMS] Database task sometimes 2011-01-03 02:56 2011-09-30 11:54
Reporter alex View Status public Project Name In-Portal CMS
Assigned To !COMMUNITY Developer
Priority normal Resolution open Fixed in Version
Status needs work Product Version 5.1.0 Target Version Icebox
Time EstimateNo estimate
Summary 0000956: Insufficient database permission handling
Description Recently there was a case, when only some of In-Portal table were actually present/accessible to In-Portal (sort of daemon mode), when there was a need to handle simple request and nothing more.

I've noticed, that in such case In-Portal doesn't properly handle this resulting more warning/notices to be raised.

Here is the patch, that prevents such behavior.
Additional Information These are only permissions, that should be given to MySQL user for testing:

GRANT SELECT ON `inportal_database`.`inp_Phrase` TO 'inportal_user'@'localhost';
GRANT SELECT ON `inportal_database`.`inp_ConfigurationValues` TO 'inportal_user'@'localhost';
GRANT SELECT ON `inportal_database`.`inp_Language` TO 'inportal_user'@'localhost';
GRANT SELECT ON `inportal_database`.`inp_Modules` TO 'inportal_user'@'localhost';
GRANT SELECT ON `inportal_database`.`inp_Theme` TO 'inportal_user'@'localhost';
GRANT SELECT ON `inportal_database`.`inp_Skins` TO 'inportal_user'@'localhost';

Also please disable debug mode or just turn DBG_SQL_FAILURE off.
Tags No tags attached.
Change Log Message Fixed some errors, when not tables in database are available
Estimate Points 0
Attached Files patch file icon handling_insufficient_database_permissions.patch [^] (8,292 bytes) 2011-01-03 02:56 [Show Content]
patch file icon handling_insufficient_database_permissions_v2.patch [^] (10,422 bytes) 2011-01-03 08:58 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to 0000953closed (5.1.2)alex Incorrect database query error reporting 

-  Notes
User avatar (0003902)
Dmitry (manager)
2011-09-24 22:20

New patch for 5.2.x needed (PHP 5 format)
User avatar (0003919)
alex (manager)
2011-09-27 04:32

I won't be hurrying with applying this patch.

- Issue History
Date Modified Username Field Change
2011-09-30 11:54 alex Target Version 5.2.0 => Icebox
2011-09-27 04:32 alex Note Added: 0003919
2011-09-24 22:20 Dmitry Note Added: 0003902
2011-09-24 22:20 Dmitry Status needs testing => needs work
2011-09-24 22:20 Dmitry Target Version Icebox => 5.2.0
2011-01-10 12:46 alex Relationship added related to 0000953
2011-01-10 12:44 alex Additional Information Updated View Revisions
2011-01-03 08:58 alex File Added: handling_insufficient_database_permissions_v2.patch
2011-01-03 08:12 alex Assigned To => !COMMUNITY
2011-01-03 08:12 alex Developer => alex
2011-01-03 08:12 alex Status active => needs testing
2011-01-03 08:12 alex Reference =>!topic/in-portal-dev/A4uPHS34o_8
2011-01-03 08:12 alex Change Log Message => Fixed some errors, when not tables in database are available
2011-01-03 02:56 alex New Issue
2011-01-03 02:56 alex File Added: handling_insufficient_database_permissions.patch

Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker