Editing Artists Is Broke0r

by **Doomith** on Thu Sep 15, 2005 2:09 pm

yeah.. just that..It returns some error when you click submit

by **evan** on Fri Sep 16, 2005 3:32 am

C'mon man.

What error?!?!?!?

/exasperated

by **Doomith** on Fri Sep 16, 2005 10:53 am

General Error

Could not update artist

DEBUG MODE

SQL Error : 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 'mailto:Doomith@gmail.com">Doomith@gmail.com", artis

UPDATE dmc_artists SET artist_name="Experimental Malevolence", artist_members="Alex Bird;;;Alex Wolken", artist_profile="A two piece impromptu experimental instrumental band. What a mouthful huh? Basically, you tell us what genre(s) you want us to play and we do it! Both members have been playing 7+ years so the music made when combining the two is something to listen out for Can play sets from 5-60 mins and basically fill in for anyone, anytime, any style, anywhere For contact email Doomith@gmail.com", artist_genres="5;;;1", artist_modified_by=78, artist_active=1, artist_image="" WHERE artist_id=119

Line : 558
File : artist_services.php

by **evan** on Fri Sep 16, 2005 11:21 am

Righto. Try it without the email and smilies, would you?

I'm sorry, my ridiculous busyness means I won't be able to look at this in depth for another week or so.

by **Doomith** on Fri Sep 16, 2005 7:30 pm

Ill try it.

by **icouldcareless** on Mon Sep 26, 2005 5:37 pm

I get it toooo

Code: Select all: General Error Could not update artist DEBUG MODE SQL Error : 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 'http://www.takingthefall.cjb.net" target="_blank">http://www.ta UPDATE dmc_artists SET artist_name="Taking The Fall", artist_members="Tom Dysart (vocals);;;Ashley Evans (guitar);;;Scott McKnight (guitar);;;Richard Sinclair (bass);;;SEEKING DRUMMER", artist_profile="[shirt] happens - as some would say, but the forming of this band was more than any excremental coincidence. Forged by the love of good music (and bad humour), it was in the cold, wet, windy, horrible, did I say cold already? City of Dunedin that these five aspiring young artists set to work on their life's passion - music Weeping guitars, soaring melodies, crunching riffs, magnificently entwined to complete perfection and successfully concealing the numerous undulating subliminal messages, just kidding Watch out, this band is hot [shirt]! (Not literally). http://www.takingthefall.cjb.net (and yes, this was written in 3rd person by ourselves in an attempt to look better than we really are)", artist_genres="5;;;1", artist_modified_by=121, artist_active=1, artist_image="uploads/dmc_artist_imgs/127/TTF.jpg" WHERE artist_id=127 Line : 558 File : artist_services.php

helppp

by **evan** on Mon Sep 26, 2005 5:45 pm

righto. Just remove the web link for now and I will come up with a solution very soon. I guess the new server must do things different, like.

Cheers for the detailed report :-)

by **brendamnfine** on Sat Oct 21, 2006 11:04 am

When I try to edit my artist and save the changes, the loading/changing screen JUST KEEPS ON GOING...!!! Even for the simplest of changes.

Is there a problem? Or is it me and I should just wait a day or two while it loads?

by **evan** on Sat Oct 21, 2006 1:16 pm

You've pasted text in that contains "special" characters with Windows encoding would be my guess. The javascript cannot handle Windows encoding because it's nonstandard and weird. This might happen if you use Word, Wordpad, Outlook or any of those sorts of "programs" to prepare your profile - it was the case with other occurances of this bug that removing hyphens and quote marks fixed it - or replacing them with characters you type yourself.
An easy way to tell is if your quotes are curly. That'll crash it.

I've covered this bug elsewhere and as yet haven't found a solution, outside of getting people to stop using programs with proprietary character encoding.

by **evan** on Sat Oct 21, 2006 1:21 pm

I just had a look at your profile, and yes, there are several curly quotes. In particular, look out of single quotes that are slanty instead of straight.

You can recreate these, I think, by using normal character sets. On my machine,
option-] = ‘
option-shift-] = ’
option-] = “
option-shift-] = ”

On windows, Option corresponds to Alt.

by **brendamnfine** on Sat Oct 21, 2006 2:06 pm

but all I've been trying to do is remove a band member...I haven't added anything to the profile.

However I do want to change the bio and add some audio to the profile.

EDIT: Ok, I've since been able to change the Bio (and the apostrophes in it) but I am still having trouble uploading a song and removing a band member.

by **evan** on Sat Oct 21, 2006 3:10 pm

Cool, I've just fixed the thing with removing members. That was a genuine logic error. You should be able to run as expected now.

As for the audio, what happens there? Remember it takes forever to upload stuff. Try uploading something tiny. Works for me on your profile - although it draws horizontal lines everywhere. Mmmm, horizontal lines.

by **brendamnfine** on Sat Oct 21, 2006 3:55 pm

Ok, i've tried to upload a 5mb .mp3 and then a 500kb .wav, and both times it will think for a moment then redirect me to the main page with no evidence of having uploaded anything. Nothing on the profile page either.

I have tried clicking both 'save changes' and 'upload' without success.

by **evan** on Sat Oct 21, 2006 10:17 pm

Save changes won't do anything.
5mb will fail because it's too large. 4.5mb is the limit.
But whatr you're describing suggests that there's another admin-only redirect in place somewhere. I just ate a worm so I'm not really in the right state to fix it, but I'll check back ASAP.

by **evan** on Sat Oct 21, 2006 10:44 pm

Ok duder, worm or not, I'm always working for you. Because I care. Like Avis, or a hotel, I care.

Check it now, you should be pleasantly surprised. And my many appolllo-gees for the messing around.

Editing Artists Is Broke0r

Editing Artists Is Broke0r

Who is online