Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (Zarzal), 71 guests, and 216 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Landyphil
Landyphil
Germany
Posts: 29
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 17
isaac 10
SteveS 8
Morgan 5
Ruben 4
jorb 4
Zarzal 2
Latest Photos
Test
Testing to drag photos
Comfortable Cats
Test
BSA photos
Previous Thread
Next Thread
Print Thread
Truncated posts #181565
03/26/07 04:05 PM
03/26/07 04:05 PM
W
weerdboil  Offline OP
stranger
Joined: Mar 2007
Posts: 21
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

Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Truncated posts [Re: weerdboil] #181566
03/26/07 04:06 PM
03/26/07 04:06 PM
W
weerdboil  Offline OP
stranger
Joined: Mar 2007
Posts: 21
!"£$£%$£%^%&^&*^&(*&(&*($%£$%£

yet, on this forum it works just fine.

Re: Truncated posts [Re: weerdboil] #181570
03/26/07 04:27 PM
03/26/07 04:27 PM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Hmm, are you using the default language encoding or have you modified that?

Re: Truncated posts [Re: Rick] #181571
03/26/07 04:29 PM
03/26/07 04:29 PM
W
weerdboil  Offline OP
stranger
Joined: Mar 2007
Posts: 21
Hi Rick.

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

Where do I check?

Re: Truncated posts [Re: weerdboil] #181575
03/26/07 05:38 PM
03/26/07 05:38 PM
David Dreezer  Offline

Pooh-Bah
Joined: Jul 2006
Posts: 2,199
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]
Re: Truncated posts [Re: David Dreezer] #181654
03/28/07 04:25 AM
03/28/07 04:25 AM
W
weerdboil  Offline OP
stranger
Joined: Mar 2007
Posts: 21
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

Re: Truncated posts [Re: weerdboil] #181665
03/28/07 11:14 AM
03/28/07 11:14 AM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
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.

Re: Truncated posts [Re: Rick] #182371
04/10/07 04:01 AM
04/10/07 04:01 AM
W
weerdboil  Offline OP
stranger
Joined: Mar 2007
Posts: 21
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

Re: Truncated posts [Re: weerdboil] #182382
04/10/07 10:22 AM
04/10/07 10:22 AM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
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.

Re: Truncated posts [Re: Rick] #183238
04/25/07 08:00 AM
04/25/07 08:00 AM
W
weerdboil  Offline OP
stranger
Joined: Mar 2007
Posts: 21
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

Re: Truncated posts [Re: weerdboil] #183561
05/01/07 03:53 AM
05/01/07 03:53 AM
W
weerdboil  Offline OP
stranger
Joined: Mar 2007
Posts: 21
hello.

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

Re: Truncated posts [Re: weerdboil] #183641
05/01/07 07:19 PM
05/01/07 07:19 PM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
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.

Re: Truncated posts [Re: weerdboil] #183644
05/01/07 07:59 PM
05/01/07 07:59 PM
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 17,012
Portland, OR; USA
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.
Need to Upgrade?
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!
Re: Truncated posts [Re: Gizmo] #183975
05/08/07 07:20 AM
05/08/07 07:20 AM
Mark S  Offline
Joined: Jul 2006
Posts: 4,722
Liverpool : England : UK
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
Re: Truncated posts [Re: Mark S] #184422
05/18/07 07:47 AM
05/18/07 07:47 AM
W
weerdboil  Offline OP
stranger
Joined: Mar 2007
Posts: 21
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



Re: Truncated posts [Re: weerdboil] #184426
05/18/07 10:00 AM
05/18/07 10:00 AM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
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.

Re: Truncated posts [Re: Rick] #184608
05/23/07 04:34 AM
05/23/07 04:34 AM
W
weerdboil  Offline OP
stranger
Joined: Mar 2007
Posts: 21
Hello,

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

Re: Truncated posts [Re: weerdboil] #184611
05/23/07 09:27 AM
05/23/07 09:27 AM
R
Rick  Offline
Former Developer
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Hmm, let me check my email again. Didn't notice anything sent on this.

Re: Truncated posts [Re: Rick] #184663
05/24/07 07:22 AM
05/24/07 07:22 AM
W
weerdboil  Offline OP
stranger
Joined: Mar 2007
Posts: 21
Hi?

I am emailing rick@groupee.com.


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
header.php after update from 7.5.x to 7.6.x
by Zarzal. 12/12/18 05:29 AM
Does 7.6.2 support php 71?
by Baldeagle. 12/12/18 02:17 AM
Cannot contact support
by . 12/11/18 06:43 PM
errors importing a database
by andrewjs18. 12/11/18 03:51 AM
Private Message, Opt out of conversation
by jorb. 12/04/18 10:11 PM
Forum Statistics
Forums36
Topics35,176
Posts191,656
Members12,121
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2