Ravel Admin Freezes in Laravel about ravel HOT 9 OPEN

can u paste the SQL error message

from ravel.

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?

from ravel.

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+

from ravel.

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

from ravel.

I'm running MySQL 5.5.29 via MAMP Pro.

from ravel.

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'

from ravel.

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?

from ravel.

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.

from ravel.

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

from ravel.