I just upgraded from 4.7 to 5.x-1.1 and for the most part everything looks good except:

When I browse for projects, none of them show up under Name, Date or Category. But If I directly go to a project's URL it shows up. I only have one level of taxonomy setup so I believe "Browse by Category" won't work but what about the other two? I did create a new project after upgrading and that project does show up when I "Browse by Name".

The other problem is that if I go to some project pages, like "View all support requests", I get these warnings:

user warning: Unknown column 'p.sid' in 'where clause' query: SELECT COUNT(n.nid) FROM node n INNER JOIN project_issues p ON p.nid = n.nid INNER JOIN node_revisions r ON r.vid = n.vid INNER JOIN users u ON p.assigned = u.uid WHERE n.status = 1 AND ((p.pid = '1557')) AND ((p.category = 'support')) AND ((p.sid = '1' OR p.sid = '8' OR p.sid = '13' OR p.sid = '14' OR p.sid = '2' OR p.sid = '3' OR p.sid = '4' OR p.sid = '5' OR p.sid = '6' OR p.sid = '7'))

user warning: Unknown column 'p.sid' in 'where clause' query: SELECT n.nid FROM node n INNER JOIN project_issues p ON p.nid = n.nid INNER JOIN node_revisions r ON r.vid = n.vid INNER JOIN users u ON p.assigned = u.uid WHERE n.status = 1 AND ((p.pid = '1557')) AND ((p.category = 'support')) AND ((p.sid = '1' OR p.sid = '8' OR p.sid = '13' OR p.sid = '14' OR p.sid = '2' OR p.sid = '3' OR p.sid = '4' OR p.sid = '5' OR p.sid = '6' OR p.sid = '7')) ORDER BY n.changed DESC LIMIT 0, 20

Comments

hunmonk’s picture

hunmonk commented
Status: Active » Postponed (maintainer needs more info)

which version of 4.7 where you upgrading from 4.7-1.x, or 4.7-2.x?

check your {project_issues} database table -- does it have a 'sid' column? this column existed in both 4.7 and 5.x, so i don't know why it would be missing after an upgrade.

if you go to a project's edit page does it show the correct taxonomy terms? if you save the page does the project then appear in the taxo listings?

aclight’s picture

aclight commented

@bkark: I assume you've checked this already, but make sure that you updated your database schema after upgrading the project module.

bkark’s picture

bkark commented

So I get the same "sid" errors on my 4.7 site. I guess it wasn't updated correctly from a version prior to 4.7.

I'm not sure what 4.7 version I have for the project module. How can I tell?

I did run the update for the modules in Drupal 5 and did get some errors when updating project_issue. I tried to print them out by my browser crashed and so I don't know exactly what the errors were. I assume it had something to do with "sid" missing.

As far as my other problem, if I go directly to a project page it does show the correct taxonomy term. Saving the project does not make it appear when browsing the taxonomy it belongs to.

If I can't figure this all out I think I might just do a clean install on Drupal 5 and re-create all the projects.

Thanks!

hunmonk’s picture

hunmonk commented

i don't think there's enough here to help you troubleshoot. the missing sid column is very bizarre, and certainly not from the 4.7 -> 5 upgrade.

not sure about the taxo stuff. it sounds like you may have missed some important db updates somewhere along the line...

softtouch’s picture

softtouch commented

DELETED

babbage’s picture

babbage commented
Status: Postponed (maintainer needs more info) » Fixed

Cleaning up old issues. This can't still be active. Marking as fixed.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.