Webmastersite.net
Register Log In

sql errors

Comments on sql errors

finsandfur
Forum Regular

Usergroup: Customer
Joined: Apr 18, 2006

Total Topics: 28
Total Comments: 103
Posted Aug 16, 2008 - 11:52 PM:

I'm also getting mysql errors after upgrading from 4.0.33 to 4.1.62

After going through the manual and learning how to get the debug output it says to post the results here.

It's only showing up on the front page. /index.php

Load time so far: 0.03 seconds.

Query 1: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC

Number of rows is 480

Load time so far: 0.05 seconds.

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

Number of rows is 93

Load time so far: 0.05 seconds.

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

Number of rows is 22

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Creating markup with Array as row

Load time so far: 0.06 seconds.

Query 4: SELECT `id`,`title`,`caneditown`,`caneditall`,`canvote`,`isadmin`,` canpost`,`canemail`,`validatecats`,`validatecomments`,`valid atelinks`,`validateedits`,`cansubmitlinks`,`cansubmitcategor ies`,`cansubmitcomments`,`caneditownlinks`,`caneditowncatego ries`,`caneditowncomments`,`caneditownprofile`,`caneditallli nks`,`caneditallcategories`,`caneditallcomments`,`caneditall profiles`,`candownloadfiles`,`canupload`,`canviewip`,`limitl inks`,`canemailmembers`,`canusehtml`,`limitlinksdaily`,`cana lias`,`cancopy`,`candeleteown`,`candeleteall`,`candofulledit `,`candeletecategories`,`candeletecomments`,`candeleteowncat egories`,`candeleteowncomments`,`candeletemembers`,`candelet eownmembers`,`canaliascategories`,`canviewpages`,`caneditvot es`,`numaliases`,`canviewvotes`,`canhideownlinks`,`canhideow ncategories`,`canhideowncomments`,`canhidealllinks`,`canhide allcategories`,`canhideallcomments`,`canratecomments`,`bytes permem`,`canpm`,`canim`,`canharddelete`,`limitpms`,`limitpms daily`,`canviewdeleted`,`cansubmitpolls`,`candeletepolls`,`c andeleteownpolls`,`caneditpolls`,`caneditownpolls`,`attachpe rpost`,`attachperpm`,`canviewshouts`,`caneditshouts`,`canedi townshouts`,`candeleteshouts`,`candeleteownshouts`,`cansubmi tshouts`,`canpollvote`,`customtitle`,`canviewinvisible`,`nam estyle`,`canpmimportant`,`canviewmodlog`,`isleader`,`cansubm itquotes`,`validatequotes`,`candeletequotes`,`candeleteownqu otes`,`canreport`,`canusesearch`,`attachperlink`,`validateat tachments`,`caneditownquotes`,`caneditallquotes`,`canviewcha t`,`caneditownevents`,`caneditallevents`,`candeleteownevents `,`candeleteevents`,`cansubmitevents`,`validateevents`,`bulk pms`,`issupermod`,`numinv`,`allowugspec`,`validateemails`,`v alidatesponsorlinks`,`cansubmittags`,`candeletetags`,`cansub mitfeeds`,`validatefeeds`,`validatefeeditems`,`numaliasestot `,`shoutsperday`,`validatetrader`,`renewdays`,`renewtimes`,` canviewownfulltrc`,`canviewallfulltrc` FROM wsnlinks_membergroups WHERE id>0

Load time so far: 0.07 seconds.

