Since moving my install to a new server, I keep getting Fatal Errors when trying to install modules, go to different Views and this latest one, when I've flushed the Cache.

Now I can't go to any pages at all with the error;

Fatal error: Class 'SelectQueryExtender' not found in /home/wildilkphil/peoplesresidency.chinese-arts-centre.org/cac/includes/pager.inc on line 15

Any idea what could be causing this?

Comments

andyceo’s picture

Can you tell what modules and there versions you use?

If you have Views, try to go to the View configuration -> Pager settings -> and set Pager ID different from 0. This may help.

damien tournoud’s picture

Component: cache system » database system
Category: bug » support
Status: Active » Fixed

Most likely, you failed to properly copy some of the files.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

spessex’s picture

Phil, did you get around this only I'm having the same problems on our Webfusion windows 2003 IIS6 dedicated server?

goldcrusaider’s picture

Priority: Normal » Major
Status: Closed (fixed) » Active

Hey guys can you help me out? I have the same problem as this guy who posted. Im getting the error Fatal error: Class 'SelectQueryExtender' not found in :C\\\pager.inc line 15

Im getting this just after a fresh install of Drupal 7. I can not access my admin page any idea how I can fix this I have re-installed Drupal now 7 times and one month has passed. I can not get past this problem.

andyceo’s picture

goldcrusaider, what operating system do you use? in what folders your drupal was installed in? (check write and execute permissions if you have Linux-based OS.)

goldcrusaider’s picture

I am using Window XP/ w Xamp server on a laptop. I'm not a php person but know how to install and set this up as well as know how my directory structure should be. Any thoughts what else to do? I cant get Drupal to launch and its been 2 or 3 months.

andyceo’s picture

Please check existance of /includes/database/select.inc file and make sure you use the correct driver in settings.php (mysql)

goldcrusaider’s picture

ok I found the file but what is the correct driver? And what exactly do I need to change in the file? I am not familiar with this

petrsimcik’s picture

Version: 7.7 » 7.9
Assigned: Unassigned » petrsimcik

I have the same problem - one time is all ok, and second is web crashed.

Fatal error: Class 'SelectQueryExtender' not found in /data/web/virtuals/katastrofy.meteopress.cz/www/includes/pager.inc on line 15

/includes/database/select.inc is ok
Driver Mysql - database Mysql
www/includes/pager.inc is ok and 755

Whats wrong?

jemond’s picture

I was having the same problem on my local development box, when trying to copy the database for the site to a new database name locally.

For me the fix was this:
http://drupal.org/node/1323786#comment-5305922

