robinbortlik / db_explorer Goto Github PK

Hi there, me again.

So, I ran into this error in

abstract_objects/_form.html.haml, line #5

for an app that has a model, "User" and a non-key string attribute, "country" in an SQLite3 local database. I looked around and it appears to be related to this issue: heartcombo/simple_form#54 which apparently has been addressed in the simple_forrm gem (see README), but perhaps might need to be tweaked in db_explorer?

Hi i found a syntax error in "app/controllers/database_connections_controller.rb".

I got this 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 'ASC LIMIT 50 OFFSET 0' at line 1: SELECT database_connections.* FROM database_connections ORDER BY database ASC LIMIT 50 OFFSET 0"

It's fixed if i modify this line:
@database_connections = DatabaseConnection.order("database ASC").page(params[:page])

To this:
@database_connections = DatabaseConnection.order("database ASC").page(params[:page])

I have attached a screenshot here: http://i.imgur.com/78Fzk.png

Will dbExplorer support UTF-8 databases for MySQL in future?

I am having an error when I bundle install your application:

An error occurred while installing eventmachine (1.0.3), and Bundler cannot continue.

Hi there,

running the export feature on big amount of data makes the server crash. It's better to enter some kind of limitation.

Thanks
L80

Truncate the long texts and no wrap numbers.
Display all data in detail view of the record.

It would be great to have name of selected connection above the table.

i18n-0.6.1 is required but only i18n-0.6.5 is available on my sistem.

DbExplorer works great with PostgreSQL and MYSQL. I cannot, however, get it to work correctly with SQLite3. I am able to successfully add (multiple) local SQLite database connections to the DatabaseConnection table via the db_explorer app while their corresponding rails servers are running. But the app does not "see" any of the corresponding SQLite3 database tables and thus the "List of Tables" is always empty on the schemas#show page. I don't know if it matters, but I have tried SQLite3 database apps under Rails 3.1.4, 3.2.1 and Rails 3.2.3 with no success. What am I missing? Any ideas? Thank you.

Hi robinbortlik,
do you plan to build an export function?
Like the dump function of phpmyadmin or just on the selected values.

Cheers
L80

I have this error after installation (you have a typo in this word in readme ;) )

LoadError in Database_connections#index

Showing /home/fsqcds/db_explorer/app/views/layouts/application.html.haml where line #11 raised:

cannot load such file -- less
  (in /home/fsqcds/db_explorer/app/assets/stylesheets/bootstrap_and_overrides.css.less)
Extracted source (around line #11):

8:     / Le HTML5 shim, for IE6-8 support of HTML elements
9:     /[if lt IE 9]
10:       <script src="http://html5shim.googlecode.com/svn/trunk/html5.js" type="text/javascript"></script>
11:     = stylesheet_link_tag "application", :media => "all"
12:     %link{:href => "/favicon.ico", :rel => "shortcut icon"}/
13:     %link{:href => "images/apple-touch-icon.png", :rel => "apple-touch-icon"}/
14:     %link{:href => "images/apple-touch-icon-72x72.png", :rel => "apple-touch-icon", :sizes => "72x72"}/

DEPRECATION WARNING: Sprockets method register_engine is deprecated.
Please register a mime type using register_mime_type then
use register_compressor or register_transformer.
https://github.com/rails/sprockets/blob/master/guides/extending_sprockets.md#supporting-all-versions-of-sprockets-in-processors
(called from block in class:Railtie at /usr/local/rvm/gems/ruby-2.3.0/gems/less-rails-2.7.1/lib/less/rails/railtie.rb:15)

DEPRECATION WARNING: You are using the a deprecated processor interface Less::Rails::ImportProcessor.
Please update your processor interface:
https://github.com/rails/sprockets/blob/master/guides/extending_sprockets.md#supporting-all-versions-of-sprockets-in-processors
(called from block in class:Railtie at /usr/local/rvm/gems/ruby-2.3.0/gems/less-rails-2.7.1/lib/less/rails/railtie.rb:20)
/usr/local/rvm/gems/ruby-2.3.0/gems/actionpack-4.2.6/lib/action_dispatch/http/mime_type.rb:163: warning: already initialized constant Mime::CSV
/usr/local/rvm/gems/ruby-2.3.0/gems/actionpack-4.2.6/lib/action_dispatch/http/mime_type.rb:163: warning: previous definition of CSV was here

Thin web server (v1.7.0 codename Dunder Mifflin)
Maximum connections set to 1024
Listening on localhost:3000, CTRL+C to stop