#6 SQL Error when exporting to PDF

closed-fixed
None
5
2006-10-09
2005-02-21
No

Hi,

when hitting the "PDF Export" button with the "Not
seen" selection button on, i get this SQL Error:

Database Problem
Unknown table 'userseen' in where clause
SELECT videodata.*, users.name AS owner,
mediatypes.name AS mediatype FROM videodata LEFT JOIN
users ON videodata.owner_id = users.id LEFT JOIN
mediatypes ON mediatype = mediatypes.id WHERE
!ISNULL(userseen.video_id) != 1 AND mediatype != 50
ORDER BY title, subtitle

I think this happens, because the "userseen" table
isn't in the "SELECT" part of the statement, so you
can't use it in the "WHERE" clause?

kind regards,

Christoph Stoppe aka happenpappen

Discussion

  • Andreas Goetz

    Andreas Goetz - 2005-09-07

    Logged In: YES
    user_id=391980

    Could you retest with latest CVS version? Seems to work...

    Thanks,
    Andi

     
  • Andreas Goetz

    Andreas Goetz - 2005-09-07
    • assigned_to: nobody --> andig2
    • status: open --> open-fixed
     
  • Andreas Goetz

    Andreas Goetz - 2006-10-09
    • status: open-fixed --> closed-fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks