Live for Speed Forums

KingTracker - open source PHP insim tracker

Tue 29 Nov 2016, 02:25

Sheepy1977

S2 licensed

Quote from K0Z3L_43V3R :I cant tell what went wrong from that error messages.
- are there any more logs in /logs folder?
- was that after manual or automatic update?

Oops,this is my mistake..I just found that the database was deleted by incident.Now it is all ok and thank you!

KingTracker - open source PHP insim tracker

Find post in thread

Mon 28 Nov 2016, 07:00

Sheepy1977

S2 licensed

The tracker (KingTracker_v0.5.2f) crashed again and show these:

======================================================================
The application has thrown an exception!
======================================================================
Zend\ServiceManager\Exception\ServiceNotCreatedException
An exception was raised while creating "Insim\Controller\Insim"; no instance re
turned
----------------------------------------------------------------------
D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManager.p
hp:941
#0 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(330): Zend\ServiceManager\ServiceManager->createServiceViaCallback(
Object(Closure), 'insimcontroller...', 'Insim\\Controlle...')
#1 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(289): Zend\ServiceManager\AbstractPluginManager->createServiceViaCa
llback(Object(Closure), 'insimcontroller...', 'Insim\\Controlle...')
#2 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(634): Zend\ServiceManager\AbstractPluginManager->createFromFactory('insimc
ontroller...', 'Insim\\Controlle...')
#3 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(597): Zend\ServiceManager\ServiceManager->doCreate('Insim\\Controlle...',
'insimcontroller...')
#4 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(530): Zend\ServiceManager\ServiceManager->create(Array)
#5 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(161): Zend\ServiceManager\ServiceManager->get('Insim\\Controlle...'
, true)
#6 D:\www\kingtracker\vendor\zendframework\zend-mvc\src\DispatchListener.php(94)
: Zend\ServiceManager\AbstractPluginManager->get('Insim\\Controlle...')
#7 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\Mv
cEvent))
#8 D:\www\kingtracker\vendor\zendframework\zend-eventmanager\src\EventManager.ph
p(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#9 D:\www\kingtracker\vendor\zendframework\zend-eventmanager\src\EventManager.ph
p(263): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend
\Mvc\MvcEvent), Object(Closure))
#10 D:\www\kingtracker\vendor\zendframework\zend-mvc\src\Application.php(340): Z
end\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mv
c\MvcEvent))
#11 D:\www\kingtracker\public\index.php(43): Zend\Mvc\Application->run()
#12 {main}

LFSTop tracker

Find post in thread

Fri 25 Nov 2016, 13:59

Sheepy1977

S2 licensed

Good news!both two are worked!

LFSTop tracker

Find post in thread

Fri 25 Nov 2016, 10:28

Sheepy1977

S2 licensed

Quote from vitaly_m :What OS is it there? I tested that on Windows Server 2012 R2 and Windows 7 (both with latest updates).

Windows server 2008 32bit with Service Pack 2

LFSTop tracker

Find post in thread

Fri 25 Nov 2016, 09:31

Sheepy1977

S2 licensed

Quote from vitaly_m :Fixed. Redownload through the same link.

BTW WARNING there is a minor bug in this version: you can not end/restart during the practice session even if you're admin (you can only do it if everyone will vote for the same thing, no mater if admin or not). To get around this, run /laps 1 command and then you can do the stuff you need (/end or /restart). If you need to get back to practice mode afterwards, you can just put /laps 0 when session starts

Sorry ,I still cant run your app of latest version. It crashed and said that it cant locate the entry of K32GetProcessMemoryInfo at KERNER32.dll.

LFSTop tracker

Find post in thread

Fri 25 Nov 2016, 09:10

Sheepy1977

S2 licensed

I cant run the windows' version of 2.0.4 in my remote-server.It said that it cant find the entry location of Qt5Core.dll.

KingTracker - open source PHP insim tracker

Find post in thread

Thu 24 Nov 2016, 02:05

Sheepy1977

S2 licensed

Thanks a lot for your kindly reply.Since we are planning to record every single lap that every player did in our server and no matter what time they did,so we have to find some other way to do that.

KingTracker - open source PHP insim tracker

Find post in thread

