Database bugs

[Shendemiar]

shendemiar said:

kae said:

The database will understand in-transport shipments as main page isle reports if copy and pasted into the submit box.

If not parsing the information into a 'transport' category (and instead favouring the event log) it should at least post a 'information not submitted, please post event log when transport completed'.

Currently it reports it as successfully parsed as a main isle page.

At least they seem not to be inserted into the database, so not so serious as it first seemed.

That and another much more serious bug fixed. Fell free to enter transports. Free goo for anyone who gets more than 5000 stoners to Ashimar.

[AeroS]

It would seem that Sol and Clausewitz ejection from the alliances has caused problems with the 'personal strength report'
Notice: Undefined index: Sol in /home/corleth/domains/corleth.com/public_html/int/features/sta_mem_strength.php on line 38

Warning: Division by zero in /home/corleth/domains/corleth.com/public_html/int/features/sta_mem_strength.php on line 38

Notice: Undefined index: Clausewitz in /home/corleth/domains/corleth.com/public_html/int/features/sta_mem_strength.php on line 30

Warning: Division by zero in /home/corleth/domains/corleth.com/public_html/int/features/sta_mem_strength.php on line 30

[Shendemiar]

Ah, will check that out. Exalts.

[kae]

That's a bug in the database in general. When Skulk went to HAWK for a few days, it was popping out that error message.

[blazed]

When you click the 'fleets' link from these pages I get the error (an e.g of 33_52_14)

Notice: Undefined variable: data in /home/corleth/domains/corleth.com/public_html/int/features/isle_distances.php on line 115

Warning: Invalid argument supplied for foreach() in /home/corleth/domains/corleth.com/public_html/int/features/isle_distances.php on line 115

Warning: array_multisort() [function.array-multisort]: Argument #1 is expected to be an array or a sort flag in /home/corleth/domains/corleth.com/public_html/int/features/isle_distances.php on line 119



Intell type When Attacker Defender Wall Mainhouse Watchtower Stoners Spears Archers Catapults LWS SWS Lms Sms Colonyships
Espionage 23rd Oct 2007 AeroS Rahein 20 20 20 2072 6279 1060 33 0 0 0 0 0
Espionage 23rd Oct 2007 blazed Rahein 20 20 20 2072 6274 1057 33 0 0 0 0 0
Espionage 23rd Oct 2007 Calamity77 Rahein 20 20 20 2072 6268 1053 33 0 0 0 0 0


Dist at 5 Knots at 2 knots Diff Coords Isle Player Data age (d) LWS SWS LMS SMS CATs COLs Stoners Spear Archers

Warning: Invalid argument supplied for foreach() in /home/corleth/domains/corleth.com/public_html/int/features/isle_distances.php on line 154

If I push go on this page it all works fine, just a little annoying!

[Shendemiar]

Thanks. It works now.

[mmupatton]

Not really a bug - but I think you might have to clear todays scanning of the game map, since the IK site is currently down. I don't know how that affects your data, but I just wanted to point it out...

[Shendemiar]

Its not going to go further unless it gets the data

And it they day stays uncompleted at the end of the day, it wont use it. So no worries.

[Warliter]

On the scan incoming fleets option I get this sql error

Found session id: ############
Notice: Undefined variable: isles in /home/corleth/domains/corleth.com/public_html/int/features/data_incoming.php on line 74

Warning: Invalid argument supplied for foreach() in /home/corleth/domains/corleth.com/public_html/int/features/data_incoming.php on line 74

Notice: Undefined variable: incomings in /home/corleth/domains/corleth.com/public_html/int/features/data_incoming.php on line 88

Warning: Invalid argument supplied for foreach() in /home/corleth/domains/corleth.com/public_html/int/features/data_incoming.php on line 88

[Shendemiar]

Its unfinished feature... (admins only see it until its coded)

[Fingal]

Errrmmm... I think this is a bug.

When posting isle data I get this message...

Submit data
Mainpage (Fleet data) was not valid. Nothing stored!

[kae]

make sure you're doing a control-A, cntl-c, then paste that into the box. Select the entire page, not just certain parts of it.

[Shendemiar]

fingal said:

Errrmmm... I think this is a bug.

When posting isle data I get this message...

Submit data
Mainpage (Fleet data) was not valid. Nothing stored!

Seems like its no longer supported... since we have the Fleets data retrieval tool... But if you insist i can make the manual stuff work too.

[eproxy]

Searching for isle lists belonging to Alliances (using either the drop down list in the 'Islelists by owner' or the A_ option in the 'Islelists by id') doesn't seem to work. It throws up some error:

array ( 'action' => 'Islelists_by_id', 'Subject' => 'A_727', 'Date1' => '689', 'Ocean' => 'All', )

Virhe kyselyssä : 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 ') AND daycount=689' at line 1
Query : SELECT * FROM data_isles WHERE CONCAT(Ocean, CONCAT(':', CONCAT(`Group`, CONCAT(':',Isle)))) IN ( ) AND daycount=689 array ( 'action' => 'Islelists_by_id', 'Subject' => 'A_727', 'Date1' => '689', 'Ocean' => 'All', )

Added; it works fine for members.

[Sol]

There seems to be an error with the new "tool" when entering reports from IK. Buildings catted don't seem to show or maybe I did something wrong. But anyway:

corleth.com/index.php?action=Isle_events&Target=14_24_12

Starting from right to left, the first Col_Att_Fail does not show the buildings that were catted down. I had to enter the attack report the old way which is seen right next to that one and it does show the buildings that were destroyed.

Unless I am completely slow in the head and I can't see it...I demand you to fix it.