Ceon URI Mapping v4.x

[AnglersCorner]

Hello,

I have installed this module and while everything seems to work fine I have seen a couple of errors in my logs as follows:

PHP Fatal error: Call to a member function add() on a non-object in /home/anglersc/public_html/includes/classes/class.CeonURIMappingHandlerBase.php on line 131

and

PHP Fatal error: 1267:Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' :: SELECT uri FROM zen_ceon_uri_mappings WHERE main_page = 'account_history_infoℴ_id=577' AND associated_db_id IS NULL AND query_string_parameters IS NULL AND language_id = '1' AND current_uri = '1' LIMIT 1; ==> (as called by) /home/anglersc/public_html/includes/classes/class.CeonURIMappingDBLookup.php on line 166 <== in /home/anglersc/public_html/includes/classes/db/mysql/query_factory.php on line 155

The module appears to work fine and do what is expected of it but these errors had me worried so I have deactivated it for now. I'm not really clued up on PHP sadly so I was just wondering if these errors are harmless or not, can I ignore them? ...if not is there an easy way to sort it or should I just forget about ever using this module?

Thanks in advance :)

[mc12345678]

Hello,

I have installed this module and while everything seems to work fine I have seen a couple of errors in my logs as follows:

PHP Fatal error: Call to a member function add() on a non-object in /home/anglersc/public_html/includes/classes/class.CeonURIMappingHandlerBase.php on line 131

and

PHP Fatal error: 1267:Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' :: SELECT uri FROM zen_ceon_uri_mappings WHERE main_page = 'account_history_infoℴ_id=577' AND associated_db_id IS NULL AND query_string_parameters IS NULL AND language_id = '1' AND current_uri = '1' LIMIT 1; ==> (as called by) /home/anglersc/public_html/includes/classes/class.CeonURIMappingDBLookup.php on line 166 <== in /home/anglersc/public_html/includes/classes/db/mysql/query_factory.php on line 155

The module appears to work fine and do what is expected of it but these errors had me worried so I have deactivated it for now. I'm not really clued up on PHP sadly so I was just wondering if these errors are harmless or not, can I ignore them? ...if not is there an easy way to sort it or should I just forget about ever using this module?

Thanks in advance :)

Couple of things going on here. For one it looks like your database is not using UTF-8 collation, would suggest following the instructions of the Convert db2utf8 plugin that converts the database to UTF-8, there are also some files through the system that would need changing to recognize/handle the db as UTF8/UTF-8, etc... The next thing is that the rewrite that is being attempted there has scrambled some of the information pushing &order_id into: ℴ_id as part of the main_page. Such a parameter should not be in the main_page but instead in the query_string_parameters field. The first error may be some sort of result of the second, but the error message generated (which btw is generated before the $messageStack has been initialized to actually present that error) indicates that there is server information missing to be able to support mapping URIs. If that issue is not generated each and every time the site is visited, then there may be something intermittent with your host's server(s) and would suggest inquiring to them why the REQUEST_URI server variable is not present or wasn't present at the time of the error. (Provide them log times of that first error.)

Perhaps there is other assistance also suggested, but that is what I see of what has been reported. Assuming that the database conversion and file modifications to support goes successfully, then the only other issue is to address whatever host problem(s) are generated. Perhaps it would help the community if you were to identify with whom you host your site?

[CherVickers]

SHIP STATION ISSUE.

Here is what the developer of Shipstation sent back to me:

I tried to reach you but was only able to leave a voicemail. It appears that you have figured this out. Currently the ZenCart 3rd Party ShipStation Connection and CEON are not compatible. Like you said its one or the other. I wish I had another option for you but because we did not build that integration we do not have control over it.

So, my question is..
is there a fix we can use in the CEON code to make this work?

Please advise!
Thanks!
Cherie

[mc12345678]

SHIP STATION ISSUE.

Here is what the developer of Shipstation sent back to me:

I tried to reach you but was only able to leave a voicemail. It appears that you have figured this out. Currently the ZenCart 3rd Party ShipStation Connection and CEON are not compatible. Like you said its one or the other. I wish I had another option for you but because we did not build that integration we do not have control over it.

So, my question is..
is there a fix we can use in the CEON code to make this work?

Please advise!
Thanks!
Cherie

