Nginx install dbase error
Installation and Configuration
It doesn't make sense then that it's not working from the installer - that's the query it creates.
Forum Activity for @brian
Installation and Configuration
It doesn't make sense then that it's not working from the installer - that's the query it creates.
Nginx install dbase error
Installation and Configuration
Try installing Jamroom using the root credentials and see if it works - if it does, we know it is a grant issue with the JR user.
Nginx install dbase error
Installation and Configuration
jimmyk:Sorry, I updated my last post with what I use to grant the permissions in mysql server.
When you created the table above from the MariaDB CLI - did you do that as the root user?
Nginx install dbase error
Installation and Configuration
jimmyk:So, we know for sure that the system is able to create InnoDB tables. That leads me to the conf file for JR. But why would my vhost conf file - being that it's super simple routing everything through the router.php file, allow the creating of MyISAM tables and not InnoDB tables?
It wouldn't - it's not going to be related to the web server config - it's going to be related to the permissions for the DB user in MariaDB.
Nginx install dbase error
Installation and Configuration
You should have no issues installing JR then - that is an exact query for creating one of the DS item_key tables in JR. If it works from the command line, I see no reason why it wouldn't work from the web. I'm not sure if you can limit engine type to specific accounts, but check your MariaDB user's credentials and make sure the DB user you are using for JR has access to use InnoDB.
Nginx install dbase error
Installation and Configuration
Not sure what to suggest - clearly the InnoDB tables are not being created. I don't see any issues in your error log, but something is not right. I have MariaDB 10.1 running here and don't see this issue, so unfortunately I am not sure what to suggest.
Try running this query from the MySQL command line client:
CREATE TABLE `jr_jruser_item_key` (
`_item_id` int(11) unsigned NOT NULL DEFAULT '0',
`key` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`index` smallint(5) unsigned NOT NULL DEFAULT '0',
`value` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`key`,`_item_id`,`index`),
KEY `_item_id` (`_item_id`),
KEY `index` (`index`),
KEY `value` (`value`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;and see if it works or gives you an error.
Featuring more than one quota
Design and Skin Customization
Eddy:By entering these quotas on "Artist Quota ID: 1,7,8,9,10,12", will all members of those quotas be featured?
Yes.
Nginx install dbase error
Installation and Configuration
jimmyk:
InnoDB engine is enable and is actually the default engine. You can see in the my.cnf above that the engine is enabled.
I tested with the InnoDB engine enabled and disabled. No luck.
brian:My guess here based on the tables showing is that you do NOT have the InnoDB engine enabled - make sure InnoDB is an enabled engine in MariaDB.
Let me know if that helps.
Let me know if that helps.
InnoDB engine is enable and is actually the default engine. You can see in the my.cnf above that the engine is enabled.
I tested with the InnoDB engine enabled and disabled. No luck.
I use MariaDB here and don't have issues, but something is not working right on your install - the tables being created are just the MyISAM ones - the InnoDB ones are NOT being created, so regardless of your config something is not setup right.
Check your MariaDB error log (I think it is at /var/log/mysql/error.log).
No SoundCloud Tracks found
Using Jamroom
dim:Wow! Do I understand correctly, they blocked the IP of my server? It`s strange! We did not use SoundCloud too often. And I did not get information from them about blocking.
I would double check that the API key is correct - if it is, then you've definitely hit some sort of rate limit and you've been blocked - SoundCloud support would have to help you out.
audio_conversions page not found. after using Import Audio tool
Using Jamroom
serveion:hello
thank you, for the help,
thank you, for the help,
I have this fixed for the next Audio Support module release - we'll get that out shortly.
Thanks!
