| Author |
 Topic  |
|
K.Storm
Starting Member
Andorra
23 Posts |
 Posted - 01 March 2004 : 03:23:36
|
hi all
I get a error with photoalbum and snitz 34.04 with a MySQL database:
the error is:
>HTTP Error 507
>507 Unexpected
>The Web server encountered an unexpected error while communicating >with the ASP service.
>Please contact the server's administrator if this problem persists.
The error comes in admin and in the forum, i have made the dir for the pictures and check with the database that the path i right.
I have read on the internet that the error is a loop error somewhere ????? but where
Please help someone...
/K.Storm
< |
 |
|
|
hirsp1
Starting Member
11 Posts |
Posted - 06 March 2004 : 15:27:29
|
I've done a little checking. Here's what I've found:
In the configuration, I've tried both "Single Album" as Yes and No. Doesn't make a difference. The variable has NO value.
I added some tags to let me know how far in the script the code gets before it bombs out. In the photo_album_upload.asp file, I've discovered the variable single_album has no value. Because of this, it selects the non-single item path. Here, it starts to loops through the following code (I've added the response.write tags):
if single_album = 0 then
response.write ("I GET HERE 06 - if single_album <br>")
response.write (ADODB.Recordset + "<br>")
Set objRec = Server.CreateObject ("ADODB.Recordset")
response.write ("I GET HERE 06a - CreateObject <br>")
sqlstr = "select * from " & strTablePrefix & "ALBUM_CAT where Member_Id = "&M_ID&" order by photo_cat_id"
objRec.Open sqlstr, My_Conn
response.write ("I GET HERE 06b - Open <br>")
objRec.MoveFirst
Do While not objRec.EOF
response.write ("I GET HERE 06c - CreateObject <br>")
cat_sel = cat_sel&" <option value="&objRec.fields("Photo_Cat_Id")&">"&objRec.fields("Photo_Cat_Name")&"</option> "
objRec.MoveNext
loop
objRec.Close
set objRec = nothing
else
response.write ("I GET HERE 06 - else if single_album <br>")
Set objRec = Server.CreateObject ("ADODB.Recordset")
response.write ("I GET HERE 06a - CreateObject <br>")
sqlstr = "select * from " & strTablePrefix & "ALBUM_CAT where Member_Id = 1"
response.write ("I GET HERE 06a - CreateObject <br>")
objRec.Open sqlstr, My_Conn
objRec.MoveFirst
Do While not objRec.EOF
cat_sel = cat_sel&" <option value="&objRec.fields("Photo_Cat_Id")&">"&objRec.fields("Photo_Cat_Name")&"</option> "
objRec.MoveNext
loop
objRec.Close
set objRec = nothing
end if
This is the code that is getting hung up and causing the ASP errors. I've cross-posted this same message in a different forum, but thought it might be good to put it here, too.< |
|
|
|
hirsp1
Starting Member
11 Posts |
Posted - 06 March 2004 : 17:02:52
|
| I've discovered part of the problem...first, you need to have the correct tables in the database. For some reason, the installation doesn't create all of the tables. I'm still working on it, but I'm getting closer!< |
|
|
|
K.Storm
Starting Member
Andorra
23 Posts |
Posted - 07 March 2004 : 15:27:03
|
i have looked on your kode, to find out what table that is missing from the database, but i cant find out where or that is missing....
Thanx for your help so far
/K.storm< |
|
|
|
K.Storm
Starting Member
Andorra
23 Posts |
Posted - 15 March 2004 : 08:42:53
|
hi all
I get a error with photoalbum and snitz 34.04 with a MySQL database:
the error is:
>HTTP Error 507
>507 Unexpected
>The Web server encountered an unexpected error while communicating >with the ASP service.
>Please contact the server's administrator if this problem persists.
The error comes in admin and in the forum, i have made the dir for the pictures and check with the database that the path i right.
I have read on the internet that the error is a loop error somewhere ????? but where
Please help someone...
and to AWD_ENVY where can i download your version of the photoalbum for MySQL, so i kan try it ????
/K.Storm
< |
|
|
|
modemmike
Starting Member
USA
20 Posts |
Posted - 06 April 2004 : 12:22:08
|
The download link is dead... could somebody kindly repost the code or email it to me?
< |
Edited by - modemmike on 06 April 2004 12:44:14 |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
|
|
modemmike
Starting Member
USA
20 Posts |
Posted - 06 April 2004 : 12:45:11
|
| I was just coming back to edited my post after I found it on snitzbitz... thanks!< |
|
|
|
Netz
Starting Member
Denmark
25 Posts |
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 20 April 2004 : 16:35:39
|
Two things. I, i think, should be easy, the other not so.
1) Is there a way that i can make it so that the forum Admins can upload as many images as they wish?
2) Is there a way that i can define what websites the images can be linked to, and any other would get a pre-definded image, without a COM being installed. (i know this one is a long shot).< |
De Priofundus Calmo Ad Te Damine |
|
|
|
pixuk
Starting Member
United Kingdom
7 Posts |
|
|
MotoX
Junior Member
201 Posts |
Posted - 22 April 2004 : 13:26:37
|
quote:
Originally posted by pixuk
I tried, fiddled a bit with the code, and then eventually gave up and wrote my own mod for photo galleries.
You can see it in action at http://www.virginflyer.com/forum
Pix
are you going to share the code?< |
|
|
|
pixuk
Starting Member
United Kingdom
7 Posts |
Posted - 22 April 2004 : 14:23:58
|
Sure, although I'll need to 'unpick' it from the VirginFlyer specifics (unless there's a demand for aircraft spotter mods!)
At the moment it uses the FileUp for uploading & thumbnail.aspx for thumbnail generation. Whilst those options work for me, it would need to be more flexible for others.
Pix< |
The Virgin Atlantic Flyer Resource using Snitz Forums since Nov 03, and lovin' it. |
|
|
|
Chrispix
Starting Member
USA
6 Posts |
Posted - 07 May 2004 : 10:21:24
|
Hey guys, I have a question. When I try to upload in w2k w/ IIS it gives me this error.
Error!
File did not upload to system please contact the system administrator
I have how ever given rights to read & write to the IIS_USR to the photo directory.
If I run trouble shooting on the photo album it says the following
Execute NConvert:
Test File Upload feature:
This is a test.
if you see "this is a test." above file checks out
Files should be able to upload to file system
Then I try to upload a file and get this.
exact path to file: /forum/photos
Write to file failed.No Errors detected, If you are still haveing problems please send me an email to Wesley Brown
File has been saved in file system.
View this file:
pict0447.jpg
The link to the file is
http://www.crossroadshoa.com/forum/photos%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20/pict0447.jpg
Bunch of spaces for some reason.. Any thoughts??
< |
Chrispix a.k.a. Bonez |
|
|
|
Chrispix
Starting Member
USA
6 Posts |
Posted - 11 May 2004 : 10:54:09
|
| I figured out what was wrong. I originally had my photo gallery in multi user mode. I added all users, but at that time, my server did not have rights to add new directories. I then had to delete all empty users, and re-add them. Then single & multi user works just fine.< |
Chrispix a.k.a. Bonez |
|
|
|
Topic |
|
MOD: Photo Album for snitz 3.4.x version 1.82
