Recommended Posts

5 hours ago, Mike Rockett said:

@Joss Hi - that's a legacy error from an earlier version of MySQL. What version are you running?

This is on a shared server and according to phpmyadmin, it is  5.1.73

Share this post


Link to post
Share on other sites

@Mike Rockett - Apparently, that error will also show on 5.5, which is what the server is running, the company have told me. I will probably migrate at some point.

Share this post


Link to post
Share on other sites
50 minutes ago, Joss said:

@Mike Rockett - Apparently, that error will also show on 5.5, which is what the server is running, the company have told me. I will probably migrate at some point.

I'd be inclined to switch to a newer version. Even 5.6.5, which is when they changed it, is considerably old now. Due to its age, I don't plan on supporting it.

In the interim, you could always try removing DEFAULT CURRENT_TIMESTAMP from the schema file (schema-create-mc.sql) before installation as the insert statement does force it. Untested, but it should work in theory.

Share this post


Link to post
Share on other sites

When I installed this module on my pw site, I got following two erros

 Module reported error during install (ProcessJumplinks): SQLSTATE[HY000]: General error: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

Failed to init module: ProcessJumplinks - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lara_db.process_jumplinks' doesn't exist

pw 2.8.35
php 5.5.9
mysql 5.5.55

 

Share this post


Link to post
Share on other sites
On 7/12/2017 at 2:54 AM, adrianmak said:

When I installed this module on my pw site, I got following two erros

 Module reported error during install (ProcessJumplinks): SQLSTATE[HY000]: General error: 1293 Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

Failed to init module: ProcessJumplinks - SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lara_db.process_jumplinks' doesn't exist

pw 2.8.35
php 5.5.9
mysql 5.5.55

 

Hi there - you will need to upgrade your version of MySQL. Version 5.5 is no longer supported, since end-2015. I recommend you use MySQL 5.7, or switch to MariaDB.

Share this post


Link to post
Share on other sites

Hi Mike

I have a multi-lingual MODX site which I've rebuilt in Processwire.

PW site isn't live but is on a test server.

As the MODX version currently has around 500 resources (lets say 500 URIs) I am keen to follow the old alleged Abraham Lincoln advice

Quote

Give me six hours to chop down a tree and I will spend the first four sharpening the axe.

I'm thinking of doing following and wanted to sanity check my approach

1. Get a sitemap of the entire MODX site into a XLS or CSV and import into Jumplinks

2. Manually go through each "old" URL and update to the new URL

Am I missing something crucial apart from keeping an eye on Google's Search Console (was Webmaster tools) and watching for 404 hits. I'll enable 404 monitoring on Jumplinks too.

Cheers for any pre flight advice. 

 

 

  • Like 1

Share this post


Link to post
Share on other sites
6 minutes ago, Peter Knight said:

Hi Mike

I have a multi-lingual MODX site which I've rebuilt in Processwire.

PW site isn't live but is on a test server.

As the MODX version currently has around 500 resources (lets say 500 URIs) I am keen to follow the old alleged Abraham Lincoln advice

I'm thinking of doing following and wanted to sanity check my approach

1. Get a sitemap of the entire MODX site into a XLS or CSV and import into Jumplinks

2. Manually go through each "old" URL and update to the new URL

Am I missing something crucial apart from keeping an eye on Google's Search Console (was Webmaster tools) and watching for 404 hits. I'll enable 404 monitoring on Jumplinks too.

Cheers for any pre flight advice. 

Hi Peter

  1. Can any of these resources/uris be combined into a pattern? If there are 500 resources, I'm sure the tree can be simplified somewhat, albeit aside technicalities such as the difference in how the two platforms create URIs (or if they've been manually set in modx).
  2. If you do a sitemap, how will you generate new uris to map to PW Pages?

At the end of the day, as long as things match up, I don't see any further issues. Not sure on how Modx works (I tried it once, didn't like it), but keep an eye out for trailing slashes as well.

