Page 1 of 1

[UAESCO fatal error] Table structure incorrect

Posted: 12 Jul 2018, 20:28
by GrandPa43
Hello,

I am trying to get my dedicated server up and running but I have bumped into some problems when I run the uaseco.bat file.

The output from the terminal is as follows:

Code: Select all

[2018-07-12 21:11:03] [Database] ...connection established successfully to a MariaDB/10.1.33 server!
[2018-07-12 21:11:03] [Database] Checking database structure:
[2018-07-12 21:11:03] [Database] > Missing table `GPauthors`
[2018-07-12 21:11:03] [Database] > Missing table `GPmaphistory`
[2018-07-12 21:11:03] [Database] > Missing table `GPmaps`
[2018-07-12 21:11:03] [Database] > Missing table `GPplayers`
[2018-07-12 21:11:03] [Database] > Missing table `GPplaylist`
[2018-07-12 21:11:03] [Database] > Missing table `GPrankings`
[2018-07-12 21:11:03] [Database] > Missing table `GPratings`
[2018-07-12 21:11:03] [Database] > Missing table `GPrecords`
[2018-07-12 21:11:03] [Database] > Missing table `GPsettings`
[2018-07-12 21:11:03] [Database] > Missing table `GPtimes`
[2018-07-12 21:11:03] [Database] > Creating table `GPauthors`
[2018-07-12 21:11:03] [Database] > Creating table `GPmaphistory`
[2018-07-12 21:11:03] [Database] > Creating table `GPmaps`
[2018-07-12 21:11:03] [Database] > Creating table `GPplayers`
[2018-07-12 21:11:03] [Database] > Creating table `GPplaylist`
[2018-07-12 21:11:03] [Database] > Creating table `GPrankings`
[2018-07-12 21:11:03] [Database] > Creating table `GPratings`
[2018-07-12 21:11:03] [Database] > Creating table `GPrecords`
[2018-07-12 21:11:03] [Database] > Creating table `GPsettings`
[2018-07-12 21:11:03] [Database] > Creating table `GPtimes`
[UASECO Fatal Error] [Database] Table structure incorrect, automatic setup failed! on line 1611 in file C:\ManiaplanetServer\uaseco\uaseco.php
Press any key to continue . . .
I am using Xampp as the controller setup and of course MariaDB. How can I overcome this obstacle? Please assist!

Best regards,
GrandPa

Re: [UAESCO fatal error] Table structure incorrect

Posted: 12 Jul 2018, 21:11
by undef.de
The better place for this question would be the UASECO section in this forum (moderator please move it :thumbsup: ).

And for code/logfiles you better should you the code block instead.

You can try to run the development snapshot from github. You maybe have to remove the current database if it was an new one.

Re: [UAESCO fatal error] Table structure incorrect

Posted: 13 Jul 2018, 17:17
by GrandPa43
I'll try to move this issue.
GrandPa

Re: [UAESCO fatal error] Table structure incorrect

Posted: 15 Jul 2018, 09:44
by GrandPa43
I'm still in the problem that I got this fault message when I start Uaseco.bat

Code: Select all

[2018-07-15 10:29:07] [Database] ...connection established successfully to a MariaDB/10.1.33 server!
[2018-07-15 10:29:07] [Database] Checking database structure:
[2018-07-15 10:29:07] [Database] > Missing table `GPauthors`
[2018-07-15 10:29:07] [Database] > Missing table `GPmaphistory`
[2018-07-15 10:29:07] [Database] > Missing table `GPmaps`
[2018-07-15 10:29:07] [Database] > Missing table `GPplayers`
[2018-07-15 10:29:07] [Database] > Missing table `GPplaylist`
[2018-07-15 10:29:07] [Database] > Missing table `GPrankings`
[2018-07-15 10:29:07] [Database] > Missing table `GPratings`
[2018-07-15 10:29:07] [Database] > Missing table `GPrecords`
[2018-07-15 10:29:07] [Database] > Missing table `GPsettings`
[2018-07-15 10:29:07] [Database] > Missing table `GPtimes`
[2018-07-15 10:29:07] [Database] > Creating table `GPauthors`
[2018-07-15 10:29:07] [Database] > Creating table `GPmaphistory`
[2018-07-15 10:29:07] [Database] > Creating table `GPmaps`
[2018-07-15 10:29:07] [Database] > Creating table `GPplayers`
[2018-07-15 10:29:07] [Database] > Creating table `GPplaylist`
[2018-07-15 10:29:07] [Database] > Creating table `GPrankings`
[2018-07-15 10:29:07] [Database] > Creating table `GPratings`
[2018-07-15 10:29:07] [Database] > Creating table `GPrecords`
[2018-07-15 10:29:07] [Database] > Creating table `GPsettings`
[2018-07-15 10:29:07] [Database] > Creating table `GPtimes`
[UASECO Fatal Error] [Database] Table structure incorrect, automatic setup failed! on line 1611 in file C:\ManiaplanetServer\uaseco\uaseco.php
Press any key to continue . . .
Please tell me the correct metod to solve the problem, The server program runs smooth, the Xammp as well.

Best regards
GrandPa

Re: [UAESCO fatal error] Table structure incorrect

Posted: 15 Jul 2018, 12:49
by undef.de
Do you have XtraDB or InnoDB Storage Engine installed and enabled?

If you use PhpMyAdmin please add a screenshot of the database and tables. Otherwise add the output from the MariaDB console from

Code: Select all

SHOW TABLES;
and

Code: Select all

DESCRIBE `GPauthors`;
DESCRIBE `GPmaphistory`;
DESCRIBE `GPmaps`;
DESCRIBE `GPplayers`;
DESCRIBE `GPplaylist`;
DESCRIBE `GPrankings`;
DESCRIBE `GPratings`;
DESCRIBE `GPrecords`;
DESCRIBE `GPsettings`;
DESCRIBE `GPtimes`;
EDIT: And some more details of your setup (OS, PHP...) would also be helpful.

Re: [UAESCO fatal error] Table structure incorrect

Posted: 29 Jul 2018, 12:24
by GrandPa43
Case closed, the fault was obvious on me, do to misspelling and wrong setting of sign.
Thanks for your attention on this issue.
The GrandPa Canyon Server runs well now :thumbsup:

GrandPa :roflol: