What's new
Xen Factory

Register today to become a member! Once signed in, you'll be able to start purchasing our products, ask questions, request support and suggest new ideas!

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

Fred

Administrator
Staff member
In xml replace version id by 90100019 it should work and make update for custom field
 

Cyentruk

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

Fred

Administrator
Staff member
Or you can uninstall and re install roster is a better way
I will fix it for next upgrade
 
Top