Resources

My Agape try

Your Agape try


Support Forum

You must be logged in to post Login Register

Search 
Search Forums:


 




MySQL error when applying changes to Page Roles.

UserPost

9:24 am
January 27, 2010


SilverHawke

Member

posts 3

1

Wordpress Version 2.9.1

Version 1.1.4.dev (also tried the version that you can now download off wordpress plugins)

I'm attempting to restrict editing capabilities to a certain user for a certain page.  I followed the guide and went to Pages, chose the page to edit and then underneath the Editors section, I clicked on Users and then selected the user I want to be able to edit the page and applied the changes.  When I logged in as this user, I got a message saying I don't have permission.

I logged back in as admin and went to Roles, then Pages.  I selected assign for selected and subpages, then selected the user, then I scrolled down and found the page I wanted to modify and checked the box beside Page Editor and the username was beside this.  I then clicked update.  I hope I am doing this correctly…please advise.

This is the error I received:

WordPress database error Incorrect integer value: '' for column 'date_limited' at row 1 for query UPDATE wp_user2role2object_rs SET date_limited = '', start_date_gmt = '0', end_date_gmt = '2035-01-01 00:00:00' WHERE assignment_id IN ('6') made by do_action, call_user_func_array, __lambda_func, scoper_admin_object_roles, ScoperAdminBulk->role_submission, ScoperRoleAssigner->assign_roles, scoper_query, scoper_db_method, call_user_funcWordPress database error Incorrect integer value: '' for column 'content_date_limited' at row 1 for query UPDATE wp_user2role2object_rs SET content_date_limited = '', content_min_date_gmt = '0', content_max_date_gmt = '2035-01-01 00:00:00' WHERE assignment_id IN ('6') made by do_action, call_user_func_array, __lambda_func, scoper_admin_object_roles, ScoperAdminBulk->role_submission, ScoperRoleAssigner->assign_roles, scoper_query, scoper_db_method, call_user_func

10:22 am
January 27, 2010


Kevin

Admin

posts 2503

2

I just updated the Role Scoper development snapshot with a fix for this error. Thanks for reporting.

BTW, it only occurs with MySQL servers that are configured to not convert nullstring values to the appropriate zero value in datetime columns.

4:51 pm
January 27, 2010


SilverHawke

Member

posts 3

3

Thank you for you quick reply.  I will try this fix in the morning and report back.

9:30 am
January 28, 2010


SilverHawke

Member

posts 3

4

I upgraded to the new version this morning and was able to save the settings correctly.  I'm still getting this error message when I log in as the restricted user and try to edit a page.  I must not be applying the settings in the correct way.  Please advise.

Error message:  You do not have sufficient permissions to access this page.

10:22 am
January 28, 2010


Kevin

Admin

posts 2503

5

What restrictions and roles did you apply?


About the Agapetry forum

Currently Online:

13 Guests

Maximum Online: 150

Forums:

Groups: 2

Forums: 7

Topics: 1247

Posts: 5656

Members:

There are 1259 members

There are 1 guests


Kevin has made 2503 posts

Top Posters:

metal450 - 178

Ragnar - 108

YikYak - 70

whiteorb - 49

Daisy - 35

Administrator: Kevin | Moderators: Kevin