Wed 23 Nov 2016, 04:26

Sheepy1977

S2 licensed

Quote from K0Z3L_43V3R :New version v0.5.2
- Layouts support
- !axlist command
- Top laps - show layout name, filter by tyres
- Main loop optimizations
- More translatable strings
....

I was trying to use KingTracker's database within my website so I wrote a simple php based script which it didn't get the things right and I don't understand why.

My script checks the LAPS table of KingTracker's database every 30 secs.If there is new lap-time record in it ,my script will read it and translate to my database's format and put it into my website's database.

The core-code was as followed:

$sql="select maxID from max_lap_id where host_id=$hostID";
$maxID=getsql($sql,0);//The max_lap_id table was set up by me in order to record the max lap ID that have been put into my database

$sql="select  * from laps where track='$track' and id>$maxID   order by id ";//make sure don't record the same lap-data again.
$ok=mysql_query($sql);
$idLog='';
if (mysql_num_rows($ok)>0){
    while ($row=mysql_fetch_array($ok))
    {
        
            $player_id=$row["player_id"];
            $sql2="select UName from players where id=$player_id";
            $plyName=getsql($sql2,0);
            $car=$row["car"];
            //$timestamp=time();
            $maxID_new=$LapId=$row['id'];
            $idLog=$maxID_new."\r\n".$idLog;
            $LapTime=$row["time"]/1000;
            $sectors=$row["sectors"];
            $timestamp=strtotime($row["added"])+8*3600;
            $var=json_decode($sectors,true);
            $st0=$var["1"];
            $st1=$var["2"];
            $SectorTime0=getSeconds($st0);
            $SectorTime1=getSeconds($st1);
            $LapCount=0;
            $data=$data."$LapId,1,$plyName,$car,4,5,6,7,8,$LapCount,$SectorTime0,$SectorTime1,$LapTime,$SectorTime0,$SectorTime1,$LapTime,$timestamp\n";
            //I will post this $data to my website's receiver.
            $sql3="update max_lap_id set maxID=$maxID_new where host_id=$hostID";//update the max-lap-id
            mysql_query($sql3);
        
    }

Well, if I set the max-lap-id to zero or something much more smaller than the LAPS table actually recorded,and the script will do it all right which will transfer all data into my website correctly in the very first time .but if the script keep running,all data transfer to my website were wrong.

So I wonder that will KingTracker update the certain LAPS record after insert it into LAPS table?If the answer is yes,could you tell me when KingTracker will update it ?

Last edited by Sheepy1977, Wed 23 Nov 2016, 04:33.

KingTracker - open source PHP insim tracker

Find post in thread

Mon 7 Nov 2016, 12:40

Sheepy1977

S2 licensed

Quote from K0Z3L_43V3R :Nice Smile

Updating should work, its working at test servers. How you starting tracker, with kingtracker.bat or manualy? Bat script is restarting tracker if it crashed. That's how updating works - new files are downloaded and tracker is stopped then bat script restart tracker. Update check is done every 3 hours or at tracker start. In case of error they are logged in /log folder.

Ok,I am with kagurazakayukari,so I will describe some technical details about our host here.

Our host was running in a Windows Server 2003 system.I have already set up a web-service of php,ngnix and mysql.so I cant use your Bat script came with the windows' version because it seems that it will set up another web-service which might crashed the web-service I already set.

Instead I use this bat to run your script:

php.exe -e d:/www/kingtracker/public/index.php insim start -d

It did work except it won't restart if it crashed..

KingTracker - open source PHP insim tracker

Find post in thread

Fri 4 Nov 2016, 07:04

Sheepy1977

S2 licensed

First of all,thank you for update the app so quickly .Second ,I still encountered a minor-bug which I already found a unusual way to solve it out.

My solution of this bug was add one line before line 266 of kingtracker\vendor\zendframework\zend-db\src\Adapter\Driver\Pdo\Connection.php,which was "$username='my db username';$password='my db password';"

PS:I did edit the file "kingtracker\config\autoload\global.php" with correct db username and password.

The error msgs were as followed:

D:\www>D:\phpStudy\php70n\php.exe -e d:/www/kingtracker/public/index.php insim s
tart -d
======================================================================
The application has thrown an exception!
======================================================================
Zend\ServiceManager\Exception\ServiceNotCreatedException
An exception was raised while creating "Insim\Controller\Insim"; no instance re
turned
----------------------------------------------------------------------
D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManager.p
hp:941
#0 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(330): Zend\ServiceManager\ServiceManager->createServiceViaCallback(
Object(Closure), 'insimcontroller...', 'Insim\\Controlle...')
#1 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(289): Zend\ServiceManager\AbstractPluginManager->createServiceViaCa
llback(Object(Closure), 'insimcontroller...', 'Insim\\Controlle...')
#2 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(634): Zend\ServiceManager\AbstractPluginManager->createFromFactory('insimc
ontroller...', 'Insim\\Controlle...')
#3 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(597): Zend\ServiceManager\ServiceManager->doCreate('Insim\\Controlle...',
'insimcontroller...')
#4 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(530): Zend\ServiceManager\ServiceManager->create(Array)
#5 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(161): Zend\ServiceManager\ServiceManager->get('Insim\\Controlle...'
, true)
#6 D:\www\kingtracker\vendor\zendframework\zend-mvc\src\DispatchListener.php(94)
: Zend\ServiceManager\AbstractPluginManager->get('Insim\\Controlle...')
#7 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\Mv
cEvent))
#8 D:\www\kingtracker\vendor\zendframework\zend-eventmanager\src\EventManager.ph
p(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#9 D:\www\kingtracker\vendor\zendframework\zend-eventmanager\src\EventManager.ph
p(263): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend
\Mvc\MvcEvent), Object(Closure))
#10 D:\www\kingtracker\vendor\zendframework\zend-mvc\src\Application.php(340): Z
end\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mv
c\MvcEvent))
#11 D:\www\kingtracker\public\index.php(42): Zend\Mvc\Application->run()
#12 {main}
======================================================================
Previous Exception(s):
======================================================================
Zend\ServiceManager\Exception\ServiceNotCreatedException
An exception was raised while creating "Insim\Service\LFSWService"; no instance
returned
----------------------------------------------------------------------
D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManager.p
hp:941
#0 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(330): Zend\ServiceManager\ServiceManager->createServiceViaCallback(
Object(Closure), 'insimcontroller...', 'Insim\\Controlle...')
#1 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(289): Zend\ServiceManager\AbstractPluginManager->createServiceViaCa
llback(Object(Closure), 'insimcontroller...', 'Insim\\Controlle...')
#2 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(634): Zend\ServiceManager\AbstractPluginManager->createFromFactory('insimc
ontroller...', 'Insim\\Controlle...')
#3 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(597): Zend\ServiceManager\ServiceManager->doCreate('Insim\\Controlle...',
'insimcontroller...')
#4 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(530): Zend\ServiceManager\ServiceManager->create(Array)
#5 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(161): Zend\ServiceManager\ServiceManager->get('Insim\\Controlle...'
, true)
#6 D:\www\kingtracker\vendor\zendframework\zend-mvc\src\DispatchListener.php(94)
: Zend\ServiceManager\AbstractPluginManager->get('Insim\\Controlle...')
#7 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\Mv
cEvent))
#8 D:\www\kingtracker\vendor\zendframework\zend-eventmanager\src\EventManager.ph
p(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#9 D:\www\kingtracker\vendor\zendframework\zend-eventmanager\src\EventManager.ph
p(263): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend
\Mvc\MvcEvent), Object(Closure))
#10 D:\www\kingtracker\vendor\zendframework\zend-mvc\src\Application.php(340): Z
end\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mv
c\MvcEvent))
#11 D:\www\kingtracker\public\index.php(42): Zend\Mvc\Application->run()
#12 {main}
======================================================================
Zend\Db\Adapter\Exception\RuntimeException
Connect Error: SQLSTATE[HY000] [1045] Access denied for user 'user'@'localhost'
(using password: YES)
----------------------------------------------------------------------
D:\www\kingtracker\vendor\zendframework\zend-db\src\Adapter\Driver\Pdo\Connectio
n.php:277
#0 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(330): Zend\ServiceManager\ServiceManager->createServiceViaCallback(
Object(Closure), 'insimcontroller...', 'Insim\\Controlle...')
#1 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(289): Zend\ServiceManager\AbstractPluginManager->createServiceViaCa
llback(Object(Closure), 'insimcontroller...', 'Insim\\Controlle...')
#2 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(634): Zend\ServiceManager\AbstractPluginManager->createFromFactory('insimc
ontroller...', 'Insim\\Controlle...')
#3 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(597): Zend\ServiceManager\ServiceManager->doCreate('Insim\\Controlle...',
'insimcontroller...')
#4 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(530): Zend\ServiceManager\ServiceManager->create(Array)
#5 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(161): Zend\ServiceManager\ServiceManager->get('Insim\\Controlle...'
, true)
#6 D:\www\kingtracker\vendor\zendframework\zend-mvc\src\DispatchListener.php(94)
: Zend\ServiceManager\AbstractPluginManager->get('Insim\\Controlle...')
#7 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\Mv
cEvent))
#8 D:\www\kingtracker\vendor\zendframework\zend-eventmanager\src\EventManager.ph
p(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#9 D:\www\kingtracker\vendor\zendframework\zend-eventmanager\src\EventManager.ph
p(263): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend
\Mvc\MvcEvent), Object(Closure))
#10 D:\www\kingtracker\vendor\zendframework\zend-mvc\src\Application.php(340): Z
end\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mv
c\MvcEvent))
#11 D:\www\kingtracker\public\index.php(42): Zend\Mvc\Application->run()
#12 {main}
======================================================================
PDOException
SQLSTATE[HY000] [1045] Access denied for user 'user'@'localhost' (using passwor
d: YES)
----------------------------------------------------------------------
D:\www\kingtracker\vendor\zendframework\zend-db\src\Adapter\Driver\Pdo\Connectio
n.php:266
#0 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(330): Zend\ServiceManager\ServiceManager->createServiceViaCallback(
Object(Closure), 'insimcontroller...', 'Insim\\Controlle...')
#1 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(289): Zend\ServiceManager\AbstractPluginManager->createServiceViaCa
llback(Object(Closure), 'insimcontroller...', 'Insim\\Controlle...')
#2 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(634): Zend\ServiceManager\AbstractPluginManager->createFromFactory('insimc
ontroller...', 'Insim\\Controlle...')
#3 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(597): Zend\ServiceManager\ServiceManager->doCreate('Insim\\Controlle...',
'insimcontroller...')
#4 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\ServiceManage
r.php(530): Zend\ServiceManager\ServiceManager->create(Array)
#5 D:\www\kingtracker\vendor\zendframework\zend-servicemanager\src\AbstractPlugi
nManager.php(161): Zend\ServiceManager\ServiceManager->get('Insim\\Controlle...'
, true)
#6 D:\www\kingtracker\vendor\zendframework\zend-mvc\src\DispatchListener.php(94)
: Zend\ServiceManager\AbstractPluginManager->get('Insim\\Controlle...')
#7 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\Mv
cEvent))
#8 D:\www\kingtracker\vendor\zendframework\zend-eventmanager\src\EventManager.ph
p(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#9 D:\www\kingtracker\vendor\zendframework\zend-eventmanager\src\EventManager.ph
p(263): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend
\Mvc\MvcEvent), Object(Closure))
#10 D:\www\kingtracker\vendor\zendframework\zend-mvc\src\Application.php(340): Z
end\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mv
c\MvcEvent))
#11 D:\www\kingtracker\public\index.php(42): Zend\Mvc\Application->run()
#12 {main}