In your specific instance, the 404 monitor is limited to 100 - you'd need to change the code to get it to show more, and that might be client-resource-intensive. JL2 will handle this better.

  • Like 1

Share this post


Link to post
Share on other sites
18 hours ago, Mike Rockett said:

Hi Peter

  1. Can any of these resources/uris be combined into a pattern? If there are 500 resources, I'm sure the tree can be simplified somewhat, albeit aside technicalities such as the difference in how the two platforms create URIs (or if they've been manually set in modx).
  2. If you do a sitemap, how will you generate new uris to map to PW Pages?

At the end of the day, as long as things match up, I don't see any further issues. Not sure on how Modx works (I tried it once, didn't like it), but keep an eye out for trailing slashes as well.

In your specific instance, the 404 monitor is limited to 100 - you'd need to change the code to get it to show more, and that might be client-resource-intensive. JL2 will handle this better.

Hi Mike

I think I'll prioritise the 100 or so most important URLs and then I can work through the others gradually. Client confirmed that actually they don't rank terrible well anyway so it looks like a relatively fresh start and the pressure is off.

Just have to upgrade to MySQL 5.6 as it's currently running 5.1.X


 

  • Like 1

Share this post


Link to post
Share on other sites

Hello Mike,

I'm trying to run Jumplinks on a server running MySQL 5.7.16, and I keep getting this error from ProcessWire:

Failed to init module: ProcessJumplinks - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'last_hit'

This is Jumplinks version 1.5.48. We used the same version of the module on another site on the same server within the last few months, and it's working fine there - so I can't understand why this isn't working. It allows me to add redirects, but they don't redirect when loaded. I was also unable to edit the module configuration from the Manage Jumplinks page - the url changed to root/module/edit?name=ProcessJumplinks, and then gave the error "Unrecognized Path". 

 

If you have any insight you could offer, I'd be most appreciative! Thanks.

Share this post


Link to post
Share on other sites

Hi @melody - thanks for the post. This has popped up before, and still not sure as to why. When it happened, I asked Zeka to delete the last_hit column and refresh the modules. It turns out that he had to delete the process_jumplinks_nf table as well, and it started to work properly. Why that is the case, I still do not know... 

You can follow the brief thread from here to see what happened: 

Let me know if those steps work for you. You might land up having to add the nf table manually and increasing the schema version in the module's configuration via phpMyAdmin or whatever tool you use to manually edit DBs.

 

  • Like 1

Share this post


Link to post
Share on other sites

Hi @Mike Rockett -- @melody and I took a look at this this morning. It looks like this is an issue with 0000-00-00 00:00:00 null dates in our strict MySQL environment. After replacing the NULL_DATE constant at the top of the module file with 'CURRENT_TIMESTAMP' and replacing the 0000-00-00 00:00:00 dates in Blueprints/schema-update-v2.sql and Blueprints/schema-update-v3.sql with the same, the problem went away after re-installing the module.

Hope that helps.

  • Like 1

Share this post


Link to post
Share on other sites
1 hour ago, thetuningspoon said:

Hi @Mike Rockett -- @melody and I took a look at this this morning. It looks like this is an issue with 0000-00-00 00:00:00 null dates in our strict MySQL environment. After replacing the NULL_DATE constant at the top of the module file with 'CURRENT_TIMESTAMP' and replacing the 0000-00-00 00:00:00 dates in Blueprints/schema-update-v2.sql and Blueprints/schema-update-v3.sql with the same, the problem went away after re-installing the module.

Hope that helps.

Thanks for letting me know. This date story has me in a tizz because I'm not seeing the correct way to use [auto-updating] timestamps and still support all MySQL enviros... Unless I'm missing something here. Had the same issue with Laravel, and they had to introduce nullableTimestamps() into the schema system. I'm actually using Illuminate for Jumplinks 2, but not sure if it'll work in every environment...

Share this post


Link to post
Share on other sites

Hi Mike

I'm creating Jumplinks for a multilingual site and I was wondering what you advise when I come across a URL like following in the 404 monitor

