php/mysql blog help...someone PLEASE! - GoFuckYourself.com

Jace · 08-08-2005, 09:49 AM

i am having a bit of trouble with b2evolution and one of it's skins

i have my blog set up so that the posts are called up by ID and not url title...but the rss still calls the posts by the url title for some reason

so, the search engines spider the pages from that rss feed, and the url looks like this http://www.jonstern.net/index.php?ti...&c=1&tb=1&pb=1

but if you noticed when you click that link, there is some mysql errors going on...but I can not figure out for the life of me what would be doing this...someone mentioned that it might be my server not knowing to allow real names or some shit like that, but my tech guy swears that everything is set up right, and I believe him

how do I set the rss so that is shows the urls like this
http://www.jonstern.net/index.php?p=...&c=1&tb=1&pb=1

istead of this
http://www.jonstern.net/index.php?ti...&c=1&tb=1&pb=1

anyone have any ideas?

Jace · 08-08-2005, 09:51 AM

and, and fyi...when I change the skin on the blog, the http://www.jonstern.net/index.php?ti...&c=1&tb=1&pb=1 url works fine...?

Jace · 08-08-2005, 10:47 AM

no one?
...

Satisfaction · 08-08-2005, 10:56 AM

a bump for you dude

Doc911 · 08-08-2005, 11:06 AM

edit your skin to mimik the right format

Jace · 08-08-2005, 11:09 AM

Quote:

Originally Posted by Doc911

edit your skin to mimik the right format

i have searched and searched and could not find anywhere in the skin to do this...or what to do really?

rickholio · 08-08-2005, 12:15 PM

I'd say it looks like you've specified a password for your SQL root account, and haven't added the password into your blog config.

Jace · 08-08-2005, 03:10 PM

Quote:

Originally Posted by rickholio

I'd say it looks like you've specified a password for your SQL root account, and haven't added the password into your blog config.

then how is every other thing in the blog working....and the feature that isn't working for this skin, is working for every other skin?

Jace · 08-08-2005, 06:12 PM

maybe someone on the night shift can help me

Serge Litehead · 08-08-2005, 06:30 PM

other than that 1 link with title in it everything else on your blog works fine, are you sure there is a prob?

Serge Litehead · 08-08-2005, 06:34 PM

my wild guess is that your blog is in new format now using cat ids to pull stuff from mysql. the link you posted here with title is the old format and no longer valid. i didnt find any links with titles on the site. everything is pulled they way you desribed you wanted.

Jace · 08-08-2005, 08:22 PM

Quote:

Originally Posted by holograph

my wild guess is that your blog is in new format now using cat ids to pull stuff from mysql. the link you posted here with title is the old format and no longer valid. i didnt find any links with titles on the site. everything is pulled they way you desribed you wanted.

what is happening is this...click the RSS feeds on the bottom right side

here is a direct link:
http://www.jonstern.net/xmlsrv/rss2.php?blog=2

look at the way the urls are in there...they are like this:
<item>
<title>Jill Kelly Productions Files for Bankruptcy</title>
<link>http://www.jonstern.net/index.php?title=jill_kelly_productions_files_for_b ankrup&more=1&c=1&tb=1&pb=1</link>

google and yahoo are picking the rss feed up and indexing those urls...and for some reason those urls aren't working

so, now two problems, i am getting shitloads of google and yahoo traffic that are being sent a page that looks like this:
http://www.jonstern.net/index.php?ti...&c=1&tb=1&pb=1

and the rss feed is feeding those error pages into the indexes

Jace · 08-08-2005, 08:30 PM

Quote:

Originally Posted by holograph

my wild guess is that your blog is in new format now using cat ids to pull stuff from mysql. the link you posted here with title is the old format and no longer valid. i didnt find any links with titles on the site. everything is pulled they way you desribed you wanted.

i also reverted back to the old format and tried clicking the urls, they never existed and never are accessible, i constantly get that mysql error

Clarion · 08-08-2005, 11:17 PM

I'm not familiar with the script but the problem is you are not using a username/password for MySQL in your script. check your config.php or config.inc.php file for the setting, or your administration panel. Let me know if you want me to take a quick look at it -- hit me up on ICQ

Jace · 08-08-2005, 11:36 PM

Quote:

Originally Posted by Clarion

I'm not familiar with the script but the problem is you are not using a username/password for MySQL in your script. check your config.php or config.inc.php file for the setting, or your administration panel. Let me know if you want me to take a quick look at it -- hit me up on ICQ

seriously, all the config files are fine, otherwise nothing in the site woudl work, cause it is using the same config for the entire site...check it out www.jonstern.net everything is in the mysql database running off the one single config.php file

Jace · 08-08-2005, 11:38 PM

and oh yeah, check this out

the site and urls all work FINE when not in this one skin...but when I have it set up as this one certain skin, it gives that error when_using_this_type_url

if I use BLAHBLAH skin, this_type_of_url_works_fine

if I use Helsinki skin (loaded now), that type of url gives the mysql error

am I getting anywhere here?

georgeyw · 08-08-2005, 11:40 PM

as others have said - looks like mysql pass/user error. Although you've mentioned everything is fine. Are you sure it's not trying to access a different file for the db connection info?

Jace · 08-08-2005, 11:42 PM

Quote:

Originally Posted by georgeyw

