SQL

  • Resolved Andrzej Klasén

    (@bibeldans)


    2 years, 7 months ago

    Hi again!

    Maybe it’s a problem with my MySQL Server:

    MySQL Version 10.5.21 MariaDB Server

    archive.php

        $sql = “CREATE OR REPLACE VIEW {$wpdb->prefix}redirection_logs_view AS

          SELECT * FROM {$wpdb->prefix}redirection_logs

          UNION ALL

          SELECT * FROM {$wpdb->prefix}redirection_logs_archive“;

    #1222 – The used SELECT statements have a different number of columns

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Andrzej Klasén

    (@bibeldans)

    2 years, 7 months ago

    SQL Statement:

    SELECT * FROM wp_redirection_logs UNION ALL SELECT * FROM wp_redirection_logs_archive;

    Plugin Author mrdenny

    (@mrdenny)

    2 years, 7 months ago

    I know the problem. Back when I created the view the columns would have matched. I’m out for a view days, but I’ll put together a new CREATE VIEW script and release an update which includes it.

    Plugin Author mrdenny

    (@mrdenny)

    2 years, 7 months ago

    I just uploaded a new version of the plugin which has a new version of the view.

    Sorry it took so long, every time I remembered that I needed to do this I was away from my computer.

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

The topic ‘SQL’ is closed to new replies.

Tags