Query 5: SELECT `id`,`name`,`links`,`comments`,`time`,`usergroup`,`password` ,`ip`,`totalhits`,`totalhitsin`,`email`,`validated`,`templat e`,`language`,`lastattempt`,`allowemail`,`signature`,`avatar name`,`stylesheet`,`allowuseremail`,`albumid`,`failedattempt s`,`totalbytes`,`funds`,`notifyoflinks`,`lastvisit`,`timezon e`,`rating`,`pmfolders`,`notifyofpms`,`acceptpms`,`cookiedur ation`,`banned`,`location`,`homepage`,`occupation`,`bio`,`ai m`,`icq`,`msn`,`yahoo`,`inactive`,`timeonline`,`totalpms`,`b uddies`,`ignored`,`isonline`,`acceptims`,`adminpermissions`, `referrer`,`groupreverttime`,`grouprevertto`,`moderationpm`, `secondarygroups`,`linksperpage`,`commentsperpage`,`shouts`, `customtitle`,`shoutban`,`topicbans`,`forumbans`,`visibility `,`birthdate`,`lastsession`,`interests`,`posteditor`,`foruma ccess`,`pmpopup`,`pmnotify`,`modnotes`,`guestnotes`,`salt`,` lastmodnote`,`newpms`,`imflag`,`orderalbums`,`lastguestnote` ,`autosubscribe`,`notifymethod`,`showavatars`,`showsigs`,`wa rninglevel`,`topics`,`posts`,`chatcolor`,`traderrating`,`inv itessent`,`validatedemail`,`newemail`,`calsub`,`macros`,`gue stnotify`,`keychecktime`,`notifykeywords`,`autosubscribepost `,`blogrss`,`positivepct`,`notifytrader` FROM wsnlinks_members WHERE id='3' AND validated=1

Load time so far: 0.08 seconds.

Query 6: SELECT `original`,`replacement`,`description`,`id`,`sortorder` FROM wsnlinks_markup WHERE type='smilie' ORDER BY sortorder

Number of rows is 14

Load time so far: 0.08 seconds.

Query 7: SELECT `id`,`to`,`subject`,`message`,`headers`,`replacement`,`mime` FROM wsnlinks_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,10

Number of rows is 0

Load time so far: 0.08 seconds.

Query 8: UPDATE wsnlinks_email SET inprogress='0' WHERE

Load time so far: 0.08 seconds.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Query 9: SELECT `id`,`type`,`objectid`,`filename`,`filetitle`,`filesize`,`wi dth`,`height`,`memberid`,`time`,`deleted`,`field`,`downloads `,`validated`,`ownerip`,`catid`,`importurl` FROM wsnlinks_attachments WHERE importurl != '' ORDER BY id ASC LIMIT 0,1

Number of rows is 0

Load time so far: 0.08 seconds.

Query 10: SELECT `id`,`frequency`,`filename`,`nextrun` FROM wsnlinks_crons WHERE nextrun < 1218954569 ORDER BY id ASC LIMIT 0,1

Number of rows is 0

Load time so far: 0.09 seconds.

Query 11: SELECT COUNT(id) FROM wsnlinks_categories WHERE parent=0 AND deleted=0 AND hide=0 AND isalbum=0 AND validated=1
Count is 2

Load time so far: 0.09 seconds.

Query 12: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`paren tnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom `,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`t ype`,`permissions`,`subscribers`,`subscriber`,`mixtypes`,`is album`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchq uery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath `,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,` reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposter id`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastt hreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomme nts`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,` wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaul tnoaccess`,`lastthreadurl`,`lastposturl` FROM wsnlinks_categories WHERE parent=0 AND validated=1 AND hide=0 AND isalbum=0 AND deleted=0 ORDER BY catcols ASC,name ASC LIMIT 0,40

Number of rows is 2

Creating category with Array as row

Creating category with Array as row

Setting cookie with name returnto, value http://www.finsandfur.net/index.php?debug=1 and expiration time 0

Warning: Cannot modify header information - headers already sent by (output started at /home/finsnet/public_html/classes/database.php:249) in /home/finsnet/public_html/includes/commonfuncs.php on line 746

Warning: Cannot modify header information - headers already sent by (output started at /home/finsnet/public_html/classes/database.php:249) in /home/finsnet/public_html/includes/commonfuncs.php on line 750

Warning: Cannot modify header information - headers already sent by (output started at /home/finsnet/public_html/classes/database.php:249) in /home/finsnet/public_html/end.php on line 71

Load time so far: 0.13 seconds.

Query 13: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid>0
Count is 1

Load time so far: 0.13 seconds.

Query 14: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=0
Count is 1

Load time so far: 0.13 seconds.

Query 15: SELECT COUNT(id) FROM wsnlinks_sessions WHERE memberid=0 AND isrobot=1
Count is 1

Load time so far: 0.14 seconds.

Query 16: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE time > 1218953969 AND (memberid>0) ORDER BY time DESC LIMIT 0,100

