24 Mar '17, 12am

MySQL 8.0では admin が予約語になったのでカラム名に admin が使われているシステムは要対応。 https://t.co/bFeLKfbRBq

Clicking "My account" when using a mysql database gives the folowing error: Completed 500 Internal Server Error in 383ms (ActiveRecord: 12.9ms) ActionView::Template::Error (Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'admin = 1 AND id <> 4) LIMIT 1' at line 1: SELECT 1 AS one FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND `users`.`status` = 1 AND (admin = 1 AND id <> 4) LIMIT 1): 3: <p><%=l(:field_login)%>: <strong><%= link_to_user(@user, :format => :username) %></strong><br /> 4: <%=l(:field_created_on)%>: <%= format_time(@user.created_on) %></p> 5: 6: <% if @user.own_account_deletable? %> 7: <p><%= link_to(l(:button_delete_my_account), {:action => 'destroy'}, :class => 'icon icon-del') %></p> 8: <% end %> 9: app/models/user.rb:687:in `own_account_d...

Full article: http://www.redmine.org/issues/25416

Tweets

@y503unavailable SQL-99の予約語ということは将来的にはMySQL以外でも...

redmine.org 26 Mar '17, 4am

Clicking "My account" when using a mysql database gives the folowing error: Completed 500 Internal Server Error in 383ms (...

Small Wars Journal Admin Note # 2017-1

smallwarsjournal.com 04 Apr '17, 6pm

Over the next week SWJ will be posting a series of administrative notes concerning issues important to the Journal and its...