WordPress.org

Ready to get started?Download WordPress

Forums

SQLite Integration
FeedWordPress now not word add news feed (7 posts)

  1. pebro
    Member
    Posted 10 months ago #

    Hi, new WordPress 3.6 bug.

    Not work add news feed in plugin FeedWordPress.

    Show error:There was a problem adding the feed. [SQL: ]

    Please fix.
    Thank you ;)

    http://wordpress.org/plugins/sqlite-integration/

  2. kjmtsh
    Member
    Plugin Author

    Posted 10 months ago #

    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.

  3. pebro
    Member
    Posted 10 months ago #

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

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

  4. kjmtsh
    Member
    Plugin Author

    Posted 10 months ago #

    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.

  5. kjmtsh
    Member
    Plugin Author

    Posted 10 months ago #

    Hi,

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

    I hope it works.

  6. pebro
    Member
    Posted 9 months ago #

    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>
    ]
  7. kjmtsh
    Member
    Plugin Author

    Posted 9 months ago #

    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.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.