as others have said - looks like mysql pass/user error. Although you've mentioned everything is fine. Are you sure it's not trying to access a different file for the db connection info?

nah, i went in and checked each file and each line....everything is exactly the same on this skin as the others, and they all call the exact same config file

georgeyw · 08-08-2005, 11:59 PM

Quote:

Originally Posted by JaceXXX

nah, i went in and checked each file and each line....everything is exactly the same on this skin as the others, and they all call the exact same config file

bump for ya

Serge Litehead · 08-09-2005, 12:25 AM

where from does rss get its urls?

08-08-2005, 09:49 AM	#1
Jace FBOP Class Of 2013 Industry Role: Join Date: Jan 2004 Location: bumfuck, ky Posts: 35,562	php/mysql blog help...someone PLEASE! i am having a bit of trouble with b2evolution and one of it's skins i have my blog set up so that the posts are called up by ID and not url title...but the rss still calls the posts by the url title for some reason so, the search engines spider the pages from that rss feed, and the url looks like this http://www.jonstern.net/index.php?ti...&c=1&tb=1&pb=1 but if you noticed when you click that link, there is some mysql errors going on...but I can not figure out for the life of me what would be doing this...someone mentioned that it might be my server not knowing to allow real names or some shit like that, but my tech guy swears that everything is set up right, and I believe him how do I set the rss so that is shows the urls like this http://www.jonstern.net/index.php?p=...&c=1&tb=1&pb=1 istead of this http://www.jonstern.net/index.php?ti...&c=1&tb=1&pb=1 anyone have any ideas?

08-08-2005, 11:06 AM	#5
Doc911 Confirmed User Join Date: Feb 2004 Location: If i was up your ass you'd know Posts: 3,695	edit your skin to mimik the right format __________________ For PHP/MySQL scripts ICQ 161480555 or email [email protected]

08-08-2005, 12:15 PM	#7
rickholio Confirmed User Industry Role: Join Date: Jan 2004 Location: Nor'easterland Posts: 1,914	I'd say it looks like you've specified a password for your SQL root account, and haven't added the password into your blog config. __________________ ~

08-08-2005, 06:30 PM	#10
Serge Litehead Confirmed User Industry Role: Join Date: Dec 2002 Location: Behind the scenes Posts: 5,190	other than that 1 link with title in it everything else on your blog works fine, are you sure there is a prob? __________________ SilverCrocodile.com Adult web design since '05

08-08-2005, 06:34 PM	#11
Serge Litehead Confirmed User Industry Role: Join Date: Dec 2002 Location: Behind the scenes Posts: 5,190	my wild guess is that your blog is in new format now using cat ids to pull stuff from mysql. the link you posted here with title is the old format and no longer valid. i didnt find any links with titles on the site. everything is pulled they way you desribed you wanted. __________________ SilverCrocodile.com Adult web design since '05

08-08-2005, 09:51 AM	#2
Jace FBOP Class Of 2013 Industry Role: Join Date: Jan 2004 Location: bumfuck, ky Posts: 35,562	and, and fyi...when I change the skin on the blog, the http://www.jonstern.net/index.php?ti...&c=1&tb=1&pb=1 url works fine...?

08-08-2005, 10:47 AM	#3
Jace FBOP Class Of 2013 Industry Role: Join Date: Jan 2004 Location: bumfuck, ky Posts: 35,562	no one? ...

08-08-2005, 10:56 AM	#4
Satisfaction WootWootCash.com Join Date: Jul 2004 Location: Australia Posts: 10,900	a bump for you dude

08-08-2005, 06:12 PM	#9
Jace FBOP Class Of 2013 Industry Role: Join Date: Jan 2004 Location: bumfuck, ky Posts: 35,562	maybe someone on the night shift can help me

08-08-2005, 11:17 PM	#14
Clarion Confirmed User Join Date: Jan 2005 Location: Ontario, OR Posts: 148	I'm not familiar with the script but the problem is you are not using a username/password for MySQL in your script. check your config.php or config.inc.php file for the setting, or your administration panel. Let me know if you want me to take a quick look at it -- hit me up on ICQ __________________ Structure Northwest :: the cure for the common code :: AIM: Asatruel \| Yahoo!: Asatruel \| ICQ: 111-638-053

08-08-2005, 11:38 PM	#16
Jace FBOP Class Of 2013 Industry Role: Join Date: Jan 2004 Location: bumfuck, ky Posts: 35,562	and oh yeah, check this out the site and urls all work FINE when not in this one skin...but when I have it set up as this one certain skin, it gives that error when_using_this_type_url if I use BLAHBLAH skin, this_type_of_url_works_fine if I use Helsinki skin (loaded now), that type of url gives the mysql error am I getting anywhere here?

08-08-2005, 11:40 PM	#17
georgeyw 58008 53773 Industry Role: Join Date: Jul 2005 Location: Australia Posts: 9,864	as others have said - looks like mysql pass/user error. Although you've mentioned everything is fine. Are you sure it's not trying to access a different file for the db connection info? __________________ TripleXPrint on Megan Fox "I would STILL suck her pussy until her face caved in. And then blow her up and do it again!"

08-09-2005, 12:25 AM	#20
Serge Litehead Confirmed User Industry Role: Join Date: Dec 2002 Location: Behind the scenes Posts: 5,190	where from does rss get its urls? __________________ SilverCrocodile.com Adult web design since '05