| View previous topic :: View next topic |
| Author |
Message |
Deirdre
Czarina Emeritus
Joined: 10 Nov 2004
Posts: 13023
Location: Camp Cooper
|
 Posted: Thu Jan 15, 2009 7:51 am Post subject: The New Board Trouble |
 |
|
Here's what I wrote to Tod, my IT God:
| Quote: | I am still trying to bring my message board into the world of phpBB3 and the conversion of the old board is giving me the pip.
Regular punctuation and some latin-language characters like ń are turning into typographical soup. I've set everything under the sun to utf8 including the converter script. If I do the cutover the recommended way, the posts that have the clunked-up characters are truncated.
For instance, the phpBB2 board shows "Hey Gang— I will be moving this message board"
The phpBB3 board shows "Hey Gang—"
...and that's it.
I've got the framework to display correctly after using Cyberduck for an FTP client.
Here's the phpBB.com community board thread about this deal:
<http>
One thing I tried was setting the MySQL connection collation to utf8_general_ci AND the database collation to utf8_general_ci.
I still got wild characters for all the dashes, apostrophes, quotation marks, parentheses, etc. BUT the whole post was present. (I think that was the combination!! I'm trying to replicate the result to no present avail)
Is there a way in phpMyAdmin to run an SQL query to fix all that shit?
I am pretty much WTF about this. Not only that, but the new board runs slowly. I'll have to see if John Worthington has the install for the phpBB3 version he's using for Jack's board— it's older, but slick as a whistle. |
Here's the process I've been using:
Use phpMyAdmin online to back up the database of this board.
Run MAMP here on my laptop to create a database server.
Install phpBB2 and load in the database. (bigdump.php)
Install phpBB3 and convert the phpBB2 board.
This is where is breaks.
The new board framework is all UTF-8 for its character set, and I'm guessing that the character set issue is the trouble, but I cannot figure out what specifics to use, if I'm messing up the backup when I use the online phpMyAdmin. I'm trying to make sure everything is the same, including the charset value in the bigdump php script. But I'm still getting fracked up when it converts to BB3.
I must have tried 30 different permutations of database/script character encodings. (UTF8_bin, UTF8_unicode_ci, UTF_general_ci)
And I don't know what the "connection collation" is, so I don't know if I'm messing with stuff I shouldn't.
Can anyone here give me a hand?
_________________
DBCooperVO.com
IMDB
Last edited by Deirdre on Wed Feb 04, 2009 8:40 pm; edited 1 time in total |
|
| Back to top |
|
 |
COURVO
Even Taller Than He Seems On TV
Joined: 10 Feb 2006
Posts: 1569
Location: Vegas, Baby!
|
| Posted: Fri Jan 16, 2009 1:46 am Post subject: |
|
|
DB,
You are already so far over my head it's not even funny.
Lou Zucaro? Yoda? Anyone? This is DB....the board mistress for chrissakes!!!
CourVO
_________________
Dave Courvoisier - Las Vegas, NV
http://www.CourVO.com
CourVO@CourVO.com
Courvo's "Voice Acting in Vegas" Blog: http://www.CourVO.biz
on your phone at courvo.mobi
702.610.6288
"I'm not a news anchor, but I play one on TV." |
|
| Back to top |
|
|
Deirdre
Czarina Emeritus
Joined: 10 Nov 2004
Posts: 13023
Location: Camp Cooper
|
| Posted: Fri Jan 16, 2009 7:15 am Post subject: |
|
|
Lou has been in touch!
I'm hoping Tod or John W will have a moment to spare this weekend.
In the meantime we're safe and sound here.
_________________
DBCooperVO.com
IMDB |
|
| Back to top |
|
|
louzucaro
The Gates of Troy
Joined: 13 Jul 2006
Posts: 1915
Location: Chicago area
|
| Posted: Fri Jan 16, 2009 10:57 am Post subject: |
|
|
In touch, but not much help so far, I'm afraid 
_________________
Lou Zucaro
http://www.voicehero.com
"Well, yeah, there's my favorite leaf!" |
|
| Back to top |
|
|
Bailey
4 Large
Joined: 04 Jun 2005
Posts: 4336
Location: Lake San Marcos... north of Connie, northwest of the Best.
|
| Posted: Fri Jan 16, 2009 11:25 am Post subject: Re: The New Board Trouble |
|
|
| Deirdre wrote: | | Can anyone here give me a hand? |
Did that help?
_________________
"Bailey"
a.k.a. Jim Sutton
Retired... Every day is Saturday, except Sunday.
VO-BB Member #00044  .gif" alt="W00T" border="0" />
AOVA Graduate 02/2004 ;
"Be a Voice, not an Echo." |
|
| Back to top |
|
|
Deirdre
Czarina Emeritus
Joined: 10 Nov 2004
Posts: 13023
Location: Camp Cooper
|
|
| Back to top |
|
|
bobbinbeamo
M&M
Joined: 05 Mar 2007
Posts: 2468
Location: Wherever I happen to be
|
| Posted: Sat Jan 17, 2009 10:21 pm Post subject: |
|
|
You speaketh a foreign tongue. Way above my cognitive disposition. Hope it works out.
_________________
Bobbin Beam
www.bobbinbeam.com
blog.bobbinbeam.com |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
