[ABD] Servers Board

Any abandoned Extensions will be moved to this forum.

WARNING: Extensions in this forum are not currently being supported or maintained by the original Extension author. Proceed at your own risk.
Forum rules
IMPORTANT: Extension Development Forum rules

WARNING: Extensions in this forum are not currently being supported nor updated by the original Extension author. Proceed at your own risk.
dynserver
Registered User
Posts: 92
Joined: Thu Apr 06, 2017 11:06 pm

Re: [RC] Servers Board

Post by dynserver »

Hey I was using this on my 3.1.9 board, then upgraded to 3.2 and it still worked, until I noticed it wasnt updating the player amount, so then I went and deleted it and downloaded your most recent github version of it..

Uploaded it..

Went to "Add Server"

and I get :

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/ext/token07/serversboard/controller/admin_controller.php on line 422: dir([ROOT]/ext/token07/serversboard/controller/../vendor/austinb/gameq/src/GameQ/Protocols/): failed to open dir: No such file or directory

Fatal error: Call to a member function read() on boolean in /usr/www/dynclan/public/forums/ext/token07/serversboard/controller/admin_controller.php on line 427

BUT then.. if I just enable it to show on index.. my whole board errors showing:

Code: Select all


SQL ERROR [ mysqli ]

Unknown column 'server_show_gametracker' in 'field list' [1054]

SQL

SELECT server_id, server_status, server_hostname, server_ip, server_players, server_map, server_join_link, server_show_gametracker FROM phpbb_serversboard ORDER BY server_order

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/token07/serversboard/event/main_listener.php
LINE: 79
CALL: phpbb\db\driver\factory->sql_query()

FILE: (not given by php)
LINE: (not given by php)
CALL: token07\serversboard\event\main_listener->load_serversboard()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 46
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/index.php
LINE: 235
CALL: phpbb\event\dispatcher->trigger_event()



I pretty much did an update from 3.1.9 to 3.2.0

I'm also now trying to delete data and get it out completely to maybe a fresh install but I'm getting this when I hit delete data after disabling:

Code: Select all


SQL ERROR [ mysqli ]

Table 'dynclan_forum.phpbb_serversboard' doesn't exist [1146]

SQL

SHOW COLUMNS FROM phpbb_serversboard

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 885
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 902
CALL: phpbb\db\tools\tools->sql_list_columns()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 602
CALL: phpbb\db\tools\tools->sql_column_exists()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 711
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 658
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 586
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 514
CALL: phpbb\db\migrator->try_revert()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 488
CALL: phpbb\db\migrator->revert_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 108
CALL: phpbb\db\migrator->revert()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 354
CALL: phpbb\extension\base->purge_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 283
CALL: phpbb\extension\manager->purge_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()



:roll:
Token07
Registered User
Posts: 62
Joined: Thu Mar 03, 2016 4:58 pm

Re: [RC] Servers Board

Post by Token07 »

It looks like it didn't add the database tables. Is there a migrations folder in the extension (ext/token07/serversboard)?
dynserver
Registered User
Posts: 92
Joined: Thu Apr 06, 2017 11:06 pm

Re: [RC] Servers Board

Post by dynserver »

yessir there is a migrations folder
Token07
Registered User
Posts: 62
Joined: Thu Mar 03, 2016 4:58 pm

Re: [RC] Servers Board

Post by Token07 »

It looks looks like something happened when your board was processing the database changes for extension, like they didn't complete.

Can you confirm whether ext/token07/serversboard/migrations/extra_server_opts.php exists?
Does the phpbb_serversboard table exist in your SQL database? Did you delete in trying to uninstall extension?
dynserver
Registered User
Posts: 92
Joined: Thu Apr 06, 2017 11:06 pm

Re: [RC] Servers Board

Post by dynserver »

that file exists yes, and nothing to do with servers board in my database..

