Webmastersite.net
Register Log In

Bulk edit links mysql error

Title Bulk edit links mysql error
Message Text I've just upgraded to 3.3.21 and now I get an error on the bulk edit links page. Here's the part of the debug:
Warning: Cannot modify header information - headers already sent by (output started at /home/linklou/public_html/classes/database.php:276) in /home/linklou/public_html/end.php on line 142

Load time so far: 0.53 seconds.
Performing query: SELECT FROM utable WHERE validated=1 AND (spotlight='yes' and filefield=1) ORDER BY rand() ASC LIMIT 0,1;

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/linklou/public_html/classes/database.php on line 108

Number of rows is for 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 utable WHERE validated=1 AND (spotlight='yes' and filefield=1) ORDER BY ran' at line 1

Load time so far: 0.62 seconds.
Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ;

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 utable WHERE validated=1 AND (spotlight='yes' and filefield=1) ORDER BY ran' at line 1

Number of rows is 938 for Resource id #56
I have a toplist in the wrapper which randomly displays a link button, and it's working fine on every other site (as far as I can tell right now), but on this page it's not showing up. At first I was thinking that there's a conflict with the toplist number, but changing that number didn't change the error, and I think the bulk edit page isn't using a toplist anyway, right? Editing is working fine also, just wondering what's causing this... smiling face
Rating
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5
0/5 based on 0 votes.
Ownership Jenny
Views 562 views. Averaging 0 views per day.
Similar Topics
Submission Date Jul 05, 2006 - 7:27 AM