Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   Gazelle (http://www.bvlist.com/forumdisplay.php?f=40)
-   -   mysql error (http://www.bvlist.com/showthread.php?t=9420)

jhuberus 17th August 2013 09:00
mysql error
 
Ok i have gazelle up and running i have installed sql fully the way it was asked to do and everything seem to install just fine however i am getting this mysql error

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,                Title,                Body,                Time                FROM news                ORDER BY Time DESC                LIMIT 5            [1] => 0.58603286743164        )      [1] => 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.34999847412109        )  )


any iideas why??

Bump: nevermind i got it the the sql i had was missing featured albums i grabbed a new source and works

Zuby 21st September 2013 19:15
insert this:
Code:

CREATE TABLE `featured_albums` (
  `GroupID` int(10) NOT NULL DEFAULT '0',
  `ThreadID` int(10) NOT NULL DEFAULT '0',
  `Title` varchar(35) NOT NULL DEFAULT '',
  `Started` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Ended` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB CHARSET utf8;
to gazelle DB


All times are GMT +2. The time now is 05:34.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.