title: MySql is not recognizing some Table Columns after uploading on Domain
body: <p>I have created a website using codeigniter Framework. Its working perfectly fine on localhost. Queries are fetching the data and showing the desired result. But after i uploaded the website on my Domain, its giving weird error messages. The same query is working fine on localhost but generating error messages on Domain database PhpMyAdmin. </p>
  
  <p>Some queries are working fine, like User login queries and some other basic queries, but queries containing complex joining generating error messages only on Domain..</p>
  
  <p>The following query is working perfeclty fine on localhost but generating missing column error message on Domain DB.</p>
  
  <pre><code>Error Number: 1054
  
  Unknown column 'Semester_courses.SemisterCourseId' in 'on clause'
  
  SELECT sum( student_marks.FinalMarks ) , semester_courses.in_semester, 
  student_marks.StudentId FROM student_marks 
  JOIN semester_courses
  ON student_marks.SemisterCourseId = Semester_courses.SemisterCourseId 
  WHERE 
  semester_courses.in_semester =1 
  GROUP BY semester_courses.in_semester , student_marks.StudentId 
  order by student_marks.FinalMarks Desc 
  Limit 0,1
  
  Filename: /home/tahakirmani/public_html/ums/models/loginmodel.php
  
  Line Number: 1523 
  </code></pre>