By desm0n on

So i decided it would be best to have a local test site for testing new modules instead of doing everything live.

So i backed up my database and files and installed them in XAMPP. Everything fires up and i get my frontpage but everytime i try to access a link from there i get

Object not found!

The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.

If you think this is a server error, please contact the webmaster.
Error 404
localhost
06/13/06 09:16:41
Apache/2.2.0 (Win32) DAV/2 mod_ssl/2.2.0 OpenSSL/0.9.8a mod_autoindex_color PHP/4.4.1-pl1

I had friendly urls urned on on the live site but can't find the database entry in the mysql to disable that (it may be the cause of the problem).

I've made sure that settings.php has the correct url path and enabled mod_rewrite in apache and restarted the engine. Anyone any ideas as to where to look ?

⋅ Categories: Drupal 4.7.x

Comments

bomarmonk’s picture

bomarmonk commented

Did you edit the location of the mod_rewrite entry? In order for it to be properly enabled, you actually have to place it in a different spot in your apache config file... there's a little tutorial about this here: http://drupal.org/node/43545

Thought it might be worth pointing out, in case you haven't seen this.

desm0n’s picture

desm0n commented

thanks for the reply. Actually tried that and its still giving me 404's :( I can however access the pages, but obviously not use the site, by typing in q=? and the place i wish to go.

I'm absolutely at a loss as to why this is doing this so need to disable clean urls on the test site i guess.

Anyone know where in mysql it is and what settings to disable clean urls ?

xano’s picture

xano
he/they
Primary language English
Location Southampton
commented

By default mod_rewrite is disabled. Are you sure you have manually enabled the module? If not, go to httpd.conf in your Apache directory and search for "mod_rewrite" in a list of modules. Once you have found it, remove the "#" at the beginning of the line.

desm0n’s picture

desm0n commented

Yes its enabled and i've restarted apache. I still keep getting the 404 errors and its very frustrating :(

xano’s picture

xano
he/they
Primary language English
Location Southampton
commented

Have you used exactly the same .htaccess file as on your webspace?

desm0n’s picture

desm0n commented

yes the very same file. I've chedked and its root in the space so thats not the problem.

This really has me baffled :(

heine’s picture

heine commented

Check whether
- AllowOverride ALL is enabled for the drupal directory (http.conf).
- RewriteBase (.htaccess) is correct.

To disable clean_urls open settings.php and add (without phptags)

$conf = array(    
  'clean_url' => 0,
);

--
The Manual | Troubleshooting FAQ | Tips for posting | Make Backups! | Consider creating a Test site.

desm0n’s picture

desm0n commented

Mmmm this is weird :) That worked and allowed me to view all pages but with lots of errors.

user warning: Duplicate entry '0' for key 1 query: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('', 'node', 'http://localhost/', '127.0.0.1', 0, 'be1a47f91281ddf692c2facc02c61cd3', 2381, 1150222298) in C:\apache\xampp\htdocs\includes\database.mysql.inc on line 120.

And when i try and login i get :-

Warning: Duplicate entry '0' for key 1 query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Duplicate entry '0' for key 1\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'user', 'Login attempt failed for <em>desm0n</em>: <em></em>.', 0, '', 'http://localhost/?q=forum/local-news/afan-forest-park-may-be-the-first-i..., 'http://localhost/?q=forum/local-news/afan-forest-park-may-be-the-first-i..., '127.0.0.1', 1150222246) in C:\\apache\\xampp\\htdocs\\includes\\database.mysql.inc on line 120.', 2, ' in C:\apache\xampp\htdocs\includes\database.mysql.inc on line 120

Warning: Duplicate entry '0' for key 1 query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Duplicate entry '0' for key 1\nquery: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('Afan Forest Park May Be The First In The UK With Mountain Bike Lifts.', 'node/604', 'http://localhost/?q=forum/local-news/afan-forest-park-may-be-the-first-i..., '127.0.0.1', 0, 'be1a47f91281ddf692c2facc02c61cd3', 677, 1150222246) in C:\\apache\\xampp\\htdocs\\includes\\database.mysql.inc on line 120.', 2, '', 'http://localhost/?q=forum/local-news/afan-forest-park-may-be-the-first-i...', 'http://localhost/?q=for in C:\apache\xampp\htdocs\includes\database.mysql.inc on line 120

Warning: Duplicate entry '0' for key 1 query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Cannot modify header information - headers already sent by (output started at C:\\apache\\xampp\\htdocs\\includes\\database.mysql.inc:120) in C:\\apache\\xampp\\htdocs\\includes\\common.inc on line 266.', 2, '', 'http://localhost/?q=forum/local-news/afan-forest-park-may-be-the-first-i...', 'http://localhost/?q=forum/local-news/afan-forest-park-may-be-the-first-i...', '127.0.0.1', 1150222246) in C:\apache\xampp\htdocs\includes\database.mysql.inc on line 120

I think i may have some issues with the exported database as Xamp is 4x and mine was 5x on the wevsite. I did however expoirt using the 4x compatabilities. I guess i'll have to either go back to the drawing board and create another sql backup or just install a base system here on xampp.

heine’s picture

heine commented

XAMPP comes with MySQL 5 as far as I know. This version has an annoying and long standing bug: when dumping with 4.0 compatability it also strips auto_increments; giving you this error. See also http://bugs.mysql.com/bug.php?id=14515 ; you'll have to add these back manually or use the script on the mysql bug page.
--
The Manual | Troubleshooting FAQ | Tips for posting | Make Backups! | Consider creating a Test site.

desm0n’s picture

desm0n commented

Fixed it by exporting again without compatability and low and behold all errors went away.

Thanks very much for all your help guys. Now i can use this local site as a test site.

Heine, once again i'm in your debt :)

Thanks to all that helped.

akuma’s picture

akuma commented

I also found this string helpful. Really got stuck until I tried some of the suggestions above.

Thanks!

"Verbing weirds language." -- Calvin (& Hobbes)

RRodrigues’s picture

RRodrigues commented

http://drupal.org/node/208777

Also a possibility: turn off the update module