/it/products/hooks/ganci-piatto/182728

That's an old URL from the italian tree of the site

The reason I'm asking is because when I browse to tree or auto-complete, I can pull up the 1827288 product page but it's not necessarily italian.

Should I manually Specify a destination in these cases and ensure we're manually pointing at the correct launguage?
 

Share this post


Link to post
Share on other sites
16 hours ago, Peter Knight said:

Hi Mike

I'm creating Jumplinks for a multilingual site and I was wondering what you advise when I come across a URL like following in the 404 monitor

/it/products/hooks/ganci-piatto/182728

That's an old URL from the italian tree of the site

The reason I'm asking is because when I browse to tree or auto-complete, I can pull up the 1827288 product page but it's not necessarily italian.

Should I manually Specify a destination in these cases and ensure we're manually pointing at the correct launguage?
 

Hi Peter,

From the top of my head, you could potentially use mapping collections to make it language aware; however, that means importing the entire dataset and using multiple languages - one collection for each language. How are your other URIs being handled?

Share this post


Link to post
Share on other sites
On 14/08/2017 at 7:07 AM, Mike Rockett said:

Hi Peter,

From the top of my head, you could potentially use mapping collections to make it language aware; however, that means importing the entire dataset and using multiple languages - one collection for each language. How are your other URIs being handled?

Hi Mike

each language is handled by a folder named after the language

domain.com/fr/ 
domain.com/de/ 
domain.com/it/ 
domain.com/es/ 

 

Share this post


Link to post
Share on other sites
9 hours ago, Peter Knight said:

Hi Mike

each language is handled by a folder named after the language

domain.com/fr/ 
domain.com/de/ 
domain.com/it/ 
domain.com/es/ 

 

You're probably going to need to do it manually. As Jumplinks 1 is not multi-lang-aware, there's no way for the destination field to know which language you need, unless you declare it manually, or by means of a mapping collection, one for each language. Destination selectors won't help as they are also not aware of languages.

So your collection could be called "italian", and would contain this:

100=/it/uri/to/page
101=/it/uri/to/other/page
102=/it/uri/to/product

And then define the language jumplink:

Source: it/{all}/{id}
Destination {id|italian}

This assumes that your ids are all different between content types (like product, etc.). You would also need to build your collections via a script, and that would require each destination page having a field with the old ID.

Share this post


Link to post
Share on other sites

Hi,

I've searched for a long time, but could not find an answer:

We relaunched a old website with a URL structure like that:

http://www.example.com/?main=notice	
http://www.example.com/?main=contact	
http://www.example.com/?main=film	
http://www.example.com/?main=references	
http://www.example.com/?main=products&sub=sunb

 Is it possible to redirect this old links via Jumplinks? I tiedy to define "?main=notice" as source but this don't work - I get the homepage with the original parameter attached ;-(.

Can you please give me a hint, many greets, Jens alias DV-JF

Share this post


Link to post
Share on other sites
3 hours ago, DV-JF said:

Hi,

I've searched for a long time, but could not find an answer:

We relaunched a old website with a URL structure like that:


http://www.example.com/?main=notice	
http://www.example.com/?main=contact	
http://www.example.com/?main=film	
http://www.example.com/?main=references	
http://www.example.com/?main=products&sub=sunb

 Is it possible to redirect this old links via Jumplinks? I tiedy to define "?main=notice" as source but this don't work - I get the homepage with the original parameter attached ;-(.

Can you please give me a hint, many greets, Jens alias DV-JF

Hi,

It is discussed somewhere in this thread. The problem is that a request like that is a request to the home page, and so the 404 event will not be triggered, and so Jumplinks cannot intervene and do the redirect.

You will need to use .htaccess to redirect all of those requests to something that Jumplinks can handle. Unfortunately, this will result in two redirects every time, but it's something you would need to work with in order to use Jumplinks.

In your .htaccess file, add the following on line 99 (just below AddDefaultCharset):

