| Message Text |
Hi
I just used the auto upgrade button to upgrade WSN links to 5.0.74 I think from 5.0.73 and now both the WSN links systems I am running are no longer functioning.
On one system, whenever I try to access a category page for example, all that is presented is a blank white page.
On the other system, I get the following error:
An error occoured at /index.php?action=displaycat&catid=7 on 2009-11-03 11:28:15. Please relay this data to support. Error #2: 'mysqli_fetch_row() expects parameter 1 to be mysqli_result, boolean given' in /user/htdocs/databases/mysqli.php on line 47.
Last SQL error: 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 'AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1257247695' at line 1
Debug info:
,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE id=7
Load time so far: 0.13 seconds.
Query 14: SELECT `id`,`name`,`parent`,`validated`,`description`,`time`,`parentnames`,`parentids`,`numlinks`,`hide`,`lastlinktime`,`custom`,`lastedit`,`moderators`,`headerinfo`,`related`,`numsub`,`type`,`permissions`,`subscribers`,`mixtypes`,`isalbum`,`orderlinks`,`totalcomments`,`ulsearchmax`,`ulsearchquery`,`ulsearchadult`,`alias`,`catcols`,`linkcols`,`dmozpath`,`sponsorlinks`,`views`,`customwrap`,`deleted`,`reqlinks`,`reqcoms`,`reqlinksdelay`,`priority`,`levelsdeep`,`lastposterid`,`lastpostername`,`lastcommenttime`,`lastthreadid`,`lastthreadtitle`,`linkshere`,`unvalidatedlinks`,`unvalidatedcomments`,`actaslink`,`countposts`,`subcatshtml`,`linksperpage`,`wysihtml`,`numonline`,`sponsorship`,`lastprofileurl`,`defaultnoaccess`,`lastthreadurl`,`lastposturl`,`specialurl`,`invisibleto` FROM wsnlinks_categories WHERE parent=7 AND validated=1 AND hide=0 AND deleted=0 AND isalbum=0 ORDER BY name ASC,name ASC LIMIT 0,40
Load time so far: 0.14 seconds.
Number of rows is 0
Load time so far: 0.14 seconds.
Query 15: SELECT COUNT(id) FROM
wsnlinks_links WHERE AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1257247695
Step 1 of backtrace:
File: /user/htdocs/databases/mysqli.php
Line: 47
Function: mysqli_fetch_row
Arguments:
Step 2 of backtrace:
File: /user/htdocs/databases/mysqli.php
Line: 82
Function: row
Arguments:
Class: db
Step 3 of backtrace:
File: /user/htdocs/classes/database.php
Line: 331
Function: rowitem
Arguments:
Class: db
Step 4 of backtrace:
File: /user/htdocs/classes/database.php
Line: 312
Function: result
Arguments: 0 0
Class: database
Step 5 of backtrace:
File: /user/htdocs/classes/category.php
Line: 172
Function: selectcount
Arguments: linkstable AND hide=0 AND deleted=0 AND validated=1 AND effectivetime < 1257247695
Class: database
Step 6 of backtrace:
File: /user/htdocs/includes/displaycat.php
Line: 171
Function: linkshere
Arguments:
Class: category
Step 7 of backtrace:
File: /user/htdocs/index.php
Line: 166
Function: require_once
Arguments: /user/htdocs/includes/displaycat.php
If you are not the administrator of this site, please report this page to the administrator. If you are the administrator, please pay careful attention: You have a parse error in your template templates/default/displaylinks.tpl (or perhaps in your header or footer) which you need to repair before this page can be displayed correctly. The error is picked up on by php at line 313 of the output.Line #308: <div class="boxtitle" onclick="minmax('infobox')"><img src="/templates/images_default/icon_info.gif" alt="submit" /> Category Stats</div>
Line #309: <div id="infobox" class="boxbody">
Line #310: <?php if (0) { ?><span class="minilabels">Subcategories:</span> 0<br /><?php } ?>
Line #311: <span class="minilabels">Links:</span>
Line #312: <?php if (4 > ) { ?>(4 counting subcategories)<?php } ?>
Line #313: <?php if (1) { ?>
[Load this template in your template editor]
Note that the line of the output is not necessarily the same line number in your template... just look for a similar looking area. The source of your error is probably not on line 313 itself, but most likely a line or two before it. Check your code carefully for syntax mistakes. If you cannot recognize one, copy and paste this output into a thread on the support forum.
Now outputing the page without any conditional or php sections evaluated:
<script type="text/javascript" src="/javascriptheader.php"> onload="if(typeof(load) == 'function'){load();}" onunload="if(typeof(GUnload) == 'function'){GUnload();}">
It was all working OK before the upgrade.
Any help would be appreciated.
Many thanks
Trevor. |
