karmica
28 Mar 07, 16:32
http://www.phpbb.com/community/viewtopic.php?t=354376 (http://www.phpbb.com/community/viewtopic.php?t=354376)
this is my first mod and i'm having trouble with it.
1. I'm not sure if I did the first step correctly. I uploaded the db_update.php file into the mail folder of my forum and put that url in my browser.
When I did that, it went to my login page.
"...forum/login.php?redirect=db_update.php"
was that what it's supposed to do?
If you are going to run the SQL manually, then please
## remember to add your table prefix if other than phpbb_. For all intents and purposes it is probably easier to just run the root/db_update.php file. Upload it to your phpBB root directory and call it in your browser - then delete it.
2. Maybe this is a result of my first mistake. Here are the errors I have when I finished editing all the files.
at the main url:
SQL Error : 1054 Unknown column 'p.post_flagged' in 'field list'
SELECT f.*, p.post_time, p.post_username, p.post_flagged, u.username, u.user_id FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order
Line : 170
File : index.php
at the viewforum.php url:
SQL Error : 1054 Unknown column 'p.post_flagged' in 'where clause'
SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 WHERE t.forum_id = 1 AND t.topic_poster = u.user_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id AND t.topic_type <> 2 AND p.post_flagged <> 1 ORDER BY t.topic_type DESC, t.topic_last_post_id DESC LIMIT 0, 50
Line : 328
File : viewforum.php
btw, it says that i can enter the SQL table manually but i have no idea how to go about doing that. TIA
this is my first mod and i'm having trouble with it.
1. I'm not sure if I did the first step correctly. I uploaded the db_update.php file into the mail folder of my forum and put that url in my browser.
When I did that, it went to my login page.
"...forum/login.php?redirect=db_update.php"
was that what it's supposed to do?
If you are going to run the SQL manually, then please
## remember to add your table prefix if other than phpbb_. For all intents and purposes it is probably easier to just run the root/db_update.php file. Upload it to your phpBB root directory and call it in your browser - then delete it.
2. Maybe this is a result of my first mistake. Here are the errors I have when I finished editing all the files.
at the main url:
SQL Error : 1054 Unknown column 'p.post_flagged' in 'field list'
SELECT f.*, p.post_time, p.post_username, p.post_flagged, u.username, u.user_id FROM (( phpbb_forums f LEFT JOIN phpbb_posts p ON p.post_id = f.forum_last_post_id ) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) ORDER BY f.cat_id, f.forum_order
Line : 170
File : index.php
at the viewforum.php url:
SQL Error : 1054 Unknown column 'p.post_flagged' in 'where clause'
SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_posts p2, phpbb_users u2 WHERE t.forum_id = 1 AND t.topic_poster = u.user_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id AND t.topic_type <> 2 AND p.post_flagged <> 1 ORDER BY t.topic_type DESC, t.topic_last_post_id DESC LIMIT 0, 50
Line : 328
File : viewforum.php
btw, it says that i can enter the SQL table manually but i have no idea how to go about doing that. TIA