By andreas-k on

Hello everyone

i installed drupal 7.8 on my localhost using XAMPP.
I created a backup of the entire drupal folder into a .zip using unarchiver (OS X)
and i also exported the database using phpMyAdmin following the instructions of the post : http://drupal.org/node/81993.

Trying to restore the site i did the followings :
1. unzip the drupal files
2. create a database with the same name using phpMyAdmin
3. import the .sql file using phpMyAdmin

whenever i try to open the site i get the message :
"Fatal error: Class 'SelectQueryExtender' not found in /Users/.../drupal/includes/pager.inc on line 15"

does anyone knows something about it ?
i thought that this was the right way to backup a drupal site...
the whole process was simple so i cannot figure out what went wrong !

thx in advance

⋅ Categories: Drupal 7.x

Comments

mshepherd’s picture

mshepherd commented

Hi,
Did anything change between backing up and restoring?
Operating system, OS version, Apache/PHP/MySQL version? Any Drupal modules, themes or core?

Did you try clearing the cache? Running update.php in case?

andreas-k’s picture

andreas-k commented

hi there !

nothing changed.
OS : OS X 10.6.8
XAMPP : 1.7.3
from phpinfo()
PHP : 5.3.1
MySql : 5.1.44
Apache : 2.2.14 (Unix)

I just deleted both the folder with the files and the db and i created a new folder to unarchive the old files and a new database to import the previously exported one.
all the names were the same
Cache is disabled using web developer (also cleared).

mshepherd’s picture

mshepherd commented

I can't really guess what might be causing your problem, but here are some things to double check:

  • Check the permissions on all the files you extracted. You need to be sure your webserver process has read permission.
  • Check that there weren't any errors when you extracted the files and that there aren't any files missing.
  • If you can (a log file somewhere?) check that all the files were backed up successfully
  • Check that you followed correct procedure when you recreated your database - or did you re-use the one you already had?
  • Check that you can run a simple query on the database using the same credentials that Drupal would be using (the login credentials you'll find in settings.php)

If you don't mind my asking, why did you backup and then restore your site?

andreas-k’s picture

andreas-k commented

well, without a backup procedure, production might one day be useless !

mshepherd’s picture

mshepherd commented

One more question:
You say get this error... Is it the only thing you see in your browser window?

andreas-k’s picture

andreas-k commented

thank you for your quick replies

i double checked all your recommentations and everything seems to be ok
unfortunately this is the only message i get...

mshepherd’s picture

mshepherd commented

Then I'm sorry, you've got me stumped.

Hopefully someone else will chime in soon. Bump the post tomorrow sometime if you don't hear from anyone else.

andreas-k’s picture

andreas-k commented

i have a drupal instalation with its database :

  • /drupal
  • drupal_db

and i created a copy of them

  • /test_drupal (copy-paste entire folder)
  • test_drupal_db (export all tables ->create db -> import with phpMyAdmin)

in the same server (localhost) meaning that the db_user will be the same
i only changed the line in /test_drupal/sites/default/settings.php to 'database' => 'test_drupal_db' to pointing to the copied database
i still get the same Fatal error...
Am i missing something ?

andreas-k’s picture

andreas-k commented

for some (unknown) reason , after many tests in export-import database
it works with the same settings i used at the first post.

Don't know what to say...

mshepherd’s picture

mshepherd commented

Well, I'm glad you're up and running again. But I know it's frustrating when you can't see why!
Good luck with your site.
Matthew

rodolfojcj’s picture

rodolfojcj commented

Hi everybody!

I lived an identical situation with a customer's site. After several tests, I managed to reproduce the error in a test enviroment using a fresh installation of drupal 7.8 and the database dump our customer provided us. To be concise, the problem was that the customer dumped only the definition of the tables, then the "registry" table was totally empty, and this table stores the paths of files used to find the definition of drupal's PHP classes. Then I changed settings.php file to use a database of a fresh install and the site worked!

In a properly dumped database of a fresh install, the SQL should contain something like this:

INSERT INTO `registry` (`name`, `type`, `filename`, `module`, `weight`) VALUES
....
....
('SearchRankingTestCase', 'class', 'modules/search/search.test', 'search', 0),
('SearchSimplifyTestCase', 'class', 'modules/search/search.test', 'search', 0),
('SearchTokenizerTestCase', 'class', 'modules/search/search.test', 'search', 0),
('SelectQuery', 'class', 'includes/database/select.inc', '', 0),
('SelectQueryExtender', 'class', 'includes/database/select.inc', '', 0),
('SelectQueryInterface', 'interface', 'includes/database/select.inc', '', 0),
('SelectQuery_pgsql', 'class', 'includes/database/pgsql/select.inc', '', 0),
....
....

Conclusion: when migrating or restoring a site, do and use a full database backup, containing tables' creation and their data.

Bye!
Rodolfo J. Castellanos J.

Sk8erPeter’s picture

Sk8erPeter commented

It's interesting, I was doing an update on a test Drupal, and then I got the error messages "Fatal error: Class 'SelectQueryExtender' not found in ...\includes\pager.inc on line 15", "Fatal error: Call to undefined function menu_get_custom_theme() in ...\includes\theme.inc on line 87", when going to Appearance, "Fatal error: Unsupported operand types in ...\modules\system\system.admin.inc on line 266", etc., and when nothing worked, I tried this "trick", inserting these rows manually (which were somehow - don't know how!! - missing):

INSERT INTO `registry` (`name`, `type`, `filename`, `module`, `weight`) VALUES
('SelectQuery', 'class', 'includes/database/select.inc', '', 0),
('SelectQueryExtender', 'class', 'includes/database/select.inc', '', 0),
('SelectQueryInterface', 'interface', 'includes/database/select.inc', '', 0),
('SelectQuery_pgsql', 'class', 'includes/database/pgsql/select.inc', '', 0);

and then everything worked again...
Really interesting.
Thanks for sharing this, Rodolfo!

emslade’s picture

emslade commented

hi, where did you post this code?

mmjvb’s picture

mmjvb commented

You can run that in any utility that allows you to maintain your database, normally phpMyAdmin.

emslade’s picture

emslade commented

Where in phpmadmin though?

mmjvb’s picture

mmjvb commented

and go to the SQL tab. Enter the code and click `Go` to execute it.