Error redirect #6333
Comments
|
After 3.4 upgrade (I think) there is an HTTP 500 error on my website, when I go thru redirected links. After disabling redirect plugin, wrong links are processing as HTTP 404 normaly This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6333. |
|
It appears your database is not up-to-date with the current system schema. If you go to the Extension Manager's Database view, you can check this and attempt to fix it by clicking the "Fix" button in the toolbar. |
|
Hello mbabker, |
|
My DB is up-to-date too |
|
This seems to be a definite Joomla! bug of some sort. A client has just reported a similar error (J! 3.4): N.B. the domain name has been replaced by ''. jos-Warning: exception 'RuntimeException' with message 'Unknown column 'header' in 'field list' SQL=SELECT On checking, I find the database IS up to date: Database table structure is up to date. |
|
Your database has not been updated correctly. |
|
Hello, But on my website, change language still not working ! Laurent |
|
Can this be closed? |
|
Don't close it yet, this issue is going to keep popping up as it has with me today. Not knowing too much about phpmyadmin, but just enough to get me into trouble, how does one go about safely applying this fix? ie, talk us through where to go in phpmyadmin and where to put it please. Thanks Bruce This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6333. |
|
when you google the error, you find many sites with the issue After: Still getting the error: Fatal error: Uncaught exception 'RuntimeException' with message 'Unknown column 'header' in 'field list' SQL=SELECT Fix: |
|
after upgrading to joomla 3.4.1 when I try to add new external urls for custom buttons, it gives me a fattal error, because it tries to go to my url/externalurl Fatal error: Uncaught exception 'RuntimeException' with message 'Unknown column 'header' in 'field list' SQL=SELECT any solution? thanks This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6333. |
Can you back this claim? The only way this specific error can occur is if the database did not get properly updated. Presumably, if the queries from this file did not get applied, then any new queries shouldn't have been executed or applied either. Update logs would show what queries were actually executed and possibly any failures. If it's really a wide spread issue, there would be a common trend to how sites were updated; using the update component, installing through the extension manager, manually FTP'ing files, or a third party platform. |
|
hello back, seems that error is well spread on joomla 3.4.1. You can even trace hundreds of recent listed websites on google with the same direct error, listed even on google while looking for : Fatal error: Uncaught exception 'RuntimeException' with message 'Unknown column 'header' in 'field list' SQL=SELECT I just tried to look at my rss: www.myurl.com//itemlist?format=feed&type=rss and get this massive white crash error. The update from joomla 3.4.0 to jooomla 3.4.1 was from the update Joomla_3.4.x_to_3.4.1-Stable-Patch_Package from the official joomla website. I will try to patch tomorrow with the full package to see what happens. Any idea? Cheers |
Try to fix your databse. (Extension -> Extension Manager -> Database -> Fix) |
|
hello, The database was fixed but still same error. What do you want me to do with that sql? where to include it? Do you randomly want me to put this code somwhere in the sql? ALTER TABLE Thanks This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6333. |
|
sorry @mbabker , i have edit the message This is the working sql fix First look if header is missing on the table, if there is header in the row, then delete it. maybe you get a error, that's ok, then the last alter table is already varchar(255). Look again in the table if header is there. |
|
Thanks for the information, it works great. This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6333. |
|
The fix is not working for me. My DB was up to date; I still applied the fix. Now I get a HTTP 404., Seems to be an issue with multi language as well, the link from my page goes to a PDF (download) and still gets the language appended ( /en/ after the domain in my case). This leads to a 404. This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6333. |
|
Scratch that, the fix works - my link was not case sensitive. The db error was fixed after applying the SQL statement. Still, this should have been done automatically on upgrade... This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6333. |
It will be done automatically 😄 |
|
Can we close this? |
|
@zero-24 juding from the date of the patch, this should have been included in 3.4.1?
|
|
This is still an issue in 3.4.6 and using the database fix tool in the extension manager does not see, nor fix the issue. Manually running the query posted above does fix it, however it seems that this cannot be fixed through the CMS. This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6333. |
|
@mbabker @infograf768 @zero-24 see #8786 I found the probable cause of the problems with this file |
PR fot issue joomla#8786 Original issue description >IMHO file https://github.com/joomla/joomla-cms/blob/staging/administrator/components/com_admin/sql/updates/mysql/3.4.0-2014-09-16.sql contains MySQL syntax errors : >is >````SQL >ALTER TABLE `#__redirect_links` ADD header smallint(3) NOT NULL DEFAULT 301; >ALTER TABLE `#__redirect_links` MODIFY new_url varchar(255); >```` >should be >````sql >ALTER TABLE `#__redirect_links` ADD `header` smallint(3) NOT NULL DEFAULT 301; >ALTER TABLE `#__redirect_links` MODIFY `new_url` varchar(255); >```` >related: joomla#6333
|
Ok, i think i found the reason: class JSchemaChangeitemMysql, function buildCheckQuery()
you can see that the checkQuery property is not created properly .../libraries/cms/schema/changeitem/mysql.sql you will get: a fix could , that i tested and seems to work properly is to add a elseif at the bottom of if-else chain: |
|
Please re-open this, see my answer above
|
|
@ggppdk IMHO fix in |
|
Set to "open" on behalf of @infograf768 by The JTracker Application at issues.joomla.org/joomla-cms/6333 |
|
re-opened |
|
@infograf768, thanks, next week, I will have more time, |
|
why are there 3 dots in front of the path? On 12/25/2015 23:19, Georgios Papadakis wrote:
|
|
@N6REJ My local path is:
|
|
Ok, i confirm at least the DATABASE "Fix" button now works after using in the JSchemaChangeitemMysql: I manually deleted the header column from the redirect_links
Notice that without the fix the reported DB changes are 79, and with the fix the reported changes are 80 If the Joomla upgrade process uses the same check then that is the reason why the change is not applied. I have not tested upgrade yet |
|
This issue regarding redirect_links table, can be re-closed since
But if found 1 more non-handled case with
Found 1 case of usage of it in file: 2.5.4-2012-03-19.sql After patching JSchemaChangeitemMysql or patching the SQL file, the number of database changes reported go up to 81, I will make a pull request for both cases: |
|
I am closing this as it was resolved with #8788 This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6333. |
|
for sake of anyone who stumbles on this looking for solution to jos-error, i found that I only get the jos-error if an alias starts with a NUMBER This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/6333. |
and others
Hello everyone,
I would like to report a problem:
On all the sites where I Joomla, after upgrading to 3.4.0 if I go on a link insesistente, instead of the usual 404 error I get the following error:
jos-Warning: exception 'RuntimeException' with message 'Unknown column 'header' in 'field list' SQL=SELECT
new_url,header,publishedFROMoq6_redirect_linksWHEREold_url= 'http://URL INEXISTENT' LIMIT 0, 1' in /home/agenzias/public_html/libraries/joomla/database/driver/mysqli.php:610 Stack trace: #0 /home/agenzias/public_html/libraries/joomla/database/driver.php(1239): JDatabaseDriverMysqli->execute() #1 /home/agenzias/public_html/plugins/system/redirect/redirect.php(74): JDatabaseDriver->loadObject() #2 [internal function]: PlgSystemRedirect::handleError(Object(JException)) #3 /home/agenzias/public_html/libraries/legacy/error/error.php(760): call_user_func(Array, Object(JException)) #4 [internal function]: JError::handleCallback(Object(JException), Array) #5 /home/agenzias/public_html/libraries/legacy/error/error.php(218): call_user_func_array(Array, Array) #6 /home/agenzias/public_html/libraries/legacy/error/error.php(179): JError::throwError(Object(JException)) #7 /home/agenzias/public_html/libraries/legacy/error/error.php(254): JError::raise(1, 404, 'Articolo non tr...', NULL, true) #8 /home/agenzias/public_html/components/com_content/models/article.php(163): JError::raiseError(404, 'Articolo non tr...') #9 /home/agenzias/public_html/plugins/system/t3/includes/joomla30/viewlegacy.php(394): ContentModelArticle->getItem() #10 /home/agenzias/public_html/components/com_content/views/article/view.html.php(42): JViewLegacy->get('Item') #11 /home/agenzias/public_html/libraries/legacy/controller/legacy.php(690): ContentViewArticle->display() #12 /home/agenzias/public_html/components/com_content/controller.php(104): JControllerLegacy->display(true, Array) #13 /home/agenzias/public_html/libraries/legacy/controller/legacy.php(728): ContentController->display() #14 /home/agenzias/public_html/components/com_content/content.php(16): JControllerLegacy->execute(NULL) #15 /home/agenzias/public_html/libraries/cms/component/helper.php(380): require_once('/home/agenzias/...') #16 /home/agenzias/public_html/libraries/cms/component/helper.php(360): JComponentHelper::executeComponent('/home/agenzias/...') #17 /home/agenzias/public_html/libraries/cms/application/site.php(191): JComponentHelper::renderComponent('com_content') #18 /home/agenzias/public_html/libraries/cms/application/site.php(230): JApplicationSite->dispatch() #19 /home/agenzias/public_html/libraries/cms/application/cms.php(251): JApplicationSite->doExecute() #20 /home/agenzias/public_html/index.php(40): JApplicationCms->execute() #21 {main}Disabling the plugin redirects the situation returns to normal, and the system returns the classic 404.
Having several articles that update automatically and have a deadline I was very comfortable the automatic redirect ... someone who has had the same problem as me knows say has solved?
Thank You
The text was updated successfully, but these errors were encountered: