E-Shop Menu - JoomAce LLC - SQL Error when

E-Shop Menu - JoomAce LLC - SQL Error when

E-Shop Menu

Shopping Cart

Show Cart

Payment Method

PayPal
Collapse JoomAce Support
Welcome, Guest
Please Login or Register.    Lost Password?
JoomAce Support
AceSEF
Report bugs
SQL Error when calling old JoomlaSEF URLs
(1 viewing) 1 Guest
Go to bottom
TOPIC: SQL Error when calling old JoomlaSEF URLs
#1139
Hermann Maurer
No photo available
Non-Customer
Non customer rank
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
SQL Error when calling old JoomlaSEF URLs 3 Days, 12 Hours ago Karma: 0
Hi,

after I installed and enabled AceSEF, the following error comes, when I try to call any old URL, for example hermannsspace.de/joomla/de/news/1-latest-news/59-google-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
 
Logged Logged
 
Last Edit: 2009/10/16 01:11 By hermann.maurer. Reason: hid the real path in the error message
  The administrator has disabled public write access.
#1142
Denis Dulici
Support team rank
Support Team
Support team rank
Posts: 453
graph
User Online Now Click here to see the profile of this user
Re:SQL Error when calling old JoomlaSEF URLs 3 Days, 12 Hours ago Karma: 6
Can u plz upload here the exported JoomSEF file?
 
Logged Logged
  The administrator has disabled public write access.
#1149
Hermann Maurer
No photo available
Non-Customer
Non customer rank
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:SQL Error when calling old JoomlaSEF URLs 3 Days, 4 Hours ago Karma: 0
Hi,

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

Hermann Maurer
File Attachment:
File Name: acesef_urls.zip
File Size: 39411
 
Logged Logged
  The administrator has disabled public write access.
#1172
Denis Dulici
Support team rank
Support Team
Support team rank
Posts: 453
graph
User Online Now Click here to see the profile of this user
Re:SQL Error when calling old JoomlaSEF URLs 2 Days, 17 Hours ago Karma: 6
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
 
Logged Logged
  The administrator has disabled public write access.
Go to top
Powered by Kunenaget the latest posts directly to your desktop