1 Reply by darrenwhitlen

(2 replies, posted in PunBB 1.3 troubleshooting)

Right OK, looked further into it. Looks like that code block is run before the rewrite.php is run, which is where I had the define for selected pages.

I take my error report back tongue

Go to forum: PunBB 1.3 troubleshooting

2 Topic by darrenwhitlen

(2 replies, posted in PunBB 1.3 troubleshooting)

/include/dblayer/sqlite.php

Lines: 97 + 107

Unless I'm missing something, get_microtime() should actually be microtime() ?

Go to forum: PunBB 1.3 troubleshooting

3 Reply by darrenwhitlen

(9 replies, posted in PunBB 1.3 discussion)

That makes sense Slavok. Is there a list or any documentation that covers the 'PARAMS' parameter of the query builder?
Or any documentation on the internals of PunBB at all?

Go to forum: PunBB 1.3 discussion

4 Reply by darrenwhitlen

(9 replies, posted in PunBB 1.3 discussion)

That has made things easier. Was missing the table prefixes off sad

Thanks for the tip pepak smile

Go to forum: PunBB 1.3 discussion

5 Reply by darrenwhitlen

(9 replies, posted in PunBB 1.3 discussion)

Ahh thank you pepak, that got me further!

I am now getting the follow error:

Database reported: SQL logic error or missing database (Errno: 1).

$query = array(
    'SELECT'    => 't.id, t.poster, t.subject, t.posted, t.first_post_id, t.sticky, p.message',
    'FROM'        => 'topics AS t, posts AS p',
    'WHERE'        => 't.forum_id=2 AND p.topic_id=t.first_post_id',
    'ORDER BY'    => 't.sticky DESC, t.posted DESC',
    'LIMIT'        => '5'
);

I have tried the 2 changes MattF mentioned earlier too, same error.
Shouldn't the errors be a little more.. descriptive? Would make things easier.

Go to forum: PunBB 1.3 discussion

6 Reply by darrenwhitlen

(9 replies, posted in PunBB 1.3 discussion)

Both
    'topics AS t INNER JOIN posts AS p'
and
    'topics AS t LEFT JOIN posts AS p'

return the same error sad

I'm using the sqlite backend if that changes anything?

Go to forum: PunBB 1.3 discussion

7 Topic by darrenwhitlen

(9 replies, posted in PunBB 1.3 discussion)

I'm creating a few static pages that integrates with PunBB.

Using this code: http://pastebin.com/f19233d24, line 24 throws a database error:
    "Database reported: not an error."
But I can't seem to find anything wrong with it?

I had taken the query from another PunBB page and changed as needed, but no dice.
Are their any PunBB database functions I'm missing?

Thanks for any help!

Go to forum: PunBB 1.3 discussion