Get your forum today!

ColonelL · 09-04-2007, 05:04 PM

Hi, when I enable the portal to be used as the main page for my site, I get that error when I try to view the site. I havent changed any info for the portal that I am aware of. Could someone help me please? The message of the error is underneath, and this is my site, http://rtsboards.20.forumer.com/

Thanks! (Sorrry I dont know what that prefix is for, but 18 was the closest to mine which is 20, dont yell at me I'm new here lol)

Quote:

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 <= 1188946398 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 rtsboards_topics AS t, rtsboards_users AS u, rtsboards_posts_text AS pt, rtsboards_posts AS p WHERE t.forum_id IN () AND t.topic_time <= 1188946398 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,3

Line : 86
File : fetchposts.php

AwptimusPrime · 09-04-2007, 05:05 PM

I believe this error is erroring due to the fact that HTML is currently disabled for all forums. This is because it is being updated.

ColonelL · 09-04-2007, 05:09 PM

Ah, thanks for the reply. I only started this a few hours ago so thats proberly it! I'll see if its working tomorrow if its just an update, I hope it is

I dont like errors lol.

AwptimusPrime · 09-04-2007, 05:11 PM

Well a server was hacked recently, so the technical staff has been working to better the HTML on the forums. As a result this may take some time.

**Pandemix** · 09-04-2007, 05:14 PM

The reason why you couldn't use the .18 prefix is because your forum is not IPB, it's phpBB.

For now, turn off the portal so you can access your board. I will write out a report so you can get that problem fixed.

From time to time, try turning on your portal again and see if it works. If not, turn it off again until it's fixed.

ColonelL · 09-04-2007, 05:14 PM

I tryed that and still getting the error, I'll turn the portal off then now. Thanks for the replys, the tech support is great here!

AwptimusPrime · 09-04-2007, 05:18 PM

Quote:

Originally Posted by Pandemix

The reason why you couldn't use the .18 prefix is because your forum is not IPB, it's phpBB.

For now, turn off the portal so you can access your board. I will write out a report so you can get that problem fixed.

From time to time, try turning on your portal again and see if it works. If not, turn it off again until it's fixed.

Ahh I was fooled to lol. Sorry about that.

DnB4me · 09-04-2007, 11:37 PM

Quote:

Originally Posted by AwptimusPrime

I believe this error is erroring due to the fact that HTML is currently disabled for all forums. This is because it is being updated.

This has nothing to do with html being disabled or enabled. First you need to understand mysql statements, then you need to understand how they correspond to certain files when you get errors like this. Just by looking at that error, you are trying to fetch a certain amount of posts to be displayed on your portal page? What are your settings just out of curiosity? I don't think you can fix this, but I would still like to know.

Edit: I just checked further into your problem. Please post a screen shot of your fportal settings, I know exactly what you did wrong. Or, if I'm not around quick enough you will need to change the "news forum" or maybe one of the other settings in your fportal.

Quote:

Originally Posted by AwptimusPrime

check the manual that corresponds to your MySQL server version for the right syntax to use near ')

notice the ') this means you left that field blank, you need to insert a proper ID into that field, if you don't want that block to show, just enter 0

ColonelL · 09-05-2007, 07:27 AM

Well it first happened when I tryed to add the news feature to the portal. When I tryed to view the portal that error occured, I deleted the link in the news thingy and it still kept comming up as an error when I tryed to view the portal. Heres screeny of the settings anyways

DnB4me · 09-05-2007, 08:07 AM

Ok, well like I said you have to fields blank, you need to enter a forum ID number if you want them to show. If you don't know what a forum ID number is you can simply hover your mouse over the forum link and it will give you the number. Just look at the end of the link example viewforum.php?f=9. f=9 equals the forum ID is 9. If you want to use that forum just simple enter 9, if you want to use multiple forums, just separate the numbers with a comma like 9,7,1 etc etc

Also for security purposes, don't provide a screen shot that has your SID in it, as it could potentially leave a gateway open for someone to hack your admin access.

ColonelL · 09-05-2007, 08:29 AM

Thanks alot its fixed! I didnt think that those 2 black fields could of caused that.

Sometimes I think my brain stops working, I blanked out the sid now, thanks for pointing that out as well

09-04-2007, 05:05 PM	#2 (permalink)
AwptimusPrime Banned User Join Date: Sep 2006 Tournaments Won: 2 Posts: 2,484 Rep Power: 0 fTrader: (22) fBuck$: 337 Bank: 101,593 Total fBuck$: 101,930 Send fBuck$ » My Forumer My Country:	Re: SQL Error 1064? I believe this error is erroring due to the fact that HTML is currently disabled for all forums. This is because it is being updated.

09-04-2007, 05:09 PM	#3 (permalink)
ColonelL Member Join Date: Sep 2007 Location: U.K Posts: 13 Rep Power: 0 fTrader: (0) fBuck$: 170 Bank: 0 Total fBuck$: 170 Send fBuck$ » My Forumer My Country:	Re: SQL Error 1064? Ah, thanks for the reply. I only started this a few hours ago so thats proberly it! I'll see if its working tomorrow if its just an update, I hope it is I dont like errors lol.

09-04-2007, 05:11 PM	#4 (permalink)
AwptimusPrime Banned User Join Date: Sep 2006 Tournaments Won: 2 Posts: 2,484 Rep Power: 0 fTrader: (22) fBuck$: 337 Bank: 101,593 Total fBuck$: 101,930 Send fBuck$ » My Forumer My Country:	Re: SQL Error 1064? Well a server was hacked recently, so the technical staff has been working to better the HTML on the forums. As a result this may take some time.

09-04-2007, 05:14 PM	#5 (permalink)
Pandemix Senior Forumer Join Date: Feb 2006 Location: En Jay Posts: 1,767 Blog Entries: 1 Rep Power: 4 fTrader: (14) fBuck$: 444 Bank: 1,256 Total fBuck$: 1,700 Send fBuck$ » My Forumer My Country:	Re: SQL Error 1064? The reason why you couldn't use the .18 prefix is because your forum is not IPB, it's phpBB. For now, turn off the portal so you can access your board. I will write out a report so you can get that problem fixed. From time to time, try turning on your portal again and see if it works. If not, turn it off again until it's fixed.
	KOLAKUBE BLOG

09-04-2007, 05:14 PM	#6 (permalink)
ColonelL Member Join Date: Sep 2007 Location: U.K Posts: 13 Rep Power: 0 fTrader: (0) fBuck$: 170 Bank: 0 Total fBuck$: 170 Send fBuck$ » My Forumer My Country:	Re: SQL Error 1064? I tryed that and still getting the error, I'll turn the portal off then now. Thanks for the replys, the tech support is great here! Last edited by ColonelL; 09-04-2007 at 05:16 PM.

Get your forum today!

Explore

Support

About

09-05-2007, 07:27 AM	#9 (permalink)
ColonelL Member Join Date: Sep 2007 Location: U.K Posts: 13 Rep Power: 0 fTrader: (0) fBuck$: 170 Bank: 0 Total fBuck$: 170 Send fBuck$ » My Forumer My Country:	Re: SQL Error 1064? Well it first happened when I tryed to add the news feature to the portal. When I tryed to view the portal that error occured, I deleted the link in the news thingy and it still kept comming up as an error when I tryed to view the portal. Heres screeny of the settings anyways Last edited by ColonelL; 09-05-2007 at 08:26 AM.

09-05-2007, 08:07 AM	#10 (permalink)
DnB4me Banned User Join Date: May 2007 Posts: 308 Rep Power: 0 fTrader: (1) fBuck$: 10,922 Bank: 0 Total fBuck$: 10,922 Send fBuck$ » My Forumer My Country:	Re: SQL Error 1064? Ok, well like I said you have to fields blank, you need to enter a forum ID number if you want them to show. If you don't know what a forum ID number is you can simply hover your mouse over the forum link and it will give you the number. Just look at the end of the link example viewforum.php?f=9. f=9 equals the forum ID is 9. If you want to use that forum just simple enter 9, if you want to use multiple forums, just separate the numbers with a comma like 9,7,1 etc etc Also for security purposes, don't provide a screen shot that has your SID in it, as it could potentially leave a gateway open for someone to hack your admin access. Last edited by DnB4me; 09-05-2007 at 08:11 AM.

09-05-2007, 08:29 AM	#11 (permalink)
ColonelL Member Join Date: Sep 2007 Location: U.K Posts: 13 Rep Power: 0 fTrader: (0) fBuck$: 170 Bank: 0 Total fBuck$: 170 Send fBuck$ » My Forumer My Country:	Re: SQL Error 1064? Thanks alot its fixed! I didnt think that those 2 black fields could of caused that. Sometimes I think my brain stops working, I blanked out the sid now, thanks for pointing that out as well

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
phpBB:Critical Error (Error creating new session)	arnaldo	phpBB2 Bug Reports	43	06-23-2007 06:40 AM
sql error 1064 ?!	kafrils	phpBB2 Bug Reports	2	04-26-2007 09:49 AM
Шта да радим? Missing option in ACP!	Blonde	IPB General Support	5	10-27-2006 01:36 PM
phpBB : Critical Error (Error creating new session)	arnaldo	phpBB2 Bug Reports	0	08-02-2006 09:53 AM
Server 7: Critical Error - Error Updating Session Key	Sophie	phpBB2 Bug Reports	6	01-09-2006 05:20 PM