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 a.album_id != 1889
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 a.album_id != 1889
AND m.status = 'enable'
AND a.status = 'enable' 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/RelatedDataManager.class.php(146): SqlDatabaseManager->executeQuery('SELECT a.*, m.u...')
#1 /home/pixin/public_html/appcode/datamanager/RelatedDataManager.class.php(84): RelatedDataManager->getAllOtherAlbumsOfMember('1889', NULL)
#2 /home/pixin/public_html/GL/lib/Datasource.class.php(61): RelatedDataManager->getData()
#3 /home/pixin/public_html/protected/controller/albums.php(633): Datasource->addDataManager(Object(RelatedDataManager))
#4 /home/pixin/public_html/protected/controller/albums.php(928): albums->otheralbums('1889', NULL)
#5 [internal function]: albums->photodetail('pixingroup', '1889', '23477')
#6 /home/pixin/public_html/GL/lib/RegisterCallback.class.php(8): call_user_func_array(Array, Array)
#7 /home/pixin/public_html/GL/lib/Application.class.php(47): RegisterCallback::register(Object(albums), 'photodetail', Array)
#8 /home/pixin/public_html/index.php(12): Application::run(Object(HttpRequest))
#9 {main}- 8.
- In file /home/pixin/public_html/appcode/datamanager/RelatedDataManager.class.php line 146.
Method: SqlDatabaseManager->executeQuery([$query FILTERED]) - 7.
- In file /home/pixin/public_html/appcode/datamanager/RelatedDataManager.class.php line 84.
Method: RelatedDataManager->getAllOtherAlbumsOfMember([$albumId FILTERED], [$memberId FILTERED]) - 6.
- In file /home/pixin/public_html/GL/lib/Datasource.class.php line 61.
Method: RelatedDataManager->getData() - 5.
- In file /home/pixin/public_html/protected/controller/albums.php line 633.
Method: Datasource->addDataManager([$dataManager FILTERED]) - 4.
- In file /home/pixin/public_html/protected/controller/albums.php line 928.
Method: albums->otheralbums([$albumId FILTERED], [$memberId FILTERED]) - 3.
- In file unknown line unknown.
Method: albums->photodetail([$username FILTERED], [$albumId FILTERED], [$photoId 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])