Joomla Templates Club 406,261 posts

[staurakis Friend staurakisJoin date: September 2015Posts: 9Downloads:0Uploads:0]

#819976

I have a problem with the 404 page of my site (JA Onepage template).
More specifically, the site is nooseit.com and if someone go to nooseit.com/test for example that doesn’t exist, will receive the following error:

jos-Warning: exception ‘RuntimeException’ with message ‘Unknown column ‘header’ in ‘field list’ SQL=SELECT new_url,header,published FROM jaxt8_redirect_links WHERE old_url = ‘http://www.nooseit.com/test‘ LIMIT 0, 1’ in /home/nooseit/public_html/libraries/joomla/database/driver/mysqli.php:610 Stack trace: #0 /home/nooseit/public_html/libraries/joomla/database/driver.php(1279): JDatabaseDriverMysqli->execute() #1 /home/nooseit/public_html/plugins/system/redirect/redirect.php(86): JDatabaseDriver->loadObject() #2 [internal function]: PlgSystemRedirect::handleError(Object(JException)) #3 /home/nooseit/public_html/libraries/legacy/error/error.php(760): call_user_func(Array, Object(JException)) #4 [internal function]: JError::handleCallback(Object(JException), Array) #5 /home/nooseit/public_html/libraries/legacy/error/error.php(218): call_user_func_array(Array, Array) #6 /home/nooseit/public_html/libraries/legacy/error/error.php(179): JError::throwError(Object(JException)) #7 /home/nooseit/public_html/libraries/legacy/error/error.php(254): JError::raise(1, 404, ‘Article not fou…’, NULL, true) #8 /home/nooseit/public_html/components/com_content/models/article.php(163): JError::raiseError(404, ‘Article not fou…’) #9 /home/nooseit/public_html/plugins/system/t3/includes/joomla30/viewlegacy.php(394): ContentModelArticle->getItem() #10 /home/nooseit/public_html/components/com_content/views/article/view.html.php(42): JViewLegacy->get(‘Item’) #11 /home/nooseit/public_html/libraries/legacy/controller/legacy.php(690): ContentViewArticle->display() #12 /home/nooseit/public_html/components/com_content/controller.php(104): JControllerLegacy->display(true, Array) #13 /home/nooseit/public_html/libraries/legacy/controller/legacy.php(728): ContentController->display() #14 /home/nooseit/public_html/components/com_content/content.php(38): JControllerLegacy->execute(NULL) #15 /home/nooseit/public_html/libraries/cms/component/helper.php(392): require_once(‘/home/nooseit/p…’) #16 /home/nooseit/public_html/libraries/cms/component/helper.php(372): JComponentHelper::executeComponent(‘/home/nooseit/p…’) #17 /home/nooseit/public_html/libraries/cms/application/site.php(191): JComponentHelper::renderComponent(‘com_content’) #18 /home/nooseit/public_html/libraries/cms/application/site.php(230): JApplicationSite->dispatch() #19 /home/nooseit/public_html/libraries/cms/application/cms.php(252): JApplicationSite->doExecute() #20 /home/nooseit/public_html/index.php(45): JApplicationCms->execute() #21 {main}

the related article for the error exists and seems correct.
Could you please help me on this error? What could it be the problem?

Thank you very much in advance for your help.
Theodore

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#826295

Hi Theodore,

Which version of Joomla are you using? It seems to be a bug in Joomla: https://issues.joomla.org/tracker/joomla-cms/6333

[staurakis Friend staurakisJoin date: September 2015Posts: 9Downloads:0Uploads:0]

#827021

Hello Saguaros,

thank you so much for your reply. I have the latest version 3.4.6.
From what I have understood from the thread you have pointed out, I have to alter the database in order to maybe fix this….? I will try to post a question to that thread as well…
Thank you very much once again for your help.
Any suggestions on this are more than highly appreciated.
Regards,
Theodore

[staurakis Friend staurakisJoin date: September 2015Posts: 9Downloads:0Uploads:0]

#827072

Hello all,

since I found a solution and worked fine, I thought I should post the solution here as well.
In order to solve this what appears to be a joomla error, one has to run the following two sql lines:

ALTER TABLE #__redirect_links ADD header smallint(3) NOT NULL DEFAULT 301;
ALTER TABLE #__redirect_links MODIFY new_url varchar(255);

where obviously #_ has to be replaced with the extension of the db table names.
After this, everything is working fine concerning the 404 page.

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#828111

Glad to hear you sorted it out!

[Author]

Posts