Deprecated: Joomla\Input\Input implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /homepages/13/d380392445/htdocs/Jlive/libraries/vendor/joomla/input/src/Input.php on line 41

Deprecated: Return type of Joomla\Input\Input::count() should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /homepages/13/d380392445/htdocs/Jlive/libraries/vendor/joomla/input/src/Input.php on line 170

Deprecated: Joomla\CMS\Input\Input implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /homepages/13/d380392445/htdocs/Jlive/libraries/src/Input/Input.php on line 31

Deprecated: Joomla\CMS\Input\Cookie implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in /homepages/13/d380392445/htdocs/Jlive/libraries/src/Input/Cookie.php on line 21

Deprecated: str_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /homepages/13/d380392445/htdocs/Jlive/libraries/src/Uri/Uri.php on line 141
Save Failed error when changing role in Admin wind - Macrotone Forum

Unknown Error 8192: KunenaControllerApplicationDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in libraries/kunena/controller/application/display.php on line 21


Unknown Error 8192: Automatic conversion of false to array is deprecated in libraries/kunena/route/route.php on line 437


Unknown Error 8192: ComponentKunenaControllerWidgetAnnouncementDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in components/com_kunena/controller/widget/announcement/display.php on line 18


Unknown Error 8192: ComponentKunenaControllerTopicItemDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in components/com_kunena/controller/topic/item/display.php on line 25


Unknown Error 8192: Automatic conversion of false to array is deprecated in libraries/kunena/forum/category/category.php on line 415


Unknown Error 8192: Automatic conversion of false to array is deprecated in libraries/kunena/bbcode/bbcode.php on line 107

Save Failed error when changing role in Admin wind


Unknown Error 8192: ComponentKunenaControllerTopicItemActionsDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in components/com_kunena/controller/topic/item/actions/display.php on line 23


Unknown Error 8192: ComponentKunenaControllerTopicPollDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in components/com_kunena/controller/topic/poll/display.php on line 21


Unknown Error 8192: ComponentKunenaControllerTopicItemMessageDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in components/com_kunena/controller/topic/item/message/display.php on line 23

9 years 4 months ago - 9 years 4 months ago #1 by DavidL
Logged into Joomla Admin, clicking on IssueTracker People.
Clicked on a user and tried to update their role.
On Save:

Save failed with the following error: Duplicate entry '' for key 'xx_it_people_phone_number_uk' SQL=UPDATE `xx_it_people` SET `user_id`='1234',`person_name`='Dave xxx',`person_email`='xx*xyzsystems.com',`person_role`='4',`username`='xx',`assigned_project`='10',`issues_admin`='0',`staff`='1',`email_notifications`='0',`registered`='1',`published`='0',`checked_out`='1005',`checked_out_time`='2014-12-23 17:16:09',`created_on`='2014-12-20 22:33:02',`created_by`='yy',`modified_on`='2014-12-23 17:16:20',`modified_by`='yy',`phone_number`='',`sms_notify`='0',`ordering`='0' WHERE `id`='63'

There is only one entry for this user.

Not sure if it makes a diff, but I don't have a xx_it_people_phone_number_uk table.
I do have a xx_it_people table
and a phone_number field (no uk)

1.63 updated to 1.64 on latest joomla 3.36

Unknown Error 8192: ComponentKunenaControllerMessageItemActionsDisplay implements the Serializable interface, which is deprecated. Implement __serialize() and __unserialize() instead (or in addition, if support for old PHP versions is necessary) in components/com_kunena/controller/message/item/actions/display.php on line 25

Please Log in or Create an account to join the conversation.

9 years 4 months ago #2 by geoffc
This is the same problem reported in an earlier post.

I think you have slightly misunderstood the earlier answer.

There is no '#__it_people_phone_number_uk' table. This is an INDEX on the phone_number field in the '#__it_people' table.
Myphpadmin provides an easy mechanism to change the index from 'UNIQUE' to 'INDEX'. Alternatively issue the provided SQL command (after changing the prefix to that of your site). Depending upon the version of myphpadmin in use, on the LHS of the myphpadmin screen expand out the tables and select the #_it_people table and there will be an entry for 'indexes' which if expanded out will show the indexes on the '#__it_people' table. Select the '#__it_people_phone_number_uk' entry and a new window will open up where you can change the index type. Save it and the change is complete.

This has been tested and proved to resolve the problem.

Regards
Geoff
The following user(s) said Thank You: DavidL

Please Log in or Create an account to join the conversation.

9 years 4 months ago #3 by DavidL
ah Ok, that did it.
Thanx!!!!

Please Log in or Create an account to join the conversation.

9 years 4 months ago #4 by geoffc
You are welcome.

Regards
Geoff

Please Log in or Create an account to join the conversation.

Time to create page: 0.142 seconds
Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries