phpBB • Free and Open Source Forum Software

Noxwizard wrote:The generated queries are not unique to your board. They're just auto-prefixed with your table prefix and some adjustments done if you're using MySQL 4.0.x.

Production server is 5.0.x, dev is 5.5.x - perhaps a contributing factor?

Noxwizard wrote:Can you post the full list of queries it gave you? It looks like it didn't separate them with semicolons.

That's the same error I was talking about earlier where I thought it was missing the semi-colon. We were running the same script on the same DB, just on different servers.

They do; both use utf8_unicode_ci by default currently. Prior to the update, I'm sure they both used utf8_bin, but as above, I can't modify the collation of post_text. Edit: Actually, I just realised what phpMyAdmin was doing with that query when I tried to modify the field collation and possibly wh...

After sorting out the character sets (they're utf8/utf8_bin now, with the exception of the individually-set field collations), restoring the database to its previous state and re-running the script, I'm unfortunately faced with the exact same as above. The initial syntax error at: ALTER TABLE phpbb3...

I can't speak for the production server, but on my dev server, collation for post_text is utf8_bin, character set for the posts table is... right enough, appears to be latin1. I'll sort that out and give the script a try again. Cheers.

I noticed that for the above, in MySQL 5.x the following query: ALTER TABLE phpbb3_posts ADD FULLTEXT (post_subject), ADD FULLTEXT (post_text), ADD FULLTEXT post_content (post_subject, post_text) # Table: 'phpbb3_privmsgs' ALTER TABLE phpbb3_privmsgs MODIFY msg_id mediumint(8) UNSIGNED NOT NULL auto...

TC wrote:is there a comma missing after the ALTER_TABLE statement?

Apparently not. That mistaken line of questioning was my fault.

Well damn, I just noticed this tonight - along with cherokee red's gig in Bar Bloc - what rubbish timing! I was lamenting to Nils about this; I would've loved to have gone to both events (I've played in Bar Bloc myself in the past). This also has to be about the 3rd time I've missed meeting Ash! A l...

*Christian* wrote:

phpDummie wrote:England? No. I see no charm in snobbery..

How exactly does living in England make you a snob? I find your comment racist and uncalled for.

I find you to be excessively English, this is very offensive to me. Please curtail your Englishness.

Hah, why not. It's been a while since I've done one of these.
Edit: New monitor! So, new desktop too - now with widescreen goodness.

SneakySimian wrote:There's a reason I have a new name.

haha, gosh, I wonder what that could possibly be.

Wow it seems like people from the UK dont like where they live. Is it really that bad over there? England and Edinburgh suck. Beyond that, it's actually quite nice. I live in the far south of Glasgow, Scotland, and I really like it here. I'd stay permanently if not for the fact that my job takes me...

ps. Scotland isn't all that great. No matter what people say, I'd be against reccommending people to live here. Junkies and neds (chavs) are slowly taking over, housing is getting sorely expensive, the state of the roads are attrocious and don't even get me started on the people that are running ou...

Aww hell, put your socks back on!

Well that's just a positively fantastic reply. Is this then meant to be a game of 'guess the identity of the old adversary hiding behind a newly registered account'? Oh, I do love those. Clayton, old chap, do you fancy playing along too? That would be so grand!