500 error on Profile page - 2008/11/06 01:58
500 - JDatabaseMySQL::query: 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 '*pi()/180)) * sin((cb_latitude*pi()/180)) + cos((*pi()/180)) * cos((cb_latitude*' at line 1 SQL=SELECT u.id,u.username,u.name, ue.*,(((acos(sin((*pi()/180)) * sin((cb_latitude*pi()/180)) + cos((*pi()/180)) * cos((cb_latitude*pi()/180)) * cos((( - cb_longitude)*pi()/180))))*180/pi())*60*1.1515) as distance FROM jos_comprofiler ue, jos_users u WHERE u.id=ue.id and ue.id <> 244 HAVING distance <= 10000 ORDER BY distance ASC
You may not be able to visit this page because of:
an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.
Please try one of the following pages:
Home Page
If difficulties persist, please contact the System Administrator of this site.
JDatabaseMySQL::query: 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 '*pi()/180)) * sin((cb_latitude*pi()/180)) + cos((*pi()/180)) * cos((cb_latitude*' at line 1 SQL=SELECT u.id,u.username,u.name, ue.*,(((acos(sin((*pi()/180)) * sin((cb_latitude*pi()/180)) + cos((*pi()/180)) * cos((cb_latitude*pi()/180)) * cos((( - cb_longitude)*pi()/180))))*180/pi())*60*1.1515) as distance FROM jos_comprofiler ue, jos_users u WHERE u.id=ue.id and ue.id <> 244 HAVING distance <= 10000 ORDER BY distance ASC
Call stack
# Function Location
1 JSite->dispatch() c:xxxxx.comindex.php:68
2 JComponentHelper->renderComponent() c:xxxxx.comincludesapplication.php:124
3 require_once() c:xxxxx.comlibrariesjoomlaapplicationcomponenthelper.php:162
4 userProfile() c:xxxxx.comcomponentscom_comprofilercomprofiler.php:88
5 HTML_comprofiler::userProfile() c:xxxxx.comcomponentscom_comprofilercomprofiler.php:639
6 CBuser->getProfileView() c:xxxxx.comcomponentscom_comprofilercomprofiler.html.php:385
7 cbTabs->getViewTabs() c:xxxxx.comadministratorcomponentscom_comprofilerplugin.foundation.php:889
8 cbTabs->generateViewTabsContent() c:xxxxx.comadministratorcomponentscom_comprofilercomprofiler.class.php:3118
9 cbTabs->_callTabPlugin() c:xxxxx.comadministratorcomponentscom_comprofilercomprofiler.class.php:3069
10 cbPluginHandler->call() c:xxxxx.comadministratorcomponentscom_comprofilercomprofiler.class.php:3788
11 call_user_func_array() c:xxxxx.comadministratorcomponentscom_comprofilerplugin.class.php:470
12 getMapNearbyUsersTab->getDisplayTab()
13 gmMapNearbyUsersTab->getOutput() c:xxxxx.comcomponentscom_comprofilerpluginuserplug_cbmapusermapuser.php:145
14 ProfileHelper->findNearbyProfiles() c:xxxxx.comcomponentscom_comprofilerpluginuserplug_cbmapusermapnearbyuserstab.class.php:162
15 ProfileHelper->getOtherProfilesUsingSQL() c:xxxxx.comcomponentscom_comprofilerpluginuserplug_cbmapuserprofilehelper.class.php:157
16 JDatabaseMySQL->loadAssocList() c:xxxxx.comcomponentscom_comprofilerpluginuserplug_cbmapuserprofilehelper.class.php:172
17 JDatabaseMySQL->query() c:xxxxx.comlibrariesjoomladatabasedatabasemysql.php:410
18 JError->raiseError() c:xxxxx.comlibrariesjoomladatabasedatabasemysql.php:229
19 JError->raise() c:xxxxx.comlibrariesjoomlaerrorerror.php:171
20 JException->__construct() c:xxxxx.comlibrariesjoomlaerrorerror.php:136
The administrator has disabled public write access.
|
