Previous Thread
Next Thread
Print Thread
Hop To
#181565 03/26/2007 5:05 PM
Joined: Mar 2007
Posts: 19
W
stranger
stranger
W Offline
Joined: Mar 2007
Posts: 19
Hello again.

Can anyone help me with this question posted on my forum?
http://www.talkmorgan.co.uk/forums/ubbthreads.php?ubb=showflat&Number=3070#Post3070

Seems that it isn't possible to enter any special characters like $%^&* into posts.

I have tested it on the forum and have the same behaviour.


Thanks,
Dave

Joined: Mar 2007
Posts: 19
W
stranger
stranger
W Offline
Joined: Mar 2007
Posts: 19
!"£$£%$£%^%&^&*^&(*&(&*($%£$%£

yet, on this forum it works just fine.

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Hmm, are you using the default language encoding or have you modified that?

Rick #181571 03/26/2007 5:29 PM
Joined: Mar 2007
Posts: 19
W
stranger
stranger
W Offline
Joined: Mar 2007
Posts: 19
Hi Rick.

I haven't modified it intentionally if I have!!

Where do I check?

Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
Header says it's ISO-8859-1, Rick. No changes in his meta tags.

What version of PHP and MySQL are you running? Not sure I'm onto something but always good to know what's being worked on.


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]
Joined: Mar 2007
Posts: 19
W
stranger
stranger
W Offline
Joined: Mar 2007
Posts: 19
Hi there.

PHP 4.3 running on Windows IIS (I know this is bad). If not running the site from Apache could be the cause then I'll make the effort to configure Apache on this machine also.

MySql 5.

Thanks,
Dave

weerdboil #181665 03/28/2007 12:14 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Hmm, has the default coallition been changed in MySQL at all? If you have something like phpmyadmin installed it should say what it's set to.

What I'd try is to look directly at the database. Look at one of the posts in question in the database, ubbt_POSTS table. See if it's storing the whole post in the database. That way we can figure out if it's a display issue or a sql issue.

Rick #182371 04/10/2007 5:01 AM
Joined: Mar 2007
Posts: 19
W
stranger
stranger
W Offline
Joined: Mar 2007
Posts: 19
Hello,

I can confirm that the posts are being truncated prior to being inserted into the database.

I have mySql tools installed (query browser etc) - can I find the coallition out from this?

Thanks,
Dave

weerdboil #182382 04/10/2007 11:22 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Probably the easiest thing would be to open up a support ticket with ftp info along with admin info for your site. This looks like something I'll need to do some direct debugging on to figure out the problem.

Rick #183238 04/25/2007 9:00 AM
Joined: Mar 2007
Posts: 19
W
stranger
stranger
W Offline
Joined: Mar 2007
Posts: 19
Hi Rick.

I have changed the collation like you suggested in your email. This seems to be an improvement, but posting of the £ sign still causes problems. Check it out, very weird, the posts truncate straight after any £ sign in the text.

Cheers for all your help.

Thanks,
Dave

Joined: Mar 2007
Posts: 19
W
stranger
stranger
W Offline
Joined: Mar 2007
Posts: 19
hello.

really hoping you can help me again with this £ sign truncation?

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
I'm still not exactly sure what's causing this. It's definitely passing the full post to mysql for insert but for some reason mysql isn't taking everything. We might have to try inserting a new row into the database directly from something like phpmyadmin to see if it will take the entire contents that way, so we can figure out if it's a mysql thing or a php thing or something in the code.

It's not something I've been able to fix in the code as it's passing everything to php's mysql_query() function properly, so it's getting that far without any problems.

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I'm curious what the html varient of £ is; perhaps it's hardcoding it as £ vs its html varient will let it pass to mysql? I'm thinking it's perhaps an extended chatacterset issue in MySQL that's dying after £...



I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #183975 05/08/2007 8:20 AM
Joined: Jul 2006
Posts: 4,057
Joined: Jul 2006
Posts: 4,057
This may help ? Click me

As i can repeat it and fix it on these forums wink


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Mark S #184422 05/18/2007 8:47 AM
Joined: Mar 2007
Posts: 19
W
stranger
stranger
W Offline
Joined: Mar 2007
Posts: 19
hello.

the data is definitely in the database.
it is being stripped on the way out.

i really hope someone can help with this as I am getting complaints on my forum - http://www.talkmorgan.co.uk/forums/ubbthreads.php?ubb=showflat&Number=4624#Post4624

The £ and '' are obviously quite key characters!!!!

Thanks,
Dave



weerdboil #184426 05/18/2007 11:00 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Hi Dave,

Can you open an actual support ticket on this? Last I had checked on yours the data wasn't going into the database, it was being stripped and only a portion of it was being stored.

Rick #184608 05/23/2007 5:34 AM
Joined: Mar 2007
Posts: 19
W
stranger
stranger
W Offline
Joined: Mar 2007
Posts: 19
Hello,

I haven't had a response from my email to you yet?

weerdboil #184611 05/23/2007 10:27 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Hmm, let me check my email again. Didn't notice anything sent on this.

Rick #184663 05/24/2007 8:22 AM
Joined: Mar 2007
Posts: 19
W
stranger
stranger
W Offline
Joined: Mar 2007
Posts: 19
Hi?

I am emailing rick@groupee.com.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Havenofsobriety), 522 guests, and 99 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)