db query @ postbit_display_start

[PntSingularity]

Originally Posted by sarahk

I'm stuck on the same thing (so I appreciate the thread). PntSingularity I'm getting none of the post information when I change to the hook you use! How did you access the post data?

turns out the syntax I was after in the original hook was

$stories = $this->registry->db->query_first

I don't think I ever tried a query_first there. However, I've used the variable Opserty mentioned there with query_read.

$foo = $this->registry->db->query_read('SQL STRING');
while ($bar = $this->registry->db->fetch_array($foo)) {
  /* Do stuff.. */
}
$this->registry->db->free_result($foo);

If you're using showthread_postbit_create you should simply use $db->query (or query_first, query_read or query_write).

If you're not already doing that, you might want to ssh to the server (if you have that possibility) and tail the error log to receive real-time error reporting.
In a command shell (cmd/terminal):

ssh example.com -l root

Replace example.com with your domain and enter your root password.

tail -f /var/log/httpd/error_log

Of course, your log may be in a slightly different location. I'm running apache on Fedora 9 myself.