Bug Reports: B16Enk's seow_server_v1.0

[Mhondoz]

Nice to know EJGr.Ost_Chamel! I am running a server using the XAMPP package, and had the problem with no response from MySQL on some of the detailed mission statistic pages.

First, InnoDB was not enabled by default, which I fixed using your post here. But since I was already 15+ missions into the campaign, I also had to convert the tables already in use from MyISAM to InnoDB. I did that by using

Code: Select all

ALTER TABLE ... ENGINE=INNODB

on all SEOW tables, as described here.

And now, the detailed mission statistic works for all the missions. Thanks!

[EJGr.Ost_Chamel]

I did that by using

Code: Select all

ALTER TABLE ... ENGINE=INNODB

on all SEOW tables, as described here.

Nice one! I didn't know that and my way was way less elegant.
I converted my DB by exporting it into a SQL-Dump, editing the dump with a text editor replacing "MyISAM" with InnoDB (88 times) and then restored the DB from the modified dump. But I have a good excuse: it was very late at night on a LAN-Party and I had no access to the internet!

Greetings

Chamel

[BBloke]

This little script will help.

Save it to a file in your www folder and call it through your web browser.

Code: Select all

<?php
$dbname = 'seow';

if (!mysql_connect('localhost', 'root', 'root')) {
    echo 'Could not connect to mysql';
    exit;
}

$result = mysql_list_tables($dbname);

if (!$result) {
    echo "DB Error, could not list tables\n";
    echo 'MySQL Error: ' . mysql_error();
    exit;
}

while ($row = mysql_fetch_row($result)) {
    $sql = "ALTER TABLE ".$row[0]." ENGINE=INNODB";
    
    mysql_query($sql);
    echo "Table ".$row[0]." Changed<br/>";
}

mysql_free_result($result);

?>

[CadMan]

Hi

Our Group are playing a lot COOP missions at the moment and the concept of an internal Squad War came up.
Having come across SEOW sytem I'd thought that would do the trick nicely.
BUT my knowledge regarding setting up SQL based DB's on PC based web server is zero so was attempting to source the auto installer package. Any updates to a link or is it still been repackaged with the newer versions DB MP etc ?

Any assistance appreciated.

CadMan
Mission Builder InSPire Dedicated
Online since Nov 2004
"The Flying Kiwis"

[IV/JG7_4Shades]

Hi CadMan,

Welcome! The all-in-one installer put together by BBloke has been superseded by newer releases of SEOW. You could try to contact BBloke to see if he wants to produce a new installer, or you could try the standard install. Check out the SEOWiki for some instructions.

http://seowwiki.swil.fr/index.php?title=Main_Page

Cheers,
4Shades

[=JFC=Tom]

I've had this same problem, 2 guys form JFC have both had a shot at trying to set it up and we haven't succeeded.
I tried to modify the original all-in-one installer and failed, so a newer all-in-one would be good!

[IV/JG7_4Shades]

Hi Tom,

If you want to test out SEOW before embarking on the install again, just drop by at SEOW HQ teamspeak some time and we'll show you the system.

Cheers,
4Shades

[=JFC=Tom]

Thanks for the offer, I'll try and come by some time in the near future

[=JFC=Tom]

Sorry if I've missed something obvious, but I can't seem to find an IP for your teamspeak on the forums. Is there one running?
I've just got permission from the head of JFC to use some of the JFC website space to host the appropriate files (ie the mission planner) if I can get it working. I've downloaded the most recent Scorched Earth files, so all I need now is to know how!

[IV/JG7_4Shades]

Hi Tom,

Check out http://seowhq.net/, the TS password is "seow".

Cheers,
4Shades