Aseco not work :(

Discuss everything about Xymph's Aseco flavoured server control scripts for TM Forever / classic TMN and for TM² Canyon.

Moderators: Xymph, TM-Patrol

Post Reply
Bankz
pedestrian
pedestrian
Posts: 6
Joined: 22 Apr 2008 18:16
Owned TM-games: TMNF

Aseco not work :(

Post by Bankz » 22 Apr 2008 20:32

HI my aseco not work

Begin Race
[PHP Warning] mysql_num_rows(): supplied argument is not a valid MySQL result resource on line 436 in file C:\TMforever_Dedicated\xaseco_096\plugins\plugin.localdatabase.php
[XASECO Warning] Could not insert challenge into database!

[04/22,20:19:33] track changed [none] >> [B-1]
[04/22,20:19:33] currently no record on B-1


Can somebody help me ``???

here is localdatabase.php line 436


// challenge found in database
if (mysql_num_rows($result) > 0) {

Xymph
Pit Crew
Pit Crew
Posts: 5680
Joined: 19 Aug 2007 12:58
Owned TM-games: TMN, TMU, TMF, TM²
Contact:

Re: Aseco not work :(

Post by Xymph » 22 Apr 2008 20:57

Bankz wrote:HI my aseco not work

Begin Race
[PHP Warning] mysql_num_rows(): supplied argument is not a valid MySQL result resource on line 436 in file C:\TMforever_Dedicated\xaseco_096\plugins\plugin.localdatabase.php
[XASECO Warning] Could not insert challenge into database!

[04/22,20:19:33] track changed [none] >> [B-1]
[04/22,20:19:33] currently no record on B-1

Can somebody help me ``???

here is localdatabase.php line 436


// challenge found in database
if (mysql_num_rows($result) > 0) {
The problem isn't with that line, it's with your database configuration. Are there really no earlier warnings in the log when starting up XASECO? Is your MySQL running? Did you correctly configure localdatabase.xml ? See this Quick Start guide for advice.
Developer of XASECO for TMF/TMN ESWC & XASECO2 for TM²: see XAseco.org
Find your way around the Mania community from the TMN ESWC hub, TMF hub, TM² hub, and SM hub

Bankz
pedestrian
pedestrian
Posts: 6
Joined: 22 Apr 2008 18:16
Owned TM-games: TMNF

Re: Aseco not work :(

Post by Bankz » 22 Apr 2008 21:14

no this is the 1 warning when ia seco start !


but i dont know what i must change on this line 436:(



[XAseco] PHP Version is 5.2.5
[XAseco] Load settings [config.xml]
[XAseco] Load admin/ops lists [adminops.xml]
[XAseco] Load plugin [plugin.localdatabase.php]
[XAseco] PHP Version is 5.2.5
[XAseco] Load settings [config.xml]
[XAseco] Load admin/ops lists [adminops.xml]
[XAseco] Load plugin [plugin.localdatabase.php]
[XAseco] Load plugin [plugin.rounds.php]
[XAseco] Load plugin [chat.admin.php]
[XAseco] Load plugin [chat.help.php]
[XAseco] Load plugin [chat.records.php]
[XAseco] Load plugin [chat.records2.php]
[XAseco] Load plugin [chat.recrels.php]
[XAseco] Load plugin [chat.dedimania.php]
[XAseco] Load plugin [chat.players.php]
[XAseco] Load plugin [chat.players2.php]
[XAseco] Load plugin [chat.wins.php]
[XAseco] Load plugin [chat.laston.php]
[XAseco] Load plugin [chat.stats.php]
[XAseco] Load plugin [chat.server.php]
[XAseco] Load plugin [chat.song.php]
[XAseco] Load plugin [chat.me.php]
[XAseco] Load plugin [plugin.tmxinfo.php]
[XAseco] Load plugin [plugin.track.php]
[XAseco] Load plugin [plugin.checkpoints.php]
[XAseco] Load plugin [plugin.dedimania.php]
[XAseco] Load plugin [plugin.rasp.php]
[XAseco] Load plugin [plugin.rasp_jukebox.php]
[XAseco] Load plugin [plugin.rasp_chat.php]
[XAseco] Load plugin [plugin.rasp_karma.php]
[XAseco] Load plugin [plugin.rasp_nextmap.php]
[XAseco] Load plugin [plugin.rasp_nextrank.php]
[XAseco] Load plugin [plugin.rasp_votes.php]
[XAseco] Load plugin [plugin.chatlog.php]
[XAseco] Load plugin [plugin.uptodate.php]
[XAseco] Load plugin [jfreu.plugin.php]
[XAseco] Load plugin [mistral.idlekick.php]
[XAseco] Try to connect to server on 127.0.0.1:5004
[XAseco] Try to authenticate with login 'SuperAdmin' and password 'SuperAdmin'
[XAseco] Connection established successfully!
[Local DB] Load settings file
[Local DB] Try to connect to MySQL server
[Local DB] MySQL Server Version is 5.0.51a
[RASP] Cleaning up unused data
*-*-*-*-*-* RASP is running! *-*-*-*-*-*
|...Loading Settings
|...Loaded!
|...Checking database structure
|...Structure OK!
|...Calculating ranks
|...Done!
[04/22,22:45:47] ************* (Dedimania) *************
[04/22,22:45:47] *** Dataserver connection on Dedimania ...
* Try connection on http://dedimania.net:8003/Dedimania ...
Webaccess (dedimania.net:8003): send: deflate, receive: deflate
* Connection and status ok! :)
* NEWS (Dedimania, 08/05): news
[04/22,22:45:49] ------------- (Dedimania) -------------
###############################################################################
XASECO v0.96 running on 127.0.0.1:5004
Name : *קşŀ*Beginner
Game : TmForever - TimeAttack
Version: 2.11.11 / 2008-04-18
Authors: Florian Schnell & Assembler Maniac
Re-Authored: Xymph
###############################################################################
Begin Race
[PHP Warning] mysql_num_rows(): supplied argument is not a valid MySQL result resource on line 436 in file C:\TMforever_Dedicated\xaseco_096\plugins\plugin.localdatabase.php
[XASECO Warning] Could not insert challenge into database!
[04/22,22:45:50] track changed [none] >> [B-1]
[04/22,22:45:50] currently no record on B-1

User avatar
lille79
Pit Crew
Pit Crew
Posts: 881
Joined: 09 Dec 2007 15:04
Owned TM-games: TMN, TMNF, TMUF
Location: Norway
Contact:

Re: Aseco not work :(

Post by lille79 » 22 Apr 2008 21:20

Are you sure you've set up the localdatabase.xml with the right user, password and name of your database?
/lille79
Old man of the Norwegian Trackmania team Super Sheep Racing
To visit my homepage/blog, and download the usbTMFserver, this is the place to go.

Bankz
pedestrian
pedestrian
Posts: 6
Joined: 22 Apr 2008 18:16
Owned TM-games: TMNF

Re: Aseco not work :(

Post by Bankz » 22 Apr 2008 21:25

sure Ive look is all correct ..


aseco work it save the wins.. but he dont save the tracks in the database & the recs °

Xymph
Pit Crew
Pit Crew
Posts: 5680
Joined: 19 Aug 2007 12:58
Owned TM-games: TMN, TMU, TMF, TM²
Contact:

Re: Aseco not work :(

Post by Xymph » 22 Apr 2008 21:40

Download and install this version of plugin.localdatabase.php in place of the original. Restart XASECO and report the MySQL errors you see in the log.
Developer of XASECO for TMF/TMN ESWC & XASECO2 for TM²: see XAseco.org
Find your way around the Mania community from the TMN ESWC hub, TMF hub, TM² hub, and SM hub

Bankz
pedestrian
pedestrian
Posts: 6
Joined: 22 Apr 2008 18:16
Owned TM-games: TMNF

Re: Aseco not work :(

Post by Bankz » 23 Apr 2008 14:24

ok i have downloaded it and change it but now aseco say :


MYSQL error: Table 'aseco.votes' doesn't exi
sql = SELECT c.Id AS ChallengeId, r.Score, p
ore) AS VotingSum, COUNT(v.Score) AS VotingC
FROM challenges c
LEFT JOIN records r ON (r.
LEFT JOIN votes v ON (v.Ch
LEFT JOIN players p ON (r.
WHERE c.Uid='4oalZWYdyx0SE
GROUP BY r.Id
ORDER BY r.Score,r.Date
LIMIT 50
[PHP Warning] mysql_num_rows(): supplied arg
source on line 457 in file C:\TMforever_Dedi
ldatabase.php
MYSQL error: Duplicate entry '4oalZWYdyx0SEF
sql = INSERT INTO challenges
(Uid, Name, Author
VALUES
('4oalZWYdyx0SEFyM
um')
[XASECO Warning] Could not insert challenge
[04/23,16:26:40] track changed [none] >> [B-
[04/23,16:26:40] currently no record on B-0

Xymph
Pit Crew
Pit Crew
Posts: 5680
Joined: 19 Aug 2007 12:58
Owned TM-games: TMN, TMU, TMF, TM²
Contact:

Re: Aseco not work :(

Post by Xymph » 23 Apr 2008 15:15

Bankz wrote:ok i have downloaded it and change it but now aseco say :

MYSQL error: Table 'aseco.votes' doesn't exist
Then you haven't created the database at all. Again, if you run into trouble, READ this guide and don't skip any steps. :wink:
Developer of XASECO for TMF/TMN ESWC & XASECO2 for TM²: see XAseco.org
Find your way around the Mania community from the TMN ESWC hub, TMF hub, TM² hub, and SM hub

Bankz
pedestrian
pedestrian
Posts: 6
Joined: 22 Apr 2008 18:16
Owned TM-games: TMNF

Re: Aseco not work :(

Post by Bankz » 23 Apr 2008 15:30

mmh i cant find what i have done false :(

when i go to remote 4 i see

Table 'aseco.rcp_challenges' doesn't existSELECT COUNT(Id) FROM rcp_challenges
Table 'aseco.rcp_challenges' doesn't exist SELECT a.*, (SELECT MIN(b.Score) FROM rcp_records AS b WHERE a.Id = b.ChallengeId) AS record FROM rcp_challenges AS a WHERE 1 ORDER BY Name asc LIMIT 0, 30

i cant understand english very good so i have some problems what remote say^^

Xymph
Pit Crew
Pit Crew
Posts: 5680
Joined: 19 Aug 2007 12:58
Owned TM-games: TMN, TMU, TMF, TM²
Contact:

Re: Aseco not work :(

Post by Xymph » 23 Apr 2008 16:11

Sigh. At the very least you've missed these steps in the QSG, but possibly others too then: :roll:
1 Create the XASECO database in MySQL (default "aseco" but any other name is okay too):
CREATE DATABASE aseco;

5. Set up the database tables in MySQL:
USE aseco;
SOURCE /home/tmn/aseco/localdb/aseco.sql;
SOURCE /home/tmn/aseco/localdb/rasp.sql;
I don't know what that 'remote' thing is, but XASECO doesn't have tables called 'rpc_challenges' and 'rpc_records' anyway.

Tell you what, if you can't figure it out, delete everything and start over following my guide step by step. Then ask specific questions when something isn't clear so I can perhaps improve the information in the guide.
Note that I'm not here to hold your hand on setting up PHP and MySQL though. :wink:
Last edited by Xymph on 23 Apr 2008 16:38, edited 1 time in total.
Developer of XASECO for TMF/TMN ESWC & XASECO2 for TM²: see XAseco.org
Find your way around the Mania community from the TMN ESWC hub, TMF hub, TM² hub, and SM hub

User avatar
f*ckfish
Pit Crew
Pit Crew
Posts: 1302
Joined: 15 Jun 2007 07:59
Owned TM-games: TMNF, TMUF
Location: Dresden, Germany
Contact:

Re: Aseco not work :(

Post by f*ckfish » 23 Apr 2008 16:24

He's talking about RemoteCP4 which brings its own database tables in a file called "live.sql". But I'm sure you don't need them since you want to run Aseco and not RemoteCP Live, do you? (To clarify this, RCP Live is another ingame server controller which would concur with Aseco and you don't need to run Live to use the normal functions of remoteCP)
inactive, sorry

Post Reply