Ceon URI Mapping v4.x

Hi, thanks for the help :smile:

Apologies if this has been asked previously. I would like to lose the ? in the url as shown below:

http://www.designerperfumesnob.com/Perfumes-I-Have-Loved?

I have others that display the same with a question mark at the end. If I am doing something wrong I'd like to know how to fix it.

Thanks

traytray:

Apologies if this has been asked previously. I would like to lose the ? in the url as shown below:

http://www.designerperfumesnob.com/Perfumes-I-Have-Loved?

I have others that display the same with a question mark at the end. If I am doing something wrong I'd like to know how to fix it.

Thanks

This would be controlled in your htaccess file. If you post it (ensure to protect any private info including the admin directory name) then perhaps help can be provided. The default installation of this does not include the ? As a single character. So either not installed per directions or have made a modification. If a modification, then this should really be addressed in a new thread.

mc12345678:

This would be controlled in your htaccess file. If you post it (ensure to protect any private info including the admin directory name) then perhaps help can be provided. The default installation of this does not include the ? As a single character. So either not installed per directions or have made a modification. If a modification, then this should really be addressed in a new thread.

here is the file info:

RewriteEngine On

 # Redirect all users to access the site WITH the 'www.' prefix
  RewriteCond %{HTTP_HOST} !^www\. [NC]
  RewriteCond %{HTTP_HOST} !\.([a-z-]+\.[a-z]{2,6})$ [NC]
  RewriteRule ^ http://www.%{HTTP_HOST}%{REQUEST_URI} [L,R=301]


## BEGIN CEON URI MAPPING REWRITE RULE


# Don't rewrite any URIs ending with a file extension (ending with .[xxxxx])
RewriteCond %{REQUEST_URI} !\.[a-z]{2,5}$ [NC]
# Don't rewrite any URIs for some, popular specific file format extensions,
#   which are not covered by main file extension condition above
RewriteCond %{REQUEST_URI} !\.(mp3|mp4|h264)$ [NC]
# Don't rewrite any URIs for some specific file format extensions,
#   which are not covered by main file extension condition above
#   Uncomment the following line to apply this condition! (Remove the # at the start of the next line)
#RewriteCond %{REQUEST_URI} !\.(3gp|3g2|h261|h263|mj2|mjp2|mp4v|mpg4|m1v|m2v|m4u|f4v|m4v|3dml)$ [NC]
# Don't rewrite admin directory
RewriteCond %{REQUEST_URI} !^/admin [NC]
# Don't rewrite editors directory
RewriteCond %{REQUEST_URI} !^/editors/ [NC]
# Don't rewrite cgi-bin directory
RewriteCond %{REQUEST_URI} !^/cgi-bin/ [NC]
# Handle all other URIs using Zen Cart (its index.php)
RewriteRule .* /index.php [QSA,L]

## END CEON URI MAPPING REWRITE RULE

I did not see anything in there to indicate a ? be placed anywhere in there. Also the ? seems to appear only or for the most part in the sidebox (Display Categories in Seperate Box mod) I can't seem to find where the others have been appearing.

Has anyone had a chance to look at this and maybe have a clue as to what we need to do to get the mysterious ? off the url

DarkAngel:

I did not see anything in there to indicate a ? be placed anywhere in there. Also the ? seems to appear only or for the most part in the sidebox (Display Categories in Seperate Box mod) I can't seem to find where the others have been appearing.

It's likely this mod is the issue..

I tend to think so also Diva, I even went so far as to reupload all the files...and doing so remembered that one of the admin files coughed up an error about needing the sessions.php file, which is not in the admin folder to begin with.

But aside from that nothing else. Tracy has even gone as far as going into her categories she has renamed for this mod to take out the underscore and replace it with a dash for SEO purposes and nothing is changed...that silly question mark is still at the end of the url.

DarkAngel:

I tend to think so also Diva, I even went so far as to reupload all the files...and doing so remembered that one of the admin files coughed up an error about needing the sessions.php file, which is not in the admin folder to begin with.

But aside from that nothing else. Tracy has even gone as far as going into her categories she has renamed for this mod to take out the underscore and replace it with a dash for SEO purposes and nothing is changed...that silly question mark is still at the end of the url.

What do you have for query_string_parameters in the SQL database for these offending links (ceon_uri_mappings table)? Is it NULL or is it blank? (NULL is preferred in this case).

mc12345678:

