Ravel Admin Freezes in Laravel

[bobrocke]

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]

can u paste the SQL error message

[bobrocke]

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]

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]

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

[bobrocke]

I'm running MySQL 5.5.29 via MAMP Pro.

[raftalks]

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]

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]

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]

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