Webmastersite.net
Register Log In

Adding Fields issues

Comments on Adding Fields issues

Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007

Total Topics: 32
Total Comments: 130
Jez
Posted Oct 13, 2007 - 10:39 AM:

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:
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Oct 13, 2007 - 11:34 AM:

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.
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007

Total Topics: 32
Total Comments: 130
Jez
Posted Oct 13, 2007 - 1:04 PM:

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]

Attached Files:
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007

Total Topics: 32
Total Comments: 130
Jez
Posted Oct 15, 2007 - 4:47 AM:

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 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.


Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Oct 15, 2007 - 11:50 AM:

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.
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007

Total Topics: 32
Total Comments: 130
Jez
Posted Oct 16, 2007 - 5:37 AM:

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
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Oct 16, 2007 - 2:42 PM:

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.
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007

Total Topics: 32
Total Comments: 130
Jez
Posted Oct 16, 2007 - 2:55 PM:

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: 32
Total Comments: 130
Jez
Posted Oct 16, 2007 - 3:08 PM:

Forget it - chmodding to 777 did the trick! I assume it's not safe to leave it like that?

Thanks Paul
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
#10 - Quote - Permalink
Posted Oct 16, 2007 - 9:46 PM:

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.
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007

Total Topics: 32
Total Comments: 130
Jez
#11 - Quote - Permalink
Posted Oct 20, 2007 - 9:48 AM:

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
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
#12 - Quote - Permalink
Posted Oct 20, 2007 - 5:28 PM:

4.1.6/7 have an autoupgrade bug. Either overwrite classes/tar.php with the 4.1.8 one or upgrade the manual way.
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007

Total Topics: 32
Total Comments: 130
Jez
#13 - Quote - Permalink
Posted Oct 22, 2007 - 10:57 AM:

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
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
#14 - Quote - Permalink
Posted Oct 23, 2007 - 12:46 PM:

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.
Jez
Forum Regular

Usergroup: Customer
Joined: Jan 19, 2007

Total Topics: 32
Total Comments: 130
Jez
#15 - Quote - Permalink
Posted Oct 25, 2007 - 10:20 AM:

Hi Paul,

Ok, That did it.

I have a new error now - I'll post a new thread
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.