error can't install website database

Found a bug? post about it here and your fix if you have one and we will review it and make them part of the official release.
luler
Posts: 8
Joined: 15 Mar 2018, 05:27

error can't install website database

Postby luler » 15 Mar 2018, 06:44

Web-server: Proprietary *nix
PHP Version: 5.6.34
MySQL version: 5.7
Amxbans version: 6.1.3 with web WEB AMXBans 6.14.4 [unofficial]

Table 'host.com_webconfig' doesn't exist


I find and edit table but don't know is find but bypass imports

From that

Code: Select all

CREATE TABLE `amx_webconfig` (
id int(11) NULL auto_increment,
cookie varchar(32) NULL,
bans_per_page int(11) NULL,
design varchar(32) NULL,
banner varchar(64) NULL,
banner_url varchar(128) NOT NULL,
default_lang varchar(32) NULL,
start_page varchar(64) NULL,
show_comment_count int(1) NULL DEFAULT '1',
show_demo_count int(1) NULL DEFAULT '1',
show_kick_count int(1) NULL DEFAULT '1',
demo_all int(1) NOT NULL DEFAULT '0',
comment_all int(1) NOT NULL DEFAULT '0',
use_capture int(1) NULL DEFAULT '1',
max_file_size int(11) NULL DEFAULT '2',
file_type varchar(64) NULL DEFAULT 'dem,zip,rar,jpg,gif',
auto_prune int(1) NOT NULL DEFAULT '0',
`max_offences` SMALLINT NOT NULL DEFAULT '10',
`max_offences_reason` VARCHAR( 128 ) NOT NULL DEFAULT 'max offences reached',
use_demo int(1) NULL DEFAULT '1',
use_comment int(1) NULL DEFAULT '1',
 PRIMARY KEY (`id`)
)


I make that

Code: Select all

CREATE TABLE `amx_webconfig` (
`id`                  int(11)       UNIQUE auto_increment,
`cookie`              varchar(32)   UNIQUE DEFAULT '',
`bans_per_page`       int(11)       NULL DEFAULT '1',
`design`              varchar(32)   UNIQUE DEFAULT '',
`banner`              varchar(64)   UNIQUE DEFAULT '',
`banner_url`          varchar(128)  UNIQUE DEFAULT '',
`default_lang`        varchar(32)   UNIQUE DEFAULT '',
`start_page`          varchar(64)   UNIQUE DEFAULT '',
`show_comment_count`  int(1)         NULL DEFAULT '1',
`show_demo_count`     int(1)         NULL DEFAULT '1',
`show_kick_count`     int(1)         NULL DEFAULT '1',
`demo_all`            int(1)         NOT NULL DEFAULT '0',
`comment_all`         int(1)         NOT NULL DEFAULT '0',
`use_capture`         int(1)         NULL DEFAULT '1',
`max_file_size`       int(11)        NULL DEFAULT '2',
`file_type`           varchar(64)    NULL DEFAULT 'dem,zip,rar,jpg,gif',
`auto_prune`          int(1)         NOT NULL DEFAULT '0',
`max_offences`        SMALLINT       NOT NULL DEFAULT '10',
`max_offences_reason` VARCHAR( 128 ) NOT NULL DEFAULT 'max offences reached',
`use_demo`              int(1)       NULL DEFAULT '1',
`use_comment`           int(1)       NULL DEFAULT '1',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM CHARSET=utf8 COLLATE=utf8_unicode_ci;


and bypass it
I'm not sure is work fine!

Code: Select all

Fatal error: Call to a member function fetch_array() on boolean in /srv/disk1/2612014/www/host.tk/bans/include/config.inc.php on line 85


I can't find fix.

Before all I wanna share little picutes with potential errors.
https://imgur.com/a/LFgAf
and
https://imgur.com/a/eFnv6
only 3 tables made it, of 19
Last edited by luler on 16 Mar 2018, 04:16, edited 1 time in total.

User avatar
indianiso1
Posts: 105
Joined: 16 Oct 2015, 01:59
Contact:

Re: error can't install website

Postby indianiso1 » 15 Mar 2018, 08:34

Then which is AMXBans WEB version?
Delete these 3 tables, delete all the files, copy fresh AMXBans 6.13 or 6.14 WEB version to file system and try to setup again.

luler
Posts: 8
Joined: 15 Mar 2018, 05:27

Re: error can't install website

Postby luler » 15 Mar 2018, 16:24

amx_bbcode failed
amx_smilies failed

Enter settings
Website failed

Set user menu
User menu failed

Install module
iexport failed

Create web admin
Webadmin level failed
Webadmin data failed

Table 'database_amxbans.amx_webconfig' doesn't exist

and still only 3 table in MySQL. This is AMXBans_WEB_6.14.4.

same with 6.13 web

luler
Posts: 8
Joined: 15 Mar 2018, 05:27

Re: error can't install website

Postby luler » 16 Mar 2018, 01:02

amx_admins_servers successfully created
amx_amxadmins already exists
amx_bans already exists
amx_bans_edit successfully created
amx_bbcode already exists
amx_comments already exists
amx_files already exists
amx_levels already exists
amx_logs already exists
amx_modulconfig already exists
amx_reasons already exists
amx_reasons_set already exists
amx_reasons_to_set already exists
amx_serverinfo already exists
amx_smilies already exists
amx_usermenu already exists
amx_webadmins already exists
amx_webconfig already exists
amx_flagged successfully create


already exists but not really

same problem and with amxbans 6.0.4. From where come this problem? php.ini? mysql ??

User avatar
indianiso1
Posts: 105
Joined: 16 Oct 2015, 01:59
Contact:

Re: error can't install website database

Postby indianiso1 » 16 Mar 2018, 12:56

You can write in setup.php

Code: Select all

error_reporting(E_ALL);
ini_set('display_errors', 1);

Then delete db amx_* tables and iclude/db.config.inc.php. Try again. That lines afterwards will show up errors occurred.

luler
Posts: 8
Joined: 15 Mar 2018, 05:27

Re: error can't install website database

Postby luler » 16 Mar 2018, 16:53

Code: Select all

Notice: Undefined index: site in /srv/disk1/2612014/www/host.com/izgoneni/setup.php on line 42

Notice: Undefined variable: msg in /srv/disk1/2612014/www/host.com/izgoneni/setup.php on line 341
AMXBans

Notice: Undefined variable: msg in /srv/disk1/2612014/www/host.com/izgoneni/setup.php on line 178

Notice: Undefined variable: msg in /srv/disk1/2612014/www/host.com/izgoneni/setup.php on line 183

Notice: Undefined variable: msg in /srv/disk1/2612014/www/host.com/izgoneni/setup.php on line 196

Notice: Undefined variable: msg in /srv/disk1/2612014/www/host.com/izgoneni/setup.php on line 209

Notice: Undefined variable: prefix_exists in /srv/disk1/2612014/www/host.com/izgoneni/setup.php on line 210
AMXBans

luler
Posts: 8
Joined: 15 Mar 2018, 05:27

Re: error can't install website database

Postby luler » 18 Mar 2018, 18:48

From where can donwnload database.sql to install manual?

edit:
I found another version of amxbans 1.6 and with this version his give me a new information about errors.

amx_admins_servers successfully created
amx_amxadmins All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_bans All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_bans_edit successfully created
amx_bbcode All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_comments All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_files All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_levels All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_logs All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_modulconfig All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_reasons All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_reasons_set All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_reasons_to_set All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_serverinfo All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_smilies All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_usermenu All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_webadmins All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_webconfig All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
amx_flagged successfully created


picture: https://imgur.com/a/dz33x
Last edited by luler on 20 Mar 2018, 02:59, edited 1 time in total.

luler
Posts: 8
Joined: 15 Mar 2018, 05:27

Re: error can't install website database

Postby luler » 20 Mar 2018, 02:53

So I change most all tables and now I can run the website, change and save in him. I only need to test it all thing.

Image
Installation progress

Creating the table structure
amx_admins_servers successfully created
amx_amxadmins successfully created
amx_bans successfully created
amx_bans_edit successfully created
amx_bbcode successfully created
amx_comments successfully created
amx_files successfully created
amx_levels successfully created
amx_logs successfully created
amx_modulconfig successfully created
amx_reasons successfully created
amx_reasons_set successfully created
amx_reasons_to_set successfully created
amx_serverinfo successfully created
amx_smilies successfully created
amx_usermenu successfully created
amx_webadmins successfully created
amx_webconfig successfully created
amx_flagged successfully created

Enter required data
amx_bbcode successfully registered
amx_smilies successfully registered

Enter settings
Website successfully registered

Set user menu
User menu successfully registered

Install module
iexport successfully registered

Create web admin
Webadmin level successfully registered
Webadmin data successfully registered


if you wanna see what I change you can check here. Or just you have like my problem. You can change web\install\tables.inc I edit him also.
Link
Attachments
end.jpg
end.jpg (134.65 KiB) Viewed 1237 times

User avatar
indianiso1
Posts: 105
Joined: 16 Oct 2015, 01:59
Contact:

Re: error can't install website database

Postby indianiso1 » 21 Mar 2018, 11:52

Thank You! Will be fixed in next version.


Return to “Bugs”

Who is online

Users browsing this forum: No registered users and 2 guests