A quick question about XFA Rosters.

Ovroo · Oct 19, 2016

Has anybody ever encountered this error? Using the latest version alongside XFA tournaments.

The error is:

Thanks in advance!

MiRacLE · Oct 20, 2016

Ovroo said:
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.

Ovroo · Oct 20, 2016

MiRacLE said:
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.

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.

MiRacLE · Oct 20, 2016

Ovroo said:
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

Ovroo · Oct 20, 2016

MiRacLE said:
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

I've tried them both on Localhost and shared hosting. I'm hoping maybe AnimeHaxor will know the issue!

MiRacLE · Oct 20, 2016

Ovroo said:
I'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

Ovroo · Oct 20, 2016

MiRacLE said:
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

Yeah, I have been. I tried manually creating the tables but that didn't solve the issue.

AnimeHaxor · Oct 20, 2016

@Ovroo

XFA Rosters and XFA tournaments right?

Ovroo · Oct 20, 2016

AnimeHaxor said:
@Ovroo

XFA Rosters and XFA tournaments right?

Yup

AnimeHaxor · Oct 20, 2016

Ok, i give a file to @MiRacLE will issue now.

Ovroo · Oct 20, 2016

AnimeHaxor said:
Ok, i give a file to @MiRacLE will issue now.

Thanks! I've been playing with the SQL/PHP files all day and seem to have no luck ha!

Then again, if I was a coder, I wouldn't be heavily reliant on Xenforo.

Here is hoping that Miracle can see the problem.

MiRacLE · Oct 22, 2016

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

Ovroo · Oct 22, 2016

MiRacLE said:

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

You goddamn hero! Thanks man!

Ovroo · Oct 22, 2016

MiRacLE said:

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

Although, I now cannot create tournaments for rosters! Ha.

Any ideas?

MiRacLE · Oct 22, 2016

Can u explain a bit more how can I get this error on my local server ?

Ovroo · Oct 23, 2016

MiRacLE said:
Can u explain a bit more how can I get this error on my local server ?

I did what you said and then when I clicked 'Tournaments' on the navigation menu. I get that error.

MiRacLE · Oct 23, 2016

Ovroo said:
I did what you said and then when I clicked 'Tournaments' on the navigation menu. I get that error.

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 .

A quick question about XFA Rosters.

Ovroo

MiRacLE

Ovroo

MiRacLE

Ovroo

MiRacLE

Ovroo

AnimeHaxor

Retro-NulledTeam

Ovroo

AnimeHaxor

Retro-NulledTeam

Ovroo

MiRacLE

Ovroo

Ovroo

MiRacLE

Ovroo

MiRacLE