My advanced forum module was working fine. Then yesterday I installed Organic Group module but didn't like it so removed it. Then I added memetracker module and deleted that as well. Today I added privatemessages and guestbook. Now when I go to view a forum or create a new topic I get this error message
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(n.nid) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE n.st' at line 1 query: SELECT DISTINCT n.title, DISTINCT(n.nid) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE n.status = 1 AND tn.tid = 13 AND n.nid != 345 ORDER BY n.created DESC LIMIT 5 in /home/MYSITE/public_html/drupal/includes/common.inc(1645) : eval()'d code on line 8.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE tn.' at line 1 query: SELECT COUNT(DISTINCT DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE tn.tid =13 AND n.nid !=345 LIMIT 5 in /home/MYSITE/public_html/drupal/includes/common.inc(1645) : eval()'d code on line 9.
I also posted this in the advanced forum module error tracking page but was told that this error is not AF related. Any ideas as to where to start looking?
Comments
=-=
why are you adding and removing modules from your production installation? New modules, themes and such should be tested against a test install so that these things don't happen to your producton environment.
Revert to the backup you took before you started throwing modules at the installation and removing them.
It is a test environment.
It is a test environment.
=-=
ok, then scrub and redo.
I build my test environments using backups with preset settings and the like. Matter of fact there is a module that helps with this in the downloads area. Then when I screw the pooch, I'm quickely back up and running.
Question... Do you know if
Question...
Do you know if it's possible to start with a fresh install and just move over the nodes, users and taxonomy?
=-=
if its a test site you can use devel.module to auto generate nodes taxonomy and users. Thus whatever is in your test site now, isn't important, or at least, shouldn't be..... if it's a test site.
it is a test environment but
it is a test environment but I have already created a bunch of data that I need to keep. Blog entries, etc. Is it easy to move just these to another database?
=-=
I don't have the answer, you will need to keep specific tables. node, revisions and maybe some others. I've never needed to do what you are asking. Maybe someone with more experience inside the database will pop in.
What you have then isnt a test site, test sites shouldn't reqire keeping anything. a true test site is one you can wipe completely clean and start over.
Either way, you can use a back up you created before you started messing with the modules.