Hi everyone.
I have spent the last 9 hours doing an upgrade from an old outdated version (1.3.11) to the latest version. This migration was also from unix/msql to windows/mssql
I have been running into 2 different problems that I cant seem to fix and I wanted to find out if anyone could help me out with them.
Currently when I try to even view a page I am getting the following SQL error:
An SQL error has occurred. Please see error.log for details. - SELECT s.sid, s.uid, s.draft_flag, s.tid, s.date, s.title, cast(s.introtext as text) as introtext, cast(s.bodytext as text) as bodytext, s.hits, s.numemails, s.comments, s.trackbacks, s.related, s.featured, s.show_topic_icon, s.commentcode, s.trackbackcode, s.statuscode, s.expire, s.postmode, s.frontpage, s.in_transit, s.owner_id, s.group_id, s.perm_owner, s.perm_group, s.perm_members, s.perm_anon, s.advanced_editor_mode, dbo.UNIX_TIMESTAMP(s.date) AS day, u.username, u.fullname, u.photo, t.topic, t.imageurl FROM gl_stories AS s, gl_users AS u, gl_topics AS t WHERE (s.uid = u.uid) AND (s.tid = t.tid) AND (date <= getUTCDate()) AND (draft_flag = 0) AND frontpage = 1 AND (s.perm_anon >= 2) AND 0 ORDER BY featured DESC, date DESC
I think this error started happening after I updated the topics but I'm not too sure, I know when I remove AND 0 from the query it does work, but I don't konw exactlly what this 0 is supposed to be a value for, or why it is breaking.
I also get kind the same error when trying to view directory.php
An SQL error has occurred. Please see error.log for details. - SELECT YEAR(date) AS year FROM gl_stories WHERE (draft_flag = 0) AND (date <= getUTCDate()) AND 0 AND (perm_anon >= 2) GROUP BY YEAR(date) ORDER BY YEAR(date) DESC
And finally when I go to the admin section and login I get this error. It seems to be logging me in because the session table gets updated with the userid.
An SQL error has occurred. Please see error.log for details. - SELECT DISTINCT ft_name FROM gl_access,gl_features WHERE ft_id = acc_ft_id AND acc_grp_id IN ()
Thanks, and any help you can give me will be great.
O and you can get access to the site here:
http://dev.truepunk.com