It is currently Thu Mar 28, 2024 9:43 am



Reply to topic  [ 2 posts ] 
 BW Item List 
Author Message
Pokemon Ranger
Pokemon Ranger
User avatar

Joined: Sun Nov 07, 2010 4:17 pm
Posts: 502
Location: Right Here
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.

_________________
Image


Mon Dec 31, 2012 8:20 am
Profile
Pokemon Master
Pokemon Master
User avatar

Joined: Tue Jul 03, 2012 10:00 pm
Posts: 1161
Location: Montréal
I believe they are fixing that, because yesterday, on the main page, there was an error too.
But now its fixed. ;)

_________________
Image
Thanks DragoBoy for this awesome sig and Mektar for the astonishing avatar!!!


Mon Dec 31, 2012 10:31 am
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 2 posts ] 

Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group
Designed by STSoftware for PTF.