View previous topic :: View next topic |
Author |
Message |
sniperkiller
Gender:  Joined: Oct 11, 2008 Age: 43 Posts: 270 Location: Ottawa, Ontario Reputation: 19.1   votes: 1

Status: Offline
|
Posted: Sun Oct 13, 2013 9:07 am Post subject: Re: OFxClanList problem |
|
|
I keep trying to install milpacs on the latest version of xtreme but no luck. Ever on a diffrent host. Only when I try to go to the milpacs admin. Im getting this error
Code:
An error occurred while attempting to run a query on the database!
Table 'milpacs2.vwar' doesn't exist
File:
/var/www/vhosts/milpacs2.righttorebel.net/httpdocs/includes/db/mysql.php
Line:
251
Stack Trace:
#3{main}
#2/var/www/vhosts/milpacs2.righttorebel.net/httpdocs/admin.php(400): include('/var/www/vhosts...')
#1/var/www/vhosts/milpacs2.righttorebel.net/httpdocs/modules/MILPACS/admin/case.php(275): include('/var/www/vhosts...')
#0/var/www/vhosts/milpacs2.righttorebel.net/httpdocs/modules/MILPACS/admin/index.php(1663): sql_db->sql_query('SELECT v.warid,...')
|
|
|
Back to top |
|
 |
pest
Gender:  Joined: Jan 21, 2009 Posts: 678
Reputation: 89.1   votes: 1

Status: Offline
Web Control Panel: Ampps 2.0 PHP Version: 5.3 SQL Version: 5.5.22 |
Posted: Sun Oct 13, 2013 2:13 pm Post subject: Re: OFxClanList problem |
|
|
where did you get your copy of milspac 2.0 I looked at mine and it has nothing to do with vwar even checked the database and no entry of vwar |
|
|
Back to top |
|
 |
coRpSE Site Admin
 Xtreme Developer

Gender:  Joined: Dec 24, 2008 Posts: 1397 Location: Back of your mind!!! Reputation: 212   votes: 11

Status: Offline
Web Control Panel: 11.42.0 (build 23) PHP Version: 5.4.24 SQL Version: 5.5.37-35.1-log |
Posted: Sun Oct 13, 2013 4:12 pm Post subject: Re: OFxClanList problem |
|
|
I also recommend NOT installing vWar. vWar is very unsecured and you would be just using a security risk script. It sounds like you either have a different version that someone imported vWar on or your trying to add vWar to it. |
|
|
Back to top |
|
 |
Sponsor
|
|
 |
sniperkiller
Gender:  Joined: Oct 11, 2008 Age: 43 Posts: 270 Location: Ottawa, Ontario Reputation: 19.1   votes: 1

