Advertisement
Guest User

Vanilla Porter IPB 3 Error

a guest
Dec 5th, 2014
219
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. select
  2. t.*,
  3. case
  4. when p.description <> '' and p.post is not null then concat('<div class="IPBDescription">', p.description, '</div>', p.post)
  5. when p.description <> '' then p.description
  6. else p.post
  7. end as post,
  8. case when t.state = 'closed' then 1 else 0 end as closed,
  9. 'IPB' as Format,
  10. p.ip_address,
  11. p.edit_time
  12. , from_unixtime(start_date) as start_date_Date, from_unixtime(edit_time) as edit_time_Date
  13. from topics t
  14. left join posts p
  15. on t.topic_firstpost = p.pid
  16. where t.tid between -2000000000 and 2000000000;Unknown column 'p.description' in 'field list'
  17. Error: (1024) Unknown column 'p.description' in 'field list'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement