By tominglis on

http://www.standrewboatclub.org/

I visited my website this morning, and discovered a whole lot of PHP and SQL warnings, and there is no website functionality that I can used.

The website was working fine last week, when I upgraded the website (including the ACL / Content Access, Event / Signup, Image, Ubercart, Views, Weather), and enabled the CAPTCHA, Nice Menus, Profile Privacy modules. I also tried using Taxonomy Access Control and TAC Lite, but could not get these to work, but they have been removed. The site is running the latest version 6.9 and the latest versions of the modules, and update.php had been run.

If anyone has any suggestions, that would be hugely appreciated, as I've put a lot of work into the site!

Many thanks,

Tom

⋅ Categories: Drupal 6.x

Comments

bwv’s picture

bwv commented

I went to register for an account on your page and got this:

Not Found

The requested URL /user/register was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Did you by any chance change the .htaccess file? Try uploading a clean .htaccess to your drupal root directory and see what happens. (Others might have better advice.)

----------------------------------------------------------------------
http://classicvinyl.biz
http://music.classicvinyl.biz
http://association.drupal.org/user/1207

ryivhnn’s picture

ryivhnn commented

As well as making sure you ran update.php on the modules as well as drupal, I second trying the clean .htaccess that came with 6.9

works at bekandloz | plays at technonaturalist

tominglis’s picture

tominglis commented

I have tried replacing all of the 6.9 files including the .htaccess file.

I have also tried to run update.php when logged in as user 1, but access is denied.

bwv’s picture

bwv commented

If you can, go into your database and truncate (clear, not/not drop) your cache and session tables. Please let us know if that makes a difference.
----------------------------------------------------------------------
http://classicvinyl.biz
http://music.classicvinyl.biz
http://association.drupal.org/user/1207

tominglis’s picture

tominglis commented

I have tried emptying (truncating) the "cache" and "sessions" tables, but it seems to have made no difference.

pfaocle’s picture

pfaocle
He/Him
Primary language English
commented

At a first glance, the error seems to stem from the SQL statement:

SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = '' AND b.status = 1 AND (r.rid IN () OR r.rid IS NULL)...

the r.rid IN () is incorrect. Something to do with block visibility settings? Check your blocks_roles table for anything untoward?

---
paul byrne
paul.leafish.co.uk | www.leafish.co.uk

---
Paul Byrne
pfaocle.co.uk | CTI digital

tominglis’s picture

tominglis commented

This is what it says in blocks_roles. I am not sure what I am to be checking for?

module delta rid
blog 0 2
blog 0 4
blog 0 5
forum 0 2
forum 0 4
forum 0 5
poll 0 2
poll 0 4
poll 0 5

bwv’s picture

bwv commented

Something just occurred to me: Did your webhost make any changes to its apache software, or to its mysql versions? Any upgrades, for example, since you last checked your site?

Have your tried a fresh installation of the 6.x tar file? Sometimes, these sorts of errors are generated if your include files are corrupted or if your .php files have blank lines at the start or finish of the file.
----------------------------------------------------------------------
http://classicvinyl.biz
http://music.classicvinyl.biz
http://association.drupal.org/user/1207

tominglis’s picture

tominglis commented

I tried copying the drupal files fresh from my computer over FTP. I haven't tried replacing the /files or /sites folders though. Do you think that would help?

tominglis’s picture

tominglis commented

I have tried replacing the "default" folder and using the most recent default settings file.

tominglis’s picture

tominglis commented

We are back in business. I have no idea why!? Maybe that default settings file made a difference? Or maybe the hosts made a change on the server?

Thanks loads for your help!

Tom

bwv’s picture

bwv commented

Glad to hear your site is back. FYI, using FTP to upload individual files to the server is generally ok but there is a small chance of file corruption using that method. Its always better to uncompress the tar file on your server, if you have access to this capability.
----------------------------------------------------------------------
http://classicvinyl.biz
http://music.classicvinyl.biz
http://association.drupal.org/user/1207