Chemo's Ultimate URL's

[bigjoed]

I have installed Zencart 1.3.7 using Xaamp. I'm having the following error at the top of my page after installing Chemo's URL Add on:

Warning: Variable passed to each() is not an array or object in X:\xampp\htdocs\mywebsite\includes\classes\db\mysql\query_factory.php on line 114

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at X:\xampp\htdocs\mywebsite\includes\classes\db\mysql\query_factory.php:114) in X:\xampp\htdocs\mywebsite\includes\functions\sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at X:\xampp\htdocs\mywebsite\includes\classes\db\mysql\query_factory.php:114) in X:\xampp\htdocs\mywebsite\includes\init_includes\init_templates.php on line 78

at the bottom of the page I get this other error message:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUC' at line 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20070806 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

Could anybody tell me what this mean and how to fix it?

Thanks

[magpie]

HI

I have the beta 3.0.0.1 seo url mod version and have just read that if you have a shared ssl the mod it will not let you customers log in, is this true.

Thanks

[tfortan]

Does anyone know if there is a way to turn underscores to dashes when creating new defined pages? Ex. (site-map.html instead of site_map.html).

[TamyA]

Even though i posted a page back that this mod does not work but i am not giving up on it, re reading this thread again it seems that some people got it to work, but where are those people to provide some help for us newbies????

Like i said i got a Linux account and i installed Zen Cart 1.3.7 and then backed up my files and my database from the working site and moved them to the new host, i installed this mod but i can not get items in the cart (always show empty cart) even though products and categories show as .html url.

since some people got it to work for them then i am assuming that i am missing something here, i followed what merlin advice to setup but no success yet.

Any Ideas?

[magpie]

Hi Tam

Have you turned on you url plugins on our admin, I have zen cart v1.3.7
and the beta3.0.0.1 seo url mod version looks to work the best, but still
getting a few problems with customers not being able to log into their acccount.


Mag

[TamyA]

Hi Tam

Have you turned on you url plugins on our admin, I have zen cart v1.3.7
and the beta3.0.0.1 seo url mod version looks to work the best, but still
getting a few problems with customers not being able to log into their account.


Mag

Hi Mag,

Yes i turned all the core page to on as suggested earlier in this thread, i am not sure why isn't working.

My categories and products works great but when you try to add an item to the to the cart it says the cart is empty, i made sure the cache directory is set to 777 (not sure if that has any thing to do with it).

Customer sign up does not write the information to the database thus customer login is not working.

I am suspecting a permission issue or the .htaccess entries, here is my basic htaccess

RewriteEngine On
RewriteBase /

# Seo Urls version 3.x
# Don't rewrite real files or directories
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.+)$ index\.php?seo_url=$1&%{QUERY_STRING} [L]

Do i need more lines in my htaccess?

I will keep playing with it until it works and when it does i will have step-by-step installation instruction, i hate to see others go through what I've been through.

[SPH]

Does anyone know if there is a way to turn underscores to dashes when creating new defined pages? Ex. (site-map.html instead of site_map.html).

I don't. But I did do a search the other day on the use of "_", "-" and "+" in urls for SEO. You might want to do the same, including doing searches on terms with the various separators to see if the search listings come up differently.

IMO, dashes are probably best, apparently being universally recognized and used. Some sources indicated it didn't matter, they all act as spaces.

Do test searches. My experience was that the "-" and "+" were very close producing results, the underscore seemed different.

[SPH]

Customer sign up does not write the information to the database thus customer login is not working.

I am suspecting a permission issue or the .htaccess entries, here is my basic htaccess

Wondering if this has anything to do with it, from pdf/instructions ChangeLog:

Fixed Bug: #511, Customer login may fail when “Recreate Session” is True and
“Force Cookie Use” is False

I will keep playing with it until it works and when it does i will have step-by-step installation instruction, i hate to see others go through what I've been through.

I know I'm looking forward to that! My last problem: PayPal order does not return to ZC admin.

[TamyA]

Wondering if this has anything to do with it, from pdf/instructions ChangeLog:

Fixed Bug: #511, Customer login may fail when “Recreate Session” is True and
“Force Cookie Use” is False

Yah that was a problem in 2.1 but it suppose to be fixed in the latest version which i am using.

[TamyA]

Update:

I got passed the shopping cart empy issue, the problem was me
I edited the file html_output.php but not the one on the site i am testing this mod with.

The issue of new customers being able to create an account and login also was resolved, I am testing without SSL installed so following dreamscape's advice to uncheck Core: Default: Skip SSL Skip transforming SSL urls i was able to create a new account and the payment process was taking me through the steps.

About the PayPal Express checkout, currently i am getting the url kind of missed up www.mysite.com/ipn_main_handler.php.html?type=ec, as you see i am having an extension addes to the file even though i enabled
Core: Default Skips Skip urls with extensions [most likely real files].

I tried to follow dreamscape solution
but i could not even find the function he mentioned in that file

to be honest with you, PayPal Express checkout was a challenge for me even on the my live site, i was never been able to get it to work, every time that button was clicked it show the following error

Return to Merchant


This transaction is invalid. Please return to the recipient's website to complete your transaction using their regular checkout flow.



and the same error i get when i remove the .html extension and reload the page.



I will keep searching/testing and i will update.