I haven't looked at the shipstation code, but it seems that 1) it is not totally integrated with ZC, but 2) that if the issue is that it doesn't know how to process the resulting URI, then ether the uri needs to be decoded using applicable functions or an alternate zen_href_link function that doesn't return the rewritten uri might be applicable. Again this is just a guess at what the issue with shipstation is in relation to the rewritten uri.

[CherVickers]

Here is the code I used to add shipstation:

added in this .php file to site: shipstation_zc.php

and I added this code to my .htaccess file:

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization},L] RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^(.*)$ app.php [QSA,L]
</IfModule>


here is the detail from the .php file:
<?php

/*
* ShipStation Shipping Module for Zen Cart, Version 1.5
*
* Copyright (c) 2011 Auctane LLC
*
* Find out more about ShipStation at www.shipstation.com
*
* Released under the GNU General Public License v2
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; under version 2 of the License
*
* This program is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street - Fifth Floor, Boston, MA 02110-1301, USA.
*/
?>
<?php

require('includes/application_top.php');

//set the content type to xml
header('Content-Type: text/xml');

/**
* function to add noode to the xml
*
* @para $FieldName string
* @para $Value string
* @retrurn xml
*/
function AddFieldToXML($FieldName, $Value) {
$FindStr = "&";
$NewStr = "&amp;";
$Result = str_replace($FindStr, $NewStr, $Value);
echo "\t\t<$FieldName>$Result</$FieldName>\n";
}

/**
* function to authenticate username and password sent from the shipstation
*
* @para $db object
* @retrurn boolean
*/
function userAuthentication($db = null) {
$un = $_GET['SS-UserName'];
$pw = $_GET['SS-Password'];
if (!isset($un) || strlen($un) == 0) {
header('WWW-Authenticate: Basic realm="ShipStation"');
header('HTTP/1.0 401 Unauthorized');
echo 'Unauthorized';
exit;
} else {
$admin_query = "SELECT admin_id, admin_pass FROM " . TABLE_ADMIN . " WHERE admin_name = '" . $un . "'";
$admin_result = $db->Execute($admin_query);
//validate the password with the zencart encrypted password
if (!zen_validate_password($pw, $admin_result->fields['admin_pass'])) {
header('WWW-Authenticate: Basic realm="ShipStation"');
header('HTTP/1.0 401 Unauthorized');
echo 'Unauthorized';
exit;
}
}
}

/**
* function to convert the start and end date with zend date format
*
* @para $date date
* @para $reverse boolean
* @retrurn date
*/
function zen_date_raw2($date, $reverse = false) {
if ($reverse) {
return substr($date, 3, 2) . substr($date, 0, 2) . substr($date, 6, 4);
} else {
return substr($date, 6, 4) . '-' . substr($date, 0, 2) . '-' . substr($date, 3, 2) . ' ' . substr($date, 11, 2) . '.' . substr($date, 14, 2) . '.' . '00';
}
}

/**
* function to convert the ordr end date with date time format
*
* @para $raw_datetime date
* @retrurn date
*/
function zen_datetime_short2($raw_datetime) {
if (($raw_datetime == '0001-01-01 00:00:00') || ($raw_datetime == ''))
return false;

$year = (int) substr($raw_datetime, 0, 4);
$month = (int) substr($raw_datetime, 5, 2);
$day = (int) substr($raw_datetime, 8, 2);
$hour = (int) substr($raw_datetime, 11, 2);
$minute = (int) substr($raw_datetime, 14, 2);
$second = (int) substr($raw_datetime, 17, 2);

return strftime(DATE_TIME_FORMAT, mktime($hour, $minute, $second, $month, $day, $year));
}

