Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author kjmtsh

    (@kjmtsh)

    Hello,

    FeedWordPress uses MySQL specific functions, which you need to rewrite manually.

    Will you edit the file PLUGINDIR/feedwordpress/feedwordpresssyndicationpage.class.php like below?

    Line 1138

    <div class="updated"><p>There was a problem adding the feed. [SQL: <?php echo esc_html(mysql_error()); ?>]</p></div>

    to

    <div class="updated"><p>There was a problem adding the feed. [SQL: <?php echo esc_html($wpdb->dbh->get_error_message()); ?>]</p></div>

    Line 785

    $errs[] = mysql_error();

    to

    $errs[] = $wpdb->dbh->get_error_message();

    Line 906

    $errs[] = mysql_error();

    to

    $errs[] = $wpdb->dbh->get_error_message();

    If this seems to be difficult, please wait for a patch file to be ready.

    Thanks.

    Thread Starter pebro

    (@pebro)

    Hi,
    no work add new feed :(. Same problem.

    WP 3.6 – no work add
    WP 3.5.1 – work add new feed

    Plugin Author kjmtsh

    (@kjmtsh)

    Hi, pebro.

    Above fix is required for SQLite Integration, but not essential.

    I specified the reason of the error and the critical bug of the plugin thanks to your report. I’m working on it, but it will take some time to fix. So please wait.

    Your report was very enlightening for me. Thank you.

    Plugin Author kjmtsh

    (@kjmtsh)

    Hi,

    I committed the version 1.4 release.
    Update and try fixing the database on the admin dashboard.

    I hope it works.

    Thread Starter pebro

    (@pebro)

    Thx quick update.

    Same problem, not work add new feed in FeedWordPress:)

    Debugging mode:

    There was a problem adding the feed. [SQL: <div style="clear:both"> </div><div class="queries" style="clear:both; margin_bottom:2px; border: red dotted thin;">Queries made or created this session were
    <ol>
    <li>Raw query:	INSERT INTO <code>wp_links</code> (<code>link_url</code>,<code>link_name</code>,<code>link_image</code>,<code>link_target</code>,<code>link_description</code>,<code>link_visible</code>,<code>link_owner</code>,<code>link_rating</code>,<code>link_rel</code>,<code>link_notes</code>,<code>link_rss</code>) VALUES ('http://www.exampledomainfeedhere.com/rrsfeed','Feed name','','','','Y',1,0,'','','http://www.exampledomainfeedhere.com/')</li>
    <li>Rewritten: INSERT OR REPLACE INTO wp_links (link_url,link_name,link_image,link_target,link_description,link_visible,link_owner,link_rating,link_rel,link_notes,link_rss) VALUES ('http://www.exampledomainfeedhere.com/','Name feed','','','','Y',1,0,'','','http://www.exampledomainfeedhere.com/')</li>
    <li>With Placeholders: INSERT OR REPLACE INTO wp_links (link_url,link_name,link_image,link_target,link_description,link_visible,link_owner,link_rating,link_rel,link_notes,link_rss) VALUES ( :param_0 , :param_1 , :param_2 , :param_3 , :param_4 , :param_5 ,1,0, :param_6 , :param_7 , :param_8 ) </li>
    <li>Prepare:	INSERT OR REPLACE INTO wp_links (link_url,link_name,link_image,link_target,link_description,link_visible,link_owner,link_rating,link_rel,link_notes,link_rss) VALUES ( :param_0 , :param_1 , :param_2 , :param_3 , :param_4 , :param_5 ,1,0, :param_6 , :param_7 , :param_8 )</li>
    <li>Executing: array ( 0 => 'http://www.exampledomainfeedhere.com//', 1 => 'Feed name', 2 => false, 3 => false, 4 => false, 5 => 'Y', 6 => false, 7 => false, 8 => 'http://www.exampledomainfeedhere.com/', )</li>
     </ol>
     </div><div style="clear:both; margin_bottom:2px; border: red dotted thin;" class="error_message" style="border-bottom:dotted blue thin;">Error occurred at line 373 in Function execute_query.  Error message was: Error while executing query! Error message was: SQLSTATE[23000]: Integrity constraint violation: 19 wp_links.link_updated may not be NULL </div>
    <pre>#0 PDOEngine->get_error_message() called at [/data/web/virtuals/www/wp-content/plugins/feedwordpress/feedwordpresssyndicationpage.class.php:1138] #1 fwp_switchfeed_page() #2 call_user_func(fwp_switchfeed_page) called at [/data/web/virtuals/www/wp-content/plugins/feedwordpress/feedwordpresssyndicationpage.class.php:360] #3 FeedWordPressSyndicationPage->display() called at [/data/web/virtuals/www//wp-content/plugins/feedwordpress/syndication.php:5] #4 include(/data/web/virtuals/www/wp-content/plugins/feedwordpress/syndication.php) called at [/data/web/virtuals//www/wp-admin/admin.php:165] </pre>
    ]

    Plugin Author kjmtsh

    (@kjmtsh)

    Will you visit the maintenance page in the admin dashboard, and execute “Sanity Check” and “Fix Database”?

    If you have already done that, please follow these steps and give me more information.

    1. download database_maintenance.php in the development version from http://wordpress.org/plugins/sqlite-integration/developers/.

    2. override utilities/database_maintenance.php with the above file.

    3. visit the admin dashboard and go to the SQLite Integration maintenance page.

    4. select wp_links in the select box at the bottom of the page and click “Display Columns”.

    5. post the displayed information to the forum.

    I’ve written a release note, see also http://dogwood.skr.jp/blog/2013/09/367/.

    Thanks.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘FeedWordPress now not word add news feed’ is closed to new replies.