× Here you can get community support related to ReDJ.

Error on 2.5.22

  • cropperesp
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 10 months ago - 9 years 10 months ago #2665 by cropperesp
Error on 2.5.22 was created by cropperesp
I have used ReDJ since I can remember... but suddently today and a fresh joomla 2.5.22 install I get this error:
500 - An error has occurred.
Unknown column 'a.skip_usergroups' in 'field list' SQL=SELECT a.id, a.fromurl, a.tourl, a.skip, a.skip_usergroups, 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 ATS_redj_redirects AS a LEFT JOIN ATS_users AS uc ON uc.id = a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc Unknown column 'a.skip_usergroups' in 'field list' SQL=SELECT a.id, a.fromurl, a.tourl, a.skip, a.skip_usergroups, 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 ATS_redj_redirects AS a LEFT JOIN ATS_users AS uc ON uc.id = a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc Unknown column 'a.skip_usergroups' in 'field list' SQL=SELECT a.id, a.fromurl, a.tourl, a.skip, a.skip_usergroups, 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 ATS_redj_redirects AS a LEFT JOIN ATS_users AS uc ON uc.id = a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.ordering asc

I did accidentally install the version for J3.0, before uninstalling it and installing the new one - could that cause the error?

Plugin is installed, activated and working fine, I just get this error on the component.
Last edit: 9 years 10 months ago by cropperesp.

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

More
9 years 10 months ago #2666 by admin
Replied by admin on topic Error on 2.5.22
The error means the table structure is not updated. Try to execute this SQL statements:
ALTER TABLE `ATS_redj_redirects` ADD COLUMN `skip_usergroups` text NOT NULL AFTER `skip`;
ALTER TABLE `ATS_redj_errors` ADD COLUMN `redirect_url` varchar(255) NOT NULL DEFAULT '' AFTER `error_code`;

Let me know if you need support with this task.

Kind regards,
Luigi

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

Time to create page: 0.135 seconds