WebmasterSite.net: PHP scripts to enable your creativity
WSN Links PHP Directory Software
PHP Scripts Webmaster Links Support Forums

Register | Forgot Password
WSN Support » WSN Links » Adding Fields issues » Adding Fields issues

Adding Fields issues

Version: 4.1.4
printPrint


Adding Fields issues
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 30
Total Posts: 127
Posted 10/13/07 - 07:39 AM:
quote post
#1
Hi,

I added some new fields to the suggest page and they work fine but after adding the relevent {} to the details page where they should display I am getting this: http://www.accommodation-uk.net/wsn/links/burstow...

I can't see if i have made a mistake - I have done the same process as i have on another site.

But as there is this issue, it might be a good idea to tell you about some other things that may have an effect.

When clicking the upgrade to new version button I get a lot of errors (attached) I copied but it didn't seem to give any debug information even though debug was set to show.

Other issues are that I get are that I can't delete test links that I put up and this is the error i get (with debug set)


Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/accommod/public_html/wsn/databases/mysql.php on line 29

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/accommod/public_html/wsn/databases/mysql.php on line 26

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/accommod/public_html/wsn/databases/mysql.php on line 26

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/accommod/public_html/wsn/databases/mysql.php on line 26

Hope you can help!

Jez.
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5926
Posted 10/13/07 - 08:34 AM:
quote post
#2
The link you gave me states there's no such category. A glance at the site seems to confirm its nonexistance. Existing categories appear to work...

The mysql warnings you've posted as useless without the debug output, so please post the debug.

The file you've attached says there are permissions or FTP info problems, or perhaps the wrong file path is set.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 30
Total Posts: 127
Posted 10/13/07 - 10:04 AM:
quote post
#3
Yes, I see what you mean. It works fine if you navigate to it but when you try to go directly to the location where I copy the location from it doesn't work.

http://www.accommodation-uk.net/wsn/surrey/horley... if you click the detail of that page you'll see what I mean. I added that one myself as a test so I don't know why the path is wrong to it.

The mysql warnings you've posted as useless without the debug output, so please post the debug.


I attach the debug I get when trying to delete a link.



I just realised what is probably wrong with the FTP! The FTP server keeps failing and needs to be restarted all the time ATM - that must be it.

[edit] Nope - it's the same! I can't see any problem with the FTP info supplied either [/edit]


Edited by Jez on 10/13/07 - 10:41 AM
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 30
Total Posts: 127
Posted 10/15/07 - 01:47 AM:
quote post
#4
Paul, I have added some more tests and have not had any problems with the URL - I can only guess that i didn't cut and paste all of the URL - unlikeley, but also likely.confused

I still have the problem of the pages not displaying the new added fields http://www.accommodation-uk.net/wsn/links/burstow...

http://www.accommodation-uk.net/wsn/links/test-12... I can't see that I have done something wrong but hope you can let me know.


Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5926
Posted 10/15/07 - 08:50 AM:
quote post
#5
I still have the problem of the pages not displaying the new added fields

