Full Version: Badger Problems
To all you tech people: The forum seems to be a little buggy recently: I've had a couple of post disappear and reappear later and it seems if you type
(the pound sign) the rest of the post doesn't appear.
ooh that's interesting let's try that. this will cost you
by george you are right. my server must be anti-capitalist. up the commies.
I'll get it sorted out.
I'll get it sorted out.
Dan, if it helps in any way, the post is actually truncated in the database as well as soon as the £ character is seen.
It also happens if I try and use the SQL toolbox to insert the record manually.
I think it must to do with the POST'd data and how the server / script handles it, the £ character must mean something odd it's not the usual culprit to this sort of thing, e.g. & or @ or =
Edit:
From the Debug info that the forum gives the £ symbol doesn't get ascii encoded like most of the other stuff. (like single quotes, double quotes, etc...)
Again I don't know whether this is a server issue / script issue / php version issue / encoding type issue or what.
It also happens if I try and use the SQL toolbox to insert the record manually.
I think it must to do with the POST'd data and how the server / script handles it, the £ character must mean something odd it's not the usual culprit to this sort of thing, e.g. & or @ or =
Edit:
From the Debug info that the forum gives the £ symbol doesn't get ascii encoded like most of the other stuff. (like single quotes, double quotes, etc...)
Again I don't know whether this is a server issue / script issue / php version issue / encoding type issue or what.
I love it when you talk dirty
QUOTE
Again I don't know whether this is a server issue / script issue / php version issue / encoding type issue or what.
Its got me stumped and all
I also seem to have some extra debug information at the bottom of the page; I'm sure it's all very interesting but I don't know what
means.
QUOTE
FORM and GET Input
showtopic = 309
pid = 4361
st = 0
request_method = get
_low_act =
act = st
t = 309
f = 9
IP_ADDRESS = 141.197.10.191
last_activity = 1177932245
last_visit = 1177872408
skinid = 0
selectedpids =
selectedpidcount = 0
SKIN & TASK Info
_css = html { overflow-x: auto; } body { background: #6B91B8; color: #000; font-family: Verdana, Tahoma, Arial, Trebuchet ...
_wrapper = <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"...
_macro = a:90:{s:7:"a_apoll";a:6:{s:8:"macro_id";s:3:"284";s:11:"macro_value";s:7:"A_APOLL";s:13:"macro_replace";s:79:"<img src='...
_skincacheid = 10
_csscacheid = 10
_imagedir = sparazero
_emodir = default
_setid = 10
_setname = Badgerfest Remix
_usecsscache = 0
Next task = Today, 12:23 PM
Time now = Today, 11:27 AM
Timestamp Now = 1177932431
Loaded PHP Templates
skin_global, skin_topic
showtopic = 309
pid = 4361
st = 0
request_method = get
_low_act =
act = st
t = 309
f = 9
IP_ADDRESS = 141.197.10.191
last_activity = 1177932245
last_visit = 1177872408
skinid = 0
selectedpids =
selectedpidcount = 0
SKIN & TASK Info
_css = html { overflow-x: auto; } body { background: #6B91B8; color: #000; font-family: Verdana, Tahoma, Arial, Trebuchet ...
_wrapper = <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"...
_macro = a:90:{s:7:"a_apoll";a:6:{s:8:"macro_id";s:3:"284";s:11:"macro_value";s:7:"A_APOLL";s:13:"macro_replace";s:79:"<img src='...
_skincacheid = 10
_csscacheid = 10
_imagedir = sparazero
_emodir = default
_setid = 10
_setname = Badgerfest Remix
_usecsscache = 0
Next task = Today, 12:23 PM
Time now = Today, 11:27 AM
Timestamp Now = 1177932431
Loaded PHP Templates
skin_global, skin_topic
means.
QUOTE(King @ 30-Apr-07, 12:28)
I also seem to have some extra debug information at the bottom of the page; I'm sure it's all very interesting but I don't know what
means.
QUOTE
FORM and GET Input
showtopic = 309
pid = 4361
st = 0
request_method = get
_low_act =
act = st
t = 309
f = 9
IP_ADDRESS = 141.197.10.191
last_activity = 1177932245
last_visit = 1177872408
skinid = 0
selectedpids =
selectedpidcount = 0
SKIN & TASK Info
_css = html { overflow-x: auto; } body { background: #6B91B8; color: #000; font-family: Verdana, Tahoma, Arial, Trebuchet ...
_wrapper = <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"...
_macro = a:90:{s:7:"a_apoll";a:6:{s:8:"macro_id";s:3:"284";s:11:"macro_value";s:7:"A_APOLL";s:13:"macro_replace";s:79:"<img src='...
_skincacheid = 10
_csscacheid = 10
_imagedir = sparazero
_emodir = default
_setid = 10
_setname = Badgerfest Remix
_usecsscache = 0
Next task = Today, 12:23 PM
Time now = Today, 11:27 AM
Timestamp Now = 1177932431
Loaded PHP Templates
skin_global, skin_topic
showtopic = 309
pid = 4361
st = 0
request_method = get
_low_act =
act = st
t = 309
f = 9
IP_ADDRESS = 141.197.10.191
last_activity = 1177932245
last_visit = 1177872408
skinid = 0
selectedpids =
selectedpidcount = 0
SKIN & TASK Info
_css = html { overflow-x: auto; } body { background: #6B91B8; color: #000; font-family: Verdana, Tahoma, Arial, Trebuchet ...
_wrapper = <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"...
_macro = a:90:{s:7:"a_apoll";a:6:{s:8:"macro_id";s:3:"284";s:11:"macro_value";s:7:"A_APOLL";s:13:"macro_replace";s:79:"<img src='...
_skincacheid = 10
_csscacheid = 10
_imagedir = sparazero
_emodir = default
_setid = 10
_setname = Badgerfest Remix
_usecsscache = 0
Next task = Today, 12:23 PM
Time now = Today, 11:27 AM
Timestamp Now = 1177932431
Loaded PHP Templates
skin_global, skin_topic
means.
King, this is just the kind of top quality content that Facebook cannot hope to offer.
eat my pound sign:
how about my URL encoded pound sign: £
well that came out as: &pound; in the db
well that came out as: &pound; in the db
spanish:
Copy of desi
Copy of desi
QUOTE
eat my pound sign:
QUOTE
how about my URL encoded pound sign: £
well that came out as: &pound; in the db
well that came out as: &pound; in the db
QUOTE
spanish:
Copy of desi
Copy of desi
Eh?
It's deep. very very deep....
I'll leave it for you to ponder more.
I'll leave it for you to ponder more.
Right I believe it is an encoding issue.
It looks like this database wants all funny symbols to be utf8_encode($var) before being inserted into the DB and then utf8_decode($var) after being extracted.
I have no idea why it doesn't just do this by default as both php and mysql have utf8 as the default.
Does the board script have a setting you can change to use utf8? I'll go have a gander myself but if anyone knows, pipe up.
It looks like this database wants all funny symbols to be utf8_encode($var) before being inserted into the DB and then utf8_decode($var) after being extracted.
I have no idea why it doesn't just do this by default as both php and mysql have utf8 as the default.
Does the board script have a setting you can change to use utf8? I'll go have a gander myself but if anyone knows, pipe up.
33
adsf
adsf
asdf
asdf
sadf
333
333
333
333
333£££
well, using the powers pooed upon me by god, I delcare a new currency. The pound is no longer. Introducing the all new uberpound denoted by the symbol:
£
One uberpound will be equivalent to infinity old pounds.
On a completely irrelated note, we have decided to introduce a fee of one uberpound per use of the word "feck". To be donated to me and pete, split evenly, for good causes and kebabs.
£
One uberpound will be equivalent to infinity old pounds.
On a completely irrelated note, we have decided to introduce a fee of one uberpound per use of the word "feck". To be donated to me and pete, split evenly, for good causes and kebabs.
Seriously, what the fecj is going on?
It appears that Dannyboy has lost his mind.
Also 'irrelated'? Is that really a word? (And before you ask I realise I've used the word 'fecj' in this post and that it's also not a word, but even so...)
It appears that Dannyboy has lost his mind.
Also 'irrelated'? Is that really a word? (And before you ask I realise I've used the word 'fecj' in this post and that it's also not a word, but even so...)
On another note I can't seem to upload photos. I get the following error:
Consider yourselves informed.
QUOTE
THE FOLLOWING ERROR(S) WERE FOUND
The requested file upload failed because suitable permissions have not been enabled on the 'uploads' directory. Please contact the board administrator and inform them of this error.
The requested file upload failed because suitable permissions have not been enabled on the 'uploads' directory. Please contact the board administrator and inform them of this error.
Consider yourselves informed.
possibly permissions on one of the loadbalanced servers. been at wimbledon all day and am too knackered now but will have a look at this when i'm more awake.
Your boss allowed you time off for Wimbledon? On a Sunday? Will wonders never cease? (Probably the best day of the tourney - even had a British winner.)
Tourney? Get a grip
Verilly I say; whan that Aprile whast shawn its loosty squier, a grate tourney of tennous we were shewn.
What?
I don't even know why I said it; I don't really like tennis. Consider me chastened.
What?
I don't even know why I said it; I don't really like tennis. Consider me chastened.
she thonketh hym upon hir knees
Test £
In case anyone else didn't understand pete's post, that was his way of saying that he has fixed Badgerfest's problems.
It took him approximately 2 minutes, once I had let him out of his cage (or rather into my server's cage).
Bravo indeed.
It took him approximately 2 minutes, once I had let him out of his cage (or rather into my server's cage).
Bravo indeed.
Spoketh too soon. Tried to send a PM to Herr Woz about my XDA lead and got:
mySQL query error: SELECT m.mgroup_others, m.id, m.name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM ibf_members m, ibf_groups g
LEFT JOIN ibf_member_extra me ON (m.id=me.id)
WHERE LOWER(m.name) IN ('thewoz')
AND m.mgroup=g.g_id
mySQL error: Unknown column 'm.id' in 'on clause'
mySQL error code:
Date: Monday 23rd 2007f July 2007 09:24:07 AM
mySQL query error: SELECT m.mgroup_others, m.id, m.name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM ibf_members m, ibf_groups g
LEFT JOIN ibf_member_extra me ON (m.id=me.id)
WHERE LOWER(m.name) IN ('thewoz')
AND m.mgroup=g.g_id
mySQL error: Unknown column 'm.id' in 'on clause'
mySQL error code:
Date: Monday 23rd 2007f July 2007 09:24:07 AM
yeah i cant reply back to him either
http://www.pocketcm.com/
for that contact manager thing
is it the miniUSB cable that i nicked off you? in which case i'll send up a new one
http://www.pocketcm.com/
for that contact manager thing
is it the miniUSB cable that i nicked off you? in which case i'll send up a new one
QUOTE(DanSon @ 23-Jul-07, 8:21)
In case anyone else didn't understand pete's post, that was his way of saying that he has fixed Badgerfest's problems.
It took him approximately 2 minutes, once I had let him out of his cage (or rather into my server's cage).
Bravo indeed.
It took him approximately 2 minutes, once I had let him out of his cage (or rather into my server's cage).
Bravo indeed.
Give him a peanut.
QUOTE(DanSon @ 23-Jul-07, 8:30)
Spoketh too soon. Tried to send a PM to Herr Woz about my XDA lead and got:
mySQL query error: SELECT m.mgroup_others, m.id, m.name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM ibf_members m, ibf_groups g
LEFT JOIN ibf_member_extra me ON (m.id=me.id)
WHERE LOWER(m.name) IN ('thewoz')
AND m.mgroup=g.g_id
mySQL error: Unknown column 'm.id' in 'on clause'
mySQL error code:
Date: Monday 23rd 2007f July 2007 09:24:07 AM
mySQL query error: SELECT m.mgroup_others, m.id, m.name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM ibf_members m, ibf_groups g
LEFT JOIN ibf_member_extra me ON (m.id=me.id)
WHERE LOWER(m.name) IN ('thewoz')
AND m.mgroup=g.g_id
mySQL error: Unknown column 'm.id' in 'on clause'
mySQL error code:
Date: Monday 23rd 2007f July 2007 09:24:07 AM
I was merely saying that, only the other day.
£££ la la la £££ la la la
QUOTE
ããã la la la ããã la la la
Piece of shit!
££££££££££££££
Bugger
Bugger
££££££££££££££££
QUOTE(Pete @ 23-Jul-07, 23:23)
££££££££££££££££
Only seems to work when posts are edited.
QUOTE(DanSon @ 23-Jul-07, 9:30)
Spoketh too soon. Tried to send a PM to Herr Woz about my XDA lead and got:
mySQL query error: SELECT m.mgroup_others, m.id, m.name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM ibf_members m, ibf_groups g
LEFT JOIN ibf_member_extra me ON (m.id=me.id)
WHERE LOWER(m.name) IN ('thewoz')
AND m.mgroup=g.g_id
mySQL error: Unknown column 'm.id' in 'on clause'
mySQL error code:
Date: Monday 23rd 2007f July 2007 09:24:07 AM
mySQL query error: SELECT m.mgroup_others, m.id, m.name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM ibf_members m, ibf_groups g
LEFT JOIN ibf_member_extra me ON (m.id=me.id)
WHERE LOWER(m.name) IN ('thewoz')
AND m.mgroup=g.g_id
mySQL error: Unknown column 'm.id' in 'on clause'
mySQL error code:
Date: Monday 23rd 2007f July 2007 09:24:07 AM
Similar to the problem I fixed in February. This post has the details.
Dan, open ssh on the firewall for tg6 and I'll fix it.
Long term: We should look around for a new forum script. Invision Board v2.0 is getting too old.
http://www.simplemachines.org/ looks interesting.
i second that
smf looks cool.
pete hit me up with your ip address. i deleted it.
Dan
pete hit me up with your ip address. i deleted it.
Dan
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.