It would be good to remind us of the link to the Printcasting site.

http://www.printcasting.com...

As it is, I have to look for old posts.

BTW, I'd like to give a shout out to Mary Lou Fulton who has decided to move on from the day-to-day at the Californian.  She brought a lot of great ideas into the publishing world, had (at least) a hand in all of the new Californian products over the last several years and Printcasting wouldn't exist without her.   While she will remain on the board of the Californian, her energy and way of sifting through vast amounts amounts of data and cultural macrotrends to help position the paper for the future will be missed in the daily grind.

All the best and thank you, Mary Lou.

I still get the following when trying to "Approve Content" on the issue "awaiting approval."

• user warning: 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 pfa.publisher_publication_id = 71 and issue_id = 1 order by cfa.timestamp' at line 2 query: select pfa.* from tbl_publisher_publication_feed_article pfa, contributor_feed_article cfa where cfa.contributor_feed_id = 99 and pfa.article_id = cfa.contributor_feed_article_id and contributor_feed_article_id in () and pfa.publisher_publication_id = 71 and issue_id = 1 order by cfa.timestamp desc in /var/www/html/includes/database.mysql.inc on line 172.
• user warning: 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 ') order by timestamp desc' at line 1 query: select contributor_feed_article_id,title,body from contributor_feed_article where contributor_feed_id = 99 and contributor_feed_article_id in () order by timestamp desc in /var/www/html/includes/database.mysql.inc on line 172.
• user warning: 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 pfa.publisher_publication_id = 71 and issue_id = 1 order by cfa.timestamp' at line 2 query: select pfa.* from tbl_publisher_publication_feed_article pfa, contributor_feed_article cfa where cfa.contributor_feed_id = 91 and pfa.article_id = cfa.contributor_feed_article_id and contributor_feed_article_id in () and pfa.publisher_publication_id = 71 and issue_id = 1 order by cfa.timestamp desc in /var/www/html/includes/database.mysql.inc on line 172.
• user warning: 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 ') order by timestamp desc' at line 1 query: select contributor_feed_article_id,title,body from contributor_feed_article where contributor_feed_id = 91 and contributor_feed_article_id in () order by timestamp desc in /var/www/html/includes/database.mysql.inc on line 172.
• user warning: 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 pfa.publisher_publication_id = 71 and issue_id = 1 order by cfa.timestamp' at line 2 query: select pfa.* from tbl_publisher_publication_feed_article pfa, contributor_feed_article cfa where cfa.contributor_feed_id = 95 and pfa.article_id = cfa.contributor_feed_article_id and contributor_feed_article_id in () and pfa.publisher_publication_id = 71 and issue_id = 1 order by cfa.timestamp desc in /var/www/html/includes/database.mysql.inc on line 172.
• user warning: 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 ') order by timestamp desc' at line 1 query: select contributor_feed_article_id,title,body from contributor_feed_article where contributor_feed_id = 95 and contributor_feed_article_id in () order by timestamp desc in /var/www/html/includes/database.mysql.inc on line 172.
• user warning: 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 pfa.publisher_publication_id = 71 and issue_id = 1 order by cfa.timestamp' at line 2 query: select pfa.* from tbl_publisher_publication_feed_article pfa, contributor_feed_article cfa where cfa.contributor_feed_id = 103 and pfa.article_id = cfa.contributor_feed_article_id and contributor_feed_article_id in () and pfa.publisher_publication_id = 71 and issue_id = 1 order by cfa.timestamp desc in /var/www/html/includes/database.mysql.inc on line 172.
• user warning: 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 ') order by timestamp desc' at line 1 query: select contributor_feed_article_id,title,body from contributor_feed_article where contributor_feed_id = 103 and contributor_feed_article_id in () order by timestamp desc in /var/www/html/includes/database.mysql.inc on line 172.

Approve "The Violet End"

Review and approve the current content. Edit the headlines with the link to the right of each headline.
 

Heh.  My bad, Apollo.  I'll get that fixed up right now.  :)

OK, Apollo.  Let me send that over again and find and answer for you.

Apollo, you can always get to the link via the Printcasting widget in my sidebar just below the archives section.  Let me know if you'd like one of these to link to your magazine from here as well.

Thank you; the widget works.

To your second question, feel free to link.  :)

I guess my fix is just wishful thinking?  :(

I still can't approve what's waiting there without an error.

Let me help out a bit. The problem in all of those queries is this part: "contributor_feed_article_id in ()". Note that there are no article IDs inside the parentheses. That's what's killing the queries.