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
Setup Error - 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


Deprecated: DateTime::__construct(): Passing null to parameter #1 ($datetime) of type string is deprecated in /homepages/13/d380392445/htdocs/Jlive/libraries/src/Date/Date.php on line 112

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

Setup Error


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

8 years 1 month ago #1 by Twincarb
Setup Error was created by Twincarb
I have just installed Issue Tracker and all appeared to go correctly, however when I went to the components control panel I am greeted with the error below:

1548 Cannot load from mysql.proc. The table is probably corrupted SQL = SELECT 1 from INFORMATION _ SCHEMA.ROUTINES WHERE ROUTINE _ SCHEMA = 'joomla' AND ROUTINE_NAME = 'jos_add_it_sample_data'

A quick check in the database and the _add_it_sample_data table isn't created on the install, I couldn't see it showing on the xml manifest for installation either. All of the other menu items work as expected mind.

database name and prefix have been sanitised for this post.

Any help would be appreciated.

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.


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 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 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 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

8 years 1 month ago - 8 years 1 month ago #2 by chrisc
Replied by chrisc on topic Setup Error

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

This problem has been seen and reported several times, and sometimes manifests itself in another guise. It is not a problem with the component but with the underlying MySQL database.

It may appear as:
  • Attempting to view or run a stored procedure
  • Attempting to insert into a table after adding a trigger for ON INSERT actions
Your case is the first situation.

In most (all?) cases the problem is caused when an underlying MySQL database is upgraded and for one reason or another the database upgrade has not completed.
The usual cause it that the database upgrade has modified the mysql.proc table (or file) with additional (or a different) number of columns and the problem only shows when an attempt is made to access the underlying database table. Most Joomla component do not use database procedures, something that avoids using the database to its advantage, but that is another topic.

Several solutions have been suggested, including copying the mysql.proc table from a working system, and also running the "mysql_upgrade --force" command on the database server.

This best solution when the problem is seen after a MySQL upgrade, caused as a result of schema changes, is to run the following command.
mysql_upgrade -u root -p

If the username for your administrative account is not root, please change it in the example above.

This may not of course be possible if the database server in not under your direct control and is run upon a hosting supplier. In this situation the hosting supplier should be informed of the problem so they can 'fix' it.

This is not an issue tracker problem per se, since it is caused by a problem in the underlying database. The 'procedure' that is trying to be run installs (and uninstalls) the sample data into the issue tracker tables. The procedure is not used in normal operation of the component so the component should still function but the sample data will be unavailable.

It does however indicate that all is not well with the MySQL database your Joomla instance is running upon.

Regards

If you are using our extensions please leave a review at the JED: IP Mapping | Issue Tracker | JAudit | Password Control

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

8 years 1 month ago - 8 years 1 month ago #3 by chrisc
Replied by chrisc on topic Setup Error

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

Further to the earlier answer, you would not expect to see the procedure in the xml manifest file. The database procedure is added in the installation script and is not present as a separate file, which explains why the xml manifest file does not contain it (or need it).

This is not a (the) problem and is provided solely as an explanation.

There was a similar problem a little while ago with a different component with the same type of symptoms. The ISP originally denied it was their problem at first before amazingly 'fixing' it. If you have the same issue get the ISP to create a database procedure and try and run it. I think they will also see the same error.

Regards

If you are using our extensions please leave a review at the JED: IP Mapping | Issue Tracker | JAudit | Password Control

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

Time to create page: 0.146 seconds
Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries