Newcomer1989 / TSN-Ranksystem

A PHP Bot that assigns time based server groups on TeamSpeak3.
https://ts-ranksystem.com
GNU General Public License v3.0
144 stars 60 forks source link

PostgreSQL Support #433

Open awbait opened 6 years ago

awbait commented 6 years ago

I'm trying to install on the Postgresql database. He created a database, and tried to install Ranksystem in it. But I get the error "database "o7db" already exists" although before the error it was written that the existing database would be recreated. Thanks in advance for the answer.

Database error: 42P04 Array ( [0] => 42P04 [1] => 7 [2] => ERROR: database "o7db" already exists ) Database error: 42601 Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "(" LINE 1: ...tf8 COLLATE utf8_unicode_ci PRIMARY KEY,cldbid int(10) NOT N... ^ ) Database error: 42601 Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "(" LINE 1: CREATE TABLE o7db.groups (sgid int(10) NOT NULL default '0' ... ^ ) Database error: 42601 Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "(" LINE 1: ... SET utf8 COLLATE utf8_unicode_ci,tsquery smallint(5) UNSIGN... ^ ) Database error: 42601 Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "(" LINE 1: CREATE TABLE o7db.server_usage (timestamp bigint(11) NOT NUL... ^ ) Database error: 42601 Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "(" LINE 1: CREATE TABLE o7db.user_snapshot (timestamp bigint(11) NOT NU... ^ ) Database error: 42601 Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "(" LINE 1: CREATE TABLE o7db.stats_server (total_user int(10) NOT NULL ... ^ ) Database error: 42601 Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "(" LINE 1: ...Y,removed tinyint(1) NOT NULL default '0',rank int(10) NOT N... ^ ) Database error: 42601 Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "SET" LINE 1: INSERT INTO o7db.stats_server SET total_user='9999' ^ ) Database error: 42601 Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "(" LINE 1: ...LATE utf8_unicode_ci PRIMARY KEY, timestamp bigint(11) NOT N... ^ ) Database error: 42P01 Array ( [0] => 42P01 [1] => 7 [2] => ERROR: relation "o7db.job_check" does not exist LINE 1: INSERT INTO o7db.job_check (job_name) VALUES ('calc_user_lim... ^ ) Database error: 42601 Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "(" LINE 1: ...tf8 COLLATE utf8_unicode_ci PRIMARY KEY, count int(10) NOT N... ^ ) Database error: 42601 Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "(" LINE 1: ...tf8 COLLATE utf8_unicode_ci PRIMARY KEY, count int(10) NOT N... ^ ) Database error: 42601 Array ( [0] => 42601 [1] => 7 [2] => ERROR: syntax error at or near "(" LINE 1: ...tf8 COLLATE utf8_unicode_ci PRIMARY KEY, count int(10) NOT N... ^ ) Database error: 3F000 Array ( [0] => 3F000 [1] => 7 [2] => ERROR: schema "o7db" does not exist LINE 1: CREATE TABLE o7db.addons_config (param varchar(255) CHARACTE... ^ ) Database error: 42P01 Array ( [0] => 42P01 [1] => 7 [2] => ERROR: relation "o7db.addons_config" does not exist LINE 1: INSERT INTO o7db.addons_config (param,value) VALUES ('assign... ^ ) Database error: 3F000 Array ( [0] => 3F000 [1] => 7 [2] => ERROR: schema "o7db" does not exist LINE 1: CREATE TABLE o7db.addon_assign_groups (uuid varchar(29) CHAR... ^ )

Newcomer1989 commented 6 years ago

Please remove / drop the database o7db. Be sure, you are using this database only for the Ranksystem and not for any other things.

After that, try to install it again. If you still run into problems, please try to contact us on our public TS3 (ts-n.net).

awbait commented 6 years ago

Unfortunately, it did not work for me. Tried and deleted and cleaned the database. We can not talk, English is not my native language. Can we somehow communicate by letter?

awbait commented 6 years ago

I tried it on my computer. It turned out the same thing. https://imgur.com/a/mwju6

awbait commented 6 years ago

@Newcomer1989 are there any solutions to this problem?

Newcomer1989 commented 6 years ago

At the moment we have really much to do.. So the next time I think there will be other priorities. Sorry, for that.. We hope you understand this. We are an open source project and have only limited resources.

We recommend to use the MySQL or MariaDB. This should run perfectly.