For some reason (I haven't yet looked into why), several tables like registry were excluded from my MySQL dump.

cweagans’s picture

Priority: Major » Normal

Support requests are never major or critical.

off’s picture

Some problem. Upgrade 6.x -> 7.x

Step: run update.php with only core files

I try to add "registry" table via dump from frash install..

SelectQueryExtender' not found in /***/includes/theme.inc on line 15

drzraf’s picture

its not about views, here's a stacktrace:

Error: Class 'SelectQueryExtender' not found in /drupal/includes/pager.inc, line 15
Fatal error: Class 'SelectQueryExtender' not found in /drupal/includes/pager.inc on line 15
Call Stack:
    0.0007     728072   1. {main}() /drush/drush.php:0
    0.0335    4837944   2. drush_main() /drush/drush.php:14
    0.1387   10747568   3. _drush_bootstrap_and_dispatch() /drush/drush.php:59
    0.1762   10749720   4. drush_bootstrap_to_phase() /drush/drush.php:76
    0.2494   15471776   5. drush_bootstrap() /drush/includes/bootstrap.inc:308
    0.2504   15472936   6. _drush_bootstrap_drupal_full() /drush/includes/bootstrap.inc:185
    0.2504   15514008   7. drupal_bootstrap() /drush/includes/bootstrap.inc:920
    0.2763   17389976   8. _drupal_bootstrap_full() /drupal/includes/bootstrap.inc:2201
    0.2853   18527168   9. require_once('/drupal/includes/pager.inc') /drupal/includes/common.inc:5082
drzraf’s picture

Version: 7.9 » 7.x-dev
Category: support » bug
fizk’s picture

Assigned: petrsimcik » Unassigned

I just ran into this issue. It had nothing to do with the files. Turns out I didn't import my database dump properly. I was clued in when I saw that the "system" table was completely empty :)

Hope this helps someone.

drzraf’s picture

same after trying to move a D6->D7 upgraded dump to another machine where module places are different.
Worse to note that {system} contains 296 entries, some of them being related to D6 modules.
Drupal D7 upgrade process does not cleanup {system} from D6 module entries. This could be related to the failure.

drzraf’s picture

this did the trick and allowed full bootstrap:

UPDATE system SET filename = REPLACE(filename, "sites/all/modules", "sites/newplace/modules") WHERE 
       filename LIKE "sites/all/modules/%" AND type = "module" 
       AND name IN ("my", "module", "whose", "path", "changed");
UPDATE registry SET filename = REPLACE(filename, "sites/all/modules", "sites/newplace/modules") WHERE 
       filename LIKE "sites/all/modules/%"
       AND module IN  ("my", "module", "whose", "path", "changed");
dasrajarshi’s picture

Title: error: Class 'SelectQueryExtender' not found in pager.inc » Specified key was too long
Component: database system » base system
Priority: Normal » Critical

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes: ALTER TABLE {sessions} ADD PRIMARY KEY (`sid`, `ssid`); Array ( ) in db_add_primary_key() (line 2891 of \includes\database\database.inc).

steinmb’s picture

Title: Specified key was too long » Class 'SelectQueryExtender' not found in pager.inc
Priority: Critical » Major

Don't highjack the issues. Create a separate one, describing your system/env, how you managed to create it and if you are able to recreate it.

chx’s picture

Priority: Major » Normal
steinmb’s picture

Status: Active » Closed (cannot reproduce)

Find this issue rather messy and cannot see any real bugs other then it's something wrong with the data in your database. Failed migration, failed restore, database corrupt after db. server crash etc. People seeing this should take a long hard look at their database and the data in it's tables.

I'll suggest we close it.

nicpeck’s picture

Like some of the other commenters, the error went away once I managed to get my database imported properly

@kambiyaso’s picture

I am getting this error with a new theme installation.
Fatal error: Class 'SelectQueryExtender' not found in /Applications/XAMPP/xamppfiles/htdocs/aqh_first_draft/includes/pager.inc on line 15.

dbahroms’s picture

Version: 7.x-dev » 7.26
Issue summary: View changes
aparnapc’s picture

#22 works for me.Thank you!!!!

PI_Ron’s picture

I saw this issue after checking out master from a development branch then merging my branch into master.

Running drush arrrhhhhhh (drush rr) fixed it for me.

ChrisValentine’s picture

Have just encountered this myself - just at a crucial time, of course - and can't fix it other than repeatedly rebuilding the registry using drush. Have cleared out the nested includes folders and they've not come back, but it seems that one or more particular pages on the site trigger this 'class not found' error and once that happens, you're in a white screen of death and can't do anything.

It doesn't appear that any particular page causes it.

So - help urgently required! And it just happens that our backup system isn't responding to restore requests just at the moment...

millenniumtree’s picture

Not 100% certain, but this may be due to a DISABLED module that isn't UNINSTALLED.

We had a couple of disabled modules on a site (Rules UI and Media Field).
A registry rebuild would allow a few pages to load before the error returned.
We logged in and after uninstalling those two, then rebuilding the registry again, the errors went away...

This didn't work on another site, however...

millenniumtree’s picture

OK, finally figured it out!
The reason our site blew up is that there was an includes folder WITHIN the includes folder.

WEB_ROOT/includes/includes

Drupal found some valid .inc files in there and added them to the registry table.

Then we fixed the problem, removing the nested includes dir, and upon rebuilding the registry, the invalid registry records were deleted, NOT re-pointed to the valid file in includes/.

I had to export the registry records from a known-good D7 site where the filename started with 'includes/', and import them into the broken site.

The attached sql file will re-import the missing registry records. Then just do a registry rebuild (drush rr)

This was for Drupal 7.39 - if you have a different version, your records may be different, so proceed with caution and back up your database before running it (obviously).

swapnilmohile’s picture

#22 works for me.Thank you!!!!

mannus’s picture

I am still facing the same error. Any resolution ?

lubwn’s picture

Thanks millenniumtree #31, you helped me a lot! Same happened to me. Not sure how includes folder got into itself like includes/includes but deleting it and re-creating registry definitelly helped.