Jump to content

SQL Error beim öffnen der Galerie

Featured Replies

Posted
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&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 by Koscomo

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use. We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.