permalinks problem with latest plugin

6 posts by 3 authors in: Forums > CMS Builder
Last Post: May 24, 2017   (RSS)

By zaba - May 12, 2017

permalinks_1-07

CMS Builder v3.09

Clean install.

A bunch of errors, but I fixed them by changing all mysql instances (in all permalink plugin files) to mysqli in all files and also commenting out the following in permalinks_cmsMenus.php

  // v1.01 upgrade - set old flag on all but the latest permalinks
/*
  if ($upgradeTo101) {
    $allAsOldQuery = "UPDATE {$TABLE_PREFIX}_permalinks SET `old` = 1";
    mysqli_query($allAsOldQuery) or die("mysqli Error: ". htmlencode(mysqli_error()) . "\n");

    $latestAsNewQuery = "UPDATE {$TABLE_PREFIX}_permalinks p1
                           JOIN (SELECT recordNum, MAX(updatedDate) as updatedDate FROM {$TABLE_PREFIX}_permalinks GROUP BY tableName, recordNum) as p2
                             ON p1.recordNum = p2.recordNum AND p1.updatedDate = p2.updatedDate
                            SET old = 0";
    mysqli_query($latestAsNewQuery) or die("mysqli Error: ". htmlencode(mysqli_error()) . "\n");
  }
*/

Not sure yet if this will have any adverse effects, please could you check it out. Sorry didn't make a note of the error messages but I am sure you could replicate.

By ross - May 16, 2017

Hi zaba

Could you double check you are using the latest version of the Permalinks plugin?

The reason I ask is because I can only find the code snippet you posted in version 1.00 to version 1.02. 

That code doesn't exist in Permalinks 1.07 and there are no direct calls to "mysql_query" in Permalinks 1.07.

Let me know how you make out.

Thanks!

-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com

Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/

By Dave - May 23, 2017

Thanks, zaba, 

We've released an updated version to address that issue.  Let me know if you need anything else.

Thanks!

Dave Edis - Senior Developer
interactivetools.com

By zaba - May 24, 2017

Tried to install (activate) the updated version.

get an error.

MySQL Error - by permalink_cms_onInstallCreateSchemas()

By Dave - May 24, 2017

Thanks Zaba, 

I've posted a temporary fix on this thread and we're working on an official patch: 
https://www.interactivetools.com/forum/forum-posts.php?postNum=2240590#post2240590

Can you reply on that thread.  Thanks!

Dave Edis - Senior Developer
interactivetools.com