Last edited by Sheepy1977, Fri 4 Nov 2016, 07:09.

KingTracker - open source PHP insim tracker

Find post in thread

Wed 2 Nov 2016, 02:08

Sheepy1977

S2 licensed

Okay... Thanks and it did works!

The reason it cant work becuz I checked "local insim" which I dont know what it means ..

But however there was something else happened.

I drove in RO1 with XFG in a 3 laps race,when someone finished his race ,the app crashed .

The full messages showed in the console window were as followed:

======================================================================
The application has thrown an exception!
======================================================================
Zend\Db\Adapter\Exception\InvalidQueryException
Statement could not be executed (42S22 - 1054 - Unknown column 'car' in 'field
list')
----------------------------------------------------------------------
D:\www\vendor\zendframework\zend-db\src\Adapter\Driver\Pdo\Statement.php:244
#0 D:\www\vendor\zendframework\zend-db\src\TableGateway\AbstractTableGateway.php
(307): Zend\Db\Adapter\Driver\Pdo\Statement->execute()
#1 D:\www\vendor\zendframework\zend-db\src\TableGateway\AbstractTableGateway.php
(263): Zend\Db\TableGateway\AbstractTableGateway->executeInsert(Object(Zend\Db\S
ql\Insert))
#2 D:\www\module\Application\src\Application\Service\CoreService.php(95): Zend\D
b\TableGateway\AbstractTableGateway->insert(Array)
#3 D:\www\module\Insim\src\Insim\Service\ResultService.php(61): Application\Serv
ice\CoreService->save(Object(Insim\Model\ResultPlayer), Object(Zend\Db\TableGate
way\TableGateway))
#4 D:\www\module\Insim\src\Insim\Service\HostService.php(601): Insim\Service\Res
ultService->addResult(Object(Insim\Packets\isRES))
#5 D:\www\module\Insim\src\Insim\Service\HostService.php(56): Insim\Service\Host
Service->confirmedFinish(Object(Insim\Packets\isRES))
#6 D:\www\module\Insim\src\Insim\Service\InsimService.php(205): Insim\Service\Ho
stService->handlePacket(Array, 'T#\x00\x19natusa\x00\x00\x00\x00\x00...')
#7 D:\www\module\Insim\src\Insim\Service\InsimService.php(141): Insim\Service\In
simService->handlePacket('T#\x00\x19natusa\x00\x00\x00\x00\x00...')
#8 D:\www\module\Insim\src\Insim\Controller\InsimController.php(130): Insim\Serv
ice\InsimService->run()
#9 D:\www\module\Insim\src\Insim\Controller\InsimController.php(89): Insim\Contr
oller\InsimController->Run()
#10 D:\www\vendor\zendframework\zend-mvc\src\Controller\AbstractActionController
.php(82): Insim\Controller\InsimController->StartAction()
#11 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatc
h(Object(Zend\Mvc\MvcEvent))
#12 D:\www\vendor\zendframework\zend-eventmanager\src\EventManager.php(490): cal
l_user_func(Array, Object(Zend\Mvc\MvcEvent))
#13 D:\www\vendor\zendframework\zend-eventmanager\src\EventManager.php(263): Zen
d\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEve
nt), Object(Closure))
#14 D:\www\vendor\zendframework\zend-mvc\src\Controller\AbstractController.php(1
18): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Z
end\Mvc\MvcEvent))
#15 D:\www\vendor\zendframework\zend-mvc\src\DispatchListener.php(114): Zend\Mvc
\Controller\AbstractController->dispatch(Object(Zend\Console\Request), Object(Ze
nd\Console\Response))
#16 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\M
vcEvent))
#17 D:\www\vendor\zendframework\zend-eventmanager\src\EventManager.php(490): cal
l_user_func(Array, Object(Zend\Mvc\MvcEvent))
#18 D:\www\vendor\zendframework\zend-eventmanager\src\EventManager.php(263): Zen
d\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEve
nt), Object(Closure))
#19 D:\www\vendor\zendframework\zend-mvc\src\Application.php(340): Zend\EventMan
ager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))

#20 D:\www\public\index.php(42): Zend\Mvc\Application->run()
#21 {main}
======================================================================
Previous Exception(s):
======================================================================
PDOException
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'car' in 'field list'
----------------------------------------------------------------------
D:\www\vendor\zendframework\zend-db\src\Adapter\Driver\Pdo\Statement.php:239
#0 D:\www\vendor\zendframework\zend-db\src\TableGateway\AbstractTableGateway.php
(307): Zend\Db\Adapter\Driver\Pdo\Statement->execute()
#1 D:\www\vendor\zendframework\zend-db\src\TableGateway\AbstractTableGateway.php
(263): Zend\Db\TableGateway\AbstractTableGateway->executeInsert(Object(Zend\Db\S
ql\Insert))
#2 D:\www\module\Application\src\Application\Service\CoreService.php(95): Zend\D
b\TableGateway\AbstractTableGateway->insert(Array)
#3 D:\www\module\Insim\src\Insim\Service\ResultService.php(61): Application\Serv
ice\CoreService->save(Object(Insim\Model\ResultPlayer), Object(Zend\Db\TableGate
way\TableGateway))
#4 D:\www\module\Insim\src\Insim\Service\HostService.php(601): Insim\Service\Res
ultService->addResult(Object(Insim\Packets\isRES))
#5 D:\www\module\Insim\src\Insim\Service\HostService.php(56): Insim\Service\Host
Service->confirmedFinish(Object(Insim\Packets\isRES))
#6 D:\www\module\Insim\src\Insim\Service\InsimService.php(205): Insim\Service\Ho
stService->handlePacket(Array, 'T#\x00\x19natusa\x00\x00\x00\x00\x00...')
#7 D:\www\module\Insim\src\Insim\Service\InsimService.php(141): Insim\Service\In
simService->handlePacket('T#\x00\x19natusa\x00\x00\x00\x00\x00...')
#8 D:\www\module\Insim\src\Insim\Controller\InsimController.php(130): Insim\Serv
ice\InsimService->run()
#9 D:\www\module\Insim\src\Insim\Controller\InsimController.php(89): Insim\Contr
oller\InsimController->Run()
#10 D:\www\vendor\zendframework\zend-mvc\src\Controller\AbstractActionController
.php(82): Insim\Controller\InsimController->StartAction()
#11 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatc
h(Object(Zend\Mvc\MvcEvent))
#12 D:\www\vendor\zendframework\zend-eventmanager\src\EventManager.php(490): cal
l_user_func(Array, Object(Zend\Mvc\MvcEvent))
#13 D:\www\vendor\zendframework\zend-eventmanager\src\EventManager.php(263): Zen
d\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEve
nt), Object(Closure))
#14 D:\www\vendor\zendframework\zend-mvc\src\Controller\AbstractController.php(1
18): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Z
end\Mvc\MvcEvent))
#15 D:\www\vendor\zendframework\zend-mvc\src\DispatchListener.php(114): Zend\Mvc
\Controller\AbstractController->dispatch(Object(Zend\Console\Request), Object(Ze
nd\Console\Response))
#16 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\M
vcEvent))
#17 D:\www\vendor\zendframework\zend-eventmanager\src\EventManager.php(490): cal
l_user_func(Array, Object(Zend\Mvc\MvcEvent))
#18 D:\www\vendor\zendframework\zend-eventmanager\src\EventManager.php(263): Zen
d\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEve
nt), Object(Closure))
#19 D:\www\vendor\zendframework\zend-mvc\src\Application.php(340): Zend\EventMan
ager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))

