Simple SEO URL (OLD version) [support thread]

[giuly]

I have installed this mod and it is great, but I have a problem:

with ezpages, for the ezpages with external links I don't have problem.
But with the ezpages with a text page and not external or internal links I have the problem
error 1054 ezpages
In fact if I disabled SSU the problem disappear.

1054 Unknown column 'pages_title' in 'field list'
in:
[SELECT pages_title FROM ezpages WHERE pages_id ='6' AND languages_id = '2']

you try
hxxp://www.giocattoliamo.it/demosugar/
and click on right on guida per registrarsi

please

[yellow1912]

You will have to check your zen version as well as your ezpage table. The column pages_title should be in your ezpages table.

[yellow1912]

I have got it installed, installation went smooth and I have been able to activate the modules. However, when I try to click on any category, it just sent me to the home page instead of loading the category product page.

I am using ZC 1.3.8a. I have previously have the SEO-URLs Beta installed, however, I have disable the modules in Admin and have also change the .htaccess to the one provided by SSU. Running on Windows platform.

Any idea where I am doing wrong?

If you run it on windows platform (IIS), I believe you need to have htaccess module installed. Maybe you can check with your host regarding this issue.

[giuly]

sorry I don't understand.

My version of zencart is 1.3.8a
my hosting is on linux
but all the other pages and products SSU goes
Only it doesn't go for that link of ezpage

[yellow1912]

sorry I don't understand.

My version of zencart is 1.3.8a

The error says that you dont have the column named pages_title in your ezpages table. But this column should be there if you have zen 1.3.8a. That is why I suggest you checking your table. You can use phpmyadmin to view the structure of the table

[giuly]

the pages_title there is in the table ez_pages_content

I have controlled another my site (that goes, but the setting is the same)

I paste here how I see the ezpages table

in the page title it says for the link that doesn't go
rows 3???
for other links rows 1

[yellow1912]

the pages_title there is in the table ez_pages_content

I have controlled another my site (that goes, but the setting is the same)

I paste here how I see the ezpages table

I suspect your zencart version may be updated from an old version? Because there is no table ez_pages_content in the default 1.3.8a. There is only table ezpages, which has pages_title column in that.

Anyhow, there is a way to work around that with your current database structure. But I do suggest you to check if your database is really up-to-date. You can go to admin, then go to version on the right hand side and see your zen database version/patch level.

[yellow1912]

I suspect you use the ez-pages multi language module, this module moves the pages_title to another table.

One way to get around that is:

Open your includes/classes/ssu/plugins/parsers/pages.php

Find this line

        static $table            = TABLE_EZPAGES; 

Replace by

        static $table            = TABLE_EZPAGES_TEXT; 

[giuly]

i have installed a new version of 1.3.8a and not upgrade.


You are GREAT!!!!
it goes with the fix
TABLE_EZPAGES_TEXT;

[merrydown]

A bit of feedback, I'll try to be brief, I know you are busy... I tried your suggestion below and everything I tried broke the page (adding the 'en' =>'en' into the array and so on.

However I changed the /includes/classes/ssu/cores/language.php code (as you said in the thread given) and changed:
-----------------------
function removeNonAlphaNumeric($name, $name_delimiter){
return preg_replace("/[^a-zA-Z0-9]/", $name_delimiter, $name);
}
-----------------------
to:
-----------------------
function removeNonAlphaNumeric($name, $name_delimiter){
$tempVar = str_replace("é","e",$name);
$name=$tempVar;
return preg_replace("/[^a-zA-Z0-9]/", $name_delimiter, $name);
}
-----------------------
This seems to have done the trick Do you think that this could cause any problems I haven't understood or is it an ok way to do it?

Cheers, Jim

Note that many browsers can not properly display non english characters, so those have to be either removed or encoded or replaced.

I guess the first option is easy to understand, for the 2nd option:
by encoding, your non english characters will be translated to something like this %98 (just an example, but you will see weird characters in the url). Some browsers such as firefox can show the nice and correct form of these characters on the address bar, some dont (IE 7 cant)

The 3rd option is replace the non-english characters by something equivalent to it. For example, you can replace é by e. If you go with this option, you can peak into includes/classes/ssu/plugins/languages/he.php to see an example. Then you will have to to follow the thread below to override the default language parser which is being used for English.

http://www.zen-cart.com/forum/showth...age#post678465

PS: by default, if your store is using English language, then SSU chooses the "remove" option for any non alpha numeric characters in the names.