Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error:Install Sourcebans step5 Fital Error. #749

Closed
KevonLin opened this issue Aug 25, 2021 · 7 comments
Closed

Error:Install Sourcebans step5 Fital Error. #749

KevonLin opened this issue Aug 25, 2021 · 7 comments

Comments

@KevonLin
Copy link

What are the steps to reproduce this issue?

1.install->step6

What happens?

An error occurred during normal installation.

What were you expecting to happen?

successful.

Any logs, error output, etc.?

Notice: Constant IN_SB already defined in /var/www/html/install/includes/converter.inc.php on line 28
Converting sb_bans...
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'player_ip' in 'field list' in /var/www/html/includes/Database.php:70 Stack trace: #0 /var/www/html/includes/Database.php(70): PDOStatement->execute() #1 /var/www/html/includes/Database.php(75): Database->execute() #2 /var/www/html/install/includes/converter.inc.php(45): Database->resultset() #3 /var/www/html/install/template/page.6.php(15): convertAmxbans(Object(Database), Object(Database)) #4 /var/www/html/install/includes/page-builder.php(62): include('/var/www/html/i...') #5 /var/www/html/install/index.php(31): include_once('/var/www/html/i...') #6 {main} thrown in /var/www/html/includes/Database.php on line 70

Any other comments?

nothing

What versions of software are you using?

Operating System:
Ububtu 20.04.2 LTS
SourceBans++ Version:
sourcebans-pp-1.6.3.Full
PHP Version:
PHP 7.2.24-0
MySQL Version:
5.7.34-0
Link to your project:
http://81.71.93.145/install/index.php
Link to a phpinfo() output:
step5

@crashzk
Copy link

crashzk commented Sep 21, 2021

If you have verified that you have all the requirements for installation?

  • Webserver
    o PHP 7.4 or higher
    • ini setting: memory_limit greater than or equal to 64M
    • GMP extension
      o MySQL 5.6 or MariaDB 10 and higher
  • Source Dedicated Server
    o MetaMod: Source
    o SourceMod: Greater Than or Equal To 1.7

Error that shows in the image says that you don't have some columns in your database.

Try doing a clean install, from scratch again.

Tried using PHP 7.3 too

@Groruk
Copy link
Member

Groruk commented Sep 21, 2021

Step 6 in the installer is optional and you only need to use it if you have an old AMXbans Database that you want to import.

@Groruk Groruk closed this as completed Sep 21, 2021
@NanakaFathry
Copy link

我也遇到了一样的错误:
报错原文:
AMXBans Import

Warning: Constant IN_SB already defined in /var/www/site4_com/sbpp/1.7.0/install/includes/converter.inc.php on line 28
Converting sb_bans...
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'player_ip' in 'field list' in /var/www/site4_com/sbpp/1.7.0/includes/Database.php:117 Stack trace: #0 /var/www/site4_com/sbpp/1.7.0/includes/Database.php(117): PDOStatement->execute() #1 /var/www/site4_com/sbpp/1.7.0/includes/Database.php(127): Database->execute() #2 /var/www/site4_com/sbpp/1.7.0/install/includes/converter.inc.php(45): Database->resultset() #3 /var/www/site4_com/sbpp/1.7.0/install/template/page.6.php(10): convertAmxbans() #4 /var/www/site4_com/sbpp/1.7.0/install/includes/routing.php(21): require_once('...') #5 /var/www/site4_com/sbpp/1.7.0/install/index.php(14): build() #6 {main} thrown in /var/www/site4_com/sbpp/1.7.0/includes/Database.php on line 117

错误经历:
是在第六步填写后(下图)
1
就报这个错误:
2

环境如下:

Ubuntu:20.04

PHP:
PHP 8.1.27 (cli) (built: Dec 21 2023 20:19:26) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.1.27, Copyright (c) Zend Technologies
with Zend OPcache v8.1.27, Copyright (c), by Zend Technologies

SQL:
mysql Ver 15.1 Distrib 10.3.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

metamod: source
SourceMod (1.11.0.6913) by AlliedModders LLC

@NanakaFathry
Copy link

我也遇到了一样的错误: 报错原文: AMXBans Import

Warning: Constant IN_SB already defined in /var/www/site4_com/sbpp/1.7.0/install/includes/converter.inc.php on line 28 Converting sb_bans... Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'player_ip' in 'field list' in /var/www/site4_com/sbpp/1.7.0/includes/Database.php:117 Stack trace: #0 /var/www/site4_com/sbpp/1.7.0/includes/Database.php(117): PDOStatement->execute() #1 /var/www/site4_com/sbpp/1.7.0/includes/Database.php(127): Database->execute() #2 /var/www/site4_com/sbpp/1.7.0/install/includes/converter.inc.php(45): Database->resultset() #3 /var/www/site4_com/sbpp/1.7.0/install/template/page.6.php(10): convertAmxbans() #4 /var/www/site4_com/sbpp/1.7.0/install/includes/routing.php(21): require_once('...') #5 /var/www/site4_com/sbpp/1.7.0/install/index.php(14): build() #6 {main} thrown in /var/www/site4_com/sbpp/1.7.0/includes/Database.php on line 117

错误经历: 是在第六步填写后(下图) 1 就报这个错误: 2

环境如下:

Ubuntu:20.04

PHP: PHP 8.1.27 (cli) (built: Dec 21 2023 20:19:26) (NTS) Copyright (c) The PHP Group Zend Engine v4.1.27, Copyright (c) Zend Technologies with Zend OPcache v8.1.27, Copyright (c), by Zend Technologies

SQL: mysql Ver 15.1 Distrib 10.3.38-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

metamod: source SourceMod (1.11.0.6913) by AlliedModders LLC

补充:
SourceBans++ Version:
sourcebans-pp-1.7.0 full

@Rushaway
Copy link
Contributor

Rushaway commented Jan 2, 2024

@NanakaFathry Sourcebans 1.7.0 was not designed to run PHP 8+
Use sbpp 1.8.0 for that.

@NanakaFathry
Copy link

@NanakaFathry Sourcebans 1.7.0 was not designed to run PHP 8+ Use sbpp 1.8.0 for that.
I tried to use 'sourcebans-pp-php81', but the same problem still exists
Uploading 2024-01-04 024848.png…
Also after the sixth step

@NanakaFathry
Copy link

I also tried reinstalling the Database-MySQL and PHP-7.4, but it still doesn't work and the same error persists

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants