Ok, now i have all content in same db, good, but... is it posible only ¿one front-end? your vmliveview in our servers, you look it blink the track label: http://web.campeonatopdlr.com/vmliveview/hotlaps.php?TrackName=ALL&Lang=es In our hotlaps for rf1, we can choose any server, all in same db. Always shows server with most recent lap. http://web.campeonatopdlr.com/hotlaps Saludos, Augusto
Hi Augusto, right now I am taking a break from all this. But what u can do is the following: - Create a central database, e.g. `vmliveall` with a `hotlaps` table only. - Create a stored procedure for each other `vmliveview` databases which is triggered when a lap within the `hotlaps` table is inserted or updated, which will update the `hotlaps` table within the `vmliveall` databases accordingly to display your desired results. Hope this helps. Cheers Frank
Hi Frank, I updated liveview plugin from 20120506.inofficial to 20130411.utf8: 1º Replaced rFactorSL and it works well 2º I have replaced old VMHotlaps.dll on plugins folder, currentscoring.xsl on VMHotlaps folder and copied new VMHotlaps.ini into root rF folder. 3º Apache server: I have deleted all files from old version and copied new files (and applied db access configuration). You can view monitor.php here: http://www.olimpusf1.es/index.php?option=com_wrapper&view=wrapper&Itemid=502 rFactor2 server and rFactorSL is working but Liveview shows "No Session Data". Hotlaps and track view works well. I need some help! Thanks.
Hi Frank, Logs say "Nothing", I mean... on logs folder I only have 2 files: 20130516.inc.mysqli.conn.php.error.log "2013-05-16 01:32:19";"Connect to SQL Server";"Error No: (1045) Error Msg: (Access denied for user 'vmliveview01dbw'@'localhost' (using password: YES))";"REMOTE_ADDR: 83.50.5.85";"HTTP_USER_AGENT: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)" 20130516.inc.requests.php.error.log "2013-05-16 01:32:19";"Connect to sql server";"ERROR: (Access denied for user 'vmliveview01dbw'@'localhost' (using password: YES))";"REMOTE_ADDR: 83.50.5.85";"HTTP_USER_AGENT: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)" But those errors ocurred because I did not configure correctly my user, dbname, etc, and now it is totally configured and working. You can see error date "2013-05-16 01:32:19", exactly when I installed the plugin. Thanks for your help, Cheers!
200 MB of log file !!! This is the error I have read into... Scoring was laoded for the first time from (file://C:/serv/olimpusf1rf2/VMHotlaps/CurrentScoring.xml). 2013-05-16 01:46:20.370 (+02:00) | ERROR | {SqlSessionUpdateStatus} Unknown column 'ServerState' in 'field list' - Query: (UPDATE `sessioninfos` SET `ServerState` = '0', `SessionStart` = '0' WHERE `ID` = '1') Thanks.
Hi Busy, it looks like the database doesn't match the loader version. Did u do an upgrade of the db? For testing, just create a new db with a different name and try to make it work this way ... Thanx & Cheers Frank
You can either update the old db with the update script ..\mysql\vmliveview.db.update.2004.sql or transfer the records from the old db to the new db in different ways (e.g. table data export/import, insert into (select), ...) ...
Thank you very much, it works! I can help you with spanish lang, it will be interesting for spanish championships. Cheers!
hi is it possible to use those scripts on separates serveurs ? I explain : I do not have a webserver apache+mysql on the game server (which host the rfactor race), and i would like to use the vmliveview (the php files) on a separate (external) web server. Is it possible ? Thank for your answer
Hi Bruno, Let the loader (rFactorSL.exe) run on the game server and configure the mysql part of the loader to point to the remote mysql+web-server. Hope this helps ... Cheers Frank
Hello Frank, I have a trouble connecting MySQL with version 2.1 that I do not have the version 2.0! Also with rfactorSL !!! Strange, you have an idea ? Pascal
Hi Pascal, without any logs from the loader it will be a little hard for me to tell you what might causes your problems. Cheers Frank
Sorry Frank, 2013-06-05 22:31:10.906 (+02:00) | ERROR | {SqlConnOpen} Authentication to host 'xxx.xxx.xxx.xxx' for user 'mysqluser' using method 'mysql_native_password' failed with message: Access denied for user 'mysqluser'@'%' to database 'vmliveview06' For rfactor 1 the config for rfactorsl is identical Edit : I have solved my Problem, bad version of sql file.