[UAESCO fatal error] Table structure incorrect

[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

[undef.de]

The better place for this question would be the UASECO section in this forum (moderator please move it ).

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.

[GrandPa43]

I'll try to move this issue.
GrandPa

[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

[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.

[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

GrandPa