When attempting to go to the "Site analytics" admin page, I receive this error:

/admin/reports/analytics

Error

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'databasenamehere.og' doesn't exist: SELECT n.created FROM {og} og INNER JOIN {node} n ON og.gid = n.nid WHERE n.created >= :period ORDER BY n.created DESC ; Array ( [:period] => 1348204341 ) in Quant->execute_query() (line 110 of /home/account/public_html/drupal/sites/all/modules/quant/plugins/Quant.inc).

I think I had reported this or something like this before, but even with the latest dev version it's still not working properly and will be disabled until a stable release is available since I can't even tell if it's properly recording data (layman's terms working even if displaying the results isn't working).

I see 700 installs of this module and have to wonder what module I have enabled that isn't being used by others that may be causing a problem, either way, I've reported the error which should demonstrate the code bug. I'll try back next year. :(

Quant 7.x-1.0-beta2+4-dev
Drupal 7.16

Comments

mstef’s picture

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

Yes, we already had this conversation over at #1749360: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbnamehere.og' doesn't exist:.

I hate to tell you, but I believe this is an issue with your environment.

Do this for me... install a completely clean Drupal 7, with just OG and Quant. See if it works. It works perfectly for me, and being that you're the only person to report this, I'm guessing everyone else too.

Maybe it would be helpful if you listed all of your active modules here as well. Something is rewriting the query (or something strange). The issue might be with your settings.php too (check out the db array).

mstef’s picture

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

I marked a new thread that had this same error as a duplicate of this so we can discuss it in one place. The other reporter mentioned that they are using OG2. I assume, now, that this is also your case. You never mentioned that..

mstef’s picture

mstef commented

Due to the new nature of how OG2 uses fields to handle group-type nodes without a single centralized table ({og}), I'm pretty sure Quant will not be able to support OG2. I'm investigating.

mstef’s picture

mstef commented
Title: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'databasenamehere.og' doesn't exist » OG 7.x-2.x not supported
Category: bug » feature
mstef’s picture

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

I just made a commit to improve OG integration. First, the group joins query was limited to only include user joins (since OG treats group content as node joins). I also removed the incorrect joining of the node table. Last, I removed group creation if you're using og-7.x-2.x.

I'm going to mark this as postponed until someone can find a single query (not a function) that will return all groups in 7.x-2.x and when they were created.

I'll tag a new release in a few minutes.

mstef’s picture

mstef commented

beta4 released: http://drupal.org/node/1834382

This stops the error if you're using og2, but like I said, it also removes the "Group creation" quant.

deanflory’s picture

deanflory commented

Cool, will check it out.