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
Warning to all if using Backup to restore DB - 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

Warning to all if using Backup to restore DB


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

12 years 3 weeks ago - 12 years 3 weeks ago #1 by geoffc

Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2115


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2115


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2022


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2070


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2115


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2115


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2022


Unknown Error 8192: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in libraries/kunena/external/nbbc/src/BBCode.php on line 2070

This is a warning about a situation I have discovered on my restored database with the Issue Tracker application. It is specific to Akkeba Backup only because that is the backup mechanism in use on our site. It is likely that similar issues may arise with other backup mechanisms.

Issue Tracker makes use of database procedures and triggers to be as efficient as possible. i.e. Keep the changes as close to the database as possible. The triggers are double checks for audit control and the sample data load and restore uses database procedures.

It seems that when the database backup is performed using Akeeba Backup that the database procedures and triggers are NOT backed up by default.

It is necessary to change the configuaration options first.

Go to the Akkeba Backup Configuration page, click on the Configure button next to the "Database Backup Engine" and set:
"Dump PROCEDUREs, FUNCTIONs and TRIGGERs" Check the box.
"No dependency tracking" Do not check the box.

Be aware that some hosting providers do not allow the database user who is used by Joomla to use the 'SHOW TRIGGERS', 'SHOW PROCEDURE STATUS' or 'SHOW FUNCTION STATUS' commands, so in this situation you would still not see these objects in the restored database, since they never make it to the backup file.

Assuming that you can 'see' the database objects then the backup will contain the procedures and triggers etc ready for a restore.

If you are in a situation where you have an 'old' backup you wish to restore, or the backup account did not have the database privileges to see the database 'triggers, procedures and functions': a reinstallation of Issue Tracker will automatically recreate the triggers and procedures.

If you do not currently have a backup component, we highly recommend Akeeba Backup (and a sister product Akeeba Admin Tools). Support is second to none and it is very reliable.

Geoff

Edited by geoffc - 25.04.2012 18:41

Regards
Geoff

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.

Time to create page: 0.131 seconds
Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries