Install fails with error; Installation error: SQLSTATE[HY093]

[ccullings]

After preparing the Ubuntu with the prerequisite software and permissions, I started the install using the index.php installer.

When I get to the ready to install page, I recieve the message "The system is connected to your database and the app/settings.php file contains this connection info..." I enter the Admin username, email, password etc. and click the "Install Chevereto" button.

The full error that comes back is
"Installation error: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound"

Any idea on how to resolve this problem?

Chris

 

[ccullings]

I turned on logging in mysql. I found that Cheverito is querying the database but with the following commands but no tables have been created int he DB yet. Is there a DB creation script I'm missing?

190130 13:08:08 86 Connect root@localhost on Photos
86 Query SET NAMES 'UTF8'
86 Query SELECT * FROM chv_settings ORDER BY setting_name ASC
86 Quit
87 Connect root@localhost on Photos
87 Query SET NAMES 'UTF8'
87 Query SELECT * FROM chv_settings ORDER BY setting_name ASC
87 Query SELECT * FROM chv_info WHERE `info_key`='version'
87 Query SELECT * FROM chv_settings
87 Quit
190130 13:08:09 88 Connect root@localhost on Photos
88 Query SET NAMES 'UTF8'
88 Query SELECT * FROM chv_settings ORDER BY setting_name ASC
88 Quit
89 Connect root@localhost on Photos
89 Query SET NAMES 'UTF8'
89 Query SELECT * FROM chv_settings ORDER BY setting_name ASC
89 Query SELECT * FROM chv_info WHERE `info_key`='version'
89 Query SELECT * FROM chv_settings
89 Quit
190130 13:08:31 90 Connect root@localhost on Photos
90 Query SET NAMES 'UTF8'
90 Query SELECT * FROM chv_settings ORDER BY setting_name ASC
90 Query SELECT * FROM chv_info WHERE `info_key`='version'
90 Quit
190130 13:08:51 85 Quit

 

[Rodolfo]

Is there a DB creation script I'm missing?

loader.php always check if the thing is installed or not, that's why it always try to get chv_settings when it detects a database connection.

When Chevereto does the install sql, it issues lots of queries in a single query so when something fails, it breaks the whole thing. Replace this:

$db->query($install_sql);

With this:

G\debug($install_sql); die();
$db->query($install_sql);

That will print you the install sql query when you attempt to install the thing at /install

 

[Support]

Unfortunately, this ticket has more than seven days without a reply or feedback from the original poster. We will now consider this ticket abandoned and its now closed.

Don't hesitate to create a new ticket if this matter is still causing you issues.

Ticket closed.