#20 D:\www\public\index.php(42): Zend\Mvc\Application->run()
#21 {main}

Last edited by Sheepy1977, Wed 2 Nov 2016, 03:36.

KingTracker - open source PHP insim tracker

Find post in thread

Tue 1 Nov 2016, 02:53

Sheepy1977

S2 licensed

Why cant I get any response from my lfs after I input those commands into LFS like "!tr,!host"?
I have already get the web-site and the monitor running in my server which running the lfs-dedicated host.

I am using version 0.5.0. There are some msg showing up , like "[2016-11-01 02:48:20] - Packet received: ISP_MSO" , in the monitor window after I typed something in the game.so I assume that the monitor was connected to my host correctly.
But still,there was nothing in my game's screen.

And PS, I already made myself as an admin through the web UI.

Last edited by Sheepy1977, Tue 1 Nov 2016, 02:59.

Marco Mark's Grid Order Mod (Alpha)

Find post in thread

Mon 16 Feb 2009, 03:08

Sheepy1977

S2 licensed

I almost serch entire internet and cant find a useful download....

Now I found it .thank you,Oliv76000!!

LFS Reorder - A drag 'n drop grid ordering program

Find post in thread

Mon 16 Feb 2009, 02:49

Sheepy1977

S2 licensed

When I run it,I got this error messages

