turning on spider friendly urls "

s2kinteg916 · December 8th, 2003, 04:19 PM

how do u turn on spider friendly urls ? i changed web host providers (doenst work no more) and cant seem to find it or remember how i turned it on before

Michael P · December 8th, 2003, 05:43 PM

It's in the Admin Options...

Use Spider-friendly URLs?

s2kinteg916 · December 8th, 2003, 06:35 PM

yeah i looked numerous times.. its not there maybe i forgot to upload a file or something

Michael P · December 8th, 2003, 07:09 PM

Maybe you didnt run the upgrade script with the final? You can find the query at the bottom of the upgrade41.sql.

s2kinteg916 · December 8th, 2003, 07:38 PM

do i just copy and paste this into phpmyadmin > sql ?

REPLACE INTO {$pp_db_prefix}settings VALUES (133,'Use Spider-friendly URLs?','spider','','no',17,6);

i did that and i got a error

Error

SQL-query :

REPLACE INTO {$pp_db_prefix}settings
VALUES ( 133, 'Use Spider-friendly URLs?', 'spider', '', 'no', 17, 6 )

MySQL said:

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 '{$pp_db_prefix}settings
VALUES ( 133, 'Use Spider-friendly URL

Michael P · December 8th, 2003, 07:41 PM

Change {$pp_db_prefix} to whatever prefix you have (if any).

WebDork · December 11th, 2003, 05:44 AM

I turned this function on - on a fresh install - but my server is redirecting back to the home page. I think in my htaccess I have a 404 redirect for missing pages - would this affect this ?

December 11th, 2003, 06:58 AM

yes, it would.

WebDork · December 11th, 2003, 07:02 AM

Didnt help removing it. Getting file not found... Anythin gelse I would have to change - surely I would have to do something in vhost.conf for example ?

Michael P · December 11th, 2003, 12:45 PM

If you turn off spidering, does the problem go away?

WebDork · December 11th, 2003, 05:41 PM

Quote:

Originally posted by Michael P
If you turn off spidering, does the problem go away?

Yep - no problems.

Site is http://www.perfectlypeet.com

December 11th, 2003, 06:24 PM

What type of server is this on?

WebDork · December 11th, 2003, 06:43 PM

Rackshack linux box / plesk admin.

criscokid · December 30th, 2003, 02:35 PM

I'm running IIS6 on Windows Server 2003. AFter having turned on Spider-friendly URLs I get the following error messages when clicking on a tumbnail:

Warning: Unknown(D:\Inetpub\wwwroot\http://www.hotel-review.net\gallery\...to.php\photo\2): failed to open stream: No such file or directory in Unknown on line 0

Warning: (null)(): Failed opening 'D:\Inetpub\wwwroot\http://www.hotel-review.net\gallery\...to.php\photo\2' for inclusion (include_path='.;c:\php4\pear') in Unknown on line 0

TheJerseyDevil · October 16th, 2004, 12:43 AM

I have the same exact problem with server 2003.

I have read all the path info bug stuff and all the post related to this i can find.

Short story is i reeeealy want this to work. Is there any fix at all?

Google isn't indexing like i want it to.

Josh's seo hack has the same problem on threads and he can't fix it so whoever does or can make this great feature work will be regarded as a true expert :-)

In todays world if your not ranked well on google you might as well hang up your hat.

Not sure why the UK guy gets crawled so well and I don't care about bandwith as much as some.

Please anyone. I give up. I need help with this as i'm sure many do. There has to be a resolution.

Chuck S · October 16th, 2004, 09:31 AM

Have you read my thread here.

It relates usually to Apache 2.0 configuration and PHP as a CGI module? Do you fit this?

http://www.photopost.com/members/for...023#post997023

TheJerseyDevil · October 17th, 2004, 12:20 AM

Hi,

Yes, I have read it and actually tried that a while ago from info gleened from php's dev site. I went back and forth with josh on this too. I really wanted his hack for threads to work.

Thanks for the reply omegegatron.. and the help you've provided in the past on other issues.

Unfortunately I'm on a Win 2003 server and stuck there with (three free T1's) so I really have to stay :-)

I have researced this extensivley, there must be a work around to accomplish the same thing (se friendly url's), maybe it doesn't need to be fixed but looked at from a differant angle and a differnt solution might pop up. Wish I was php guru instead of a network engineer

Any other ideas or leads out there, I'll gladly run them down. I'm even willing to pay for a solution.

Chuck S · October 17th, 2004, 10:51 AM

Jersey

From my research on the issue that is the only solutions possible thus far. This is totally server related and to my knowledge no php trick is going to solve it. Remember the spider url is a php path explosion trick

which allows the / to replace certain variables like = and ? so that spiders/bots will index them better. This is totally dependent on server ability to follow the path information.

TheJerseyDevil · October 19th, 2004, 08:00 PM

Yes, i've spent hours myself researching. It seems windows will only follow a path that actually exists and leads somewhere (kind of funny considering it won't do anything else quite right). Thanks...

Chuck S · October 20th, 2004, 10:26 AM

You ain't gonna hear any compliments from me on windows LOL