The Energon Pub

[megatran]

Been having issues on & off with site last 2 days. Anyone else?

The great news is view of mobile site is taking shape. Thanks Ryan.

[Seibertron]

Been having issues on & off with site last 2 days. Anyone else?

The great news is view of mobile site is taking shape. Thanks Ryan.

What issues have you been having?

[Seibertron]

FYI ... I'm aware of the errors this afternoon with accessing the site. i'm trying to track down the 503 errors that some of you are getting when the server gets hammered by spiders like Google, Bing, Amazon, Yandex, etc. I've been working on this problem since last night around when I last posted in this thread in response to megatran. These 503 errors are incredibly frustrating. At least now they only happen when the server is getting hammered and it runs out of resources. Trying to fine tune it so that this doesn't happen.

[molleking]

Area reports is broken right now.

[Seibertron]

Area reports is broken right now.

Can you give me a link to what you are referring?

[molleking]

https://www.seibertron.com/sightings/st ... re_id=7676


This is the actual error message:
SELECT
si.item_id,
si.series_id,
si.item_name,
si.image
c.title AS series_title
FROM sighting_items si
INNER JOIN tf_series c ON si.series_id = c.series_id
WHERE si.is_active = 1
AND si.tstamp >= UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 18 MONTH))
AND (
si.item_id NOT IN (
SELECT s11.item_id
FROM sightings s11
WHERE s11.item_id = si.item_id
)
OR si.item_id IN (
SELECT s12.item_id
FROM sightings s12
WHERE s12.item_id = si.item_id
AND s12.tstamp >= UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 1 YEAR))
)
)
AND c.is_sightings = 1
ORDER BY c.lft ASC, si.item_name ASC
Database query failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.title AS series_title FROM sighting_items si INNER JOIN tf_series c ON si....' at line 6