![]() |
| |||||||
| IPB General Support Post your questions here, no bug reports. |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| | #736 (permalink) |
| Member | http://clanmojo.20.forumer.com/ 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 <= 1191013999 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 clanmojo_topics AS t, clanmojo_users AS u, clanmojo_posts_text AS pt, clanmojo_posts AS p WHERE t.forum_id IN () AND t.topic_time <= 1191013999 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 : 92 File : fetchposts.php |
| | |
| | #737 (permalink) |
| Member | I get the following mesage when i open my forum :- 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 <= 1191019350 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 maingalley_topics AS t, maingalley_users AS u, maingalley_posts_text AS pt, maingalley_posts AS p WHERE t.forum_id IN () AND t.topic_time <= 1191019350 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 : 92 File : fetchposts.php Sorry about this, but it is all over my head - any assistance would be appreciated. The Forum address is - http://maingalley.14.forumer.com/ Regards Cliff |
| | |
| | #738 (permalink) |
| Member | http://streetproject.19.forumer.com/ 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 <= 1191059796 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 streetproject_topics AS t, streetproject_users AS u, streetproject_posts_text AS pt, streetproject_posts AS p WHERE t.forum_id IN () AND t.topic_time <= 1191059796 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 : 92 File : fetchposts.php Can u please fix this? thanks |
| | |
| | #739 (permalink) |
| Member | some1 help plz? problem not solved portal has sql error http://clanmojo.20.forumer.com/ i switched to forum so as my members can login without problems so plz fix the portal to enable portal as main page thx |
| | |
| | #742 (permalink) |
| Member | i cant enable portal will it be fixed plz?it keeps saying when i enable portal : 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 <= 1191059796 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 streetproject_topics AS t, streetproject_users AS u, streetproject_posts_text AS pt, streetproject_posts AS p WHERE t.forum_id IN () AND t.topic_time <= 1191059796 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 : 92 File : fetchposts.php http://clanmojo.20.forumer.com/ plz help only forum works i cant enable portal ;/ |
| | |
| | #743 (permalink) |
| Member | can some1 fix the problem plz??? if i switch my forum to portal it says the above message... now i have only forum enabled i want to have it as portal...fix it plz |
| | |
| | #746 (permalink) |
| Member ![]() | I have the portal problem at http://thatonesong.20.forumer.com/ portal is disabled so the error can be seen at http://thatonesong.20.forumer.com/portal.php |
| | |
| | #747 (permalink) | |
| fSupport Manager ![]() ![]() Join Date: Mar 2004 Tournaments Won: 1
Posts: 8,695
Blog Entries: 1 Rep Power: 10 ![]() ![]() fTrader: (23) My Forumer My Country: | Quote:
| |
![]() [http://www.tacticalassistance.co.uk/][http://proxcentral.info/][AJAX Domain Search][Cheap Web Hosting] ![]() ISF REOPENING date: To be announced www.flahost.com The best place for cheap web hosting! | ||
| | |
| | #748 (permalink) |
| Member ![]() | Well, considering that the topic is "ALL ERRORS LIKE THIS..." (and my error is indeed like that) and the debug message appears to be an SQL database query (SQL Error : 1064 You have an error in your SQL syntax) and the fact that I, along with about a hundred other people have posted this error in the phpBB support forum without a single response from the staff I figured this would be as good of a place as any to ask about it. |
| | |
| | #749 (permalink) |
| fSupport Manager ![]() ![]() Join Date: Mar 2004 Tournaments Won: 1
Posts: 8,695
Blog Entries: 1 Rep Power: 10 ![]() ![]() fTrader: (23) My Forumer My Country: | IPB Bug Reports is the section you posted in. YOUR forum is a phpBB forum. Please repost in the correct section. |
![]() [http://www.tacticalassistance.co.uk/][http://proxcentral.info/][AJAX Domain Search][Cheap Web Hosting] ![]() ISF REOPENING date: To be announced www.flahost.com The best place for cheap web hosting! | |
| | |
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mysql errors Again | The Blindman | IPB General Support | 8 | 04-26-2006 11:55 AM |
| [resolved]*Mysql Errors? | XIII | IPB General Support | 3 | 09-20-2004 01:08 PM |
| [resolved]*[being Worked On]*mysql Errors :( | Daz | IPB General Support | 1 | 05-16-2004 12:47 PM |
| [resolved]*Mysql Errors? | cmk2034 | IPB General Support | 0 | 12-31-1969 06:00 PM |