Follow us on Twitter
  

1. Check the Documentation

2. Make a search

3. Read Support Rules before posting
  • Index
  • » AceSEF
  • » Solved Issues
  • » SQL Error when calling old JoomlaSEF...
Page: 1

SQL Error when calling old JoomlaSEF URLs

SQL Error when calling old JoomlaSEF URLs

#1 Top 15-10-2009 15:07:31

SQL Error when calling old JoomlaSEF URLs

Hi,

after I installed and enabled AceSEF, the following error comes, when I try to call any old URL, for example http://hermannsspace.de/joomla/de/news/ … le-gadget:

Code:

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 ''' at line 1 SQL=SELECT url_sef FROM jos_acesef_urls WHERE url_real = lang=de'



Warning: Cannot modify header information - headers already sent by (output started at /dir_a/dir_b/dir_c/joomla/plugins/system/jfdatabase/intercept.jdatabasemysql.php:77) in /dir_a/dir_b/dir_c/joomla/administrator/components/com_acesef/classes/aceseftools.php on line 844

After the error message one can see the standard Joomla information box about not found component:
"404 - Component not found"

The SQL statement in the error message depends on the called link.

My configuration:
- Linux
- Joomla 1.5.14
- Joomfish 2.0.3
- AceSEF 1.1.2
- PHP 5.2.10
- MySQL Database 5.0.85 utf8_general_ci

Regards,
Hermann Maurer

Hermann Maurer
Non-Customer
useravatar
Offline
13 Posts
User info in posts
Administrator has disabled public posting
#2 Top 15-10-2009 15:26:29

Re: SQL Error when calling old JoomlaSEF URLs

Can u plz upload here the exported JoomSEF file?

Denis Dulici
Administrator
ranks
useravatar
Offline
2270 Posts
User info in posts
Administrator has disabled public posting
#3 Top 15-10-2009 23:44:15

Re: SQL Error when calling old JoomlaSEF URLs

Hi,

I've exported all ACESef entries with 'Export Filtered'. I hope, I did, what you meant :-)
Best regards,

Hermann Maurer acesef_urls.zip

Hermann Maurer
Non-Customer
useravatar
Offline
13 Posts
User info in posts
Administrator has disabled public posting
#4 Top 16-10-2009 10:51:17

Re: SQL Error when calling old JoomlaSEF URLs

Oops, misunderstood...

You cannot call old SEF URLs, now AceSEF is the SEF URL manager for your site so ou can call only the URLs generated by AceSEF. However, you can set your extensions parameters to get same URLs as Joomla SEF.

Best Regards

Denis Dulici
Administrator
ranks
useravatar
Offline
2270 Posts
User info in posts
Administrator has disabled public posting
#5 Top 21-10-2009 16:29:52

Re: SQL Error when calling old JoomlaSEF URLs

the update to the version 1.1.3 didn't change anything.
okay, after I looked into the source code, I found a small but nasty bug in the file mainrouter.php:

in the line 153 you have:

Code:

$db->setQuery("SELECT url_sef FROM jos_acesef_urls WHERE url_real = ".$uri->_query."'");

I changed it to

Code:

$db->setQuery("SELECT url_sef FROM jos_acesef_urls WHERE url_real = '".$uri->_query."'");

and now the error is gone!

Hermann Maurer
Non-Customer
useravatar
Offline
13 Posts
User info in posts
Administrator has disabled public posting
#6 Top 22-10-2009 03:31:45

Re: SQL Error when calling old JoomlaSEF URLs

Thank you for reporting the bug wink

Denis Dulici
Administrator
ranks
useravatar
Offline
2270 Posts
User info in posts
Administrator has disabled public posting
#7 Top 28-10-2009 05:57:27

Re: SQL Error when calling old JoomlaSEF URLs

God bless you, Hermann!!!
This bug took a year from my life.
Great work!!!
gr,
akizuki

Frank G.
Non-Customer
useravatar
Offline
1 Posts
User info in posts
Administrator has disabled public posting
Page: 1
  • Index
  • » AceSEF
  • » Solved Issues
  • » SQL Error when calling old JoomlaSEF...