Message:
invalid query:- SELECT a.*, m.username, p.pic_small, p.pic_thumb
FROM member m, album a
LEFT OUTER JOIN album_photo p ON (a.album_id = p.album_id AND p.status = 'enable')
WHERE m.member_id =
AND m.status = 'enable'
AND a.status = 'enable'
AND a.album_status != 'private'
AND a.member_id = m.member_id
GROUP BY a.album_id
ORDER BY a.album_id DESC
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 'AND m.status = 'enable'
AND a.status = 'enable'
AND a.album_status ' at line 5
Created in file
/home/pixin/public_html/GL/lib/database/SqlDatabaseManager.class.php on line
148.
Stack Trace:#0 /home/pixin/public_html/appcode/datamanager/AlbumsDataManager.class.php(156): SqlDatabaseManager->executeQuery('SELECT a.*, m.u...')
#1 /home/pixin/public_html/appcode/datamanager/AlbumsDataManager.class.php(105): AlbumsDataManager->getAllAlbumsOfMember(NULL, 'client')
#2 /home/pixin/public_html/GL/lib/Datasource.class.php(61): AlbumsDataManager->getData()
#3 /home/pixin/public_html/protected/controller/albums.php(157): Datasource->addDataManager(Object(AlbumsDataManager))
#4 [internal function]: albums->view('shivakant5050')
#5 /home/pixin/public_html/GL/lib/RegisterCallback.class.php(8): call_user_func_array(Array, Array)
#6 /home/pixin/public_html/GL/lib/Application.class.php(47): RegisterCallback::register(Object(albums), 'view', Array)
#7 /home/pixin/public_html/index.php(12): Application::run(Object(HttpRequest))
#8 {main}- 7.
- In file /home/pixin/public_html/appcode/datamanager/AlbumsDataManager.class.php line 156.
Method: SqlDatabaseManager->executeQuery([$query FILTERED]) - 6.
- In file /home/pixin/public_html/appcode/datamanager/AlbumsDataManager.class.php line 105.
Method: AlbumsDataManager->getAllAlbumsOfMember([$memberId FILTERED], [$mode FILTERED]) - 5.
- In file /home/pixin/public_html/GL/lib/Datasource.class.php line 61.
Method: AlbumsDataManager->getData() - 4.
- In file /home/pixin/public_html/protected/controller/albums.php line 157.
Method: Datasource->addDataManager([$dataManager FILTERED]) - 3.
- In file unknown line unknown.
Method: albums->view([$username FILTERED]) - 2.
- In file /home/pixin/public_html/GL/lib/RegisterCallback.class.php line 8.
Method: call_user_func_array([$function_name FILTERED], [$parameters FILTERED]) - 1.
- In file /home/pixin/public_html/GL/lib/Application.class.php line 47.
Method: RegisterCallback::register([$class FILTERED], [$funcName FILTERED], [$args FILTERED]) - 0.
- In file /home/pixin/public_html/index.php line 12.
Method: Application::run([$request FILTERED])