SQL Error : 1064 You have an error in your SQL syntax

Hulp nodig bij een modificaties of op zoek naar een MOD? Bekijk ons archief. Support wordt helaas niet meer verleend.
Forumregels

Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
phpBB2.0.x
Gesloten
wittebolx
Berichten: 6
Lid geworden op: 16 jan 2008, 22:53

SQL Error : 1064 You have an error in your SQL syntax

Bericht door wittebolx » 16 jan 2008, 23:09

  • Adres van je forum: http://www.wittebolx.com/forum
    Event. modificaties op je forum:
    XFire Messenger 1.0.0 Mondego 2.0.22 subSilver; cs_green; cs_red english
    Report Posts 1.2.3c wGEric 2.0.22 subSilver; cs_green; cs_red english
    Staff Posts 1.0.9 tehbmwman 2.0.22 subSilver; cs_green; cs_red english
    Xfire Miniprofile Mod 1.0.0c saabirsa 2.0.22 subSilver; cs_green; cs_red english
    Resend Activation Email 1.0.1 damnian 2.0.22 subSilver; cs_green; cs_red english
    SendMeFile Mod 1.0.1 rodman 2.0.22 subSilver; cs_green; cs_red english
    Memberlist Access 1.0.3 Joe Belmaati 2.0.22 subSilver; cs_green; cs_red english
    Log IP Address on Registration 1.0.1 TerraFrost 2.0.22 subSilver; cs_green; cs_red english
    ImageShack Mod 1.3.3 thirstyg 2.0.22 subSilver; cs_green; cs_red english
    Posts in Last 24 Hours 1.0.1 Throckmorton 2.0.22 subSilver; cs_green; cs_red english
    Proxy Revealer 2.0.0 TerraFrost 2.0.22 subSilver; cs_green; cs_red english
    Paypal Link in Profile 1.0.0 eviL3 2.0.22 subSilver; cs_green; cs_red english
    Change Registration Date 1.0.1 alexi02 2.0.22 subSilver; cs_green; cs_red english
    Another News Mod 1.0.1 Janmarques 2.0.22 subSilver; cs_green; cs_red english
    Admins/mods color management 2.2.0 -=ET=- 2.0.22 subSilver; cs_green; cs_red english
    Admin Contacts List 1.0.0 edi82 2.0.22 subSilver; cs_green; cs_red english
    ActionMod 1.0.4a dvandersluis 2.0.22 subSilver; cs_green; cs_red english
    ACP Site Announcement Centre 1.2.3 lefty74 2.0.22 subSilver; cs_green; cs_red english
    Birthdays 3.0.0 TerraFrost 2.0.22 subSilver; cs_green; cs_red english
    Forum Auth by Post Count 1.0.0 drathbun 2.0.22 subSilver; cs_green; cs_red english
    Edit User's Postcount 1.0.3 tomlevens 2.0.22 subSilver; cs_green; cs_red english
    View Next/Previous at Bottom of Topic 1.0.0 StaticXD00d 2.0.22 subSilver; cs_green; cs_red english
    60 Minute Time Online 1.0.1 Rambo4104 2.0.22 subSilver; cs_green; cs_red english
    EasyMOD 0.3.0 Nuttzy 2.0.22 subSilver; cs_green; cs_red english
    Wanneer ontstond het probleem?
    na dat ik een reply heb geplaatst krijg ik een scherm met:
    Your message has been entered successfully.

    Click Here to view your message

    Click Here to return to the forum
    wanneer ik op return to the forum klik is er niks aan de hand, wanneer ik op view your message klik krijg ik een error, maar de reply is wel gespost.
    phpBB versie: 2.0.22
    ja
    Heb je onlangs iets veranderd aan je forum?
    nee
    Wat is het probleem?
wanneer ik op return to the forum klik is er niks aan de hand, wanneer ik op view your message klik krijg ik een error, maar de reply is wel gespost.
error =
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,t.topic_staff, 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 phpbb_topics t, phpbb_forums f, phpbb_posts p, phpbb_posts p2 WHERE p.post_id = 6 AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= 6 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 : 157
File : viewtopic.php
..

Gebruikersavatar
Ramon Fincken
Berichten: 2552
Lid geworden op: 27 nov 2005, 23:15
Locatie: Diemen
Contacteer:

Re: SQL Error : 1064 You have an error in your SQL syntax

Bericht door Ramon Fincken » 17 jan 2008, 16:55

ga naar die regel en zoek

Code: Selecteer alles

f.max_posts_to_viewORDER BY
vervang door

Code: Selecteer alles

f.max_posts_to_view ORDER BY
zie je de spatie ??
Wijziging: Verplaatst naar mod forum
Freelance webdevelopment, including phpbb2 scripting!

Website founder van: phpBBinstallers.net phpBBantispam.com
Mods: zie op http://www.phpbb.com Blog in wording: RamonFincken.com

wittebolx
Berichten: 6
Lid geworden op: 16 jan 2008, 22:53

Re: SQL Error : 1064 You have an error in your SQL syntax

Bericht door wittebolx » 17 jan 2008, 18:55

Geweldig!!
echt zon klein foutje en alles loopt verkeerd.
echt bedankt.!
(zeker gezien de snelle reactie)

Gebruikersavatar
Ramon Fincken
Berichten: 2552
Lid geworden op: 27 nov 2005, 23:15
Locatie: Diemen
Contacteer:

Re: SQL Error : 1064 You have an error in your SQL syntax

Bericht door Ramon Fincken » 17 jan 2008, 19:00

Toppie !
Freelance webdevelopment, including phpbb2 scripting!

Website founder van: phpBBinstallers.net phpBBantispam.com
Mods: zie op http://www.phpbb.com Blog in wording: RamonFincken.com

Gesloten