O
Ovroo
Has anybody ever encountered this error? Using the latest version alongside XFA tournaments.
The error is:
Thanks in advance!
The error is:
Thanks in advance!
Well to give you complete solutions I need both the add-on , so that I can install and test but this is actually related to MySQL databases.Has anybody ever encountered this error? Using the latest version alongside XFA tournaments.
The error is:
Thanks in advance!
Well to give you complete solutions I need both the add-on , so that I can install and test but this is actually related to MySQL databases.
Well I don't have the access to download that if @AnimeHaxor can provide me the add-ons maybe then I can tell what issues are there with database.I realise that. I've been trying to fix it on localhost but haven't had any luck.
The two addons are available to download here, XFA Roster & XFA Tournament.
Thanks.
Well I don't have the access to download that if @AnimeHaxor can provide me the add-ons maybe then I can tell what issues are there with database.
Regards
Issue I told you already its with MySQL databases so probably you need to do its proper installation or you need to mess up with the php files that are actually writing/creating the database. II've tried them both on Localhost and shared hosting. I'm hoping maybe AnimeHaxor will know the issue
Issue I told you already its with MySQL databases so probably you need to do its proper installation or you need to mess up with the php files that are actually writing/creating the database. I
Ok, i give a file to @MiRacLE will issue now.
CREATE TABLE IF NOT EXISTS `xfa_roster_club_field` (
`field_id` varbinary(25) NOT NULL,
`display_group` enum('information') NOT NULL DEFAULT 'information',
`display_order` int(10) unsigned NOT NULL DEFAULT '1',
`field_type` enum('textbox','textarea','select','radio','checkbox','multiselect') NOT NULL DEFAULT 'textbox',
`field_choices` blob NOT NULL,
`match_type` enum('none','number','alphanumeric','email','url','regex','callback') NOT NULL DEFAULT 'none',
`match_regex` varchar(250) NOT NULL DEFAULT '',
`match_callback_class` varchar(75) NOT NULL DEFAULT '',
`match_callback_method` varchar(75) NOT NULL DEFAULT '',
`max_length` int(10) unsigned NOT NULL DEFAULT '0',
`required` tinyint(3) unsigned NOT NULL DEFAULT '0',
`show_registration` tinyint(3) unsigned NOT NULL DEFAULT '0',
`user_editable` enum('yes','once','never') NOT NULL DEFAULT 'yes',
`viewable_profile` tinyint(4) NOT NULL DEFAULT '1',
`viewable_message` tinyint(4) NOT NULL DEFAULT '0',
`display_template` text,
`moderator_editable` tinyint(3) unsigned NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Finally resolved all issues
Open library/xfa/Roster/controller admin/clubfileld.php
And look for
$dw->get('field_id')
And replace it with
$fieldDw->get('field_id')
And run this MySQL query in your database
Code:CREATE TABLE IF NOT EXISTS `xfa_roster_club_field` ( `field_id` varbinary(25) NOT NULL, `display_group` enum('information') NOT NULL DEFAULT 'information', `display_order` int(10) unsigned NOT NULL DEFAULT '1', `field_type` enum('textbox','textarea','select','radio','checkbox','multiselect') NOT NULL DEFAULT 'textbox', `field_choices` blob NOT NULL, `match_type` enum('none','number','alphanumeric','email','url','regex','callback') NOT NULL DEFAULT 'none', `match_regex` varchar(250) NOT NULL DEFAULT '', `match_callback_class` varchar(75) NOT NULL DEFAULT '', `match_callback_method` varchar(75) NOT NULL DEFAULT '', `max_length` int(10) unsigned NOT NULL DEFAULT '0', `required` tinyint(3) unsigned NOT NULL DEFAULT '0', `show_registration` tinyint(3) unsigned NOT NULL DEFAULT '0', `user_editable` enum('yes','once','never') NOT NULL DEFAULT 'yes', `viewable_profile` tinyint(4) NOT NULL DEFAULT '1', `viewable_message` tinyint(4) NOT NULL DEFAULT '0', `display_template` text, `moderator_editable` tinyint(3) unsigned NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
And enjoy your plugin
Finally resolved all issues
Open library/xfa/Roster/controller admin/clubfileld.php
And look for
$dw->get('field_id')
And replace it with
$fieldDw->get('field_id')
And run this MySQL query in your database
Code:CREATE TABLE IF NOT EXISTS `xfa_roster_club_field` ( `field_id` varbinary(25) NOT NULL, `display_group` enum('information') NOT NULL DEFAULT 'information', `display_order` int(10) unsigned NOT NULL DEFAULT '1', `field_type` enum('textbox','textarea','select','radio','checkbox','multiselect') NOT NULL DEFAULT 'textbox', `field_choices` blob NOT NULL, `match_type` enum('none','number','alphanumeric','email','url','regex','callback') NOT NULL DEFAULT 'none', `match_regex` varchar(250) NOT NULL DEFAULT '', `match_callback_class` varchar(75) NOT NULL DEFAULT '', `match_callback_method` varchar(75) NOT NULL DEFAULT '', `max_length` int(10) unsigned NOT NULL DEFAULT '0', `required` tinyint(3) unsigned NOT NULL DEFAULT '0', `show_registration` tinyint(3) unsigned NOT NULL DEFAULT '0', `user_editable` enum('yes','once','never') NOT NULL DEFAULT 'yes', `viewable_profile` tinyint(4) NOT NULL DEFAULT '1', `viewable_message` tinyint(4) NOT NULL DEFAULT '0', `display_template` text, `moderator_editable` tinyint(3) unsigned NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
And enjoy your plugin
Can u explain a bit more how can I get this error on my local server ?
Link or any login you can provide ? Also have you installed the tournament add-on integration with rosters as I don't have such error .I did what you said and then when I clicked 'Tournaments' on the navigation menu. I get that error.