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}

2 Attachments

 
ronyDdeveloper replied on at Permalink Reply
ronyDdeveloper
Seems like you have deleted a file which was in use on that page. Is this something that you have done there?

Rony
hoteland replied on at Permalink Reply
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...
ronyDdeveloper replied on at Permalink Reply
ronyDdeveloper
You could delete the block rather digging into the huge DB.

Rony
hoteland replied on at Permalink Reply
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?
ronyDdeveloper replied on at Permalink Reply
ronyDdeveloper
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
jshannon replied on at Permalink Best Answer Reply
jshannon
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.
hoteland replied on at Permalink Reply
Fixed by unintalling the cu3er package.