[DEV] phpBBToGo 1.1.5

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
timconstan
Registered User
Posts: 62
Joined: Tue Oct 29, 2002 5:50 pm
Contact:

Post by timconstan »

zone97 wrote: sorry to take so long to get back to you as well. here is there error i get this time.

Code: Select all

SELECT post_id FROM phpbb_posts AS p WHERE p.topic_id = 25
any clue?


OK, now you need to compare the select against your database. Is there a phpbb_posts table, does the phpbb_posts table contain a field named post_id, and is there a record in the table where topic_id = 25?

If you use MySQL and phpMyAdmin installed, you can try to copy and paste your select statement and run it and see what happens.

If you use MySQL, but don't have phpMyAdmin installed, I would highly recommend it.

Hope that helps.

- Tim
User avatar
zone97
Registered User
Posts: 76
Joined: Thu Jul 24, 2003 4:00 pm
Contact:

Post by zone97 »

myphpadmin does not report an error for the above sql.. here is the results.

Code: Select all

SQL-query : [Edit] [Explain SQL] [Create PHP Code]
SELECT post_id
FROM phpbb_posts AS p
WHERE p.topic_id = 25 LIMIT 0 , 30
im confused, do you know of any mods that would conflict with this.. The mods I have installed that make data base changes are..

attach mod (removed)
guestbook
spellcheck
a few avatar changes

cant think of any other.
timconstan
Registered User
Posts: 62
Joined: Tue Oct 29, 2002 5:50 pm
Contact:

Post by timconstan »

The results you show of your SQL query is just the SQL code - what DATA does the query return - any?

Sorry I can't help you with the mod conflicts. I haven't installed any mods in my testing of phpBBToGo, and I havn't had any reports of any conflicts.
timconstan
Registered User
Posts: 62
Joined: Tue Oct 29, 2002 5:50 pm
Contact:

Post by timconstan »

I think this will fix the problem Zone97 and another user were having.

Watch for a new release of phpBBToGo that will fix the problem. In the meantime, here's how you can fix it:

Open your phpbbtogo.php file in a text editor

Find the function phpbb_fetch_thread($topic_id = '')

Within that function find:

Code: Select all

$sql = "SELECT post_id FROM " . POSTS_TABLE;
$sql = $sql . " AS p WHERE p.topic_id = " . $topic_id;
On the second line, get rid of the "AS p " - leave the space between the quote and WHERE
Now get rid of the "p." before topic_id

Now find the WHILE loop within that same function:

Code: Select all

while ($row = $db->sql_fetchrow($result))
{
      	 $posts_list .= $row[0] . ',';
}
In that while, relace the "[0]" with "[post_id]"

Now save & upload phpbbtogo.php
Post Reply

Return to “[2.0.x] MODs in Development”