Number of rows is 1

Creating online with Array as row

Query 17: SELECT DISTINCT FROM wsnlinks_tags WHERE 1=1 GROUP BY name ORDER BY uses DESC LIMIT 0,10

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

Number of rows is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM wsnlinks_tags WHERE 1=1 GROUP BY name ORDER BY uses DESC LIMIT 0,10' at line 1

Load time so far: 0.14 seconds.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM wsnlinks_tags WHERE 1=1 GROUP BY name ORDER BY uses DESC LIMIT 0,10' at line 1

Query 18: SELECT `` FROM wsnlinks_quotes WHERE validated=1 ORDER BY rand() ASC LIMIT 0,1

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

Number of rows is Table 'finsnet_spheric1.wsnlinks_quotes' doesn't exist

Load time so far: 0.14 seconds.

Table 'finsnet_spheric1.wsnlinks_quotes' doesn't exist

Query 19: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE time > 1218953969 AND (inchat=1 AND memberid>0) ORDER BY time DESC LIMIT 0,100

Number of rows is 0

Load time so far: 0.23 seconds.

Query 20: SELECT `id`,`memberid`,`location`,`time`,`ip`,`browser`,`starttime` ,`catid`,`threadid`,`areaname`,`lastsearch`,`nopermission`,` inchat`,`name`,`isrobot`,`lastchat`,`groupnamestyle`,`accept ims`,`visibility`,`profileurl` FROM wsnlinks_sessions WHERE memberid=3

Number of rows is 1

Creating online with Array as row

Load time so far: 0.23 seconds.

Query 21: UPDATE wsnlinks_sessions SET starttime='1218944374', time='1218954569', location='http://www.finsandfur.net/index.php?debug=1', catid='0', threadid='', areaname='Main', nopermission='0', inchat='0', ip='75.100.208.171' WHERE id=312560
finsandfur
Forum Regular

Usergroup: Customer
Joined: Apr 18, 2006

Total Topics: 28
Total Comments: 103
Posted Aug 17, 2008 - 12:53 PM:

I'm willing to pay someone to run this upgrade for me.
I've tried everything within my limits to do it successfully to no avail.

Getting tons of errors one after the other. Yes I tried to follow the instructions in the readme.html.
Site is currently dead when viewed through MIE..

tables don't exist
mysql_num_rows(): supplied argument is not a valid MySQL result resource
No such file or directory
Could not change perms on templates
Permission denied
fwrite(): supplied argument is not a valid stream resource
stat failed for temp/current.tar.gz
Paul
developer

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

Total Topics: 61
Total Comments: 7867
Paul
Posted Aug 17, 2008 - 6:38 PM:

scripts.webmastersite.net/w...index.php?section=upgrades

Probably the config.php couldn't be edited due to your not having FTP info supplied while in apache 777 mode, leading to tables not being recorded.

I'd expect a 4.0.33 install to be under the control of hackers by now.
finsandfur
Forum Regular

Usergroup: Customer
Joined: Apr 18, 2006

Total Topics: 28
Total Comments: 103
Posted Aug 17, 2008 - 8:25 PM:

I dont know....I doubt hackers took it over, but nothing is impossible.
I ran the upgrade again and for the most part, it took. It's being displayed as "Your WSN Links 4.1.62 is up to date".

The problem now is with this;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hidden/public_html/databases/mysql.php on line 27
..which only shows on the site front so far.

A few items in the admin center show the following error at the top of the page;
Warning: Invalid argument supplied for foreach() in /home/hidden/public_html/includes/admincommonfuncs.php on line 739
...such as all links under the settings category.

I'd still be willing to pay you to have a look at things Paul...if your willing. Unless what I'm describing is tell tale stupidity on my part and your willing to point it out.

The site still only works on Firefox...MIE shows nothing but the "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hidden/public_html/databases/mysql.php on line 27", error.


http://www.finsandfur.net
Paul
developer

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

Total Topics: 61
Total Comments: 7867
Paul
Posted Aug 18, 2008 - 5:15 AM:

It doesn't work in my firefox: http://www.webmastersite.net/screenshots/24082.jpg

Looks exactly the same as it did when I made post #3.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.