Help...Can’t delete page, Index Search Engine Error
Permalink
So I moved my site site from to the main directory (following instructions here:http://www.concrete5.org/help/building_with_concrete5/installation/...
Everything seemed fine, but when I ran System & Maintenance I get this:
mysql error: [1054: Unknown column 'fsDisplayOrder' in 'order clause'] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fv.fvType = '1' and fvIsApproved = '1' order by fsDisplayOrder asc, fID asc limit 0,1000 ")
And if I try to delete an existing page I get this:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'fsDisplayOrder' in 'order clause'] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fv.fvType = '1' and fvIsApproved = '1' order by fsDisplayOrder asc, fID asc limit 0,1000 ") ' in /var/www/vhosts/jackojazz.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /var/www/vhosts/jackojazz.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1054, 'Unknown column ...', 'SELECT DISTINCT...', false, Object(ADODB_mysql)) #1 /var/www/vhosts/jackojazz.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('SELECT DISTINCT...', false) #2 /var/www/vhosts/jackojazz.com/httpdocs/concrete/libraries/3rdparty/ in /var/www/vhosts/jackojazz.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Any help would greatly be appreciated!
Everything seemed fine, but when I ran System & Maintenance I get this:
mysql error: [1054: Unknown column 'fsDisplayOrder' in 'order clause'] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fv.fvType = '1' and fvIsApproved = '1' order by fsDisplayOrder asc, fID asc limit 0,1000 ")
And if I try to delete an existing page I get this:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'fsDisplayOrder' in 'order clause'] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fv.fvType = '1' and fvIsApproved = '1' order by fsDisplayOrder asc, fID asc limit 0,1000 ") ' in /var/www/vhosts/jackojazz.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /var/www/vhosts/jackojazz.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1054, 'Unknown column ...', 'SELECT DISTINCT...', false, Object(ADODB_mysql)) #1 /var/www/vhosts/jackojazz.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('SELECT DISTINCT...', false) #2 /var/www/vhosts/jackojazz.com/httpdocs/concrete/libraries/3rdparty/ in /var/www/vhosts/jackojazz.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Any help would greatly be appreciated!
