| DooM |
21st March 2012 14:51 |
I figured out what was the problem. I reconfigured gazelle and now works but I still got a problem. (See attached printscreen).
Code:
MySQL: Invalid Query: SELECT fa.GroupID, tg.Name, tg.WikiImage, fa.ThreadID, fa.Title FROM featured_albums AS fa JOIN torrents_group AS tg ON tg.ID=fa.GroupID WHERE Ended = 0 SQL error: 1146 (Table 'gazelle.featured_albums' doesn't exist)Array ( [0] => Array ( [0] => SELECT ID, Name, Level FROM permissions ORDER BY Level [1] => 1.1200904846191 ) [1] => Array ( [0] => SELECT SessionID, Browser, OperatingSystem, IP, LastUpdate FROM users_sessions WHERE UserID='1' ORDER BY LastUpdate DESC [1] => 0.31304359436035 ) [2] => Array ( [0] => SELECT Enabled FROM users_main WHERE ID='1' [1] => 0.23698806762695 ) [3] => Array ( [0] => SELECT Uploaded AS BytesUploaded, Downloaded AS BytesDownloaded, RequiredRatio FROM users_main WHERE ID='1' [1] => 0.18310546875 ) [4] => Array ( [0] => SELECT m.ID, m.Username, m.PermissionID, m.Paranoia, i.Artist, i.Donor, i.Warned, i.Avatar, m.Enabled, m.Title, i.CatchupTime, m.Visible FROM users_main AS m INNER JOIN users_info AS i ON i.UserID=m.ID WHERE m.ID='1' [1] => 0.22101402282715 ) [5] => Array ( [0] => SELECT m.Invites, m.torrent_pass, m.IP, m.CustomPermissions, i.AuthKey, i.RatioWatchEnds, i.RatioWatchDownload, i.StyleID, i.StyleURL, i.DisableInvites, i.DisablePosting, i.DisableUpload, i.DisableWiki, i.DisableAvatar, i.DisablePM, i.DisableRequests, i.SiteOptions, i.DownloadAlt, i.LastReadNews FROM users_main AS m INNER JOIN users_info AS i ON i.UserID=m.ID WHERE m.ID='1' [1] => 0.30517578125 ) [6] => Array ( [0] => SELECT p.Level AS Class, p.Values as Permissions FROM permissions AS p WHERE ID='15' [1] => 0.25200843811035 ) [7] => Array ( [0] => SELECT ID, Label FROM users_notify_filters WHERE UserID='1' [1] => 0.2589225769043 ) [8] => Array ( [0] => SELECT ID, LOWER(REPLACE(Name," ","_")) AS Name, Name AS ProperName FROM stylesheets [1] => 0.18596649169922 ) [9] => Array ( [0] => SELECT ID, Title, Body, Time FROM news ORDER BY Time DESC LIMIT 5 [1] => 0.30899047851562 ) [10] => Array ( [0] => UPDATE users_info SET LastReadNews = '' WHERE UserID = 1 [1] => 63.047885894775 ) [11] => Array ( [0] => SELECT COUNT(s.TopicID) FROM users_subscriptions AS s JOIN forums_last_read_topics AS l ON s.UserID = l.UserID AND s.TopicID = l.TopicID JOIN forums_topics AS t ON l.TopicID = t.ID JOIN forums AS f ON t.ForumID = f.ID WHERE f.MinClassRead <= 1000 AND l.PostID < t.LastPostID AND s.UserID = 1 [1] => 0.33116340637207 ) [12] => Array ( [0] => SELECT ID FROM news ORDER BY Time DESC LIMIT 1 [1] => 0.19001960754395 ) [13] => Array ( [0] => SELECT COUNT(ID) FROM staff_pm_conversations WHERE UserID='1' AND Unread = '1' [1] => 0.17595291137695 ) [14] => Array ( [0] => SELECT COUNT(UnRead) FROM pm_conversations_users WHERE UserID='1' AND UnRead = '1' AND InInbox = '1' [1] => 0.17285346984863 ) [15] => Array ( [0] => SELECT COUNT(UserID) FROM users_notify_torrents WHERE UserID='1' AND UnRead='1' [1] => 0.17714500427246 ) [16] => Array ( [0] => SELECT COUNT(ID) FROM staff_pm_conversations WHERE Status='Unanswered' AND (AssignedToUser=1 OR Level=1000) [1] => 0.17404556274414 ) [17] => Array ( [0] => SELECT COUNT(ID) FROM reportsv2 WHERE Status='New' [1] => 0.17213821411133 ) [18] => Array ( [0] => SELECT COUNT(ID) FROM reports WHERE Status='New' [1] => 0.17309188842773 ) [19] => Array ( [0] => SELECT fa.GroupID, tg.Name, tg.WikiImage, fa.ThreadID, fa.Title FROM featured_albums AS fa JOIN torrents_group AS tg ON tg.ID=fa.GroupID WHERE Ended = 0 [1] => 0.57792663574219 ) )
http://s7.postimage.org/dw5ahqh23/gazelle.jpg |
