serious problem!!

[JP Stones]

Hi guys, Ihave a serious problem on my site
http://216.10.4.112/forums/index.php and I have no idea how to fix it, could anyone suggest anything?
Thanks ever so much!
JP

[phumphries]

It looks like you are calling fetch_array with an invalid argument. If you recently modified your code to do a special query for something, look there first. I notice that you are receiving 15 error messages and have 16 forums and there is no result beside your Forum Moderated by status line on each forum. Could be related.

[JP Stones]

Thanks, I had it down to the moderators as well, but that is all I could get.

I don't think I modified that part of my code to be honest, where should I look? What files?

Thanks a lot, sorry I'm brash but I need a solution! :(
JP

[phumphries]

The error is being generated in a routine called fetch_array that is called to extract each row from a result returned by a query (hence the need for a query identifier). If you saved a backup (of course you did), restore the original version of each file you modified whilst trying to get the moderator hack running and make sure that your system was working, before. Then have a look in the files you modified for any code that calls fetch_array; I would look for a simple error like misspelling the variable you are passing, but you may also have made an error in the line assigning the result variable, which would be calling the query function, just before you use the fetch_array function.

[JP Stones]

thanks for that - I only ever touched the templates in VB, not any other files. Could I still have caused this error?
JP

[Freddie Bingham]

Nope - if you have never modified your files then you didn't cause it. Replace your index.php just to be safe though. If that doesn't work then perhaps your forumpermissions table has become corrupted.

[phumphries]

As rangersfan implied, the templates only use existing variables; they do not trigger function calls, themselves. If replacing your index.php file does not fix it, the only thing other than database/table corruption would be a previously unknown bug. Since $moderators is not a new variable in this context, that is doubtful.

[doron]

seems to work now

[phumphries]

Well... Share; what did you do to fix it?

[JP Stones]

would you believe nothing......it just fixed itself.

Does this happen with mySQL a lot?

[phumphries]

mySQL is a relational database so that it is possible that something happened to break a relationship and then you made some more posts, one of which fixed the relationship by putting in some new data over bad. That would explain "fixed itself" type behaviour. Hopefully, it does not happen, often. Since vB is running some huge boards, unless other folk are keeping quite (yeah, right!), I would say it looks like a rare thinng.

[JP Stones]

one would hope so.... :(