[ZenCart] EZ-Pages don't get the magic
[ZenCart] EZ-Pages don't get the magic
I just noticed that practically all pages get a nice URL from Magic SEO URL except the EZ-Pages... which is a pity since I quite often use them in our shop. Is there a way to enable them?
Or do I need to manually add rules to the .htaccess file? (And if yes, how?)
Thanks!
Mick
Re: [ZenCart] EZ-Pages don't get the magic
Re: [ZenCart] EZ-Pages don't get the magic
I just checked the tables zen_ezpages & zen_ezpages_content, one entry was indeed wrong. I corrected it and regenerated the htaccess. Unfortunately it still doesn't work.
I've installed the zen cart mod called multilanguage_ezpages_1-3-0-5v2-01. Do you think this might interfere with Magic SEO? Would it help you to have a look at my database?
Kind regards,
Mick
Re: [ZenCart] EZ-Pages don't get the magic
Code: Select all
SELECT pages_title FROM ezpages WHERE pages_id = '<id>' AND languages_id = '<active_language>'
Re: [ZenCart] EZ-Pages don't get the magic
Installation of the mod multilanguage_ezpages_1-3-0-5v2-01 introduces a new table called zen_ezpages_content where all the multilingual content is placed including titles and languageid's.
This could be problematic...
Is there a possibility you make a special compilation where you change your code to new table (ezpages_content), columns pages_id and languages_id are named exactly the same...
Code: Select all
SELECT pages_title FROM ezpages_content WHERE pages_id = '<id>' AND languages_id = '<active_language>'
I hope so!
Re: [ZenCart] EZ-Pages don't get the magic
Re: [ZenCart] EZ-Pages don't get the magic
We are using your add on in one of our website and would like to buy a second one for another site (which is multi langual). However, we have the same issue as described above. We don't feel comfortable about changing the table name to ezpages_content in database_tables.php as this will impact all other scripts that refer to ezpages table (There are columns in ezpages that do not exist in ezpages_content). Is it possible to have a different compile as suggested above.
Thank you
Regards
Re: [ZenCart] EZ-Pages don't get the magic
Re: [ZenCart] EZ-Pages don't get the magic
~J~ wrote:More clean solution will be to make appropriate change to TABLE_EZPAGES constant in includes/database_tables.php.
Hi Jiri, to solve this problem I made this simple workaround:
Code: Select all
define('TABLE_EZPAGES', DB_PREFIX . 'ezpages_content');
include(DIR_WS_INCLUDES . 'magic_seo_url.php');
define('TABLE_EZPAGES', DB_PREFIX . 'ezpages');
But, nothing changed, the title still was taken from ezpages table.
May you confirm that the query uses the define TABLE_EZPAGES and not the table name itself?
Re: [ZenCart] EZ-Pages don't get the magic
So, jiry, please this thing must be solved.
We cannot modify the define since it's needed that way in a lot of other scripts.
If you are worried about compatibility issues, the solution is quite simple:
just a check if TABLE_EZPAGES_TEXT is defined.
If yes use TABLE_EZPAGES_TEXT, if not, use TABLE_EZPAGES in your query.
Isn't it simple?