After installing Acesef, and the properties extension, I get errors either DB errors or Code500 errors

If I set the Acesef properties extension to "no SEF" everything works fine, and the URL's are abysmal


If I set the Acesef properties extension to "Acesef basic router" I usually get a search OK, I often get a code 500, especially if you hit search and dont choose anything, but often get this output over the top of the search box:

No valid database connection Duplicate entry 'index.php?option=com_properties&Itemid=90&bathrooms=%3Abathrooms' for key 'url_real' SQL=INSERT INTO jos_acesef_urls (url_sef, url_real, used, cdate, source, params) VALUES ('properties/bathrooms/bedrooms/3-rental-property/country/locality/maxprice/minprice/parking/state/showresults/type/itemid-90', 'index.php?option=c........(/snip)


If I set the Acesef properties extension to "component router" things are very much like Acesef basic router, except often when you click on a property you get this:
No valid database connection 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 'order by rt.ordering' at line 1 SQL=SELECT rt.* FROM jos_properties_rates as rt WHERE rt.published = 1 AND rt.productid = order by rt.ordering
No valid database connection 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 'order by i.ordering' at line 1 SQL=SELECT i.* FROM jos_properties_images as i WHERE i.published = 1 AND i.parent = order by i.ordering
No valid database connection 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 'order by p.ordering' at line 1 SQL=SELECT p.*,c.name as name_category,t.name as name_type,cy.name as name_country,s.name as name_state,l.name as name_locality,pf.name as name_profile,pf.logo_image as logo_image_profile, CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(":", p.id, p.alias) ELSE p.id END as Pslug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as Cslug, CASE WHEN CHAR_LENGTH(cy.alias) THEN CONCAT_WS(":", cy.id, cy.alias) ELSE cy.id END as CYslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END as Sslug, CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(":", l.id, l.alias) ELSE l.id END as Lslug, CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(":", t.id, t.alias) ELSE t.id END as Tslug FROM jos_properties_products as p LEFT JOIN jos_properties_country AS cy ON cy.id = p.cyid LEFT JOIN jos_properties_state AS s ON s.id = p.sid LEFT JOIN jos_properties_locality AS l ON l.id = p.lid LEFT JOIN jos_properties_category AS c ON c.id = p.cid LEFT JOIN jos_properties_type AS t ON t.id = p.type LEFT JOIN jos_properties_profiles AS pf ON pf.mid = p.agent_id WHERE p.published = 1 AND p.parent = order by p.ordering

This lands above the property listing

If I set the Acesef properties extension to "Acesef Extension" the whole site white screens


Any ideas?

hello, i am posting here a post i made into the joomace forum, because the last com-property extension update for ACEsef broke up all my site...

Re: com-property problem

i upgraded from 1.3.4 to 1.5 the acesef component and the com-property extension.

Here is the list of my problems:

after upgrade, all properties URLS are 404

site is working only if i choose acesef router extension or default joomla extensions, but the site is NOT working if i select acesef extension router and i receive the following error:

Call to undefined method AceSEF_com_properties::_getState() in /home/lorenzofp/casascomprar.com.br/administrator/components/com_acesef/extensions/com_properties.php on line 71

i lost alll my urls, my site is not working, all indexed urls in google are 404 and i payed for a piece of bad code....

how to fix this?? how to upgrade from 1.3.4 to 1.5 without loosing all urls?

we DEFINITIVELY need help! all my site is broken and i am losing money!!!

same with me, paid for aceSEF and their unable use extension. Now I'm try to use ARTIO joomsef. Everything work's fine. GOODBYE ACEsef

can u post ur url or sitemap, i want to see how work ARTIO, and what plugin u use??

Looks about the same for me, but with less errors. Page 500 errors if we let the SEF component re-write the URL's, and if we use Joomla routing, the URL's look a lot better, but.. clicking on the property from a search returs you to a std no options chosen search

How have you set this up?

Enzo wrote:
can u post ur url or sitemap, i want to see how work ARTIO, and what plugin u use??



My sample web

My Artio configuration setting:

BASIC:
JoomSEF Enabled? : Yes
Disable creation of new SEF URLS : No
Number duplicate URLS : No
Replacement Character : -
Page Spacer .... : -
Strip Character : ,|~|!|@|%|^|*|(|)|+|<|>|:|;|{|}|[|]|---|--|..|.
Trim Friendly character : -|.
Use Title or alias : Title Alias
File suffix :
Default index file :
Page text : JText::_('PAGE')-%s
All lowercase? : YES
Use index for sections and categories : YES

ADVANCED
Non-ascii char replacements: (add this), properties| , showproperty| , showresults| ,

Do not remove SID from SEF URL: No (important)


IN MANAGE EXTENSION: use: JoomSEF basic rewriting for handler Properties



That's my step setting, maybe not perfect but it work's

I've seen ur site it looks very fine!!!
Good work, what vers. of ARTIO is working??
The Meta Data are working...very nice!!
But change ur generator data for security...!!
Tomorrow i look to make the same with my site...hoping in ggod thinks.

In joomla there are disactive the SEF URL's??

ARTIO 3.7.4 the last version I known

I've tried but it not work for me!!
alot of 404 errors.

here is the continuation of the Epopeia with ACESEF support...

I posted a ticket now, let's see...


I managed to upgrade to 1.5.2 with com:property extension after a LOT of problems with 404 urls of properties for sale etc... Now I did it, i am on 1.5.2 and Property Extension 1.5.2. Apparentely things worked, but i noticed that the new extensions 1.5.2 creates new URLS with an /array/ field instead of the /category/ field we had before, this is ugly and unuseful, categories are not shown in URLs anymore, just /array/

Old urls works, they were set as locked and used in my site before the upgrade, , they were working at the beginning, since i purged... And Now.. but when you create a new property, the URL is created with /array/ instead of the /category-name/ in the URL field... , please fix this NOW and i will save my site!!!!

I put a test environment on another domain, not the production one, for you to test..

i am copying an example of an old url before upgrading to 1.5.2 and a new url.

www.mysite.com.br/lotes/florianopolis/ri...iliaria-rio-vermelho

www.mysite.com.br/array/florianopolis/ri...lho?lid=57&sid=1

The urls are all 2 with 404 error??

please guys help me in this thread, post here your problem, acesef will fix the extension!!

www.joomace.net/support/forums?task=topi...=2&id=7119#p8632

I have send u an email...
1 question what is with ur sitemap??
what is with ur moduls??
and if u go without sef..all works??
and send an url that work

They already upgrade the extension, I haved test it, seem work. Need more time to test

YES IT SEEMS TO WORK!!! 1.5.3!!!

still have bug, the pagination not work after install the extension

The new version of Acesef + Extension seems to be working, however I needed to set "Enable Source Tracker" to "no" to stop the code output errors

So nearly perfect

Same happening here - it shows the last and first page only - but no pages inbetween

for me it is working, but you need to disable sef creation for the pages of the search. insert the "maxprice" into the disable-SEF variables configuration field in acesef... i put this content there:

tmpl, task=map, maxprice