Status: Offline
|
Posted: Sun Oct 13, 2013 9:15 pm Post subject: Re: OFxClanList problem |
|
|
pest wrote (View Post):
where did you get your copy of milspac 2.0 I looked at mine and it has nothing to do with vwar even checked the database and no entry of vwar
I got it from your site. If you look in MILPACS/Admin/index.php on line 615 I see this
Code:
@include("modules/MILPACS/includes/milpacs.inc.php");
$sql = "SELECT v.warid, v.status, v.matchtypeid, v.dateline, vo.oppname, vo.oppid FROM vwar" . $n . " v INNER JOIN vwar" . $n . "_opponents vo WHERE v.oppid = vo.oppid AND v.status = 1 ORDER BY dateline DESC";
$result = $db->sql_query($sql);
while ( $row = $db->sql_fetchrow($result) ) {
$warid = $row["warid"];
$date = date("F j, Y", $row["dateline"]);
$enemy = $row["oppname"];
?>
I delieted that and was able to get into the admin section of the milpacs but when I add a soldier I get this error
Code:
Message:
An error occurred while attempting to run a query on the database!
Query was empty
File:
/var/www/vhosts/milpacs2.righttorebel.net/httpdocs/includes/db/mysql.php
Line:
251
Stack Trace:
#4{main}
#3/var/www/vhosts/milpacs2.righttorebel.net/httpdocs/admin.php(400): include('/var/www/vhosts...')
#2/var/www/vhosts/milpacs2.righttorebel.net/httpdocs/modules/MILPACS/admin/case.php(98): include('/var/www/vhosts...')
#1/var/www/vhosts/milpacs2.righttorebel.net/httpdocs/modules/MILPACS/admin/index.php(85): include('/var/www/vhosts...')
#0/var/www/vhosts/milpacs2.righttorebel.net/httpdocs/modules/MILPACS/admin/addsoldier.php(74): sql_db->sql_query(NULL)
It will still add the soldier though but when I click on the soldiers profile I get this error
Code:
An error occurred while attempting to run a query on the database!
Unknown column 'GEN.Hutchew' in 'where clause'
File:
/var/www/vhosts/milpacs2.righttorebel.net/httpdocs/includes/db/mysql.php
Line:
251
Stack Trace:
#2{main}
#1/var/www/vhosts/milpacs2.righttorebel.net/httpdocs/modules.php(107): include('/var/www/vhosts...')
#0/var/www/vhosts/milpacs2.righttorebel.net/httpdocs/modules/MILPACS/soldierprofile.php(63): sql_db->sql_query('SELECT u_name F...')
|
|
|
Back to top |
|
 |
pest
Gender:  Joined: Jan 21, 2009 Posts: 678
Reputation: 89.1   votes: 1

Status: Offline
Web Control Panel: Ampps 2.0 PHP Version: 5.3 SQL Version: 5.5.22 |
|
Back to top |
|
 |
sniperkiller
Gender:  Joined: Oct 11, 2008 Age: 43 Posts: 270 Location: Ottawa, Ontario Reputation: 19.1   votes: 1

Status: Offline
|
Posted: Sun Oct 13, 2013 9:47 pm Post subject: Re: OFxClanList problem |
|
|
My clan has a dedicated server. Im not sure why but they asked me to work on this and I was confused as to the location. Im still confused lol.
This is the path that i have to go to in ftp /var/www/vhosts/milpacs2.righttorebel.net/httpdocs/modules/MILPACS |
|
|
Back to top |
|
 |
Sponsor
|
|
 |
pest
Gender:  Joined: Jan 21, 2009 Posts: 678
Reputation: 89.1   votes: 1

Status: Offline
Web Control Panel: Ampps 2.0 PHP Version: 5.3 SQL Version: 5.5.22 |
Posted: Sun Oct 13, 2013 9:57 pm Post subject: Re: OFxClanList problem |
|
|
lol ..you just need to find out the correct path once you do ..it should work fine |
|
|
Back to top |
|
 |
sniperkiller
Gender:  Joined: Oct 11, 2008 Age: 43 Posts: 270 Location: Ottawa, Ontario Reputation: 19.1   votes: 1

Status: Offline
|
Posted: Mon Oct 14, 2013 7:01 am Post subject: Re: OFxClanList problem |
|
|
pest wrote (View Post):
lol ..you just need to find out the correct path once you do ..it should work fine
Are you able to get into the milpacs admin? Ive installed it on my server which is way less confusing and Im still getting the error when I dont touch the MILPACS/asmin/index.php file |
|
|
Back to top |
|
 |
sniperkiller
Gender:  Joined: Oct 11, 2008 Age: 43 Posts: 270 Location: Ottawa, Ontario Reputation: 19.1   votes: 1

Status: Offline
|
Posted: Mon Oct 14, 2013 7:16 am Post subject: Re: OFxClanList problem |
|
|
On my site www.rebelgamingleague.net/milpacs2 when I add a soldier Im getting this
Code:
The webpage at http://www.rebelgamingleague.net/milpacs2/admin.php might be temporarily down or it may have moved permanently to a new web address.
Error code: ERR_CONTENT_DECODING_FAILED
and when I click on the soldiers profile in the milpacs module I get this
Code:
The webpage at http://www.rebelgamingleague.net/milpacs2/modules.php?name=MILPACS&file=soldierprofile&uniqueid=1 might be temporarily down or it may have moved permanently to a new web address.
Error code: ERR_CONTENT_DECODING_FAILED
Go here http://www.rebelgamingleague.net/milpacs2/modules.php?name=MILPACS&file=roster and click on my name |
|
|
Back to top |
|
 |
Sponsor
|
|
 |
sniperkiller
Gender:  Joined: Oct 11, 2008 Age: 43 Posts: 270 Location: Ottawa, Ontario Reputation: 19.1   votes: 1

Status: Offline
|
Posted: Mon Oct 14, 2013 8:58 am Post subject: Re: OFxClanList problem |
|
|
This is the error log
Code:
---------[SQL Error]------------------------------------------------------------------------------------------------------------
- [14 Oct 2013 - 09:08:49] -
User: admin
IP: 67.70.130.80
URL: /milpacs2/modules.php?name=MILPACS&file=soldierprofile&uniqueid=52
File: /home2/sniper/public_html/milpacs2/modules/MILPACS/soldierprofile.php
Line: 63
Message:
Code:
Query: SELECT u_name FROM nuke_milpacs_members WHERE GEN.Hutchew = uniqueid
and this is whats on line 63
Code:
$reportsto = $db->sql_query("SELECT u_name FROM " . $prefix . "_milpacs_members WHERE $reports = uniqueid");
|
|
|
Back to top |
|
 |
Mabe
Joined: Jul 28, 2013 Posts: 1
Reputation: 0.1  
Status: Offline
|
Posted: Thu Oct 17, 2013 1:58 pm Post subject: Re: OFxClanList problem |
|
|
Im trying to use milpacs on version 2.09 as well and having the exact same problem. Im using RC2 from www.3rd-infantry-division.com |
|
|
Back to top |
|
 |
pest
Gender:  Joined: Jan 21, 2009 Posts: 678
Reputation: 89.1   votes: 1

Status: Offline
Web Control Panel: Ampps 2.0 PHP Version: 5.3 SQL Version: 5.5.22 |
Posted: Thu Oct 17, 2013 4:15 pm Post subject: Re: OFxClanList problem |
|
|
vwar is incorporated into milspac from pncnuke they took over updating milspac so if you want it to work right then you will need to install vwar which alot of people have said is not safe to use on a live site due to security issues i only found this out about milspac halfway thu this thread.when i have time i will look into removing vwar or some one here can do it sooner great till then i removed the download from my site. |
|
|
Back to top |
|
 |
Sponsor
|
|
 |
FinalTouch68
Joined: Jan 04, 2014 Posts: 14
Reputation: 1.9  

Status: Offline
|
Posted: Sun Jan 19, 2014 9:06 pm Post subject: Re: OFxClanList problem |
|
|
any body get a clan list mod for Nuke Evolution Xtreme version 2.0.9d
in working order i have tried many times to install this version with no luck |
|
|
Back to top |
|
 |
5STAR
Gender:  Joined: Dec 31, 2008 Posts: 560 Location: Missouri Reputation: 79.1   votes: 4

Status: Offline
Web Control Panel: 11.50.0 (build 0) PHP Version: 5.3.29 SQL Version: 5.5.40-cll |
Posted: Sun Jan 19, 2014 10:30 pm Post subject: Re: OFxClanList problem |
|
|
FinalTouch68 wrote (View Post):
any body get a clan list mod for Nuke Evolution Xtreme version 2.0.9d
in working order i have tried many times to install this version with no luck
Check out RD Clan Roster, haven't used it but it should work fine.You may need to register on RD to get it
http://www.realmdesignz.com/files/file/116-rd-clan-roster/ |
|
|
Back to top |
|
 |
FinalTouch68
Joined: Jan 04, 2014 Posts: 14
Reputation: 1.9  

Status: Offline
|
Posted: Mon Jan 20, 2014 5:47 pm Post subject: Re: OFxClanList problem |
|
|
Thanks 5star looking into it now. |
|
|
Back to top |
|
 |
Sponsor
|
|
 |
|