× Here you can get community support related to ReDJ.

Cannot redirect hyphenated URLs

  • albert8675
  • Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 2 months ago #1497 by albert8675
Cannot redirect hyphenated URLs was created by albert8675
When I tried to redirect hyphenated URLs:

From URL: /go-to.php
To URL: /index.php

Then the following error message comes up:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'catid) AND `alias` = 'go-to.php'' at line 3 SQL=SELECT `id` FROM table_content WHERE FIND_IN_SET(,catid) AND `alias` = 'go-to.php'

Please help! Thanks!

Please Log in or Create an account to join the conversation.

More
11 years 2 months ago #1500 by admin
Replied by admin on topic Cannot redirect hyphenated URLs
Hi,
the right rule should be:
From URL: ^/go-to\.php$
To URL: http://{siteurl}/index.php
Request only: true (checked)

Anyway, from the MySQL error message it doesn't seem an issue related to ReDJ tables, so is strange to me...

Try to fix rule, if the problem persists I will check your site in some way.

Kind regards,
Luigi

Please Log in or Create an account to join the conversation.

  • albert8675
  • Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 2 months ago #1502 by albert8675
Replied by albert8675 on topic Cannot redirect hyphenated URLs
Hi,

Thank you for the reply!

I changed the rule but same error message...

The point is, use underscore (go_to.php) works...
Attachments:

Please Log in or Create an account to join the conversation.

More
11 years 2 months ago #1504 by admin
Replied by admin on topic Cannot redirect hyphenated URLs
Sorry but I cannot see URL from the screenshot. Can you send me the source (original) URL that should be redirected? You can publish here or send me an email at info(at)selfget.com.

Please Log in or Create an account to join the conversation.

  • albert8675
  • Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 2 months ago #1511 by albert8675
Replied by albert8675 on topic Cannot redirect hyphenated URLs

Sorry but I cannot see URL from the screenshot. Can you send me the source (original) URL that should be redirected? You can publish here or send me an email at info(at)selfget.com.


I made 2 redirects:

go-to.php and go_to.php, both point to index.php,

You can try at www.chinagolfntour.com/go-to.php and www.chinagolfntour.com/go_to.php and you will know what I am talking about.

Please Log in or Create an account to join the conversation.

More
11 years 2 months ago #1513 by admin
Replied by admin on topic Cannot redirect hyphenated URLs
Thank you.
The second one works and return a 301 redirect to the index.php. The first one return an error 500, an I do not think is caused by ReDJ or better, ReDJ is not able to intercept it.

You should send me a dump of your ReDJ rules table.

Please Log in or Create an account to join the conversation.

Time to create page: 0.155 seconds