UBBCentral

Truncated posts

Posted By: weerdboil

Truncated posts - 03/26/07 09:05 PM

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
Posted By: weerdboil

Re: Truncated posts - 03/26/07 09:06 PM

!"$%$%^%&^&*^&(*&(&*($%$%

yet, on this forum it works just fine.
Posted By: Rick

Re: Truncated posts - 03/26/07 09:27 PM

Hmm, are you using the default language encoding or have you modified that?
Posted By: weerdboil

Re: Truncated posts - 03/26/07 09:29 PM

Hi Rick.

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

Where do I check?
Posted By: David Dreezer

Re: Truncated posts - 03/26/07 10:38 PM

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.
Posted By: weerdboil

Re: Truncated posts - 03/28/07 09:25 AM

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
Posted By: Rick

Re: Truncated posts - 03/28/07 04:14 PM

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.
Posted By: weerdboil

Re: Truncated posts - 04/10/07 09:01 AM

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
Posted By: Rick

Re: Truncated posts - 04/10/07 03:22 PM

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.
Posted By: weerdboil

Re: Truncated posts - 04/25/07 01:00 PM

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
Posted By: weerdboil

Re: Truncated posts - 05/01/07 08:53 AM

hello.

really hoping you can help me again with this sign truncation?
Posted By: Rick

Re: Truncated posts - 05/02/07 12:19 AM

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.
Posted By: Gizmo

Re: Truncated posts - 05/02/07 12:59 AM

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

Posted By: Mark S

Re: Truncated posts - 05/08/07 12:20 PM

This may help ? Click me

As i can repeat it and fix it on these forums wink
Posted By: weerdboil

Re: Truncated posts - 05/18/07 12:47 PM

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


Posted By: Rick

Re: Truncated posts - 05/18/07 03:00 PM

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.
Posted By: weerdboil

Re: Truncated posts - 05/23/07 09:34 AM

Hello,

I haven't had a response from my email to you yet?
Posted By: Rick

Re: Truncated posts - 05/23/07 02:27 PM

Hmm, let me check my email again. Didn't notice anything sent on this.
Posted By: weerdboil

Re: Truncated posts - 05/24/07 12:22 PM

Hi?

I am emailing rick@groupee.com.
© 2017 UBB.threads PHP Forum Software Community