blog documentation FAQ followers forum marketplace services youtube

solved Database errors

The Jamroom Network » Forum » Installation and Configuration » Page » Database errors
jamesmanley
@jamesmanley
7 years ago
62 posts
Ran integrity check again and now I have errors from the database. "Query Error: 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 '' at line 1" and a second error now appears," jrSoundCloud failed to get any response from soundcloud: http://api.soundcloud.com/tracks.json?client_id={ CLIENT ID CLIPPED FOR SECURITY }&q=Siqqthegritt22&offset=0&limit=100." No one can use soundcloud to import. I reinstalled it and still have the errors. Thank you guys....
updated by @jamesmanley: 05/28/17 08:49:15AM
michael
@michael
7 years ago
7,744 posts
Its saying it found nothing, change that 'Siqqthegritt22' to 'love' and a ton of data comes back.

--edit--
In your activity log after the SQL error message, is there a ?

If you click on that ? is there more info?
updated by @michael: 02/24/17 11:58:35AM
jamesmanley
@jamesmanley
7 years ago
62 posts
Yes. Do you want me to post it or pm a ticket. I can import using the search tool however, if I or a user goes to their track and try to add the url either from the address bar or via the share button, it does nothing when you hit the create button and the file is not added. The icon spins as if it was loading and then nothing. We had an artist successfully import using the search feature if it finds his music on soundcloud. The instance with one artist soundclound can't find his account and he can not import manually. Hope this helps. Thank you again Michael.
updated by @jamesmanley: 02/24/17 02:37:31PM
jamesmanley
@jamesmanley
7 years ago
62 posts
Update; I think we have figured out the Soundcloud issue however the database error continues and also for each new sign up.
michael
@michael
7 years ago
7,744 posts
sure, send me the details to a ticket if you like: support at jamroom dot net along with some login codes to your site.

And if possible steps to trigger the activity log entry, that way I can understand when its fixed.

Thanks.
jamesmanley
@jamesmanley
7 years ago
62 posts
Okay 👌🏿 will do
jamesmanley
@jamesmanley
7 years ago
62 posts
Unable to duplicate errors after reinstalling the core. Seems to be working fine now. Thanks for the support Michael. As always you're awesome.
michael
@michael
7 years ago
7,744 posts
Love it when things sort themselves out :) thanks @jamesmanley

Tags