Posted March 11, 201114 yr comment_46134 Hallo, ich habe ein Problem mit der IP.Gallerie. Jedes mal wenn ich sie aufrufe, kommt es zu einem SQL Error. Weiß jemand wie ich das Problem lösen kann? Leider kenne ich mich noch nicht so gut mit dem IP.Board aus, da ich es noch nicht sehr lange habe und es in dem Zeitraum seit meinem Kauf auch noch nicht intensiv benutzt habe. Ich würde mich daher freuen wenn mir jemand helfen könnte! Systeminformationen: Webserver: IIS 7.5 Datenbankserver: Microsoft SQL Server 2008 R2 Enterprise Edition (64-bit) Gruß Koscomo Fehlermeldung: ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 11 Mar 2011 08:45:40 +0000 Error: 156 - Falsche Syntax in der Nähe des OR-Schlüsselworts. IP Address: ***.***.***.*** - /index.php?app=gallery ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- MSSQL query error: SELECT TOP 30 a.*,i.*,m.members_display_name, m.members_seo_name,rating.rate, rating.rdate FROM ipb_gallery_albums_main a LEFT JOIN ipb_gallery_images i ON ( i.id=a.album_cover_img_id ) LEFT JOIN ipb_members m ON ( i.member_id=m.member_id ) LEFT JOIN ipb_gallery_ratings rating ON ( rating.rating_foreign_id=a.album_id AND rating.member_id=1 ) WHERE ( ( (a.album_is_global=0 AND ( ( a.album_is_public=1 AND OR ( a.album_g_perms_view='*' )) OR ( a.album_is_public=0 AND a.album_owner_id=1 ) OR ( a.album_is_public=2 AND ( a.album_owner_id=1 ) ) ) ) OR (a.album_is_global=1 AND OR ( a.album_g_perms_view='*' )) ) ) ORDER BY a.album_last_img_date desc .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | C:\inetpub\wwwBoard\ips_kernel\classDb.php | [db_driver_mssql].query | 1080 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | C:\inetpub\wwwBoard\admin\applications_addon\[url="https://www.invisionpower.com/clients/index.php?app=nexus&module=promotion§ion=referral&id=5636&direct=aHR0cDovL3d3dy5pbnZpc2lvbnBvd2VyLmNvbS8%3D"]IPS[/url]\gallery\sources\classes\gallery\albums.php| [classNodes].fetchTree | 2002 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | C:\inetpub\wwwBoard\admin\applications_addon\[url="https://www.invisionpower.com/clients/index.php?app=nexus&module=promotion§ion=referral&id=5636&direct=aHR0cDovL3d3dy5pbnZpc2lvbnBvd2VyLmNvbS8%3D"]IPS[/url]\gallery\sources\classes\gallery\albums.php| [gallery_albums]._fetchAlbums | 441 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | C:\inetpub\wwwBoard\admin\applications_addon\[url="https://www.invisionpower.com/clients/index.php?app=nexus&module=promotion§ion=referral&id=5636&direct=aHR0cDovL3d3dy5pbnZpc2lvbnBvd2VyLmNvbS8%3D"]IPS[/url]\gallery\modules_public\albums\home.php| [gallery_albums].fetchAlbumsByFilters | 77 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | C:\inetpub\wwwBoard\admin\sources\base\ipsController.php | [public_gallery_albums_home].doExecute | 285 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' Edited March 11, 201114 yr by Koscomo
March 11, 201114 yr comment_46135 Ggf. einmal die Dateien neu hochladen, ansonsten ein Update nicht richtig durchgeführt? Genauer helfen kann dir da schlussendlich, wenn beides nicht funktioniert bzw. zutrifft nur der Support per Ticketsystem.
Create an account or sign in to comment