Discussion Forums  >  Grunts, Groans, Complaints

Replies: 5    Views: 133

Moto110
Aspiring developer
Profile
Posts: 205
Reg: Jul 26, 2011
Orlando, FL
8,700
01/16/13 01:09 PM (11 years ago)

Unable to make changes to a menu row with an apostrophe in the title

I'm using a Buzztouch.com hosted version 2.0 app and when I added a row with the title " What's on Tap " it let me add it no problem. However, when I go into the row properties and try to make any changes I get the error message shown below. Even if I remove the apostrophe I still get the error below. The only thing I can do is keep the default row settings or delete the screen and start over with a new name. Any suggestions on how to fix this? An error ocurred in running the fnExecuteNonQuery() method in utilityFunctions.php (6)
 
farcat
buzztouch Evangelist
Profile
Posts: 1008
Reg: Jan 27, 2012
France
13,230
like
01/16/13 01:18 PM (11 years ago)
Do you have any screen with an apostrophe in the nickname?
 
Paul Rogers
Android Fan
Profile
Posts: 2524
Reg: May 30, 2011
UK
35,740
like
01/16/13 01:40 PM (11 years ago)
Try putting a backslash \ before the apostrophe. Although, as it's on the BT Server I should imagine they would be handling magic quotes in the php.
 
Moto110
Aspiring developer
Profile
Posts: 205
Reg: Jul 26, 2011
Orlando, FL
8,700
like
01/16/13 02:17 PM (11 years ago)
@raveyd - That worked! I deleted the row and recreated it with the name: What\'s on Tap. It saved it without the \ but now I can edit the properties. Can you explain why that worked? This is just for my own knowledge, if you don't know why and just know that it WORKS that is ok too.
 
Paul Rogers
Android Fan
Profile
Posts: 2524
Reg: May 30, 2011
UK
35,740
like
01/16/13 03:04 PM (11 years ago)
lol! not really! All I know is that certain characters need to be escaped with a backslash in php (so it can write data correctly to mysql?). It should be handled serverside but for some reason yours isn't. My guess is that BT are working on something behind the scenes and it's a temporary problem. That's my poor and inaccurate explanation anyway!
 
Niraj
buzztouch Evangelist
Profile
Posts: 2943
Reg: Jul 11, 2012
Cerritos
37,930
like
01/17/13 04:51 AM (11 years ago)
To be on the super safe side, change it to "What is on tap" Even though the \ worked, I would not use it because that is a warning signal of "danger ahead". -- Niraj
 

Login + Screen Name Required to Post

pointerLogin to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.