View Single Post
  #5  
Old 21st March 2012, 14:51
DooM's Avatar
DooM DooM is offline
Senior Member
 
Join Date: Feb 2009
United Kingdom
Posts: 118
Default
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         )  )
Click the image to open in full size.
__________________
* Ubuntu Linux User since 2009 *
Reply With Quote