| Author |
 Topic  |
|
|
ian9001
Starting Member
22 Posts |
 Posted - 16 March 2006 : 18:19:54
|
I've just taken over as admin on a forum running vers 3.4.05 and a MySql database. Never used Snitz with MsSql before, always been with MS Access, and never had an issue with the Photo Album Mod before; it's always installed sweet as a nut!
The MySql vers is 4.0.26 and the Mod is Photo Album v1.82 for Snitz 3.4.xx
Problem: After specifying the "/photos" directory, the tables are created without any issues. When I then try to access album_admin.asp it times out. I've checked the tables with phpMyAdmin and they're there OK and the config table has the right data in it.
Any suggestions as to where I should be looking to solve this, I'm at the head + brick wall stage!
Thanks folks...
Ian |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
ian9001
Starting Member
22 Posts |
Posted - 18 March 2006 : 15:10:24
|
Thanks, but is a Windows server.
Made some progress; as far as I can work out the page falls over at line 447 of admin_album.asp, here:
Set objRec = Server.CreateObject ("ADODB.Recordset")
sqlstr = "SELECT " & strTablePrefix & "members.M_NAME, " & strTablePrefix & "members.Member_Id," & strTablePrefix & "album_users.member_id as nullchk FROM " & strTablePrefix & "members "&_
"LEFT JOIN " & strTablePrefix & "album_users ON " & strTablePrefix & "members.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
When I comment out this section, the page loads and displays all the correct info from the config table. When I then click on "Album User Admin" I then get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.26]Table 'xxxxx_snitz.FORUM_members' doesn't exist
/admin_album_admin_users.asp, line 66
I will get there! But any help would be appreciated as this is the first time I've had problems like this with Snitz and still getting to know the code.
Ian |
 |
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 18 March 2006 : 19:53:41
|
| Don't spose you have a copy of admin_album_admin_users.asp? If the original problem was with the table not being found you'd expect it to display the error straight off. You having problems with any other bits of the mod? |
|
|
|
ian9001
Starting Member
22 Posts |
Posted - 19 March 2006 : 15:19:49
|
Thanks Modifichicci!
Even though this is Windows server, changing the tables names to uppercase has done the trick... almost! Now have an issue with the pics not appearing in albums :( but I'm sure this is just me.
If anyone else has this issue, feel free to email me for a copy of the amended Mod files (save a bit of "finding and replacing" maybe)
Thanks for the replies
Ian |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 March 2006 : 16:09:18
|
Depending on your what your host has set the mysql system variable lower_case_table_names the case of the table names will be an issue.
Usually, this isn't a problem on windows servers, because windows treat file names as the same whether they be upper case or lower case. So boo.asp will be the same as BOO.asp on windows, but on Unix systems, they are 2 different files.
MySQL stores it's tables in files on the server. That's why modifichicci suggested the case change. But the host might have override the default way of how mysql handles case names.
See here for more info: http://dev.mysql.com/doc/refman/4.1/en/name-case-sensitivity.html |
Support Snitz Forums
|
|
|
|
ian9001
Starting Member
22 Posts |
Posted - 19 March 2006 : 17:10:51
|
Thanks for the link, this was a lesson learned in NOT thinking globally. I got too hung up on specifics I reckon.
All running sweet as a nut now.
Thanks guys
Ian |
|
|
|
jwashburn
Starting Member
28 Posts |
Posted - 22 March 2006 : 11:58:08
|
I am using a Windows server and having a tough time with this mod since switching to mysql. My forum has been up and running with the mod and accessdb for some time. We just recently switched to mysql and this is the last piece to get working. You get access denied errors. The permissions have not changed and just as a test I changed my config.asp to point back to access as a test and the photo album works again.
I am not sure what to check anymore |
 |
|
|
|
jwashburn
Starting Member
28 Posts |
Posted - 22 March 2006 : 12:40:18
|
Here is some more information that may be helpful. I tried using the test function of the mod and it comes back with
exact path to file: /members
Permission deniedNo 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:
Sunset.jpg
The weird part is I did a search in the code for Permission denied and its not anywhere in the code for the mod, so I am not sure where the Permission denied message is coming from, |
|
|
|
|
jwashburn
Starting Member
28 Posts |
Posted - 24 March 2006 : 01:07:24
|
I am stuck now for sure.
Here is the code from the the test page
objUpload("File1").SaveAs strMapPath
' Release upload object from memory
Set objUpload = Nothing
response.write "exact path to file: " &strPath&"<BR>"
response.write err.description
if instr(err.description,"error") then
response.write "<BR> if you get this error:<BR>ADODB.Stream error '800a0bbc'<BR>Write to file failed.<BR>/dev/clsField.asp, line 178<BR>"
response.write "and there are NO ERRORS on the other page I do not have a fix for this sorry"
else
Response.write "No Errors detected, If you are still haveing problems please send me an email to <a href=mailto:burthold@yahoo.com>Wesley Brown</a><BR>"
end if
The error I get is Permissiondenied
'response.write err.description
I remmed out the repsonse.write to see if the error was coming from the mod or not and sure enough I didnt get the error message.
I dont know where the permissiondenied error is coming from |
|
|
|
| |
Topic |
|
Topic Locked
