× Here you can get community support related to ReDJ.

Installation error

More
10 years 2 months ago #2109 by Verma
Installation error was created by Verma
I installed ReDJ on 2.5 joomla, and the home page of ReDJ component Admin shows following error:

500 - An error has occurred.
Unknown column 'a.skip' in 'field list' SQL=SELECT a.id, a.fromurl, a.tourl, a.skip, a.redirect, a.case_sensitive, a.request_only, a.decode_url, a.placeholders, a.comment, a.hits, a.last_visit, a.ordering, a.published, a.checked_out, a.checked_out_time,uc.name AS editor FROM kn64m_redj_redirects AS a LEFT JOIN kn64m_users AS uc ON uc.id = a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc Unknown column 'a.skip' in 'field list' SQL=SELECT a.id, a.fromurl, a.tourl, a.skip, a.redirect, a.case_sensitive, a.request_only, a.decode_url, a.placeholders, a.comment, a.hits, a.last_visit, a.ordering, a.published, a.checked_out, a.checked_out_time,uc.name AS editor FROM kn64m_redj_redirects AS a LEFT JOIN kn64m_users AS uc ON uc.id = a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc LIMIT 0, 20 Unknown column 'a.skip' in 'field list' SQL=SELECT a.id, a.fromurl, a.tourl, a.skip, a.redirect, a.case_sensitive, a.request_only, a.decode_url, a.placeholders, a.comment, a.hits, a.last_visit, a.ordering, a.published, a.checked_out, a.checked_out_time,uc.name AS editor FROM kn64m_redj_redirects AS a LEFT JOIN kn64m_users AS uc ON uc.id = a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc

Return to Control Panel


Although 404 error admin page is visible.

Please help

Please Log in or Create an account to join the conversation.

More
10 years 2 months ago #2111 by admin
Replied by admin on topic Installation error
Hi,
it seems the table schema is not updated (skip field was added in the last version). If you have no rules to preserve, just drop the kn64m_redj_redirects table and reinstall the ReDJ package.

Another solution could be to execute this sql statement on the Joomla db (e.g. using phpMyAdmin):
ALTER TABLE `kn64m_redj_redirects` ADD COLUMN `skip` varchar(255) NOT NULL DEFAULT '' AFTER `tourl`;

Let me know if you need help with this.

Kind regards,
Luigi

Please Log in or Create an account to join the conversation.

Time to create page: 0.078 seconds