| Author |
 Topic  |
|
withanhdammit
Junior Member
USA
236 Posts |
 Posted - 27 March 2005 : 00:59:57
|
OK, using a different profile, it works fine...so how do I fix my profile so it works...
h |
I reject your reality and substitute my own. |
 |
|
|
hawkdrean
New Member
73 Posts |
Posted - 27 March 2005 : 01:09:24
|
I try the mod and got this error went I try to posted
Microsoft JET Database Engine error '80040e14'
Malformed GUID. in query expression '{fn LCASE(M_NAME)}='user''.
/inc_insert_image.asp, line 85
this is line 85: set rsImg = My_Conn.Execute(sSQL) |
|
|
|
rodham
New Member
65 Posts |
Posted - 27 March 2005 : 08:55:56
|
withanhdammit
I think the problem could stem from having run the Photo Album MOD in non-Single Album mode and then switching to Single Mode at a later date. Check the PHOTO_ALBUM_CAT table there should only be your 4 catergories; Classifieds, Other, Skydiving and Volcano. Then check your PHOTO_ALBUM_USERS table for duplicates.
Hawkdrean
Try replacing line 84 with:
sSQL = "Select * From " & strMemberTablePrefix &
"ALBUM_USERS Where M_NAME='" & strDBNTUserName &"'" Wrapped code for display
Let me know how it goes. |
Edited by - rodham on 27 March 2005 09:58:48 |
|
|
|
withanhdammit
Junior Member
USA
236 Posts |
Posted - 27 March 2005 : 15:46:21
|
Yeah, it was kind of funky...there were lots of weird things in there. It must have been from User Album to Single Album. In any case, I deleted my user's photo album rights and added them again and viola...it's working now.
Thanks for the help, it's a great mod!
I'm still planning on testing it with the classifieds mod, I'll get back to you on that and let you know how it goes.
No go on the classifieds...it shows the categories properly, but doesn't show the images.
h
|
I reject your reality and substitute my own. |
Edited by - withanhdammit on 27 March 2005 16:07:29 |
|
|
|
rodham
New Member
65 Posts |
Posted - 27 March 2005 : 16:16:14
|
Ok, I just checked it out - easy to fix.
On the second <form> add: name="PostTopic" to
<FORM METHOD ="POST" ACTION="classPlaceAd.asp">
so that it looks like this
<FORM name="PostTopic" METHOD ="POST" ACTION="classPlaceAd.asp"> |
Edited by - rodham on 27 March 2005 16:27:08 |
|
|
|
withanhdammit
Junior Member
USA
236 Posts |
Posted - 27 March 2005 : 16:34:07
|
I assume to make that change inside classPlaceAd.asp...mine is at http://thepoopsheet.dnjhome.com/classplacead.txt and I made the original chage on line 234.
How should it look?
Thanks a ton for your help, this will be really cool when we get it working!
h
|
I reject your reality and substitute my own. |
|
|
|
hawkdrean
New Member
73 Posts |
Posted - 27 March 2005 : 16:51:59
|
Change line 84 now getting this one
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Member_id=1order by photo_cat_name'.
/inc_insert_image.asp, line 110
This is line 110: set rsCat = My_Conn.Execute(sSQL) |
Edited by - hawkdrean on 27 March 2005 16:55:00 |
|
|
|
rodham
New Member
65 Posts |
Posted - 27 March 2005 : 17:00:33
|
hawkdrean,
Good find, small bug:
Fix line 108:
to include a space before order
sSQL = sSQL & " order by photo_cat_name"
|
Edited by - rodham on 27 March 2005 17:04:35 |
|
|
|
hawkdrean
New Member
73 Posts |
Posted - 27 March 2005 : 17:33:01
|
This is from line 98 and it has a space between the Member_id and Order by
sSQL = "Select * From " & strMemberTablePrefix & "ALBUM_CAT Where Member_id=" & iUserID & "order by photo_cat_name" |
|
|
|
hawkdrean
New Member
73 Posts |
Posted - 27 March 2005 : 17:59:00
|
Fixed line 108
Now getting error from line 110
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Member_id=1order by photo_cat_name'.
/inc_insert_image.asp, line 110
|
Edited by - hawkdrean on 27 March 2005 18:02:15 |
|
|
|
rodham
New Member
65 Posts |
Posted - 27 March 2005 : 18:11:58
|
quote:
Originally posted by hawkdrean
This is from line 98 and it has a space between the Member_id and Order by
sSQL = "Select * From " & strMemberTablePrefix & "ALBUM_CAT Where Member_id=" & iUserID & "order by photo_cat_name"
Put the space between the " and the word order
Get latest version v1.d, link found in first post.
thnx |
Edited by - rodham on 28 March 2005 08:27:27 |
|
|
|
withanhdammit
Junior Member
USA
236 Posts |
Posted - 28 March 2005 : 09:41:55
|
Hey Rod,
Thanks again for your help yesterday. This is a great mod! My users will appreciate it!
h |
I reject your reality and substitute my own. |
|
|
|
rodham
New Member
65 Posts |
Posted - 28 March 2005 : 11:18:17
|
No problem, thnx for the ICQ fix - I don't think I would have ever noticed it as I never use the stuff.
btw. You might want to replace the space after the image insert with a [br] before the text so that it wraps the ad content below the image on the classified Mod changes we did. |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 28 March 2005 : 21:08:41
|
| Line 111 has the no space between the order call of th SQL. I am not sure if it is in this version, but I know in version c of the mod, the only way to get it to work for someone, was to remove the album for the user, then re add it, has this been fixed in this version? |
Cheers,
David Greening |
|
|
|
rodham
New Member
65 Posts |
Posted - 28 March 2005 : 21:18:42
|
| Yes it's been fixed in 1.d and fixed with trim() for some recordset fields due to some db connections returning padded fields. So if thumbnails weren't showing in messages and were available, they will now show. Sorry for any grief. |
|
|
|
Topic |
|
Topic Locked
