In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
956 [In-Portal CMS] Database task sometimes 2011-01-03 02:56 2011-09-30 11:54
alex  
!COMMUNITY  
normal  
needs work 5.1.0  
open  
 
none  
https://groups.google.com/forum/#!topic/in-portal-dev/A4uPHS34o_8
Fixed some errors, when not tables in database are available
0
0000956: Insufficient database permission handling
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.
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.
related to 0000953closed  (5.1.2)alex Incorrect database query error reporting 
patch handling_insufficient_database_permissions.patch (8,292) 2011-01-03 02:56
http://tracker.in-portal.org/file_download.php?file_id=888&type=bug
patch handling_insufficient_database_permissions_v2.patch (10,422) 2011-01-03 08:58
http://tracker.in-portal.org/file_download.php?file_id=890&type=bug
Issue History
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 bug_revision_view_page.php?rev_id=652#r652
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 => https://groups.google.com/forum/#!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

Notes
(0003902)
Dmitry   
2011-09-24 22:20   
New patch for 5.2.x needed (PHP 5 format)
(0003919)
alex   
2011-09-27 04:32   
I won't be hurrying with applying this patch.