VbForum block broke my site :eek:

[peach]

When I created it all was still working, then I activated it in Flexiblock (does that matter?), and BAM I got a databse error.

Then I went tto my frontpage and I get this:

Database error in vBulletin 3.5.4:

Unknown column 'users.name' in 'field list'
query: SELECT n.nid, n.type AS n_type, n.title AS n_title, n.changed AS n_changed, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp FROM drupal_node n LEFT JOIN drupal_node_comment_statistics node_comment_statistics ON n.nid = node_comment_statistics.nid LEFT JOIN user users ON n.uid = users.uid WHERE n.status = '1' ORDER BY node_comment_statistics.last_comment_timestamp DESC LIMIT 0, 10

MySQL Error :
Error Number : 0
Date : Tuesday, May 30th 2006 @ 02:06:27 PM
Script : http://www.clearwind.nl/zooi/VbDrupal/
Referrer :
IP Address : 82.172.96.127
Username : peach
Classname : vb_database



How do I fix this? And why did this happen with a module that comes with the system :confused:
I get this error on every Drupal page

ps The flexiblock was placed in node.tpl.php below each post,

[elmuerte]

that doesn't look like a query the vbforumblocks module would produce.

[peach]

that doesn't look like a query the vbforumblocks module would produce.
it happend after clicking submit, when enabling the vbforumblock in flexiblock

[peach]

I deleted the vbforum entry of the block in question in the drupal_forum_blocks table, but my site is still busted, what now?

[peach]

oh wait, the error did change, now it's just this:

There seems to have been a problem with the VbDrupal forums database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience.


edit:now I also get the vbulletin db error error again, ...confusion

[elmuerte]

what other modules are you using? flexiblock looks "vbdrupal 4.6 safe"

or is this something you manually added?

[peach]

flexiblock was in use before the error occured, without problems.

Here is a list of the modules I'm using, all of the enabled ones worked without problems, until now:
http://clearwind.nl/zooi/vbdmods.gif

Is there an easy way to at least get the site up again? can I like hardcore-disable something to prevent the error from occuring?

[sifuhall]

Have you (or are you able to) disabled flexiblock?

Also, does the email contain more info about the error?

[peach]

hmm it didn't really send me an email.
I'm not able to load any Drupal page, so it would need to disabled from phpmyadmin, does anyone know how to do that?
Then again, there might be a chance that the db is corrupted elsewere, judging from the error it might also be the statistics module?

[peach]

oh wait I'll just rename flexiblock.module duh

[peach]

right, so now my site is accessible again, half of it, because I use flexiblock a lot. And for some reasons ie doesn't display anything at all, though it loads the website source.

However, the module admin page is not accessible, it gives this error:

Database error in vBulletin 3.5.4:

Unknown column 'users.name' in 'field list'
query: SELECT n.nid, n.type AS n_type, n.title AS n_title, n.changed AS n_changed, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp FROM drupal_node n LEFT JOIN drupal_node_comment_statistics node_comment_statistics ON n.nid = node_comment_statistics.nid LEFT JOIN user users ON n.uid = users.uid WHERE n.status = '1' ORDER BY node_comment_statistics.last_comment_timestamp DESC LIMIT 0, 10

MySQL Error :
Error Number : 0
Date : Wednesday, May 31st 2006 @ 02:06:24 AM
Script : http://www.clearwind.nl/zooi/VbDrupal/admin/modules
Referrer : http://www.clearwind.nl/zooi/VbDrupal/admin/menu
IP Address : 82.172.96.127
Username : peach
Classname : vb_database


Looks like sort of the same error again, but where does it come from :|

edit:this error does not occur when I load the bluemarine theme, so maybe the error has to do with flexiblock code in my template

[peach]

Okay, site is completely recovered now, I'm not able to reproduce the problem, the forum blocks seem to work as advertised now :)

I think the problem might have been caused my packet lost, since my ISP went down yesterday, and around the downtime the connection was slower then normal.