RewriteCond %{QUERY_STRING} ^main=(.+)$ [NC]
RewriteRule ^$ /rq [R=302]

When you request example.com/?main=something, it will be redirected to example.com/rq?main=something, and then you can create a jumplink for it.

  • Thanks 1

Share this post


Link to post
Share on other sites

I don't seem to get it to redirect at all. Or maybe I don't get it right? Is this module compatible with processwire 3.0 with multiple languages enabled?

My source (old url) is: 

Quote

de/foobar

My destination is a selected page that exists.

If I call https://mydomain.com/de/foobar I just get a 404 instead of the page I'm looking to redirect to.

Share this post


Link to post
Share on other sites
On 9/4/2017 at 11:40 AM, DarsVaeda said:

I don't seem to get it to redirect at all. Or maybe I don't get it right? Is this module compatible with processwire 3.0 with multiple languages enabled?

My source (old url) is: 

My destination is a selected page that exists.

If I call https://mydomain.com/de/foobar I just get a 404 instead of the page I'm looking to redirect to.

Jumplinks is compatible with v3 (though not thoroughly tested). As for multi-language, it is not specifically supported in terms of the additional features. However, a 404 event would still trigger the jumplinks routine. Please enable debug mode in Jumplinks' config and paste that log here. If it's very long, please add as an attachment.

Share this post


Link to post
Share on other sites

It's strange. I guess this has nothing to do with jumplinks.

https://mydomain.com/de/existing-page/non-existing -> 404 -> I get the jumplink debug page

https://mydomain.com/de/non-existing -> I just get the root page

 