What do you have for query_string_parameters in the SQL database for these offending links (ceon_uri_mappings table)? Is it NULL or is it blank? (NULL is preferred in this case).

Given that the module works everywhere BUT where they are displayed in this other module (Display Categories in Seperate Box mod), I would say that it would appear that there is nothing wrong with the the Ceon URI install and the URI db entries.. The issue appears isolated to another module and how it is misinforming the URIs. Not an issue with Ceon URI at all..

DivaVocals:

Given that the module works everywhere BUT where they are displayed in this other module (Display Categories in Seperate Box mod), I would say that it would appear that there is nothing wrong with the the Ceon URI install and the URI db entries.. The issue appears isolated to another module and how it is misinforming the URIs. Not an issue with Ceon URI at all..

LOve this multiquote option...LOL

ok I shall look at the files for the sidebox...but it did show up in other areas too for a bit....ceon was installed for a month or so prior to the side box mod

mc12345678:

What do you have for query_string_parameters in the SQL database for these offending links (ceon_uri_mappings table)? Is it NULL or is it blank? (NULL is preferred in this case).

well that one that flew over the cuckoos nest is in good company...I have no clue how to check db for this...sorry

but if you tell me where to check in there I will see if the other mod is not being null

I think this might help with the db lookup you asked about???

[Attachment no longer available]

DarkAngel:

I think this might help with the db lookup you asked about???

[Attachment no longer available]

Partially, now if you look at the individual entries, specifically the ones that are displaying the ? To see if the data in column 5 to identify what is present.
That setup is consistent with a default installation, so new items should appear correctly, but old ones may have something incorrectly set.

DarkAngel:

LOve this multiquote option...LOL

ok I shall look at the files for the sidebox...but it did show up in other areas too for a bit....ceon was installed for a month or so prior to the side box mod

well that one that flew over the cuckoos nest is in good company...I have no clue how to check db for this...sorry

but if you tell me where to check in there I will see if the other mod is not being null

How about a link to the site.. It helps if we don't have to GUESS answers..

DivaVocals:

How about a link to the site.. It helps if we don't have to GUESS answers..

the link:

http://www.designerperfumesnob.com/

I finally finished going through the db and removing any duplicates from the many name variations...LOL

Every single entry had NULL in column 5, even removing the duplicates did not help any.

It is not set to auto gen the name, she has to go in and manually add the link name she wants to appear.

DarkAngel:

... ok I shall look at the files for the sidebox...but it did show up in other areas too for a bit....ceon was installed for a month or so prior to the side box mod ...
I'd say the most likely cause is the module you are using for the sidebox is incorrectly adding an extra "&" in the params sent to zen_href_link (it should also pass the full cPath - not just the category id).

Try changing the following around line #24 in "separate_category_sidebox.php" from:

	while (!$categories_ap->EOF)  {
		$id = $categories_ap->fields['categories_id'];
		$name = $categories_ap->fields['categories_name'];
	  	$add_content .= '<li><a href="' . zen_href_link(FILENAME_DEFAULT, '&cPath='.$id) . '">'.$name.'</a></li>' . "\n";
	
		$categories_ap->MoveNext();
	}

to:

	while (!$categories_ap->EOF)  {
		$name = $categories_ap->fields['categories_name'];
		$cPath_new = zen_get_path($categories_ap->fields['categories_id']);
		$cPath_new = str_replace('=0_', '=', $cPath_new);
	  	$add_content .= '<li><a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new) . '">'.$name.'</a></li>' . "\n";

		$categories_ap->MoveNext();
	}

YAY the obstinate question mark is gone.
Thank you so much.

DarkAngel:

YAY the obstinate question mark is gone.
Thank you so much.
Thank You for confirming the issue was solved by updating the code in a 3rd party add-on module (for Zen Cart 1.3.x).

lhungil:

Thank You for confirming the issue was solved by updating the code in a 3rd party add-on module (for Zen Cart 1.3.x).

Yep.. These issues folks report are almost NEVER caused by this module but by some OTHER module. (usually because they are incorrectly using the zen_href_link function)

Imgetting an error with google sitemaps generation that appears to be to do with urls.

2008 MySQL client ran out of memory
in:
[ SELECT uri FROM ceon_uri_mappings WHERE main_page = 'product_info' AND associated_db_id = '1294' AND language_id = '1' AND current_uri = '1' LIMIT 1;]
2013 Lost connection to MySQL server during query
in:
[select count(*) as total from sessions where sesskey = '1ca2fbd7dc8c2849bf4b6788953ada29']