Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (Gizmo, isaac, M4TT), 54 guests, and 389 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Gizmo
Gizmo
Portland, OR; USA
Posts: 16,788
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 14
M4TT 12
Ruben 8
FREAK 4
mmkk 4
isaac 3
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
Truncated posts #181565
03/26/07 04:05 PM
03/26/07 04:05 PM
Joined: Mar 2007
Posts: 21
W
weerdboil Offline OP
stranger
weerdboil  Offline OP
stranger
W
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
Joined: Mar 2007
Posts: 21
W
weerdboil Offline OP
stranger
weerdboil  Offline OP
stranger
W
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
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
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
Joined: Mar 2007
Posts: 21
W
weerdboil Offline OP
stranger
weerdboil  Offline OP
stranger
W
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
Joined: Jul 2006
Posts: 2,199
David Dreezer Offline

Pooh-Bah
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
Joined: Mar 2007
Posts: 21
W
weerdboil Offline OP
stranger
weerdboil  Offline OP
stranger
W
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
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
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
Joined: Mar 2007
Posts: 21
W
weerdboil Offline OP
stranger
weerdboil  Offline OP
stranger
W
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
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
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
Joined: Mar 2007
Posts: 21
W
weerdboil Offline OP
stranger
weerdboil  Offline OP
stranger
W
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
Joined: Mar 2007
Posts: 21
W
weerdboil Offline OP
stranger
weerdboil  Offline OP
stranger
W
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
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
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
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
Gizmo Online tapedshut
UBB.threads Developer
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 16,788
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.
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
Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
Mark S Offline
Mark S  Offline

Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
This may help ? Click me

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


Version v7.5.8
People who inspire me Gizmo ID242 SD
Its been a long road. . . .to be waiting
Re: Truncated posts [Re: Mark S] #184422
05/18/07 07:47 AM
05/18/07 07:47 AM
Joined: Mar 2007
Posts: 21
W
weerdboil Offline OP
stranger
weerdboil  Offline OP
stranger
W
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
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
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
Joined: Mar 2007
Posts: 21
W
weerdboil Offline OP
stranger
weerdboil  Offline OP
stranger
W
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
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
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
Joined: Mar 2007
Posts: 21
W
weerdboil Offline OP
stranger
weerdboil  Offline OP
stranger
W
Joined: Mar 2007
Posts: 21
Hi?

I am emailing rick@groupee.com.


Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar [Not a Bug]
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,544
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)