charlesgodwin

I’m looking at the access problem. Here’s the view definition.

I had to change the quote character to get it past the forums formatter.

CREATE 
    ALGORITHM = TEMPTABLE 
    DEFINER = 'ogsonca'@'localhost' 
    SQL SECURITY INVOKER
VIEW 'ogsonca_ottawa_branch'.'nameindex_library' AS
    SELECT 
        'ogsonca_ottawa_branch'.'nameindex'.'SURNAME' AS 'SURNAME',
        'ogsonca_ottawa_branch'.'nameindex'.'NAME_DATE' AS 'NAME_DATE',
        'ogsonca_ottawa_branch'.'nameindex'.'PAGE' AS 'PAGE',
        'Library Info' AS 'Comment',
        'ogsonca_ottawa_branch'.'nameindex'.'LIBREF' AS 'LIBREF',
        'ogsonca_ottawa_branch'.'library'.'subcallid' AS 'subcallid',
        'ogsonca_ottawa_branch'.'library'.'callid' AS 'callid',
        'ogsonca_ottawa_branch'.'library'.'ID' AS 'ID',
        'ogsonca_ottawa_branch'.'library'.'Category' AS 'Category',
        'ogsonca_ottawa_branch'.'library'.'Classification' AS 'Classification',
        'ogsonca_ottawa_branch'.'library'.'Collection' AS 'Collection',
        'ogsonca_ottawa_branch'.'library'.'Description' AS 'Description',
        'ogsonca_ottawa_branch'.'library'.'keyword' AS 'keyword',
        'ogsonca_ottawa_branch'.'library'.'created' AS 'created',
        'ogsonca_ottawa_branch'.'library'.'Title' AS 'Title',
        'ogsonca_ottawa_branch'.'library'.'Publisher' AS 'Publisher',
        'ogsonca_ottawa_branch'.'library'.'Author' AS 'Author',
        'ogsonca_ottawa_branch'.'library'.'Abstract' AS 'Abstract',
        'ogsonca_ottawa_branch'.'library'.'ISBN' AS 'ISBN',
        'ogsonca_ottawa_branch'.'library'.'modified' AS 'modified',
        'ogsonca_ottawa_branch'.'library'.'Status' AS 'Status',
        'ogsonca_ottawa_branch'.'library'.'dewey' AS 'dewey',
        'ogsonca_ottawa_branch'.'library'.'Oldbook' AS 'Oldbook',
        'ogsonca_ottawa_branch'.'library'.'donated_by' AS 'donated_by'
    FROM
        ('ogsonca_ottawa_branch'.'nameindex'
        JOIN 'ogsonca_ottawa_branch'.'library' ON (('ogsonca_ottawa_branch'.'nameindex'.'LIBREF' = 'ogsonca_ottawa_branch'.'library'.'Classification')))

• This reply was modified 5 years, 3 months ago by charlesgodwin.
• This reply was modified 5 years, 3 months ago by charlesgodwin.

We would really, really, really like this feature.

Please add my vote to the list.

Thanks

Thanks. That fixed it.

• This reply was modified 7 years ago by charlesgodwin.

My email reply didn’t come through. Yes it was visible before.

I’ve considered a delete using wp command line and a re install. what do you think?

Thanks. found it.

The URL is in the original post
https://genealogyalacarte.ca/?feed=rss2

In the English text the column title is Passwords but it should be Password without the ‘s’. Then it works as described.

I found a solution others might like to use.

I added this code to my site code. I used a site specific plugin so I don’t know if it will work in a functions.php in a theme. It is another function for the cron process and with a high priority number runs after the import has completed.

add_action( 'acui_cron_process', 'cg_move_file', 99 ); // rename pre-existing moved file

function cg_move_file () {
  $movefile  = get_option( "acui_cron_path_to_move");
  if ($movefile && file_exists($movefile)) {
    $parts = pathinfo($movefile);
    $filename = $parts['filename'];
    if ($filename){
      $date = date('YmdHis'); 
      $newfile = $parts['dirname'] . '/' . $filename .'_' . $date . '.' . $parts['extension'];
      rename($movefile , $newfile);
    } 
  }
}

I found my problem. This was obscure!

https://www.ads-software.com/support/topic/name-in-query-string-creates-404?replies=8

It also fails if its a POST

It’s my own plugin. But to make it simpler, i’ve removed the plugin from the equation. I’ve developed a simple html file that does the same thing.

Use this URL and just press Search.

https://ogsottawa.on.ca/testpress.html