Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Photoalbum ver.1.82, no folder accepted		  New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 3

modifichicci
Average Member

Italy
787 Posts
Posted - 16 February 2007 :  11:55:58  Show Profile  Visit modifichicci's Homepage
line 293
strSql = "delete from " & strMemberTablePrefix & "ALBUM_Cat where Member_id .......
line 448 and following:
sqlstr = "select " & strTablePrefix & "members.M_NAME,...

etc and there is also album_users in the same lines

line 461
sqlstr = "select * from " & strTablePrefix & "album_users"
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page

ugger
Junior Member

Denmark
127 Posts
Posted - 18 February 2007 :  02:45:38  Show Profile  Visit ugger's Homepage
I've changes it all to upper cases but still no luck
Here is the names of the tables directly from my php-site on the server, is something missing or misspelled:
FORUM_ALBUM
FORUM_ALBUM_CAT
FORUM_ALBUM_CONFIG
FORUM_ALBUM_USERS
FORUM_ALLOWED_MEMBERS
FORUM_AVATAR
FORUM_A_REPLY
FORUM_A_TOPICS
FORUM_BADWORDS
FORUM_CATEGORY
FORUM_CONFIG_EXTENSION
FORUM_CONFIG_NEW
FORUM_FORUM
FORUM_GROUPS
FORUM_GROUP_NAMES
FORUM_MEMBERS
FORUM_MEMBERS_PENDING
FORUM_MODERATOR
FORUM_NAMEFILTER
FORUM_PM
FORUM_REPLY
FORUM_SUBSCRIPTIONS
FORUM_TOPICS
FORUM_TOTALS
FORUM_UPSIZE

and the admin.album.asp looks like this
http://sportfish.dk/admin_album_asp.txt
Edited by - ugger on 18 February 2007 02:46:43
Go to Top of Page

modifichicci
Average Member

Italy
787 Posts
Posted - 18 February 2007 :  04:11:23  Show Profile  Visit modifichicci's Homepage
You miss some changes, in these lines:

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"


Change to:


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"
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page

ugger
Junior Member

Denmark
127 Posts
Posted - 18 February 2007 :  06:28:59  Show Profile  Visit ugger's Homepage
Yes now its running.
But of course its not the end of trouble.
I'm trying to make a new directory where to upload the photos and admitting some file-type jpg gif ect.
When I'm summiting it it does'nt remember the settings.
Go to Top of Page

modifichicci
Average Member

Italy
787 Posts
Posted - 18 February 2007 :  07:21:30  Show Profile  Visit modifichicci's Homepage
directory has to be created from ftp and assigned permission.
You cannot create dir from admin_album.
You can only set an existing dir.
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page

ugger
Junior Member

Denmark
127 Posts
Posted - 18 February 2007 :  09:04:23  Show Profile  Visit ugger's Homepage
Yes I know, and I have created a folder and granted it all access.
It stills having the /Uploads as default in the settings and it dont even reconize this even the /Uploads allrealy exist
Edited by - ugger on 18 February 2007 09:11:22
Go to Top of Page

modifichicci
Average Member

Italy
787 Posts
Posted - 18 February 2007 :  11:33:06  Show Profile  Visit modifichicci's Homepage
have you /uploads or forum/uploads ?

You need to check also
admin_album_admin_users.asp

where is the same query three times..
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Edited by - modifichicci on 18 February 2007 11:35:12
Go to Top of Page

ugger
Junior Member

Denmark
127 Posts
Posted - 19 February 2007 :  03:33:12  Show Profile  Visit ugger's Homepage
Hi again
Now I've managed to get it to make the right folder where to put the photos, i.e. /uploads as in the default. It was a backslash problem where \ has to be changed to /

But I cannot make it remember the settings in admin_album.asp


the files now:
http://www.sportfish.dk/admin_album_asp.txt

http://www.sportfish.dk/admin_album_admin_users_asp.txt

Hope you can help me.
Go to Top of Page

ugger
Junior Member

Denmark
127 Posts
Posted - 25 February 2007 :  13:23:32  Show Profile  Visit ugger's Homepage
Is their anyone who knows about the folder problem om a unix-server, and the problem by saving the setting in admin_album.
I can se that a table is made and the default settings are put in the records. But I can not get it to save new setting.
Go to Top of Page

modifichicci
Average Member

Italy
787 Posts
Posted - 25 February 2007 :  15:01:54  Show Profile  Visit modifichicci's Homepage
I don't see anything wrong in your file, in table album_config values are right?
They have to be updated from admin album, and routine seems ok..
Have you tryed to unistall and reinstall tables from admin album?
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page

ugger
Junior Member

Denmark
127 Posts
Posted - 26 February 2007 :  11:14:04  Show Profile  Visit ugger's Homepage
Hi
I have deleted an reconstructed a new table in Admin_album.
This is the fields in the config-table.

num_files int(11) Ja NULL
file_size int(11) Ja NULL
thumbnails int(11) Ja NULL
base_dir char(50) Ja NULL
thumbnailer char(100) Ja NULL
img_type char(20) Ja NULL
approve int(11) Ja NULL
num_cat int(11) Ja NULL
pop_win int(11) Ja NULL
base_width int(11) Ja NULL
base_hight int(11) Ja NULL
offset_left int(11) Ja NULL
offset_top int(11) Ja NULL
single_album int(11) Ja NULL
Cat_Photo_Display int(11) Ja NULL

Maybe they have to be in uppercases too?

Go to Top of Page

modifichicci
Average Member

Italy
787 Posts
Posted - 26 February 2007 :  15:01:16  Show Profile  Visit modifichicci's Homepage
No they could be in lower case, it's only table name that is case sensitive.
When you install photo album from admin page, values in album are inserted correctly?
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page

ugger
Junior Member

Denmark
127 Posts
Posted - 26 February 2007 :  17:44:24  Show Profile  Visit ugger's Homepage
Yes the default values are loaded into the fields.
The troubleshooter shows something wrong.
Edited by - ugger on 28 February 2007 14:36:50
Go to Top of Page

modifichicci
Average Member

Italy
787 Posts
Posted - 27 February 2007 :  12:25:15  Show Profile  Visit modifichicci's Homepage
TRy this admin_album, it's in italian, but if it works you can esaily translate

http://www.mclink.it/personal/MC6270/download/admin_album.zip
Ernia e Laparocele
Forum di Ernia e Laparocele
Acces - MySql Migration Tutorial
Adamantine forum
Go to Top of Page

ugger
Junior Member

Denmark
127 Posts
Posted - 27 February 2007 :  17:02:19  Show Profile  Visit ugger's Homepage
Hi
I've tried your version of admin_album and its still give the same result.
Did your see the troubleshooter-result?
It looks like the folder is not accepted even if it excist with wide acces(777)
Edited by - ugger on 27 February 2007 17:04:00
Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.36 seconds. Powered By: Snitz Forums 2000 Version 3.4.07