When I attempt to load any of the most recent albums that I have uploaded, I am treated to a blank white page. When I turn on debuging, I get this:
(ado_mssql): SELECT top 1 g_itemId FROM g2_AccessSubscriberMap WHERE g_itemId=5758 AND g_accessListId IN (8,9,11,13,14,17,19,1277,5730,5731,5732,5733,5734,5735,5736,5737,5739,8260,9384,11011,11615,11634,11656,11658,11660,12871,13043,16822,27026,30370,30371,30372,30373,30374,30375,30376,30377,30378,30379,30380,30381,30382,30383,30384,30385,30386,30387,30388,30389,30390,30391,30392,30393,30394,30395,30396,30397,30398,30399,30400,30401,30403,30404,30405,30406,30407,30408,30409,30410,30411,30412,30413,30414,30415,30416,30417,30418,30419,30420,30421,30422,30423,30424,30425,30426,30427,30428,30429,30430,30431,30432,30433,30434,30762,32357)
As you can see this is a SQL select statement, however I am not seeing any errors. I also have a huge list of errors on my main gallery page when debuging is enabled, (for viewing at http://www.crawfordalbum.com/debug.txt), but those have been there since I first installed this instance of gallery, and have not posed any problems until now. Please Help, I am at a complete loss.
My gallery is located here:
http://www.crawfordalbum.com
PHP Info is located here:
http://www.calebcorban.com/phpinfo.php
Gallery URL = http://www.calebcorban.com/main.php
Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.2.8 isapi
Webserver = Microsoft-IIS/6.0
Database = ado_mssql Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2), lock.system=database
Toolkits = SquareThumb, Dcraw, ImageMagick, Gd, Ffmpeg, Exif
Acceleration = full/1800, full/900
Operating system = Windows NT SERVER 5.2 build 3790
Default theme = siriux
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US) AppleWebKit/530.5 (KHTML, like Gecko) Chrome/2.0.172.33 Safari/530.5
Rows in GalleryAccessMap table = 339
Rows in GalleryAccessSubscriberMap table = 4168
Rows in GalleryUser table = 5
Rows in GalleryItem table = 4166
Rows in GalleryAlbumItem table = 99
Rows in GalleryCacheMap table = 14341
Posted: Sat, 2009-07-04 04:44
Posts: 9018
EDIT. Sorry, I was trying to reply to another post.
I wouldn't even know where to start to work on your problem.
Don't know IIS
Don't know MS SQL
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 9018
Actually, can you put your Gallery back into debug so I can see the errors on your main page.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 31
The text file located here:
http://www.crawfordalbum.com/debug.txt
is an exact copy/paste of my main page errors. I prefer not to leave my gallery in debug mode because it shows the location and password to my database server, which I'd rather not have floating out there. I hope you understand, and appreciate your time. Thank You.
Posts: 9018
There are no errors in that debug, I see no problems with it. Can you put Gallery into debug mode and try browsing to one of the pages that are blank or you're having issues with?
Then post that debug output.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 31
there are no errors listed. It is a blank white page, when in debug mode it is a white page with a SQL statement written on it, as indicated in my initial post. If there is something more that you need I'm afraid I don't understand.
Posts: 9018
I don't know then. You're using IIS, which I don't know and MSSQL, which I really don't know.
The debug output doesn't contain any errors that are obvious to me. Try deleting your cache, database and template.
Are you sure your username, password, etc is in the debug output. It's not in my 2.3 installs when I put them into 'buffered' debug mode.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 31
If you look at the debug.txt file you can see where my SQL login information is located, but I have *** it out. Thanks for looking. Anyone else have any ideas?
Posts: 31
A little BUMP here. Anyone got any ideas on this?