@edit: aahhh I found it! URL Segements was turned on but not handled. So everything not existing was just redirected to frontpage.

  • Like 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By FrancisChung
      Hi,
      I was wondering if anyone knew what this did? 

      If so, do you know what modules it actually impacts? Is there another log that lists the action it took?

      I'm having some weird problems with PHP duplicate declaration per link below, since this module was run.
       
       
    • By tpr
      AdminOnSteroids
      Various admin tweaks to enhance ProcessWire admin.
      http://modules.processwire.com/modules/admin-on-steroids/
      https://github.com/rolandtoth/AdminOnSteroids

    • By Macrura
      Field Descriptions Extended
      This module enables you to extend field descriptions by dividing short descriptions with a longer text that is revealed in a toggle.
      Github: https://github.com/outflux3/FieldDescriptionsExtended
      Extending your field descriptions using the standard field's description field.
      Once this module is installed, it will automatically search your description field for the presence of 5 dashes (-----).
      Any content above the 5 dashes will be visible and the content below the dashes will be hidden. A 'More...' link will appear at the end of the short description which when clicked will reveal the rest of the description.
      Using Simple Markdown Editor with the description field
      If you have Simple Markdown Editor (InputfieldSimpleMDE) installed, you can enable the field description to have that editor.
      *When using Simple MDE, you can use the button (Insert Horizontal Line) instead of typing 5 dashes. More about SimpleMDE.
      Extending your field descriptions using content from a ProcessWire Page for the field description.
      You may use the content from a ProcessWire page as a field description. This would allow you to easily insert images, links, and use hanna codes.
      To use page content for your field descriptions, please follow these instructions:
      Install Select Fields module (FieldtypeFields) http://modules.processwire.com/modules/fieldtype-fields/ Create a new field using this field type, e.g. field_select. Add the field to any template you will be using for your field descriptions. Setup your help pages (for example under a settings branch) where you will store the field description content,using the template containing the Field Select. Add content to a page and select the field where that content should show. To show a short text before the link to the longer content, separate them with 5 dashes Be sure to update your settings on this page, first enable page content descriptions,then specify the name of the Select Fields field, template to search, and content field. If you create a field description using this method, please note that the description field must be blank for contexts where you want the page content to appear.
      You can freely use template context for field descriptions, but the Page Content method is not context sensitive and will display under all contexts where the description is blank.
      ----
      original post:
      This is a new module, hope to release soon, which allows extended field descriptions, in currently 2 ways.
      The main feature of the module is that you can have a short description and then a 'more...' link which drops down a longer block of text.
      This is achieved by separating the intro/visible text and the rest with 5 dashes.

      Example setup:

      the 2nd way is if you are using AdminThemeUiKit, you can show extended field instructions in a panel. The content of the panel is edited on a regular PW page. This use case would probably not be that common, but if you had a field that required some extended instructions for how to use, this could be useful; Also, since this allows you to target information and instructions down at the field level, it could reduce the amount of documentation needed on a global level, since it is a lot more context targeted.

    • By netcarver
      Part 1 of a 2 part Module & Service Reveal.
      I'm currently working on a new module: ModuleReleaseNotes that was inspired by the work I originally did on making Ryan's ProcessWireUpgrades module "release" aware. In the end, I decided to ditch the approach I was originally taking and instead work on a module that hooked in to the UpgradeConfirmation dialog and the module edit page.
      Aims
      My aims for this module are as follows...
      Make discovery of a module's changes prior to an upgrade a trivial task. Make breaking changes very obvious. Make reading of a module's support documentation post-install a trivial task. Make module authors start to think about how they can improve the change discovery process for their modules. Make sure the display of information from the module support files/commit messages doesn't introduce a vulnerability. Looking at these in turn...
      Making discovery of a module's changes prior to upgrade a trivial task.
      This is done by adding a "What's changed section" to the upgrade confirmation dialog.  This section takes a best-effort approach to showing what's changed between the installed version and the updated version that's available via the module repository.
      At present, it is only able to talk to github-hosted repositories in order to ask them for the release notes, the changelog file (if present) and a list of commits between the git tag that matches the installed version and the tag matching the latest version.
      It will display the Release Notes (if the author is using the feature), else it will display the commits between the tags (if tagging is used by the module author) else it will show the changelog file (if present) else it will show the latest N commits on the master branch (N, of course, being configurable to your liking.)
      An example of the Github Release Notes pulled in for you, taken from Mike Rockett's TextformatterTypographer Module...

      An example of a tag-to-tag commit list from the same module...

      An example of a changelog - formatted to show just the changes (formatting styles will change)...

      Finally, an example of a fallback list of commits - sorry Adrian ...

       
      Making breaking changes obvious.
      This is currently done by searching for a set of configurable search strings. Later versions may be able to support breaking change detection via use of Semantic Versioning - but this may require some way of signalling the use of this versioning standard on a module-by-module basis.
      For now, then, you can customise the default set of change markers. Here I have added my own alias to the list of breaking change markers and the changes section of the changelog is styled accordingly (these will be improved)...

       
      Make reading of a module's support documentation, post-install, a trivial task.
      This is done by making some of the support files (like the README, CHANGELOG and LICENSE files) readable from the module's information/settings screen. There is an option to control the initial open/closed state of this section...

      Here is Tracy's README file from within the module settings page... 

       
      Make module authors start to think about how they can improve the change discovery process for their modules.
      There are notes in each of the sections displayed on the upgrade confirmation page that help authors use each of the features...

       
      Make sure display of external information doesn't introduce a vulnerability.
      This is an ongoing concern, and is the thing that is most likely to delay or prevent this module's release lead to this module's withdrawl should a vulnerability be found. Currently, output is formatted either via Markdown + HTML Purifier (if it was originally a Markdown file) or via htmlspecialchars() if it has come from a plaintext file.
      If you discover a vulnerability, please get in contact with me via the forum PM system.
       
      Ongoing...
      For now, I've concentrated on integration with GitHub, as most people use that platform to host their code. I know a few people are hosting their repositories with BitBucket (PWFoo comes to mind) and some with GitLab (Mike Rockett?) and I would eventually like to have adaptor implementations for these providers (and perhaps GitKraken) - but for now, GitHub rules and the other hosts are unsupported.
       
      Links
      Github: ModuleReleaseNotes
      PW Module Repository: Here (pending?)