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
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.
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.
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
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?
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.
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.
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.
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
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.
Comments on Adding Fields issues
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
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.
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
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.
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
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.
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]
Attached Files:
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
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.
I still have the problem of the pages not displaying the new added fields www.accommodation-uk.net/ws...nks/burstow-park-1286.html
www.accommodation-uk.net/ws...t/wsn/links/test-1287.html I can't see that I have done something wrong but hope you can let me know.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
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.
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
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
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?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
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.
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
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.
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
Forget it - chmodding to 777 did the trick! I assume it's not safe to leave it like that?
Thanks Paul
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
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.
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
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
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
4.1.6/7 have an autoupgrade bug. Either overwrite classes/tar.php with the 4.1.8 one or upgrade the manual way.
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
That didn't appear to make any difference.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
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.
Forum Regular
Usergroup: Customer
Joined: Jan 19, 2007
Total Topics: 32
Total Comments: 130
Hi Paul,
Ok, That did it.
I have a new error now - I'll post a new thread