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&section=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&section=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&section=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

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.