phpdevshell team mailing list archive

[Greg <1268890@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Testing 3.5 RC.  After I create a new user, I receive an error when
attempting to access the user information.

The exception class is "PHPDS_databaseException" and the error code is 0. The content of the exception is as follow:
Error invoking a query of class "PAGINATION_readPaginationQuery"

SELECT SQL_CALC_FOUND_ROWS
			t1.user_id, t1.user_display_name, t1.user_name, t1.user_password, t1.user_email, t1.user_group, t1.user_role, t1.date_registered, t1.language,
			t2.user_group_name,
			t3.user_role_name
		FROM
			_db_core_users t1
		LEFT JOIN
			_db_core_user_groups t2
		ON
			t1.user_group = t2.user_group_id
		LEFT JOIN
			_db_core_user_roles t3
		ON
			t1.user_role = t3.user_role_id
		 WHERE user_id != \'x\' 
	

 LIMIT 0, 30

It appears that the user_id and proper db prefix is not being supplied
to the sql query.  This error also appears on pending users menu item.

** Affects: phpdevshell
     Importance: Medium
     Assignee: Greg (gregfr)
         Status: Fix Committed

** Changed in: phpdevshell
   Importance: Undecided => Medium

** Changed in: phpdevshell
     Assignee: (unassigned) => Greg (gregfr)

** Changed in: phpdevshell
       Status: New => Confirmed

** Changed in: phpdevshell
    Milestone: None => 3.5

-- 
You received this bug notification because you are a member of
PHPDevShell, which is subscribed to PHPDevShell.
https://bugs.launchpad.net/bugs/1268890

Title:
  Some user admin queries should have autoProtect disabled

Status in Open Source PHP RAD Framework with UI.:
  Fix Committed

Bug description:
  Testing 3.5 RC.  After I create a new user, I receive an error when
  attempting to access the user information.

  The exception class is "PHPDS_databaseException" and the error code is 0. The content of the exception is as follow:
  Error invoking a query of class "PAGINATION_readPaginationQuery"

  SELECT SQL_CALC_FOUND_ROWS
  			t1.user_id, t1.user_display_name, t1.user_name, t1.user_password, t1.user_email, t1.user_group, t1.user_role, t1.date_registered, t1.language,
  			t2.user_group_name,
  			t3.user_role_name
  		FROM
  			_db_core_users t1
  		LEFT JOIN
  			_db_core_user_groups t2
  		ON
  			t1.user_group = t2.user_group_id
  		LEFT JOIN
  			_db_core_user_roles t3
  		ON
  			t1.user_role = t3.user_role_id
  		 WHERE user_id != \'x\' 
  	

   LIMIT 0, 30

  It appears that the user_id and proper db prefix is not being supplied
  to the sql query.  This error also appears on pending users menu item.

To manage notifications about this bug go to:
https://bugs.launchpad.net/phpdevshell/+bug/1268890/+subscriptions