 | [Solved] Back with a problem! |  |
 Posted: 02/02/2007 4:02 PM |
 |
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
 |
|
|
|
Joined: Jan 06, 2006
Local time: 8:35 PM
|
|
|
|
|
 |
Have been away as one of my boys has been and still is ill, so I'm not sleeping very well and my mind is mushy 
I've made a new forum and was adding mods (using EM, its so much easier when it doesn't matter if it goes wrong..lol!) anyway I got this error message
| Code:
|
Could not obtain topic information
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY p.post_id ASC' at line 5
SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.min_posts_to_view, f.max_posts_to_view, COUNT(p2.post_id) AS prev_posts FROM phpbb2_topics t, phpbb2_forums f, phpbb2_posts p, phpbb2_posts p2 WHERE p.post_id = 7 AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= 7 AND f.forum_id = t.forum_id GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments , f.min_posts_to_view, f.max_posts_to_viewORDER BY p.post_id ASC
Line : 625
File : viewtopic.php
|
And realised I'd forgotten to do the SQL changes.
So I did them and now I got this error message in phpMyAdmin
| Code:
|
Error
SQL query:
ALTER TABLE phpbb2_forums ADD min_posts_to_view mediumint( 8 ) default 0;
MySQL said:
#1060 - Duplicate column name 'min_posts_to_view'
|
I don't know what to do to fix it or what it means.   |
|
|
|
|
| Back to Top |
|
|
| Re: Back with a problem! | |
| Posted: 02/03/2007 5:41 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 4:35 PM
Location: St Pete, FL
|
|
|
|
|
|
Search for max_posts_to_viewORDER in your viewtopic.php file. It will be around line 626. You will want to put a space between max_posts_to_view and ORDER...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Back with a problem! | |
| Posted: 02/04/2007 6:15 AM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 8:35 PM
|
|
|
|
|
|
Oh is that all!! I thought it was going to be a major problem
Thanks so much!!
 |
|
|
|
|
| Back to Top |
|
|
| Re: Back with a problem! | |
| Posted: 02/04/2007 12:40 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:35 PM
Location: St Pete, FL
|
|
|
|
|
|
Yes, that was a fairly simple problem. It appeared that the SQL changes had already been successfully made, so the duplicate field error could be safely ignored...
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
