Adopts News

[Bloodrun]

Originally Posted by mapleblade

now its still bugged :( (but its better then earlier)

That is strange =/

Originally Posted by Saphira

I tried <br>, and <p>, and neither work. It turns

These

Are

Separate, into

These are separate, etc.

Alright, then ill have to make BBcode work for it.

[Saphira]

Hmm. I haven't tried this out since I changed the database field for detail to LONGTEXT. I'm trying to post news now, and I'm getting an error on add_news.php. I'm guessing that there's an error inserting it into the database.

PHP Code:

    $query = "INSERT INTO ".$prefix."news(topic, detail, name, nid, datetime) VALUES('".$topic."', '".$detail."', '".$name."', '".$Max_idd."', '".$datetime."')"; 


The line of code to insert it, and below, the database layout:

nid int(11)
topic varchar(255)
detail longtext
name varchar(65)
datetime varchar(25)

Does this all seem right to you?

[Bloodrun]

Originally Posted by Saphira

Hmm. I haven't tried this out since I changed the database field for detail to LONGTEXT. I'm trying to post news now, and I'm getting an error on add_news.php. I'm guessing that there's an error inserting it into the database.

PHP Code:

    $query = "INSERT INTO ".$prefix."news(topic, detail, name, nid, datetime) VALUES('".$topic."', '".$detail."', '".$name."', '".$Max_idd."', '".$datetime."')"; 


The line of code to insert it, and below, the database layout:

Does this all seem right to you?

Can you tell me the error please.

And find the '$result' nearest to the line where it says the error is, and place this right after it:

die('Invalid query: ' . mysql_error());

[Saphira]

Invalid query: 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 'm testing this using single quotes.', 'Jon', '31/05/09 02:32:12')' at line 1

I tried to post:

I'm testing this using single quotes.

Someone else posted last night after I went to bed, and they managed to post fine, so I'm guessing it has something to do with single quotes. (')

[Bloodrun]

Originally Posted by Saphira

I tried to post:

Someone else posted last night after I went to bed, and they managed to post fine, so I'm guessing it has something to do with single quotes. (')

That's really wierd because it works fine on my test site, and some one else site.

I believe I put stripspalshes in the code, make sure i stripsplashed the name of the poster, the title and the details.

[Saphira]

What part of the code are the stripslash parts in? I can double check just to make sure that they're there etc.

[Bloodrun]

Originally Posted by Saphira

What part of the code are the stripslash parts in? I can double check just to make sure that they're there etc.

They would be right after a query and the items it is calling.

It would look like this:

$something = stripsplash($something)

[Saphira]

Okay, I've looked through the files, and the only file I can find the stripslashes in is news.php. Wouldn't it need to be in add_news.php, being's that's the file that adds news to the database (which the script is having trouble doing?) I downloaded a fresh copy of the zip file, and it's the same in there. Only on news.php

[Bloodrun]

Originally Posted by Saphira

Okay, I've looked through the files, and the only file I can find the stripslashes in is news.php. Wouldn't it need to be in add_news.php, being's that's the file that adds news to the database (which the script is having trouble doing?) I downloaded a fresh copy of the zip file, and it's the same in there. Only on news.php

Oh, well I usually only put the stripsplash in the file that is calling the info, but I should probably do start doing it the other way.

Anyway, um, what was your problem again? Lol I cant remember.

EDIT:

This is really wierd, because the sites I installed this on, don't have that error at all, and they have tons of single quotes in their posts o.0

[Saphira]

Yeah it is weird. I just tried uploading a fresh add_news.php, to see if it would change anything, and nada. Still nothing. The problem was posting articles with single quotes in lol.