Forum Hosting  

Go Back   Forum Hosting > phpBB2 Support > phpBB2 Bug Reports

phpBB2 Bug Reports Only phpBB2 errors & bugs should be submitted here


Closed Thread
 
LinkBack Thread Tools Display Modes
Old 02-12-2008, 05:04 PM   #1 (permalink)
Member
 
Rohyan's Avatar
 
Join Date: Oct 2007

Posts: 7
Rep Power: 0 Rohyan is on a distinguished road
fTrader: (0)
fBuck$: 126
Bank: 0
Total fBuck$: 126

My Forumer
My Country:
Default [RESOLVED] fportal bug error help now please!!!!!!

I have had the debug on the fportal for over 4 months now I have made posts in here with no response or no solution to this problem I would really like to have this fixed. I really enjoy forumer and don't really want to switch forums, but I have been patient with this problem and would like a solution
this is the message the fportal gives me


Could not query announcements 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 ') AND t.topic_time <= 1202860928 AND t.topic_poster = u.user_id AND ' at line 23

SELECT t.topic_id, t.topic_time, t.topic_title, pt.post_text, u.username, u.user_id, t.topic_replies, pt.bbcode_uid, t.forum_id, t.topic_poster, t.topic_first_post_id, t.topic_status, pt.post_id, p.post_id, p.enable_smilies FROM thetsviets_topics AS t, thetsviets_users AS u, thetsviets_posts_text AS pt, thetsviets_posts AS p WHERE t.forum_id IN (13,) AND t.topic_time <= 1202860928 AND t.topic_poster = u.user_id AND t.topic_first_post_id = pt.post_id AND t.topic_first_post_id = p.post_id AND t.topic_status <> 2 ORDER BY t.topic_time DESC LIMIT 0,5

Line : 95
File : fetchposts.php

My forums are The_Tsviets :: Home I have the fportal disabled atm
Rohyan is offline  
Old 02-12-2008, 05:40 PM   #2 (permalink)
Confessed Noob
 
SawanM's Avatar
 
Join Date: Dec 2006
Tournaments Won: 4

Posts: 9,087
Rep Power: 13 SawanM has a spectacular aura aboutSawanM has a spectacular aura aboutSawanM has a spectacular aura about
fTrader: (36)
fBuck$: 76,711
Bank: 0
Total fBuck$: 76,711

My Forumer
My Country:
Default Re: fportal bug error help now please!!!!!!

In the news forums youj should only have the forum number of the url inserted in that field.

Sezza Web Directory
Top Web Hosting Reviews|Top 10 Web Hosting|Web Host Rating
Tu ne cede malis, sed contra audentior ito
Do not give in to evil but proceed ever more boldly against it!
SawanM is online now  
Old 02-12-2008, 07:37 PM   #3 (permalink)
Active Forumer
 
Tuitam's Avatar
 
Join Date: Feb 2005

Posts: 552
Rep Power: 4 Tuitam is on a distinguished road
fTrader: (0)
fBuck$: 8,165
Bank: 0
Total fBuck$: 8,165

My Forumer
My Country:
Default Re: fportal bug error help now please!!!!!!

Quote:
SELECT t.topic_id, t.topic_time, t.topic_title, pt.post_text, u.username, u.user_id, t.topic_replies, pt.bbcode_uid, t.forum_id, t.topic_poster, t.topic_first_post_id, t.topic_status, pt.post_id, p.post_id, p.enable_smilies FROM thetsviets_topics AS t, thetsviets_users AS u, thetsviets_posts_text AS pt, thetsviets_posts AS p WHERE t.forum_id IN (13,) AND t.topic_time <= 1202860928 AND t.topic_poster = u.user_id AND t.topic_first_post_id = pt.post_id AND t.topic_first_post_id = p.post_id AND t.topic_status <> 2 ORDER BY t.topic_time DESC LIMIT 0,5
There is a comma after 13. Remove it and all should work again as expected.

Administration Panel => fPortal => News forum(s)

Tuitam

Tuitam is offline  
Old 02-13-2008, 05:15 PM   #4 (permalink)
Member
 
Rohyan's Avatar
 
Join Date: Oct 2007

Posts: 7
Rep Power: 0 Rohyan is on a distinguished road
fTrader: (0)
fBuck$: 126
Bank: 0
Total fBuck$: 126

My Forumer
My Country:
Default Re: fportal bug error help now please!!!!!!

Yes it is working now thanks
Rohyan is offline  
Old 02-13-2008, 07:37 PM   #5 (permalink)
Elite Forumer
 
Wild Cat's Avatar
 
Join Date: May 2007

Location: UK
Posts: 4,863
Rep Power: 7 Wild Cat will become famous soon enoughWild Cat will become famous soon enough
fTrader: (3)
fBuck$: 1,394
Bank: 120,300
Total fBuck$: 121,694

My Forumer
My Country:
Default Re: fportal bug error help now please!!!!!!

Support Resolved!

If you have any further questions, feel free to create a new thread.


Thanks for choosing Forumer!

[No Name Forums][RCX forums][Forum Promotion][IHWC forums]

USEFUL TIP: If your support request gets resolved, click on THREAD TOOLS > MARK THIS THREAD AS SOLVED. This will mark the thread RESOLVED and will close the thread. (please use this tip!)

Please do not PM/e-mail me for support unless I ask you to.
Do a search and if you don't find your answer create a thread with your question and I will be happy to help. I can not be replying the same answer over and over in an e-mail/PM. Thanks.
Wild Cat is offline  
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
20.forumer.com General Error fPortal Treborish phpBB2 General Questions 85 01-26-2008 07:07 AM
fPortal Help Planner phpBB2 General Questions 1 01-14-2007 06:32 PM
Fportal SifoDyas phpBB2 skinning Help 4 05-26-2006 07:08 AM
help with fportal clintb phpBB2 General Questions 1 04-13-2006 07:49 AM
Regarding the fPortal inside_out phpBB2 General Questions 6 02-16-2006 05:22 AM