// SSZen.php?action=export&start_date=06/02/2009%2005:30&end_date=11/05/2009%2022:53
if ($_GET['action'] == 'export') {
//call the user authentication before start of order data replication
userAuthentication($db);
$sd = zen_date_raw2((!isset($_GET['start_date']) ? date("m-d-Y", (time())) : $_GET['start_date']));
$ed = zen_date_raw2((!isset($_GET['end_date']) ? date("m-d-Y", (time())) : $_GET['end_date']));

//get order from database
$orders_query = "SELECT * FROM " . TABLE_ORDERS . " WHERE orders_id >'0' and IFNULL(last_modified, date_purchased) BETWEEN '" . $sd . "' AND DATE_ADD('" . $ed . "', INTERVAL 1 MINUTE)";
$orders_result = $db->Execute($orders_query);

if ($orders_result->fields['orders_id']) {
//begin outputing XML
echo "<?xml version=\"1.0\" encoding=\"utf-16\"?>\n";
echo "<Orders>\n";
//process orders
while (!$orders_result->EOF) {
//get order items from datbase
$orderitems_query = "SELECT * FROM " . TABLE_ORDERS_PRODUCTS . " WHERE orders_id = '" . $orders_result->fields['orders_id'] . "'";
$orderitems_result = $db->Execute($orderitems_query);

$cust_id = $orders_result->fields['customers_id'];
$cust_deff_id = $orders_result->fields['customers_default_address_id'];
$address_query = "SELECT * FROM " . TABLE_ADDRESS_BOOK . " WHERE customers_id = '$cust_id' and address_book_id = '$cust_deff_id'";
$address_result = $db->Execute($address_query);

//billing country code
$billing_country_id = $orders_result->fields['billing_country'];
$billing_query = "SELECT * FROM " . TABLE_COUNTRIES . " WHERE countries_name = '$billing_country_id'";
$billing_result = $db->Execute($billing_query);
//billing country code
//shipping country code
$shipping_country_id = $orders_result->fields['delivery_country'];
$shipping_query = "SELECT * FROM " . TABLE_COUNTRIES . " WHERE countries_name = '$shipping_country_id'";
$shipping_result = $db->Execute($shipping_query);
//billing zone code
$billing_zone_id = addslashes($orders_result->fields['billing_state']);
$zone_billing_query = "SELECT * FROM " . TABLE_ZONES . " WHERE zone_name = '$billing_zone_id'";
$zone_billing_result = $db->Execute($zone_billing_query);
//billing zone code
//shipping zone code
$shipping_zone_id = addslashes($orders_result->fields['delivery_state']);
$zone_shipping_query = "SELECT * FROM " . TABLE_ZONES . " WHERE zone_name = '$shipping_zone_id'";
$zone_shipping_result = $db->Execute($zone_shipping_query);
//shipping zone code

$ship_order_id = $orders_result->fields['orders_id'];
$ship_query = "SELECT * FROM " . TABLE_ORDERS_TOTAL . " WHERE orders_id = '$ship_order_id' and class = 'ot_shipping'";
$ship_result = $db->Execute($ship_query);

$orders_status = $db->Execute("select orders_status_id, orders_status_name
from " . TABLE_ORDERS_STATUS . "
where language_id = '" . (int) $_SESSION['languages_id'] . "' and orders_status_id = '" . $orders_result->fields['orders_status'] . "'");

if ($orders_status->fields['orders_status_name']) {
$order_status = $orders_status->fields['orders_status_name'];
$order_status_id = $orders_status->fields['orders_status_id'];
} else {
$order_status = '';
$order_status_id = '';
}

if ($order_status_id) {
$orders_history = $db->Execute("select date_added
from " . TABLE_ORDERS_STATUS_HISTORY . "
where orders_id = '" . zen_db_input($orders_result->fields['orders_id']) . "' and orders_status_id = '" . $order_status_id . "'
order by date_added LIMIT 1");

$last_modified = zen_datetime_short2($orders_history->fields['date_added']);

$orders_history_comments = $db->Execute("select comments
from " . TABLE_ORDERS_STATUS_HISTORY . "
where orders_id = '" . zen_db_input($orders_result->fields['orders_id']) . "' and (comments is not null or comments != '')
order by date_added LIMIT 1");

$shipping_comments = $orders_history_comments->fields['comments'];
} else {
$last_modified = '';
$shipping_comments = '';
}

echo "\t<Order>\n";

//order details
AddFieldToXML("OrderNumber", $orders_result->fields['orders_id']);
AddFieldToXML("OrderDate", zen_datetime_short2($orders_result->fields['date_purchased']));
AddFieldToXML("OrderStatusCode", $order_status_id);
AddFieldToXML("OrderStatusName", $order_status);
AddFieldToXML("LastModified", $last_modified);
AddFieldToXML("LastModifiedOrderTable", $orders_result->fields['last_modified']);
AddFieldToXML("date_purchased", $orders_result->fields['date_purchased']);
AddFieldToXML("PaymentMethod", '<![CDATA[' . $orders_result->fields['payment_method'] . ']]>');
AddFieldToXML("PaymentMethodCode", $orders_result->fields['payment_module_code']);
AddFieldToXML("ShippingMethod", '<![CDATA[' . $orders_result->fields['shipping_method'] . ']]>');
//AddFieldToXML("ShippingMethodCode", $orders_result->fields['shipping_module_code']);
AddFieldToXML("ShippingMethodCode", '<![CDATA[' . $orders_result->fields['shipping_method'] . ']]>');
AddFieldToXML("CouponCode", $orders_result->fields['coupon_code']);
AddFieldToXML("Currency", $orders_result->fields['currency']);
AddFieldToXML("CurrencyValue", $orders_result->fields['currency_value']);
AddFieldToXML("OrderTotal", $orders_result->fields['order_total']);
AddFieldToXML("TaxAmount", $orders_result->fields['order_tax']);
AddFieldToXML("ShippingAmount", $ship_result->fields['value']);
AddFieldToXML("CommentsFromBuyer", '<![CDATA[' . $shipping_comments . ']]>');
//order details
//customer details
echo "\t<Customer>\n";

AddFieldToXML("CustomerNumber", $orders_result->fields['customers_id']);

//billing details
echo "\t<BillTo>\n";

$billing_state = $orders_result->fields['billing_state'];

AddFieldToXML("Name", '<![CDATA[' . $orders_result->fields['billing_name'] . ']]>');
AddFieldToXML("Company", '<![CDATA[' . $orders_result->fields['billing_company'] . ']]>');
AddFieldToXML("Address1", '<![CDATA[' . $orders_result->fields['billing_street_address'] . ']]>');
AddFieldToXML("Address2", '<![CDATA[' . $orders_result->fields['billing_suburb'] . ']]>');
AddFieldToXML("City", '<![CDATA[' . $orders_result->fields['billing_city'] . ']]>');
AddFieldToXML("State", '<![CDATA[' . $billing_state . ']]>');
AddFieldToXML("StateCode", $zone_billing_result->fields['zone_code']);
AddFieldToXML("PostalCode", $orders_result->fields['billing_postcode']);
AddFieldToXML("Country", $orders_result->fields['billing_country']);
AddFieldToXML("CountryCode", $billing_result->fields['countries_iso_code_2']);
AddFieldToXML("Phone", $orders_result->fields['customers_telephone']);
AddFieldToXML("Email", $orders_result->fields['customers_email_address']);
// AddFieldToXML("CountryCode", $country_result->fields['countries_iso_code_2']);

echo "\t</BillTo>\n";
//billing details
//shipping details

echo "\t<ShipTo>\n";

$shipping_state = $orders_result->fields['delivery_state'];

AddFieldToXML("Name", '<![CDATA[' . $orders_result->fields['delivery_name'] . ']]>');
AddFieldToXML("Company", '<![CDATA[' . $orders_result->fields['delivery_company'] . ']]>');
AddFieldToXML("Address1", '<![CDATA[' . $orders_result->fields['delivery_street_address'] . ']]>');
AddFieldToXML("Address2", '<![CDATA[' . $orders_result->fields['delivery_suburb'] . ']]>');
AddFieldToXML("City", '<![CDATA[' . $orders_result->fields['delivery_city'] . ']]>');
AddFieldToXML("State", '<![CDATA[' . $shipping_state . ']]>');
AddFieldToXML("StateCode", $zone_shipping_result->fields['zone_code']);
AddFieldToXML("PostalCode", $orders_result->fields['delivery_postcode']);
AddFieldToXML("Country", $orders_result->fields['delivery_country']);
AddFieldToXML("CountryCode", $shipping_result->fields['countries_iso_code_2']);

echo "\t</ShipTo>\n";
//shipping details

echo "\t</Customer>\n";
//customer details
echo "\t<Items>\n";
//process Order Items
while (!$orderitems_result->EOF) {

$image_query = "SELECT products_image, products_weight FROM " . TABLE_PRODUCTS . " WHERE products_id = '" . $orderitems_result->fields['products_id'] . "'";
$image_result = $db->Execute($image_query);

echo "\t<Item>\n";
AddFieldToXML("ProductID", $orderitems_result->fields['products_id']);
AddFieldToXML("SKU", '<![CDATA[' . $orderitems_result->fields['products_model'] . ']]>');
AddFieldToXML("Name", '<![CDATA[' . $orderitems_result->fields['products_name'] . ']]>');
AddFieldToXML("ImageUrl", HTTP_SERVER . DIR_WS_CATALOG . DIR_WS_IMAGES . $image_result->fields['products_image']);
AddFieldToXML("Weight", $image_result->fields['products_weight']);
AddFieldToXML("UnitPrice", round($orderitems_result->fields['final_price'], 2));
AddFieldToXML("TaxAmount", round($orderitems_result->fields['products_tax'], 2));
AddFieldToXML("Quantity", $orderitems_result->fields['products_quantity']);

$orderitems_attributes_query = "SELECT orders_products_attributes_id, products_options, products_options_values FROM " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " WHERE orders_id = '" . $orders_result->fields['orders_id'] . "' and orders_products_id = '" . $orderitems_result->fields['orders_products_id'] . "'";
$orderitems_attributes_result = $db->Execute($orderitems_attributes_query);

if ($orderitems_attributes_result->fields['orders_products_attributes_id']) {
echo "\t<Options>\n";
}

while (!$orderitems_attributes_result->EOF) {

echo "\t<Option><Name><![CDATA[" . $orderitems_attributes_result->fields['products_options'] . "]]></Name><Value><![CDATA[" . $orderitems_attributes_result->fields['products_options_values'] . "]]></Value></Option>\n";

$orderitems_attributes_result->MoveNext();
}

if ($orderitems_attributes_result->fields['orders_products_attributes_id']) {
echo "\t</Options>\n";
}

echo "\t</Item>\n";

$orderitems_result->MoveNext();
}
//process Order Items
echo "\t</Items>\n";
echo "\t</Order>\n";

$orders_result->MoveNext();
}

//process Orders
//finish outputing XML
echo "</Orders>";
} else {

echo "<?xml version=\"1.0\" encoding=\"utf-16\"?>\n";
echo "<Orders />\n";
}
} elseif ($_GET['action'] == 'verifystatus') {
echo 'true';
} elseif ($_GET['action'] == 'update') {

//?action=update&order_number=ABC123&status=4&comment=commment
userAuthentication($db);
if ($_GET['order_number']) {

$status = strtolower($_GET['status']);
$customer_notified = '0';
$comments = $_GET['comment'];


$record_query = "SELECT orders_id FROM " . TABLE_ORDERS . " WHERE orders_id = '" . $_GET['order_number'] . "'";
$record_result = $db->Execute($record_query);

if ($record_result->fields['orders_id']) {

$orders_status = $db->Execute("select orders_status_id, orders_status_name
from " . TABLE_ORDERS_STATUS . "
where language_id = '" . (int) $_SESSION['languages_id'] . "' and LOWER(orders_status_name) = '" . $status . "'");

if ($orders_status->fields['orders_status_id']) {

$status = $orders_status->fields['orders_status_id'];

$db->Execute("update " . TABLE_ORDERS . "
set orders_status = '" . zen_db_input($status) . "', last_modified = now()
where orders_id = '" . (int) $_GET['order_number'] . "'");

$db->Execute("insert into " . TABLE_ORDERS_STATUS_HISTORY . "
(orders_id, orders_status_id, date_added, customer_notified, comments)
values ('" . (int) $_GET['order_number'] . "',
'" . zen_db_input($status) . "',
now(),
'" . zen_db_input($customer_notified) . "',
'" . zen_db_input($comments) . "')");
echo 'Status updated successfully';
} else {
echo 'No order status in database';
}
} else {
echo 'Order does not exist in database';
}
} else {
echo 'No order number';
}
} else {
echo 'No action parameter. Please contact software provider.';
}
?>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

[CherVickers]

I haven't looked at the shipstation code, but it seems that 1) it is not totally integrated with ZC, but 2) that if the issue is that it doesn't know how to process the resulting URI, then ether the uri needs to be decoded using applicable functions or an alternate zen_href_link function that doesn't return the rewritten uri might be applicable. Again this is just a guess at what the issue with shipstation is in relation to the rewritten uri.

Please see the last post I made with the added code. Is there a place in CEON where I can override the above as you suggest?
I am not a developer, so any specifics would be helpful!
thanks!
c

[mc12345678]

Please see the last post I made with the added code. Is there a place in CEON where I can override the above as you suggest?
I am not a developer, so any specifics would be helpful!
thanks!
c

See/saw it, but in the future, please enclose the code within code tags '[' CODE ']' (remove the spaces and single apostrophes. I still haven't figured out how to type that in this editor so that it will remain intact, but maybe one day. :) ) This can be automated by clicking the # symbol in the toolbar above the message box and then pasting the code...

A few things I see so far:

One, where is the addition of the .htaccess code in relation to the CEON .htaccess code?
Two, a filename "shipstation_zc.php" was provided and the added rewrite directs to app.php, then there is "the code of the .php". How do these three pieces fit together?
Three, this method of access is rife with potential security issues... transferring username and password in a GET statement??? Wow... No validation on the GET data sent? Another Wow...
Four, what is actually called to "activate" shipstation? Is there some sort of specific filename called, or is it "always active"?
Five, can we take this to a new thread as it looks like the discussion may be lengthy. Suggest starting a new thread perhaps in the general section, returning here to post the link for those interested, continue the discussion there (including answering the above questions), then we can post a solution here for those interested in the end result... Just an idea that perhaps others may appreciate as well. :) To me it looks like initial integration of the program with ZC is the issue (.htaccess rule), but need to work through that to provide a suitable method of having both because so far I don't see any issue with "the code of the .php" per se.

[CherVickers]

See/saw it, but in the future, please enclose the code within code tags '[' CODE ']' (remove the spaces and single apostrophes. I still haven't figured out how to type that in this editor so that it will remain intact, but maybe one day. :) ) This can be automated by clicking the # symbol in the toolbar above the message box and then pasting the code...

A few things I see so far:

One, where is the addition of the .htaccess code in relation to the CEON .htaccess code?
Two, a filename "shipstation_zc.php" was provided and the added rewrite directs to app.php, then there is "the code of the .php". How do these three pieces fit together?
Three, this method of access is rife with potential security issues... transferring username and password in a GET statement??? Wow... No validation on the GET data sent? Another Wow...
Four, what is actually called to "activate" shipstation? Is there some sort of specific filename called, or is it "always active"?
Five, can we take this to a new thread as it looks like the discussion may be lengthy. Suggest starting a new thread perhaps in the general section, returning here to post the link for those interested, continue the discussion there (including answering the above questions), then we can post a solution here for those interested in the end result... Just an idea that perhaps others may appreciate as well. :) To me it looks like initial integration of the program with ZC is the issue (.htaccess rule), but need to work through that to provide a suitable method of having both because so far I don't see any issue with "the code of the .php" per se.

Yes, I've continued the discussion here:
https://www.zen-cart.com/showthread....74#post1288674

I will get with my developer to see how to best respond to your questions! THANK YOU!

[racingtech]

I'll save everyone some time and get to the point.

Just installed CEON and started with the generated rewrite code from the CEON install, while it does convert the url the page doesn't come up it just has an 404 error.

If I turn off Ceon the page works fine but no url rewrite.

I noticed in the url listed in the error that the root directory of the server is showing up twice with page not found. I have the htaccess in the root directory of the server and there isn't anything in the htaccess that I can see to where its being added so that I can remove it, maybe I have the htaccess in the wrong directory.

site is http://www.atvpartspro.com/ and there is only one product, handlebars.

Any help would be appreciated.

[racingtech]

I'll save everyone some time and get to the point.

Just installed CEON and started with the generated rewrite code from the CEON install, while it does convert the url the page doesn't come up it just has an 404 error.

If I turn off Ceon the page works fine but no url rewrite.

I noticed in the url listed in the error that the root directory of the server is showing up twice with page not found. I have the htaccess in the root directory of the server and there isn't anything in the htaccess that I can see to where its being added so that I can remove it, maybe I have the htaccess in the wrong directory.

site is http://www.atvpartspro.com/ and there is only one product, handlebars.

Any help would be appreciated.

Never mind, moved the generated code to the server root and it works fine now. Sorry