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?

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?

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 /xxxxxxxxxxxxxxxxxxxxxxxxxx/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!!!

Property extension for AceSEF has been updated, upgrade to the new version plz.

Property extension for AceSEF has been updated, upgrade to the new version plz.

How? In my Acesef control panel it says: "com_properties 1.5.0 1.5.0 Commercial Up-to-date"

same here, richard king is right, and my site is still broken, i am pissed off and the inly thing i can do is writing the worse review ever in joomla extensios... this is a lack of respect for our job... my site has all 404 urls of properties and i am LOOSING money, and here it seems that nobody cares!!!

I am now running V1.51 for the com_property acesef extension, and still getting DB errors when running some searches
I am gettin a 404 if you seearch and choose no options
Again, if you set com_properties to be "no SEF" everything runs perfectly, but the URL's are abysmal

Richard, did you solve this problem????

Upgrade your Property extension for AceSEF to 1.5.2, clean cache first.

i did it, apparentely things worked, but then 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/... can you fix????