That's because those aren't the template variables for the fields. Link template variables always start with {LINK.

As for link deletion, I can't seem to reproduce the issue. Somehow the id number goes missing for you but not for me.

Edited by Paul on 10/15/07 - 12:13 PM
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 30
Total Posts: 127
Posted 10/16/07 - 02:37 AM:
quote post
#6
Link deletion is OK if I do it out of the admin area. It just doesn't work if i go to edit links from the admin area.

Thanks for the {LINK info - I didn't notice as I did set them up in bulk and then copied from the .tpl file shocked

I still can't upgrade to the newer versions using the new utility. I have checked that the FTP info is OK (and that the FTP sever is running). So what files might need permissions?
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5926
Posted 10/16/07 - 11:42 AM:
quote post
#7
Were you using the bulk edit links page? If so, fixed that.

The base directory might need to be 777. The messages it gives say that there's no such file, though, not that it doesn't have permission. Which implies the path has to be what's wrong, leading it to look in the wrong spot.

What operating system does your server run? If it's Windows maybe that could make a difference to how paths get resolved, I haven't dealt with Windows servers.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 30
Total Posts: 127
Posted 10/16/07 - 11:55 AM:
quote post
#8
It's linux. But, oddly enough I did have a problem with another site hosted on that server that may have been a similar issue. Is there a way around it? How can I find out if that is indeed the issue? I will change the permissions first and let you know.

Thanks Paul.
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 30
Total Posts: 127
Posted 10/16/07 - 12:08 PM:
quote post
#9
Forget it - chmodding to 777 did the trick! I assume it's not safe to leave it like that?

Thanks Paul
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5926
Posted 10/16/07 - 06:46 PM:
quote post
#10
Just found the same upgrade errors on one of my installs, a problem with the ftpchmodbase function in 4.1.5. Fixed.

I assume it's not safe to leave it like that?

It's safe enough. Not ideal in theory, but when PHP and FTP are two different users various directories have to end up as 777. If another customer on a shared hosting server has SSH and knows your file path and proper security precautions aren't in place they could upload an exploit to your site, but that's true anyway with the attachments directory and other 777 directories.

Running PHP as CGI solves the issue and eliminates the messiness of permissions, but seems to lead all errors to be rather uninformative 500 errors.

Edited by Paul on 10/16/07 - 06:51 PM
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 30
Total Posts: 127
Posted 10/20/07 - 06:48 AM:
quote post
#11
I thought that CHMODing to 777 had fixed the problem but now I am unable to upgrade to the latest again.



Here's what it said:

Unable to open in read mode ''
Warning: Invalid argument supplied for foreach() in /home/accommod/public_html/wsn/includes/filefunctions.php on line 51

(repeats about 10 times)



Here's what the debug said:



Load time so far: 0.11 seconds.

Query 2: SELECT `name`,`value` FROM wsnlinks_switches WHERE id>0

Number of rows is 86

Load time so far: 0.12 seconds.

Query 3: SELECT `id`,`type`,`original`,`replacement`,`description`,`originalclose`,`replacementclose`,`sortorder` FROM wsnlinks_markup WHERE type='wsncode' ORDER BY sortorder

Number of rows is 22

Load time so far: 0.13 seconds.

Query 4: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,`canpost`,`canemail`,`validatecats`,`validatecomments`,`validatelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategories`,`cansubmitcomments`,`caneditownlinks`,`caneditowncategories`,`caneditowncomments`,`caneditownprofile`,`caneditalllinks`,`caneditallcategories`,`caneditallcomments`,`caneditallprofiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitlinks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`canalias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit`,`candeletecategories`,`candeletecomments`,`candeleteowncategories`,`candeleteowncomments`,`candeletemembers`,`candeleteownmembers`,`canaliascategories`,`canviewpages`,`caneditvotes`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideowncategories`,`canhideowncomments`,`canhidealllinks`,`canhideallcategories`,`canhideallcomments`,`canratecomments`,`bytespermem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpmsdaily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`candeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachperpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`caneditownshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmitshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`namestyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubmitquotes`,`validatequotes`,`candeletequotes`,`candeleteownquotes`,`canreport`,`canusesearch`,`attachperlink`,`validateattachments`,`caneditownquotes`,`caneditallquotes`,`canviewchat`,`caneditownevents`,`caneditallevents`,`candeleteownevents`,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulkpms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`validatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansubmitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot`,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes` FROM wsnlinks_membergroups WHERE id>0

Load time so far: 0.13 seconds.

Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password`,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`template`,`language`,`lastattempt`,`allowemail`,`signature`,`avatarname`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempts`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezone`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookieduration`,`banned`,`location`,`homepage`,`occupation`,`bio`,`aim`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`buddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`,`referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`,`secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`,`customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility`,`birthdate`,`lastsession`,`interests`,`posteditor`,`forumaccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,`lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote`,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`warninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`invitessent`,`validatedemail`,`newemail`,`calsub`,`macros`,`guestnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost`,`blogrss`,`positivepct` FROM wsnlinks_members WHERE id='1' AND validated=1

Unable to open in read mode ''
Warning: Invalid argument supplied for foreach() in /home/accommod/public_html/wsn/includes/filefunctions.php on line 51

Warning: Invalid argument supplied for foreach() in /home/accommod/public_html/wsn/includes/filefunctions.php on line 51

Warning: Invalid argument supplied for foreach() in /home/accommod/public_html/wsn/includes/filefunctions.php on line 51

Warning: Invalid argument supplied for foreach() in /home/accommod/public_html/wsn/includes/filefunctions.php on line 51

Warning: Invalid argument supplied for foreach() in /home/accommod/public_html/wsn/includes/filefunctions.php on line 51

Warning: Invalid argument supplied for foreach() in /home/accommod/public_html/wsn/includes/filefunctions.php on line 51

Warning: Invalid argument supplied for foreach() in /home/accommod/public_html/wsn/includes/filefunctions.php on line 51

Warning: Invalid argument supplied for foreach() in /home/accommod/public_html/wsn/includes/filefunctions.php on line 51

Warning: Invalid argument supplied for foreach() in /home/accommod/public_html/wsn/includes/filefunctions.php on line 51

Warning: Invalid argument supplied for foreach() in /home/accommod/public_html/wsn/includes/filefunctions.php on line 51
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5926
Posted 10/20/07 - 02:28 PM:
quote post
#12
4.1.6/7 have an autoupgrade bug. Either overwrite classes/tar.php with the 4.1.8 one or upgrade the manual way.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 30
Total Posts: 127
Posted 10/22/07 - 07:57 AM:
quote post
#13
4.1.6/7 have an autoupgrade bug. Either overwrite classes/tar.php with the 4.1.8 one


That didn't appear to make any difference.
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 55
Total Posts: 5926
Posted 10/23/07 - 09:46 AM:
quote post
#14
If PHP runs as apache, your files will end up owned by apache after an upgrade rather than by your FTP user -- so your FTP user won't be able to overwrite them. Presuming your FTP user still owns the directory you can delete the file first to be able to reupload it.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 30
Total Posts: 127
Posted 10/25/07 - 07:20 AM:
quote post
#15
Hi Paul,

Ok, That did it.

I have a new error now - I'll post a new thread
Search thread for
Download thread as


You don't have permission to post.

Please login or register.

© 2008

   
 
© 2008 Paul Knierim. All rights reserved.