Stapo
Modding Veteran
Can't this be setup with an exteranal database?
this gives me and idea, are you using my Lite pack?
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Can't this be setup with an exteranal database?
Problem signature:
Problem Event Name: APPCRASH
Application Name: arma2oaserver.exe
Application Version: 1.62.101.480
Application Timestamp: 510a3586
Fault Module Name: HiveExt.dll
Fault Module Version: 0.9.6.10
Fault Module Timestamp: 50d8307b
Exception Code: c0000005
Exception Offset: 0001ac28
OS Version: 6.1.7601.2.1.0.272.7
Locale ID: 1033
Additional Information 1: 0a9e
Additional Information 2: 0a9e372d3b4ad19135b953a78882e789
Additional Information 3: 0a9e
Additional Information 4: 0a9e372d3b4ad19135b953a78882e789
Read our privacy statement online:
http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409
If the online privacy statement is not available, please read our privacy statement offline:
C:\Windows\system32\en-US\erofflps.txt
2013-02-09 15:36:19 HiveExt: [Information] HiveExt 189dc495436c
2013-02-09 15:36:19 Database: [Information] Connected to MySQL database 174.122.124.156:3306/dayz_oring client ver: 5.5.28 server ver: 5.1.66-cll
2013-02-09 15:36:20 Database: [Information] Connected to MySQL database 174.122.124.156:3306/dayz_oring client ver: 5.5.28 server ver: 5.1.66-cll
2013-02-09 15:36:20 HiveExt: [Information] Method: 302 Params: 1:
2013-02-09 15:36:20 Database: [Error] Error 1146 (Table 'dayz_oring.Object_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT COUNT(*) FROM `Object_DATA` WHERE `Instance` = 1 AND `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 6 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )'
2013-02-09 15:36:20 Database: [Error] Error 1146 (Table 'dayz_oring.Object_DATA' doesn't exist) in MySQLQuery SQL: 'SELECT `ObjectID`, `Classname`, `CharacterID`, `Worldspace`, `Inventory`, `Hitpoints`, `Fuel`, `Damage` FROM `Object_DATA` WHERE `Instance`=1 AND `Classname` IS NOT NULL'
SQL query:
DELIMITER ;; CREATE PROCEDURE `pCleanupOOB`() BEGIN DECLARE intLineCount INT DEFAULT 0; DECLARE intDummyCount INT DEFAULT 0; DECLARE intDoLine INT DEFAULT 0; DECLARE intWest INT DEFAULT 0; DECLARE intNorth INT DEFAULT 0; SELECT COUNT(*) INTO intLineCount FROM object_data; SELECT COUNT(*) INTO intDummyCount FROM object_data WHERE Classname = 'dummy'; WHILE (intLineCount > intDummyCount) DO SET intDoLine = intLineCount - 1; SELECT ObjectUID, Worldspace INTO @rsObjectUID, @rsWorldspace FROM object_data LIMIT intDoLine, 1; SELECT REPLACE(@rsWorldspace, '[', '') INTO @rsWorldspace; SELECT REPLACE(@rsWorldspace, ']', '') INTO @rsWorldspace; SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 2), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 1)[...]
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'intDoLine, 1;
SELECT REPLACE(@rsWorldspace, '[', '') INTO @rsWorldsp' at line 26
just run this line if you know where your mysql.exe is mysql.exe --user=username --password=password --host=127.0.0.1 --port=3306 --database=dayzoring --execute="call pMain()"
Resources\mysql.exe --user=dayz_name --password=pw --host=174.122.124.156 --port=3306 --database=dayz_oring --execute="call pMain()"
ERROR 1267 (HY000) at line 1: Illegal mix of collations (utf8_general_ci,IMPLICI
T) and (utf8_unicode_ci,IMPLICIT) for operation '='
Press any key to continue . . .