The BW Item Iists won't appear. I comes up with an error.
Code:
-- Error -- Invalid query: SELECT i.*, m.mart, m.mall, h.hold_pokemon
FROM bw_items i
LEFT OUTER JOIN bw_pokemart_items m
ON m.itemnum=i.itemnum
LEFT OUTER JOIN bw_hold_items h
ON h.itemnum=i.itemnum
WHERE category <> 'unused'
ORDER BY name
MySQL error: Can't create/write to file '/tmp/#sql_3d57_1.MYD' (Errcode: 17)
And above each list it comes up with this:
Code:
[phpBB Debug] PHP Warning
: in file /var/www/vhosts/psypokes.com/httpdocs/bw/items.php on line 105: Invalid argument supplied for foreach()
EDIT: Same type of thing happened with the HGSS Item Lists.
Code:
-- Error --
Invalid query: SELECT DISTINCT i.*,
e.dowsing AS has_dowsing,
e.itemball AS on_ground,
e.gift AS is_gift,
p.itemnum AS has_pickup,
wl.routes AS dowsing_routes,
pi.pokemon_names, pi.pokemon_routes,
m.johto, m.goldenrod, m.kanto, m.celadon,
hi.hold_pokemon
FROM hgss_items i
LEFT OUTER JOIN hgss_items_extra e ON i.itemnum=e.itemnum
LEFT OUTER JOIN hgss_items_pickup p ON p.itemnum=i.itemnum
LEFT OUTER JOIN hgss_pokewalker_items_locations wl ON wl.itemnum=i.itemnum
LEFT OUTER JOIN hgss_pokewalker_pokemon_items pi ON pi.itemnum=i.itemnum
LEFT OUTER JOIN hgss_pokemart_items m ON i.itemnum=m.itemnum
LEFT OUTER JOIN hgss_hold_items hi ON i.itemnum=hi.itemnum
ORDER BY i.name ASC
MySQL error: Can't create/write to file '/tmp/#sql_3d57_1.MYD' (Errcode: 17)
Stack Trace:
Query() [/var/www/vhosts/psypokes.com/httpdocs/hgss/items.php#72]
And above each list:
Code:
[phpBB Debug] PHP Warning
: in file /var/www/vhosts/psypokes.com/httpdocs/hgss/items.php on line 119: Invalid argument supplied for foreach()
The spacing in the above isn't exact in case that matters.
~
