× Here you can get community support related to ReDJ.

I get an error when trying to use redj

  • blackvx
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 3 months ago #3385 by blackvx
Hi,
I installed the latest version and I get this error when I navigate to the component menu:

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 joomlaprefix_redj_redirects AS a LEFT JOIN joomlaprefix_users AS uc ON uc.id = a.checked_out ORDER BY a.ordering asc LIMIT 0, 100

Database Version 5.5.40-36.1
Database Collation utf8_general_ci
PHP Version 5.4.35
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.3.6 Stable [ Ember ] 01-October-2014 02:00 GMT

Thanks for your help!
Michael

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

More
9 years 3 months ago #3386 by admin
Replied by admin on topic I get an error when trying to use redj
Hi Michael,
it seems that the database was not installed. Try to uninstall the whole package and install again. Let me know.

Kind regards,
Luigi

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

  • blackvx
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 3 months ago #3387 by blackvx
Replied by blackvx on topic I get an error when trying to use redj
Luigi,
Thank you for your quick reply. I uninstalled the 3 redj components/plugins and reinstalled. I get the same error unfortunately. I also noticed that when I activate the 404 plugin with the options (Track errors, Redirect errors, Track referers), I get a SQL error when typing an invalid link on my website (see attached). I don't get the error when these are set to No.

I disabled the whole thing for now.


Thanks!

This message has an attachment file.
Please log in or register to see it.

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

More
9 years 3 months ago #3389 by admin
Replied by admin on topic I get an error when trying to use redj
Hi Michael,
it seems the error is still the same, a problem on database:

'Unknown column 'redirect_url'


A working solution should be to drop only ReDJ table _redj_errors and reinstall the package over. Anyway, I would like to help you to fix the issue so, if you want, contact me on skype.

Kind regards,
Luigi
The following user(s) said Thank You: blackvx

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

  • blackvx
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 3 months ago #3392 by blackvx
Replied by blackvx on topic I get an error when trying to use redj
Thanks Luigi,
I tried after I just dropped the error table but I had the same problem. I just drop all redj tables below and it worked after re-installation.
Thanks for your help!
Michael

prefix_redj_errors
prefix_redj_pages404
prefix_redj_redirects
prefix_redj_referers
prefix_redj_referer_urls
prefix_redj_visited_urls

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

More
9 years 3 months ago #3395 by admin
Replied by admin on topic I get an error when trying to use redj
I happy the problem is solved now. It seems from time to time the installation fails, but I really don't know why (the installation process is up to Joomla).

Kind regards,
Luigi

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

Time to create page: 0.086 seconds