Nova 2.3.0 Install/update MySQL error

Having a problem getting Nova installed? Can't figure out why something isn't working right? This is the place to get help and report any bugs you find with Nova!

Putski Tue Nov 19, 2013 2:10 pm

Nova 2.3.0 Install/update MySQL error

If you are having trouble updating to or Installing Nova 2.3.0, don't worry, you aren't alone. There is an error in one of the SQL statements in the install. It doesn't error on every server, so the problem may not affect you, some servers are more fault tolerant than others. Details of the error and how to fix it:

A Database Error Occurred
Error Number: 1064
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 'nova_sessions (last_activity)' at line 1

CREATE INDEX last_activity_idx ON nova_sessions(last_activity)

Filename: /public_html/aurora/nova/modules/assets/install/data.php
Line Number: 15

The fix it pretty simple, a missing space and removing the ():

$this->db->query("CREATE INDEX last_activity_idx ON $sess_table(last_activity)");

to

$this->db->query("CREATE INDEX last_activity_idx ON $sess_table last_activity");

It's pretty simple to fix once you know what you are looking for.

Todd

Posts: 1


Return to Help

Who is online

Users browsing this forum: No registered users and 2 guests

cron