[RC] Servers Board

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Anti-Spam Guide
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
dynserver
Registered User
Posts: 65
Joined: Thu Apr 06, 2017 11:06 pm

Re: [RC] Servers Board

Post by dynserver » Sun Jul 09, 2017 9:02 pm

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 » Sun Jul 09, 2017 9:40 pm

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: 65
Joined: Thu Apr 06, 2017 11:06 pm

Re: [RC] Servers Board

Post by dynserver » Mon Jul 10, 2017 12:34 am

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 » Mon Jul 10, 2017 1:50 am

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: 65
Joined: Thu Apr 06, 2017 11:06 pm

Re: [RC] Servers Board

Post by dynserver » Mon Jul 10, 2017 4:32 am

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 » Mon Jul 10, 2017 7:44 pm

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: 223
Joined: Mon Feb 04, 2013 10:01 am

Re: [RC] Servers Board

Post by chfs » Thu Jul 13, 2017 2:51 pm

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 » Tue Aug 22, 2017 6:00 pm

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 » Tue Aug 22, 2017 6:33 pm

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 » Thu Aug 24, 2017 8:16 pm

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 » Thu Aug 24, 2017 8:21 pm

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 » Thu Aug 24, 2017 8:41 pm

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 » Fri Aug 25, 2017 9:24 am

help possibly?

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

Re: [RC] Servers Board

Post by Token07 » 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:

nucky91
Registered User
Posts: 23
Joined: Wed Jun 21, 2017 3:04 pm

Re: [RC] Servers Board

Post by nucky91 » Fri Aug 25, 2017 9:57 am

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

Post Reply

Return to “Extensions in Development”

Who is online

Users browsing this forum: nou nou, zorni and 16 guests

cron