can't use quotes?

Sergeant Joined: Oct 16, 2003 Posts: 123

when i try to put a phrase in double quotes, like "like this" the board replaces the quotes with " & and ; " and if i use single quotes, it threw up a sql error. i have another phpbb2 board running seperately on the same system and it works fine.

any ideas?

EDIT: the & and ; was interpretted as a " when i posted this, sorry for the confusion.

Sergeant Joined: Oct 16, 2003 Posts: 123

here is the exact error i get:

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'dfasfg')' at line 1

INSERT INTO nuke_bbposts_text (post_id, post_subject, bbcode_uid, post_text) VALUES (169, '', 'eb80eb41f1', ''dfasfg')

Line : 319
File : yada\yada\includes\functions_post.php

i get that when i type in -- 'dfasfg

Posted: Fri Dec 12, 2003 3:10 pm

re-upload the qoute file phpbb file

Sergeant Joined: Oct 16, 2003 Posts: 123

what do you mean?

this is the phpbb built into nuke 6.9

Sergeant Joined: Oct 16, 2003 Posts: 123

when i post just a single quote it gives me the error just like above one.

Error in posting

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';quot;')' at line 1

INSERT INTO nuke_bbposts_text (post_id, post_subject, bbcode_uid, post_text) VALUES (179, '', 'df2065f549', ''"')

Line : 319
File : yada\yada\includes\functions_post.php

when i do 2 single quotes, it posts a blank post.

again, i have phpbb2.0.6 standalone on the same server. and it works fine there.

Sergeant Joined: Oct 16, 2003 Posts: 123

nobody has anything? no ideas? suggestions?

Nuke Soldier Joined: Jul 16, 2003 Posts: 14

Hi, i just got the same problem as you Sad

I cant figure out why, and tryed everything......until....
I wisited your site, and saw that you just upgraded coppermine.
I didnt upgrade it, but installed it for the first time a couple of dayes ago, with some other blocks and modules, and have had the qute problem ever since.
The only thing i can see wee have in comon, is the coppermine, that we both installed/upgraded at the same time.

Did you notice if your qute problem began AFTER upgrading cp ?

Sorry for the bad english, my rambeling, and no answer to your question, but im only trying to figure this out, as i am no programmer.

Thanks

Nuke Soldier Joined: Jul 16, 2003 Posts: 14

Oh i forgot.
At the exact same time, i got a problem with clicking on some, not ervey time, the "view last post" arrow.
It shows up with an error, that no topic is available ?
This is not happening at all threads with more pages, but only some..strange.

Again, it migt not have nothing to do with the other problem, and i did install several modules that day, but i just had to ask.

Thanks

Sergeant Joined: Oct 16, 2003 Posts: 123

you may be on to something. i had another error that happenned since coppermine, but i cant say i know for sure that it was working before coppermine or not.

i didnt upgrade coppermine, i started to, but ended up just losing starting from scratch.

Sergeant Joined: Oct 16, 2003 Posts: 123

http://coppermine.findhere.org/modules.php?name=Forums&file=viewtopic&t=106

posted over there, and got the same error! i think you are on to something.

Sergeant Joined: Oct 16, 2003 Posts: 123

anything?

Nuke Soldier Joined: Jul 16, 2003 Posts: 14

Seems that only you and me got this problem in the whole community, and i dont have a clue what to do about it.

If nothing appers here or on the other site you posted, i probably gonne delete all and start over ...without the coppermine gallery Embarassed

I also, besides the two other sideeffects, discovered a third sideeffect, but its not as common as the other two, but it happens now and then, and never has done this before.
My users is beginning to have problems, if they log into ther account, and go out again they get the 1064 sql error. That has never happened before, but now, with the other problems, i get contactet every day from a user who ran into this Crying or Very sad

Nuke Soldier Joined: Jul 16, 2003 Posts: 14

hmm, i have a little breakthrough, but not a whole solution.

To get rid of the quote situation, i removed the coppermine block from the left side, to the center.
Now when you go to your forum, the block is not activated, and the quote problem is gone. Right side, would probably also work.

If this solves my other problems i dont know yet.

This is offcource not the correct way to do it, and i dont have a solution, but when you and me are alone on this, and i dont know how to code, this is the second best i can come up with right now.

Nuke Soldier Joined: May 07, 2003 Posts: 24

In PHP when you want to use " " as a literal characters to quote something "like this" you have to put a \ character before it... Let me shoulw you an example.

Code:

echo = "\"Quote this\"";

See the difference? The \" will be interpreted as a quotation mark and of course without them PHP trys to parse what is between them.

Sergeant Joined: Oct 16, 2003 Posts: 123

but i have no idea where to apply that Dixen.

I will give that at try Butte. i posted the problem at www.techimo.com and one user said he has it working, but they are on seperate DBs. mine is in the same DB, is yours?