Enabling catch all breaks site about craft-plugin-redirect

[24hoursmedia-craftcms]

What worked for me:

• renaming the {prefix}dolphiq_redirects_catch_all_urls{prefix} table to {prefix}_dolphiq_redirects_catch_all_urls (as described in another issue)
• and then, clearing the cache using the 'utility' section in CPNav

The last step was essential

[johanzandstra]

I will dig into it!

[baileydoestech]

Experiencing the same issue, any idea on when a fix could be implemented?

[AmericanTrails]

Excellent to hear. It’s a great plugin that we’re relying heavily on for our transition to craft. On 7/4/18, 12:03 PM, "Johan Zandstra" <[email protected]<mailto:[email protected]>> wrote: I will dig into it! — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<#49 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AiiJQak6Gv1_ZUy5yaIN9VvsrMA96tI7ks5uDRGVgaJpZM4UB6CM>.

[johanzandstra]

We fixed this issue in the just released version v1.0.17

[AmericanTrails]

I’m still receiving: Internal Server Error Server Error “ When going to the link redirect/registered-catch-all-urls On 7/4/18, 1:46 PM, "Johan Zandstra" <[email protected]<mailto:[email protected]>> wrote: Closed #49<#49>. — You are receiving this because you commented. Reply to this email directly, view it on GitHub<#49 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AiiJQTsMootj5Sg7iug0LkqrNbwMvHVoks5uDSm9gaJpZM4UB6CM>.

[johanzandstra]

Did you set a twig tempalate in the /templates/ dir and point it in the plugin settings, like:

404.twig (set 404.twig in the settings, not the whole absolute path. and else, could you give me a dump if te error?

[johanzandstra]

Reading your post (again), it looks like you have troubles to get the registered list in the plugin section (not visiting a not existing page), please let me know the error from the log!

[AmericanTrails]

Here is the error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'av05116a.craft_dolphiq_redirects_catch_all_urls' doesn't exist The SQL being executed was: SELECT * FROM `craft_dolphiq_redirects_catch_all_urls` WHERE `siteId`=1 ORDER BY `dateUpdated` DESC LIMIT 100 Error Info: Array ( [0] => 42S02 [1] => 1146 [2] => Table 'av05116a.craft_dolphiq_redirects_catch_all_urls' doesn't exist On 7/4/18, 2:00 PM, "Johan Zandstra" <[email protected]<mailto:[email protected]>> wrote: Reading your post (again), it looks like you have troubles to get the registered list in the plugin section (not visiting a not existing page), please let me know the error from the log! — You are receiving this because you commented. Reply to this email directly, view it on GitHub<#49 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AiiJQcH4rXSD42p0CVQJ4Z5JidRhROWYks5uDSzqgaJpZM4UB6CM>.

[johanzandstra]

I see that you use craft_ as a table prefix. The error points out that the table craft_dolphiq_redirects_catch_all_urls does not exist. Can you please verify that the table dolphiq_redirects_catch_all_urls (no craft_ as a prefix) exists in the database? And did you change the prefix setting after the installation?

[AmericanTrails]

No, I do not see any table “dolphiq_redirects_catch_all_urls in the database (with or without the craft_ prefix) On 7/4/18, 2:23 PM, "Johan Zandstra" <[email protected]<mailto:[email protected]>> wrote: I see that you use craft_ as a table prefix. The error points out that the table craft_dolphiq_redirects_catch_all_urls does not exist. Can you please verify that the table dolphiq_redirects_catch_all_urls (no craft_ as a prefix) exists in the database? And did you change the prefix setting after the installation? — You are receiving this because you commented. Reply to this email directly, view it on GitHub<#49 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AiiJQf4ezvxNduj2SHb8n8OrXNv0u4iaks5uDTI9gaJpZM4UB6CM>.

[AmericanTrails]

To your second question, no, I did not (nor do I know how to) change the prefix setting after installation. On 7/4/18, 2:23 PM, "Johan Zandstra" <[email protected]<mailto:[email protected]>> wrote: I see that you use craft_ as a table prefix. The error points out that the table craft_dolphiq_redirects_catch_all_urls does not exist. Can you please verify that the table dolphiq_redirects_catch_all_urls (no craft_ as a prefix) exists in the database? And did you change the prefix setting after the installation? — You are receiving this because you commented. Reply to this email directly, view it on GitHub<#49 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AiiJQf4ezvxNduj2SHb8n8OrXNv0u4iaks5uDTI9gaJpZM4UB6CM>.

[johanzandstra]

looks like you missed a migration script.

can you try to run
./craft migrate/up --plugin=redirect

from you project craft folder?

see: https://docs.craftcms.com/v3/plugin-migrations.html#executing-migrations

[baileydoestech]

Seeing the same issue, the migration seems to append the database prefix to the end of the table name:

[baileydoestech]

Hi is there any update on getting this resolved please?

[dowadidi]

+1 :-)