Author |
Topic |
AWD_ENVY
Junior Member
103 Posts |
Posted - 02 December 2003 : 23:04:14
|
quote: Originally posted by jeepgen
hi there. Me too, i have mysql problems. The pic are there (i "translated" my db from access to mysql), all tables are there, but the pics dont show. The page of any members say Sorry no pic. If u go to "modify" option, u can see them. And the admin-menu option for Photo album goes in .asp time out. What's that?? Thanking u in advance,
When I modified the PhotoAlbums for out site & into MySQL, I had to do alot of changes. I know I converded alot of the recordsets to Arrays. I'll see if I can put my photoalbum code togeather for the other MySQL users. < |
|
|
AWD_ENVY
Junior Member
103 Posts |
Posted - 03 December 2003 : 14:44:17
|
Someone with MySQL, give this a try.... just replace your Photo_Album.asp with the code in this file. Because I started making changes for our site with no thought that someone else might want it, There my be something that doesn't work. Everything should be fine, but make a backup of your original file. I don't think there will be any issues with MSaccess databases using this, but it was modified under MySQL. If anything it might speed up a MSAccess database, because almost everything is done through arrays rather than recordsets.
Note: This is JUST the code for the photo_album.asp file. If someone can verify there are not any issues, I'll give out the rest of the code.
Some of the things that have changed in this file Vs. the original: '# Album Gives users the choice of single or Multi Mode (nolonger does and admin select 1 style) '# Album Only diplays users with photos in their albums under Multi Mode '# Album diplays photos & albums in order of Newest to Oldest (so the main page is always fresh and new looking) '# Album Diplays PhotoCounts in users album under Multi Mode '# Album Auto Displays the most recent picture in the ablumb, if a user has not selected one to diplay for their album '# Album uses more array's for speed & MySQL compatibility
Demo of Photo_Album.asp
The Code
< |
Edited by - AWD_ENVY on 03 December 2003 14:49:21 |
|
|
mvita
Starting Member
1 Posts |
Posted - 10 December 2003 : 08:25:43
|
I tried your module on my photoalbum (under MSaccess). It doesn't work: Under "user view" I could see no users at all, while in "picture view" things are better, but the path to the pictures is not correct: the user directory comes with a lot of spaces after its name, so the picture is not found (eg. public/pictures/jimmy%20%20%20%20%20%20%20%20%20%20%20%20%20/picture.gif)
Any clue? I would like very much to use this mod, since I like the look and the main page "always updated"
Marco --------------- www.citroends.it< |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people' s passwords IS his pasttime. |
|
|
AWD_ENVY
Junior Member
103 Posts |
Posted - 10 December 2003 : 09:22:40
|
I'm not sure how your database fields differ from mine in MySQL. To start we need to find out where the error is occuring, and where it's getting the space(%20) values.
If you're fammiler with arrays, can you tell me what value your getting for "aData(1,i)" in the photo display loop ?
I'm guessing thats where the error is, and I'd like to verify that the "1" colomb(member's name) is the same one as the one that I'm pulling.< |
Edited by - AWD_ENVY on 10 December 2003 09:23:29 |
|
|
bitwise2000
Starting Member
38 Posts |
Posted - 13 December 2003 : 12:07:32
|
AWD_ENVY, that code doesn't work on Access because Access does not support aggregate functions. Your SQL includes a join and a group by and that does not work in Access. I'm trying to rework the sql so it runs. Access users, if you turn off the on error resume you'll see the error from ADO. -- Bit< |
|
|
bitwise2000
Starting Member
38 Posts |
Posted - 02 January 2004 : 12:37:26
|
How is ASPJpeg used? I see a test for its presence, but it doesn't seem to get used to generate thumbs if it's there.< |
|
|
unclefunk
Starting Member
South Africa
3 Posts |
Posted - 08 January 2004 : 12:30:18
|
Where can I download this mod, since it can't be downloaded from www.wesworld.net/mods/default.asp anymore.
< |
|
|
hirsp1
Starting Member
11 Posts |
Posted - 03 February 2004 : 09:15:44
|
quote: Originally posted by Sherm
quote: Originally posted by Jeff V
Active Server Pages error 'ASP 0113'
Script timed out
/photo_album_upload.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
That is the precise error I'm getting.
Clues, anyone?
I, too am getting this particular error. I've had my ISP check to make sure that permissions are correctly set AND that the FileServerObject is working. They assure me that both are as they need to be.
Any other suggestions on how to solve this problem? I actually have the same problem with the File Lister, too, so I'm still suspecting something at the ISP level, not necessarily with the code.< |
|
|
Kuthula
Starting Member
6 Posts |
Posted - 09 February 2004 : 04:04:07
|
quote: Where can I download this mod, since it can't be downloaded from www.wesworld.net/mods/default.asp anymore.
Same question... can anyone point me in the right direction? Cheers.< |
|
|
Thomas
Starting Member
Belgium
20 Posts |
|
Kuthula
Starting Member
6 Posts |
Posted - 09 February 2004 : 17:16:01
|
Excellent - thanks very much Thomas. Now fingers crossed for an easy day in the office so that I can get to make the changes!
Much appreciated.< |
Edited by - Kuthula on 10 February 2004 07:55:10 |
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 10 February 2004 : 08:45:39
|
Seems like the developer dropped Snitz and use phpBB in a Postnuke site now.< |
|
|
Thomas
Starting Member
Belgium
20 Posts |
Posted - 10 February 2004 : 11:28:31
|
quote: Originally posted by wii
Seems like the developer dropped Snitz and use phpBB in a Postnuke site now.
Too bad. < |
|
|
Kuthula
Starting Member
6 Posts |
Posted - 13 February 2004 : 09:01:28
|
I gather a few people have already made mods so that only those users with photo's in their albums are shown. Still I thought I'd tackle it myself, and here's how I did it.
At around line 191 in Photo_Album.asp I changed this line quote: sqlst = "select * from "& strMemberTablePrefix & "ALBUM_USERS order by M_NAME"
for this chunk quote: strMemberTablePrefix & "ALBUM_USERS.M_NAME, " & _ "count(" & strMemberTablePrefix & "ALBUM.Photo_id) as total " & _ "FROM "& strMemberTablePrefix & "ALBUM_USERS INNER JOIN " & _ strMemberTablePrefix & "ALBUM ON " & strMemberTablePrefix & "ALBUM_USERS.Member_id = " & _ strMemberTablePrefix & "ALBUM.Member_id " & _ "group by " & strMemberTablePrefix & "ALBUM_USERS.Member_id, " & strMemberTablePrefix & "ALBUM_USERS.M_NAME " & _ "order by M_NAME"
In effect this is only gathering albums with more than one record, and we keep that count - it's added to the 'aData()' array.
After the mods at around line 394 (before the mods it's somewhere like 381) I change this line quote: Response.Write aData(1,i)&"</a>"&vbNewLine
for this quote: Response.Write aData(1,i)&"["&aData(2,i)&"]</a>"&vbNewLine
The benefit over an earlier post is that we're counting the number of photo's once at the very outset rather than calling the database for each user with an album - this should speed up the process somewhat.
At the mo' I've done nothing with 'hidden' images... if I do anything it will be to prevent the use of hidden pics, its an album after all and not somewhere for people to swap or store their pics!< |
|
|
fireskull
Starting Member
United Kingdom
5 Posts |
Posted - 24 February 2004 : 19:09:54
|
Hey All! Ive got a problem, when i click on "Upload Files into Album" it takes ages to load and when it does finally do something a page cannot be displayed comes up and has this:
Active Server Pages, ASP 0113 (0x80004005) The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools. /forum/photo_album_upload.asp
and once i got a different error to this but only once and cant remember what it said what could be wrong, ne help wud b appreciated
Paul< |
|
|
Topic |
|