Koscomo 0 Report post Posted March 11, 2011 (edited) 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, 2011 by Koscomo Share this post Link to post
Helge 192 Report post Posted March 11, 2011 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. Share this post Link to post