Forum Activity for @brian

brian
@brian
12/20/15 09:38:56AM
10,149 posts

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.
brian
@brian
12/20/15 09:36:02AM
10,149 posts

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.
brian
@brian
12/20/15 09:28:15AM
10,149 posts

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.
brian
@brian
12/20/15 09:06:10AM
10,149 posts

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.
brian
@brian
12/20/15 09:05:55AM
10,149 posts

Nginx install dbase error


Installation and Configuration

jimmyk:
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.

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).
brian
@brian
12/20/15 05:39:48AM
10,149 posts

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.
brian
@brian
12/20/15 05:38:02AM
10,149 posts

audio_conversions page not found. after using Import Audio tool


Using Jamroom

serveion:
hello

thank you, for the help,

I have this fixed for the next Audio Support module release - we'll get that out shortly.

Thanks!
brian
@brian
12/20/15 05:36:16AM
10,149 posts

tweak the Like/Dislike module


Using Jamroom

Strumelia:
Were you able to take a look at the non-working 'Like" links described above...for Forum Discussions in the Activity Feed, as discussed in the last few posts above? (and i'm guessing it would need fixing for both non-Beta JR and the new Beta). It sure would perfect the 'Like' experience for my members and me while we are still not on the Beta JR.

Yes - we've been working on this. It's a bit more complicated than it may seem on the surface since:

- a forum post may or may not be in a category
- the category name could be changed AFTER the like has happened
- the profile the forum is on could change their profile name AFTER the like

So the URL has to always be constructed from the latest data for the forum or profile (and not stored as a key in the datastore) - the trick is to make that retrieval as efficient as possible so we're not hammering the database whenever the timeline is listed.

Hopefully have that wrapped up soon.

Thanks!
brian
@brian
12/20/15 05:33:54AM
10,149 posts

jrAction_item_index


Jamroom Developers

Natedogg265:
When I make a custom jrAction_item_index.tpl I get a mysterious

<div class="col8 last">

This is not in my profile_item_index.tpl

It wouldn't be - it would be in your profile_header.tpl or profile_footer.tpl - typically a profile is setup so the "sidebar" is either in the header or footer (depending if you want it on the left or right), and the "opening" div for the profile body is in the header, and the closing div for the body is in the footer.
brian
@brian
12/20/15 05:31:50AM
10,149 posts

TypeError: $(...).qtip is not a function


Jamroom Developers

All references to qtip() in Jamroom are in the System Tips module (jrTips) - you can disable that module and you should NOT see this.

Search your code for calls to qtip().
  296