You are not logged in. Please login or register.
PunBB Forums → Posts by Ghirai
Pages 1
This showed up in postgresql log:
May 11 12:38:05 ghirai postgres[85424]: [2-1] ERROR: syntax error at or near "WHERE" at character 38
May 11 12:38:05 ghirai postgres[85424]: [2-2] STATEMENT: UPDATE xxx_tb_users SET last_visit= WHERE id=9
Any ideas?
Note that i haven't modified login.php.
Thanks.
Probably not a very large amount that would be interested in (or that you would want on) a computer security related board
Exactly.
As a sidenote, it seems to work if you refresh the blank page 
Eh couldn't care less about them.
You're right it doesn't seem to work on IE6, but does with 7. Don't plan on fixing it though.
The domain doesn't seem to resolve; besides, i doubt they would colo their server in a DC in London...
Pretty much default install, couple tweaks to the theme and index, smilies buttons when posting, UTF-8, and captcha when registering.
Alright, here we go.
I posted 'test\123':
STATEMENT: INSERT INTO node_tb_posts (poster, poster_id, poster_ip, message, hide_smilies, posted, topic_id) VALUES ('Ghirai',2, '<ip-removed>', 'test\\123', '0', 1209499955, 76)
This also happens on edits.
Any indeas? 
Thanks.
Thanks.
Keeping an eye on the logs...
Alright, i'll come back when i find new info
So far warning is triggered periodically, on vacuum it seems.
Smartys, any indeas?
Seems everything is working, but the warnings are annoying... 
Here's phpinfo(), if you think it helps figuring things out:
<removed>
EDIT: Also if you need any additional info let me know 
I have User Management mod (which i haven't used yet) and mod_easy_bbcode.
I did a couple minor modification (like showing thread title in a particular forum when viewing the index, etc), but none add any extra stuff to the db.
Any way i could check who the culprit is?
EDIT: I grep-ed for addslashes, only place i found it was in header.php, javascript "function process_form(the_form)", which doesn't seem to have anything to do with the db.
Seems to have something to do with PunBB using backslashes to escape stuff:
escape_string_warning (boolean)
When on, a warning is issued if a backslash (\) appears in an ordinary string literal ('...' syntax) and standard_conforming_strings is off. The default is on.
Applications that wish to use backslash as escape should be modified to use escape string syntax (E'...'), because the default behavior of ordinary strings will change in a future release for SQL compatibility. This variable can be enabled to help detect applications that will break.
From: http://postgresql.mirrors-r-us.net/docs … tible.html
So instead of \\ php should be using E to escape backslashes?
Hey,
I get periodical warnings in my PostgreSQL logfile:
postgres[98505]: [2-1] WARNING: nonstandard use of \\ in a string literal at character 137
postgres[98505]: [2-2] HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Running PunBB 1.2.17 and PostgreSQL 8.3.
Any ideas?
Yanks.
Ok more searching and i've fixed it.
Thanks to MattF for this post: http://punbb.org/forums/viewtopic.php?pid=99969#p99969
Hey,
After enabling debug mode, i get an error like this:
'ERROR: invalid byte sequence for encoding "UTF8": 0xa3 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".'
I found only 2 posts related to this error on this board, and couldn't find a workaround.
Don't really care about UTF, but it's annoying that users get errors when posting; is there a way to say silently convert UTF8 chars to null or something (ugly hack)?
True. I assume having this feature is more trouble than it's worth...
Long lines without any spaces don't display properly.
For example:
Themanutilityformatsanddisplaystheon-linemanualpages.ThisversionknowsabouttheMANPATHandPAGERenvironmenThemanutilityformatsanddisplaystheon-linemanualpages.ThisversionknowsabouttheMANPATHandPAGERenvironmentvariablessoyoucanhaveyourownsetofpersonalmanpagesandThisversionknowsabouttheMANPATHandPAGERenvironmentvariablessoyoucanhaveyourownsetofpersonalmanpagesandtvariablessoyoucanhaveyourownsetofpersonalmanpagesandThisversionknowsabouttheMANPATHandPAGERenvironmentvariablessoyoucanhaveyourownsetofpersonalmanpagesand
The line is not wrapped. This is annoying for example when posting long links (and links are disabled), esp. when forum width is smaller than default.
It's not really a bug, but a adding a feature that splits long lines so they fit would be cool.
Pages 1
PunBB Forums → Posts by Ghirai
Powered by PunBB, supported by Informer Technologies, Inc.