Database is created, but table creation fails
justinrpurdy
18-07-2012 17:26:33
I get to this point in the installation:
Nothing in the mysqld.log since the service started.
Here's what I'm seeing in my Apache error_log:
From what I can see in phpMyAdmin, the database has been created, but there are no tables.
Prerequisite checks are all passed.
OpenSUSE 12.1, MySQL 5.5.16-log, latest version of ONA (11.02.10) downloaded from the site today.
- Connected to 'localhost' as 'root'.
Dropped existing instance of 'ona_default'.
Created new database 'ona_default'.
Selected existing DB: 'ona_default'.
There was an error processing tables.
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 'TYPE=INNODB DEFAULT CHARSET=utf8 DEFAULT COLLATE=utf8_general_ci' at line 8
There was a fatal error. Install may be incomplete. Fix the issue and try again.[/list:u:tw0j5pkv]
Nothing in the mysqld.log since the service started.
Here's what I'm seeing in my Apache error_log:
PHP Notice: Undefined index: APACHE_RUN_USER in /opt/ona/install/install.php on line 48, referer: http://10.10.0.180/ona/
PHP Notice: Undefined index: APACHE_RUN_USER in /opt/ona/install/install.php on line 48, referer: http://10.10.0.180/ona/
PHP Notice: Undefined variable: ona_contexts in /opt/ona/install/install.php on line 61, referer: http://10.10.0.180/ona/
PHP Notice: Undefined variable: db_context in /opt/ona/install/install.php on line 61, referer: http://10.10.0.180/ona/
PHP Notice: Undefined variable: mainstyle in /opt/ona/install/install.php on line 157, referer: http://10.10.0.180/ona/
PHP Notice: Undefined variable: upgrade in /opt/ona/install/install.php on line 214, referer: http://10.10.0.180/ona/
PHP Notice: Undefined index: context_name in /opt/ona/www/include/functions_general.inc.php on line 146, referer: http://10.10.0.180/ona/
PHP Notice: Undefined index: log_to_db in /opt/ona/www/include/functions_general.inc.php on line 62, referer: http://10.10.0.180/ona/
PHP Notice: Undefined index: context_name in /opt/ona/www/include/functions_general.inc.php on line 146, referer: http://10.10.0.180/ona/
PHP Notice: Undefined index: log_to_db in /opt/ona/www/include/functions_general.inc.php on line 62, referer: http://10.10.0.180/ona/
PHP Notice: Undefined index: context_name in /opt/ona/www/include/functions_general.inc.php on line 146, referer: http://10.10.0.180/ona/
PHP Notice: Undefined index: log_to_db in /opt/ona/www/include/functions_general.inc.php on line 62, referer: http://10.10.0.180/ona/
From what I can see in phpMyAdmin, the database has been created, but there are no tables.
Prerequisite checks are all passed.
OpenSUSE 12.1, MySQL 5.5.16-log, latest version of ONA (11.02.10) downloaded from the site today.
Matt
27-07-2012 12:13:33
I think the issue are running into is the TYPE vs ENGINE syntax. There is a note on the install page (http://opennetadmin.com/docs/installation) that gives some instructions on how to fix that file and run the install. The new code is fixed for this but I dont yet have a tarball release. You can however get the latest code from the github.com/opennetadmin/ona repository which should work fine for you. I hope to release a new tarball soon.
justinrpurdy
31-07-2012 17:44:00
Beautiful, that fixed it. Don't know how I didn't see that. Thanks!