I've just upgraded from 5.1 to 5.2 following all the steps as required. When re-enabling contributed modules, I had a bizarre message come up saying that db table content_type_story deleted, db table content_type_forum deleted, db table content_type_article deleted - basically all of my content type tables were deleted.
Now all of my content still exists and i can access it through admin, all the content-types show up in the administration section but if I go to the forum, no forum topics show up - if I go to articles, no articles show up. The link between the nodes & their content type appears to have disappeared. If I create new content (eg. an article) it won't show up in the site.

Any suggestions? Ideas? Do you need more info?

Any help would be GREATLY appreciated.

Comments

dww’s picture

dww
we/he/they
commented
Component: update.module » update system

I know it's confusing, but "update.module" is for the part of core (added in 6.x) that checks for available updates to your modules and themes. You're talking about update.php, which is the "update system" component...

lorns’s picture

lorns commented

Apologies for that - thanks for moving to the right spot (I think it's the right spot). To add to the above, I've tried manually adding the node nid & vid to the content_type_x tables to see if that will reinstate the connections - but still no go. Nothing shows up when I go to the forum - yet I am able to view the content by going directly to the node - it just isn't registering it as forum content.
Going to try a database backup restore - but am dubious as I'll need to run the update script again - which is what deleted the tables in the first place.
L

lorns’s picture

lorns commented

So a DB backup did nothing - but I've had a look over the error logs (which I should've done sooner) and I'm getting a MASS of "Not unique table/alias" errors whenever I try to access content.
EG:
Not unique table/alias: 'tn' query:SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM node n INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN term_node tn ON tn.nid = n.nid WHERE (tn.tid = 0) AND ( tn.tid IN (4,5,6,7,8,9) AND n.status = 1 ) ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 5
It appears there are duplicate inner joins happening in each case - which I'm assuming is why content isn't showing up. How did this happen & how do I fix it?
L

dpearcefl’s picture

dpearcefl commented
Component: update system » update.module
Status: Active » Closed (won't fix)

Considering the lack of activity on this issue and that Drupal v5 is no longer supported by fixes or patches, I am going to close this ticket. If this issue still exists and you want to continue to ask for technical support, please reopen and update this ticket.

dww’s picture

dww
we/he/they
commented
Component: update.module » database update system