× Here you can get community support related to ReDJ.

Database error

  • mikem22
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 2 months ago - 9 years 2 months ago #3431 by mikem22
Database error was created by mikem22
An error has occurred.

500 Unknown column 'a.skip' 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 xxxxx_redj_redirects AS a LEFT JOIN xxxx_users AS uc ON uc.id = a.checked_out ORDER BY a.ordering asc LIMIT 0, 50


This is after upgrading a site from J2.5 to J3.3 ... Is it ok to delete the redj tables in the database to see if that fixes the problem.
Last edit: 9 years 2 months ago by mikem22.

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

More
9 years 2 months ago #3432 by admin
Replied by admin on topic Database error
If you do not have rules to save, uninstall, drop tables and reinstall. This usually fixes the issue.

Let me know...
The following user(s) said Thank You: mikem22

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

  • mikem22
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 2 months ago #3433 by mikem22
Replied by mikem22 on topic Database error
Yes, that has worked fine ..

Thank you !!

Mike

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

More
9 years 2 months ago #3437 by admin
Replied by admin on topic Database error
U're welcome. :)

Luigi

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

Time to create page: 0.090 seconds