• This area is dedicated to the support of our xF1 add-ons. For xF2, please use the dedicated area: HERE.
  • We are aware that a no permission error was shown when you tried to purchase in the last 2 days, this is now fixed.

Bug Fixed Error when create custom clubs field

Cyentruk

Member
Joined
Nov 16, 2015
Messages
30
Hi,

I get this error when trying create new custom field of clubs. Can't you help me get out of this?

Code:
Mysqli statement execute error : Field 'display_template' doesn't have a default value
Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1638
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1627
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
XenForo_DataWriter->save() in XFA/Roster/ControllerAdmin/ClubField.php at line 137
XFA_Roster_ControllerAdmin_ClubField->actionSave() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/fifavnor/public_html/forum/admin.php at line 13
I created a club before.

Many thanks!
 
Last edited:

Cyentruk

Member
Joined
Nov 16, 2015
Messages
30
Hi @Fredxd

You make a little mistake in Updgrade.php so it occurs this error: :D
Code:
Fatal error: Class 'XFA_ExtendedCover_Install_Upgrade_901000190' not found in /home/fifavnor/public_html/forum/library/XFA/Roster/Install/Upgrade.php on line 18
I found that you forget change Extend Cover to Roster? :p
 

Cyentruk

Member
Joined
Nov 16, 2015
Messages
30
Hi Fred!

I don't want to border you but when I tried upgrade today, it's still get that error. The error text just change from "ExtendedCover" to "Roster".

I found that problem is the version ID "901000190" is not the right one. After see code at "addon_xfa_roster.xml", I tried change version ID into "90100009" at both xml file and Upgrade.php file. I'm not sure it's the right way but it allow me upgrade successfully. But the custom field still doesn't work.
 

Fredxd

Administrator
Staff member
Joined
Nov 14, 2015
Messages
1,853
In xml replace version id by 90100019 it should work and make update for custom field
 

Cyentruk

Member
Joined
Nov 16, 2015
Messages
30
I tried follow you but nothing. (just chage only in xml file)

May I tried all these?
- Xml file 901000190 --> 90100019
- /library/XFA\Roster/Install/Upgrade.php: 901000190 --> 90100019
- Rename /library/XFA\Roster/Install/Upgrade/903010090.php --> 90100019.php and change content inside: 901000190 --> 90100019

P/S: I'm not a coder so I does not understand about structure of files. I just do follow my logical.
 
Last edited:

Fredxd

Administrator
Staff member
Joined
Nov 14, 2015
Messages
1,853
Or you can uninstall and re install roster is a better way
I will fix it for next upgrade
 
  • Like
Reactions: Cyentruk