Page Versioning and ADOdb exception
Permalink
I try to figure out a cryptic ADOdb exception only one page of my c5 site (C5 version 5.6.1.2). When I try either to access the page or edit it I get an exception as you can see in the attached picture. The page is a part of mutilaguage site, has several other subpages and I don't want to recreate, otherwise I could just start over from the beginning. In the Logs I get the message:
Exception Occurred: /home/hoteland/public_html/new/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysql error: [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 'LIMIT 1' at line 1] in EXECUTE("SELECT fvFilename FROM FileVersions WHERE fID=3 AND fvID= LIMIT 1")
(1064)
#0 /home/hoteland/public_html/new/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1064, 'You have an err...', 'SELECT fvFilena...', false, Object(ADODB_mysql))
#1 /home/hoteland/public_html/new/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('SELECT fvFilena...', false)
#2 /home/hoteland/public_html/new/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php(497): ADOConnection->Execute('SELECT fvFilena...', false)
#3 /home/hoteland/public_html/new/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php(162): ADODB_mysql->SelectLimit('SELECT fvFilena...', 1, -1, false)
#4 /home/hoteland/public_html/new/packages/cu3er/blocks/cu3er/controller.php(519): ADODB_mysql->GetOne('SELECT fvFilena...')
#5 /home/hoteland/public_html/new/packages/cu3er/blocks/cu3er/controller.php(146): Cu3erBlockController->pathfromfileid('3')
#6 /home/hoteland/public_html/new/packages/cu3er/blocks/cu3er/controller.php(207): Cu3erBlockController->loadBlockInformation()
#7 [internal function]: Cu3erBlockController->view()
#8 /home/hoteland/public_html/new/concrete/core/libraries/controller.php(224): call_user_func_array(Array, Array)
#9 /home/hoteland/public_html/new/concrete/core/libraries/block_controller.php(474): Concrete5_Library_Controller->runTask('view', Array)
#10 /home/hoteland/public_html/new/concrete/core/libraries/block_view.php(212): Concrete5_Library_BlockController->setupAndRun('view')
#11 /home/hoteland/public_html/new/concrete/core/models/area.php(642): Concrete5_Library_BlockView->render(Object(Block))
#12 /home/hoteland/public_html/new/themes/greek_hotel1/elements/header.php(44): Concrete5_Model_Area->display(Object(Page))
#13 /home/hoteland/public_html/new/concrete/core/libraries/view.php(447): include('/home/hoteland/...')
#14 /home/hoteland/public_html/new/themes/greek_hotel1/full.php(3): Concrete5_Library_View->inc('elements/header...')
#15 /home/hoteland/public_html/new/concrete/core/libraries/view.php(929): include('/home/hoteland/...')
#16 /home/hoteland/public_html/new/concrete/dispatcher.php(258): Concrete5_Library_View->render(Object(Page))
#17 /home/hoteland/public_html/new/index.php(2): require('/home/hoteland/...')
#18 {main}
Exception Occurred: /home/hoteland/public_html/new/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysql error: [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 'LIMIT 1' at line 1] in EXECUTE("SELECT fvFilename FROM FileVersions WHERE fID=3 AND fvID= LIMIT 1")
(1064)
#0 /home/hoteland/public_html/new/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1064, 'You have an err...', 'SELECT fvFilena...', false, Object(ADODB_mysql))
#1 /home/hoteland/public_html/new/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('SELECT fvFilena...', false)
#2 /home/hoteland/public_html/new/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php(497): ADOConnection->Execute('SELECT fvFilena...', false)
#3 /home/hoteland/public_html/new/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php(162): ADODB_mysql->SelectLimit('SELECT fvFilena...', 1, -1, false)
#4 /home/hoteland/public_html/new/packages/cu3er/blocks/cu3er/controller.php(519): ADODB_mysql->GetOne('SELECT fvFilena...')
#5 /home/hoteland/public_html/new/packages/cu3er/blocks/cu3er/controller.php(146): Cu3erBlockController->pathfromfileid('3')
#6 /home/hoteland/public_html/new/packages/cu3er/blocks/cu3er/controller.php(207): Cu3erBlockController->loadBlockInformation()
#7 [internal function]: Cu3erBlockController->view()
#8 /home/hoteland/public_html/new/concrete/core/libraries/controller.php(224): call_user_func_array(Array, Array)
#9 /home/hoteland/public_html/new/concrete/core/libraries/block_controller.php(474): Concrete5_Library_Controller->runTask('view', Array)
#10 /home/hoteland/public_html/new/concrete/core/libraries/block_view.php(212): Concrete5_Library_BlockController->setupAndRun('view')
#11 /home/hoteland/public_html/new/concrete/core/models/area.php(642): Concrete5_Library_BlockView->render(Object(Block))
#12 /home/hoteland/public_html/new/themes/greek_hotel1/elements/header.php(44): Concrete5_Model_Area->display(Object(Page))
#13 /home/hoteland/public_html/new/concrete/core/libraries/view.php(447): include('/home/hoteland/...')
#14 /home/hoteland/public_html/new/themes/greek_hotel1/full.php(3): Concrete5_Library_View->inc('elements/header...')
#15 /home/hoteland/public_html/new/concrete/core/libraries/view.php(929): include('/home/hoteland/...')
#16 /home/hoteland/public_html/new/concrete/dispatcher.php(258): Concrete5_Library_View->render(Object(Page))
#17 /home/hoteland/public_html/new/index.php(2): require('/home/hoteland/...')
#18 {main}
Thanks for your replay! Its been alot of work by puting new menu, links, renamings. It should be a way to trace the records in MySQL db to edit the wrong file name or version. Any idea how to trace the faulty record?
Have a look on line if its something I miss:http://www.hotelandreas.com/new...
Have a look on line if its something I miss:http://www.hotelandreas.com/new...
You could delete the block rather digging into the huge DB.
Rony
Rony
It wouldn't let me go in edit mode in the particular faulty page (the german language main)http://www.hotelandreas.com/new/de/.... Although I can edit any other subpage of the current page or other language page. Can I force edit mode in some way?
I'm not sure how you force the edit mode. But if you want then I can have a look. You can PM me the login details as well as DB access. Though its up to you.
Rony
Rony
The stack trace shows that it's a problem with the cu3er package you installed (http://www.concrete5.org/marketplace/addons/cu3er-slideshow/). You should contact the developer via the support request process or, at the very least, ensure it's at the latest (appropriate) version.
Fixed by unintalling the cu3er package.
Rony