where would I look in my database, just overall? Or in like phpbb_modules (it's not there either)


EDIT:

Yes I tried deleting but I can't delete data completely.. because when pressing "delete data" i get this:

Code: Select all

SQL ERROR [ mysqli ]

Table 'dynclan_forum.phpbb_serversboard' doesn't exist [1146]

SQL

SHOW COLUMNS FROM phpbb_serversboard

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 885
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 902
CALL: phpbb\db\tools\tools->sql_list_columns()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 602
CALL: phpbb\db\tools\tools->sql_column_exists()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 711
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 658
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 586
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 514
CALL: phpbb\db\migrator->try_revert()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 488
CALL: phpbb\db\migrator->revert_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 108
CALL: phpbb\db\migrator->revert()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 354
CALL: phpbb\extension\base->purge_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 283
CALL: phpbb\extension\manager->purge_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()


I've tried to disable it.. and upload up to date files and re-enabling it.. but thats when I still have the errors when trying to add a server and what not.
Token07
Registered User
Posts: 62
Joined: Thu Mar 03, 2016 4:58 pm

Re: [RC] Servers Board

Post by Token07 »

try running this query to recreate the serversboard table

Code: Select all

CREATE TABLE IF NOT EXISTS phpbb_serversboard (
  server_id mediumint(8) unsigned PRIMARY KEY NOT NULL AUTO_INCREMENT,
  server_order mediumint(8) unsigned NOT NULL DEFAULT '1',
  server_ip varchar(60) COLLATE utf8_bin DEFAULT NULL,
  server_status mediumint(8) unsigned DEFAULT NULL,
  server_hostname varchar(255) COLLATE utf8_bin DEFAULT NULL,
  server_map varchar(32) COLLATE utf8_bin DEFAULT NULL,
  server_lastupdate int(11) NOT NULL,
  server_players text COLLATE utf8_bin NOT NULL,
  server_playerlist text COLLATE utf8_bin NOT NULL,
  server_type varchar(30) COLLATE utf8_bin NOT NULL DEFAULT 'source',
  server_query_port mediumint(8) unsigned DEFAULT NULL,
  server_join_link varchar(255) COLLATE utf8_bin DEFAULT NULL,
  server_show_gametracker tinyint(1) unsigned NOT NULL DEFAULT '1',
  server_show_time_online tinyint(1) unsigned NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
Then try deleting the extension data and uninstalling again.
chfs
Registered User
Posts: 247
Joined: Mon Feb 04, 2013 10:01 am

Re: [RC] Servers Board

Post by chfs »

The extension will be approved?

This extension is very good.

Thank you.
I'm sorry for my english. :?
nucky91
Registered User
Posts: 23
Joined: Wed Jun 21, 2017 3:04 pm

Re: [RC] Servers Board

Post by nucky91 »

This extension is compatible for phpbb3.2?
Token07
Registered User
Posts: 62
Joined: Thu Mar 03, 2016 4:58 pm

Re: [RC] Servers Board

Post by Token07 »

nucky91 wrote: Tue Aug 22, 2017 6:00 pm This extension is compatible for phpbb3.2?
Yes
nucky91
Registered User
Posts: 23
Joined: Wed Jun 21, 2017 3:04 pm

Re: [RC] Servers Board

Post by nucky91 »

I install this but not refresh the online players etc...
Token07
Registered User
Posts: 62
Joined: Thu Mar 03, 2016 4:58 pm

Re: [RC] Servers Board

Post by Token07 »

nucky91 wrote: Thu Aug 24, 2017 8:16 pm I install this but not refresh the online players etc...
Does it just always say 0 players, or does it show some players after server is added and just never updates?
nucky91
Registered User
Posts: 23
Joined: Wed Jun 21, 2017 3:04 pm

Re: [RC] Servers Board

Post by nucky91 »

just always show 0 player
nucky91
Registered User
Posts: 23
Joined: Wed Jun 21, 2017 3:04 pm

Re: [RC] Servers Board

Post by nucky91 »

help possibly?
Token07
Registered User
Posts: 62
Joined: Thu Mar 03, 2016 4:58 pm

Re: [RC] Servers Board

Post by Token07 »

nucky91 wrote: Fri Aug 25, 2017 9:24 am help possibly?
Couple questions:
What type of game server(s)?:
What type of hosting are you using (shared, vps, dedicated, etc)?:
PHP Version:
nucky91
Registered User
Posts: 23
Joined: Wed Jun 21, 2017 3:04 pm

Re: [RC] Servers Board

Post by nucky91 »

Token07 wrote: Fri Aug 25, 2017 9:51 am
nucky91 wrote: Fri Aug 25, 2017 9:24 am help possibly?
Couple questions:
What type of game server(s)?:
What type of hosting are you using (shared, vps, dedicated, etc)?:
PHP Version:
San Andreas Multiplayer (samp)
hosting: VPS
Php:5.6.26, Phpbb 3.2.1
Locked

Return to “Abandoned Extensions”