An error occurred trying to download 'http://burnsy.no-ip.info/LFS_Reorder/LFS Reorder.application'.

lfs Promo movie

Find post in thread

Fri 19 Sep 2008, 02:35

Sheepy1977

S2 licensed

I am so proud of this video not only becuz it was made by a Chinese-LFS-player but also becuz the author is one of my friend.

Keep going,buddy!

.NET (C#) - Open Source Cruise Server

Find post in thread

Fri 30 May 2008, 12:53

Sheepy1977

S2 licensed

I think this should fixed the MCI errors.but I still haven't test it yet.


private void MCI_CarInformation(Packets.IS_MCI MCI)
{
            try
            {

                for (int i = 0; i < MCI.NumC; i++)
                {
                    decimal SpeedMS = (decimal)(((MCI.Info[i].Speed / 32768f) * 100f) / 2);
                    ......

In this section,replace all Players.Count with MIC.NumC.

.NET (C#) - Open Source Cruise Server

Find post in thread

Sun 25 May 2008, 09:52

Sheepy1977

S2 licensed

I just figured out a way to defined a lane.

When a car is in a lane's exit or entry,check the car's angle

.if wrong,the car drive in a wrong side.just like the method that used in checking the direction of pit-lane exit and entry.

Anyway...thank for your code and help!

.NET (C#) - Open Source Cruise Server

Find post in thread

Sun 25 May 2008, 06:25

Sheepy1977

S2 licensed

Where can i get the layout ? I want AS5's ,just as a example to understand how it works.thank you...

One more question:

How to defined a drive-lane?

I mean I want ppl drive though a path with the right side.I have checked the code ,and found nothing to define the drive-lane..so pls help me.

PS.......I translated it to simplified-Chinese..it works good in Y20....

Last edited by Sheepy1977, Sun 25 May 2008, 07:01.

Attention All Live For Speed Drifters!(competition)

Find post in thread

Sat 19 Jan 2008, 10:38

Sheepy1977

S2 licensed

So great but I am a super-rookie in LFS dirft..

Traditional/Simplified Chinese

Find post in thread

Thu 10 Jan 2008, 12:56

Sheepy1977

S2 licensed

Great news!
I cant wait for that.

How can i get the cars list which was allowed in a server through INSIM?

Find post in thread

How can i get the cars list which was allowed in a server through INSIM?

Mon 20 Aug 2007, 09:04

Sheepy1977

S2 licensed

I am working on some PHP scripts which can enable ppl to check my server's status from a web browser.

As the title of this thread said, I cant find a way to get the cars-list which was allowed in my server.I have checked out all of the INSIM packet and nothing found.

So if anyone who know how to do this ,pls tell me.thanks a lot

Hope u guys can understand what i said easily..because English is not my native language.

Sound Improvements/Ideas Log

Find post in thread

Sun 22 Apr 2007, 04:40

Sheepy1977

S2 licensed

the patch W sounds are pretty nice for current LFS sound engine.
but i do feel the off power volume in some of the cars is too high. maybe this volume should be lower and thus add more 'contrast' to the engine sound. i mean in some cars the noise with full throttle can be much louder and maybe this effect can be created by increase the volume difference by lowering off power volume

also i think the gearwhine in the open wheelers is a bit too high, and the cars sound like some kind of jet plane. is that realistic?

Is there anyone who got the dedicated server?

Find post in thread

Fri 21 Apr 2006, 13:45

Sheepy1977

S2 licensed

Thanks a lot!!!

Not very fast but ,yes,I got it.

I am wondering when the time is comes,if there is a mirror download site for us?

Last edited by Sheepy1977, Fri 21 Apr 2006, 13:49.

Is there anyone who got the dedicated server?

Find post in thread

Is there anyone who got the dedicated server?

Fri 21 Apr 2006, 13:35

Sheepy1977

S2 licensed

Pls upload it to somewhere else www.liveforspeed.net. and post the link to here.becuz I(I think that there is a lot of ppl like me) can't download it from there.

THANKS A LOT!!

will we ever get NORDSHLEIFE?

Find post in thread

Wed 19 Apr 2006, 00:52

Sheepy1977

S2 licensed

PS: I had driverd Nordschleife in GPL,it make me crazy for a few days before i knew that i cant finish one single lap without any damage...