Joomla! Issue Tracker | Joomla! CMS #5953 - redirect plugin unknown column `header` error

Closed
2 Feb 2015
Medium
Build: master
# 5953

thinkerytim
2 Feb 2015

Steps to reproduce the issue

Joomla! 3.4.0-beta1 Beta
Enable system redirect plugin

Type in a known bad URL

Expected result

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

JApplicationCms -> execute() @ /home/thinkery/www/testsite/index.php:40
JApplicationSite -> doExecute() @ /home/thinkery/www/testsite/libraries/cms/application/cms.php:251
JApplicationSite -> dispatch() @ /home/thinkery/www/testsite/libraries/cms/application/site.php:230
JComponentHelper :: renderComponent() @ /home/thinkery/www/testsite/libraries/cms/application/site.php:191
JComponentHelper :: executeComponent() @ /home/thinkery/www/testsite/libraries/cms/component/helper.php:360
require_once() @ /home/thinkery/www/testsite/libraries/cms/component/helper.php:380
JControllerLegacy -> execute() @ /home/thinkery/www/testsite/components/com_content/content.php:16
ContentController -> display() @ /home/thinkery/www/testsite/libraries/legacy/controller/legacy.php:728
JControllerLegacy -> display() @ /home/thinkery/www/testsite/components/com_content/controller.php:104
ContentViewArticle -> display() @ /home/thinkery/www/testsite/libraries/legacy/controller/legacy.php:690
JError :: raiseWarning() @ /home/thinkery/www/testsite/components/com_content/views/article/view.html.php:50
JError :: raise() @ /home/thinkery/www/testsite/libraries/legacy/error/error.php:277

Actual result

System information (as much as possible)

Additional comments

This threw a Fatal PHP error one time, then appeared to handle it via JError in subsequent attempts-- still, it doesn't handle the error gracefully and results in unstyled error page.

thinkerytim - open - 2 Feb 2015

roland-d - comment - 2 Feb 2015

Hello,
Did you do an update or a clean installation? As far as I can tell for a clean installation the header field is there when creating the table.

thinkerytim - comment - 2 Feb 2015

This was an upgrade from the previous 3.4 build

roland-d - comment - 2 Feb 2015

In that case such behavior can be expected because the update database queries won't run since you are going from 3.4 to 3.4 :) One thing you can try is to click on the Fix button in the Extension Manager -> Database page. If that fails, a clean installation will need to be done.

thinkerytim - comment - 2 Feb 2015

Fix button did not appear to resolve it, but no big deal. I thought since it was going from alpha -> beta that the version check would catch that.

Thanks for the help.

zero-24 - close - 2 Feb 2015

thinkerytim - close - 2 Feb 2015

thinkerytim - change - 2 Feb 2015

Status	New	⇒	Closed
Closed_Date	0000-00-00 00:00:00	⇒	2015-02-02 22:02:24

kraps04 - comment - 27 Feb 2015

I have this issue after upgrading from 3.3.6 to 3.4 on a live site - "fix database" does not work and clean install is not an option. Help!

sovainfo - comment - 27 Feb 2015

Apply these:

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

kraps04 - comment - 27 Feb 2015

Works like a charm. Thank you very much!

Willard1975 - comment - 4 Apr 2015

I had the same issue and sovainfo's solutions worked great. Thanks.

zero-24 - change - 4 Apr 2015

Labels

Added: ?

groenermedia - comment - 18 Jun 2015

@sovainfo Your solution works great. Thank you.

Add a Comment

Older
Newer

Joomla! Issue Tracker - CMS

[#5953] - redirect plugin unknown column `header` error