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
Resolved: Install fails using MySQLi - 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

Resolved: Install fails using MySQLi


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

11 years 7 months ago - 11 years 7 months ago #1 by lioledingue

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

Hi, and thank you for this beautiful component I'm eager to use !

I have tried to install it on a Joomla 2.5.6, but fails with this ugly message :

500 - Une erreur s'est produite
JDatabaseMySQLi::query: 1146 - Table 'myDatabase.jz9t0_it_email' doesn't exist SQL=CREATE TRIGGER `jz9t0_it_email_bu` BEFORE UPDATE ON `jz9t0_it_email` FOR EACH ROW BEGIN IF (NEW.MODIFIED_ON IS NULL OR NEW.MODIFIED_ON = '0000-00-00 00:00:00') THEN SET NEW.MODIFIED_ON := sysdate(); END IF; IF (NEW.MODIFIED_BY IS NULL OR NEW.MODIFIED_BY = '') THEN SET NEW.MODIFIED_BY := USER(); END IF; END;

Retour au panneau de contrĂ´le


This seems to be related to my DataBase type, wich is MySQLi.
I have tested with another Joomla install using MySQL, and IssueTracker component install was then successful.

Any hint on that point, or maybe am I doing something bad ?

Many thanks,
Lionel

Edited by lioledingue - 01.10.2012 16:44

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

The topic has been locked.
11 years 7 months ago #2 by geoffc
Interesting.

Looks like (for some reason) the table hasn't been created. The error is coming from the 'script.php' installation file, since that is where the triggers are created.

I presume that this is a fresh install (from what you have said). Are the other table created in the database? There should be about seven tables created all called #_it_issues, #__it_projects etc.

I suspect you may find that none of the tables exist, it you could confirm. My suspicion is that it thinks it is an upgrade and not an install for some reason.

The clue could be in the database connection type since you have said that MySQL works and MySQLi fails.

I have not heard of this problem before, but it might possibly explain another strange (similar) problem I am investigating with Joomla 3.0.

I will have to run a few tests.

Regards
Geoff
The topic has been locked.
11 years 7 months ago #3 by lioledingue
Thank you for you quick reply.
True, in both cases it's a brand new install.
After checking my database structure (on Joomla's install which fails), these tables were created :

jz9t0_it_emails
jz9t0_it_issues
jz9t0_it_meta
jz9t0_it_people
jz9t0_it_priority
jz9t0_it_projects
jz9t0_it_roles
jz9t0_it_status
jz9t0_it_types

I suggest a fail back method that could delete them when install fails, but don't know if it's possible ^_^

I would love no to switch back to MySQL to be able to use your component.
Thanks for your time.
The topic has been locked.
11 years 7 months ago #4 by geoffc
Found it.

Change line 775 in the script.php so that the line reads:

$query= "CREATE TRIGGER `#__it_emails_bu` BEFORE UPDATE ON `#__it_emails` FOR EACH ROW";

The table name was wrong. Seems that the error is picked up by mysqli but not by mysql.

Very strange.

Well spotted, I am surprised this hasn't been reported before.

---

Re the uninstall. Even though the install has failed the component may still have been created. If so you should be able to uninstall it through the 'Extensions/Manage' screen.

Failing that in the FAQ there is a 'hammer' approach which will do the trick as a fall back.

If you correct the line above you should be able to reinstall since it does check whether the tables etc exist when trying to create them.

Edited by geoffc - 01.10.2012 17:22

Regards
Geoff
The topic has been locked.
11 years 7 months ago #5 by lioledingue
Perfect it's now installing fine!
I think this fix deserve to be included in 1.2.3 ;)
Anyway, thanks a lot for your help.
Lionel
The topic has been locked.
11 years 7 months ago #6 by geoffc
I am already ahead of you, it has already been made to the release repository.

Thank you for reporting it.

Regards
Geoff
The topic has been locked.
Time to create page: 0.140 seconds
Go To Top

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries