Psypoke
http://www.psypokes.com/forums/

BW Item List
http://www.psypokes.com/forums/viewtopic.php?f=35&t=30863		 Page 1 of 1
Author:  Dare234 [ Mon Dec 31, 2012 8:20 am ]
Post subject:  BW Item List
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.
Author:  GhostPony750 [ Mon Dec 31, 2012 10:31 am ]
Post subject:  Re: BW Item List
I believe they are fixing that, because yesterday, on the main page, there was an error too.
But now its fixed. ;)
Page 1 of 1 All times are UTC - 8 hours [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/