I haven't been able to find anything matching my problems when searching. It's nearly enough to make me look for another mod, but I'll see if anyone has had similar issues before I move on.
The first problem occurs when I try to go to the admin_album.asp page. I keep getting a script timeout error. I figured this was because of a bad Do...Loop somewhere, so I started commenting them out until I found the offending loop. It appears that it doesn't even serve a purpose. The following code creates two variables, but they are never written to the page. Are they from an older version of the mod and just didn't get removed?
Set objRec = Server.CreateObject ("ADODB.Recordset")
sqlstr = "SELECT " & strTablePrefix & "M.M_NAME, " & strTablePrefix & "M.MEMBER_ID," & strTablePrefix & "ALBUM_USERS.MEMBER_ID AS nullchk FROM " & strTablePrefix & "MEMBERS M"&_
"LEFT JOIN " & strTablePrefix & "ALBUM_USERS ON " & strTablePrefix & "M.MEMBER_ID = " & strTablePrefix & "ALBUM_USERS.MEMBER_ID "&_
"WHERE " & strTablePrefix & "ALBUM_USERS.MEMBER_ID IS NULL"
member_select = "<select name=""adduser"">"
objRec.Open sqlstr, My_Conn
'Do While not objRec.EOF
member_select = member_select & "<option value=""" & objRec.fields("MEMBER_ID") & """>" & objRec.fields("M_NAME") & "</option>"
objRec.MoveNext
'loop
objRec.close
member_select = member_select & "</select>"
delete_select = "<select name=""deleteuser"">"
sqlstr = "SELECT * FROM " & strTablePrefix & "ALBUM_USERS"
objRec.Open sqlstr, My_Conn
Do While not objRec.EOF
delete_select = delete_select & "<option value=""" & objRec.fields("MEMBER_ID") & """>" & objRec.fields("M_NAME") & "</option>"
objRec.MoveNext
loop
objRec.close
delete_select = delete_select & "</select>"
set objRec = nothing
Next, I uploaded an image into my main gallery (I'm the only user), and when I click that gallery, I get an error that there are no images in it! I haven't had the energy or motivation this morning to go through another file and try to figure out what in the world is going on, so I thought I'd see if anyone has had similar issues.
What alternatives can people suggest for the Photo Album mod if this doesn't work out?
Topic Locked
Posted - 27 May 2006 : 09:16:03
