Distraction's Replies

Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)

Forum: Plugins
In reply to: [Link Library] Entire library broke

Distraction
(@distraction)

11 years, 1 month ago

Thanks for pinpointing the query error.

All part of being married to the site owner 😉

I’ll deactivate debug mode and leave the updating to her. Thanks for your help!

Forum: Plugins
In reply to: [Link Library] Entire library broke
Distraction
(@distraction)

11 years, 1 month ago
Aha! Lines 449 – 458 of render-link-library-sc.php are
```
} elseif ( 'catlist' == $order ) {
            $linkquery .= ' FIELD(t.term_id,' . $categorylist . ') ';
        }

        $linkquery .= ', ';
    }

	if ( $featuredfirst ) {
		$linkquery .= ' , link_featured DESC, ';
	}
```
She has the libraries set to show featured links first, so two consecutive commas are being added to the query.

Deleting the initial comma to so that the code is now
```
if ( $featuredfirst ) {
		$linkquery .= ' , link_featured DESC, ';
	}
```
fixes the problem.
Forum: Plugins
In reply to: [Link Library] Entire library broke

Distraction
(@distraction)

11 years, 1 month ago

Debug shows this SQL query
SELECT distinct *, l.link_id as proper_link_id, UNIX_TIMESTAMP(l.link_updated) as link_date, IF (DATE_ADD(l.link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FROM wp_terms t LEFT JOIN wp_term_taxonomy tt ON (t.term_id = tt.term_id) LEFT JOIN wp_term_relationships tr ON (tt.term_taxonomy_id = tr.term_taxonomy_id) LEFT JOIN wp_links l ON (tr.object_id = l.link_id) LEFT JOIN wp_links_extrainfo le ON (l.link_id = le.link_id) WHERE tt.taxonomy = "link_category" AND t.term_id in (16) AND l.link_visible != "N" ORDER by FIELD(t.term_id,16) , , link_featured DESC, l.link_name ASC

Testing that directly in PHPMyAdmin throws an error unless I remove the extra comma before link_featured on the last line. Any idea what’s producing the extra comma, or what should be in the empty space between the two commas?

Forum: Plugins
In reply to: [Link Library] Entire library broke

Distraction
(@distraction)

11 years, 1 month ago

Debug mode on CarolWP’s site is on now.

Forum: Plugins
In reply to: [Print, PDF, Email by PrintFriendly] Custom CSS works in Chrome, but not other browsers

Thread Starter Distraction
(@distraction)

13 years, 3 months ago

Thanks for the response! I had checked this on two separate computers, and in both cases Chrome was displaying the print version as specified in the custom stylesheet, but Firefox and IE were not. Eventually I gave up for the night – and when I checked again in the morning, all browsers were picking up the custom stylesheet correctly. No idea what the problem was, but I’m going to blame it on gremlins and mark the thread resolved.

Forum: Plugins
In reply to: [Print, PDF, Email by PrintFriendly] Custom CSS works in Chrome, but not other browsers

Thread Starter Distraction
(@distraction)

13 years, 3 months ago

Really? I’m seeing the photo aligned left in Chrome (which is what I specify in the custom stylesheet) but aligned right in Firefox and IE. Are you seeing it aligned left in both, or right in both?

Viewing 6 replies - 1 through 6 (of 6 total)