SQL syntax error when using MySQL

[evgenyneu]

If using MySQL database instead of PostrgeSQL it shows an error when opening the newly created project in browser:

ActiveRecord::StatementInvalid in Projects#show

Showing /home/evgeny/code/tmp/copycopter-server/app/views/projects/show.html.erb where line #4 raised:

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 'key ASC' at line 1: SELECT `locales`.* FROM `locales`  WHERE `locales`.`project_id` = 1 AND `locales`.`enabled` = 1 ORDER BY key ASC

Is copycopter-server supposed to support MySQL?

[darpanp]

I had the same issue when using MySQL database. I modified the following code to fix this issue.

In .../copycopter-server/app/views/projects/show.html.erb where line #4 is
<% @project.locales.enabled_in_order.each do |locale| -%>

Modify to
<% @project.locales.each do |locale| -%>

[darpanp]

@evgenyneu,
I played around with MySQL a little bit more. There were additional issues with the UPDATE so I modified some underlying queries. Seems to be working fine on my local. If you are interested in the changes, let me know.

[evgenyneu]

@darpanp thank you, yes it would be nice if you could share your changes.

[darpanp]

Make following changes to app/models/localization.rb. This should allow you to publish blurbs to all environments (i.e. publish after selecting Production instead of Draft). Oh and don't forget the aforementioned fix above.

Let me know how this works for you.

=========== CODE CHANGES ==================

def self.latest_version
#MYSQL
<<-eosql
SELECT DISTINCT localization_id, id, content
FROM versions ORDER BY localization_id DESC, id DESC
eosql
end

def self.publish
#MYSQL
ActiveRecord::Base.connection.execute <<-eosql
UPDATE localizations
INNER JOIN (
#{latest_version}
) latest_version
ON localizations.id = latest_version.localization_id
SET published_version_id = latest_version.id,
published_content = latest_version.content,
updated_at = '#{connection.quoted_date(Time.now)}'
WHERE localizations.id IN (#{scoped.map(&:id).join(',')});
eosql
end

[patricksrobertson]

copycopter-server wasn't designed to support MySQL. I'm personally not enthused about supporting it either. Not saying I won't look to improve cross-DB compatibility though.

[patricksrobertson]

Duplicate to #66