search

raftalks / ravel

CMS developed with Laravel 4 PHP framework and Angularjs
BSD 3-Clause "New" or "Revised" License
217 stars 38 forks source link

Ravel Admin Freezes in Laravel #28

Open bobrocke opened 11 years ago

bobrocke commented 11 years ago

I installed Ravel with composer and that seemed to work fine. When I go to mysite.com/admin I can log into Ravel and see the admin interface. But when I click on the Dashboard tab, I get a view with a spinner at the top that never loads any content.

When I click the Media tab I get a big SQL state error message, briefly, at the top.

How do I get Ravel working?

Bob

raftalks commented 11 years ago

can u paste the SQL error message

bobrocke commented 11 years ago

SQLSTATE[HY000]: General error: 1 no such function: if (SQL: select *, if(user_id = 2,"private","shared") as type from "mcollections" where "user_id" = ? or ("shared" = ?) limit 10 offset 0) (Bindings: array ( 0 => '2', 1 => 1, ))

Would that also explain the stall on the Dashboard tab?

raftalks commented 11 years ago

I haven't finished the dashboard and since there are no controllers and no service requests, the ajax loader is displayed.

As for the SQL error, seems like your MySQL version is not supporting the Control Flow Function IF() http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_if

Can you tell me your MySQL version ? RavelCMS Requires MySQL 5.0+

raftalks commented 11 years ago

I think I should probably avoid that line of SQL to make it comply with other databases via PDO.

bobrocke commented 11 years ago

I'm running MySQL 5.5.29 via MAMP Pro.

raftalks commented 11 years ago

Thats strange, I can't seem to replicate the same issue. Did you add a collection to the media, or is that error shown straight after you have clicked to Media ?

Can you check if the database table 'mcollections' exists? Also make sure you are using MySQL by checking the app/config/database.php file where the array key for 'default' should be 'mysql'

bobrocke commented 11 years ago

I get the error immediately after clicking on the Media tab. No collections have yet been added.

The table mcollections does exist.

BUT, I am running Laravel 4 locally with a SQLite database!

Must I be running MySQL to use Ravel?

raftalks commented 11 years ago

Yes, that is the issue. You will need to use MySQL to use Ravel as of now, as I need to remove some of those SQL query statements to make it work with other databases.

bobrocke commented 11 years ago

OK, I'll try that next. I thought the Laravel environment was pretty database agnostic.