Last updated February 10, 2012. Created by sun on May 3, 2006.
Edited by krupali mehta, jpl, LeeHunter, annajonna. Log in to edit this page.
i was add all the modules for drupal chat. but after that my site can not open.
Last updated February 10, 2012. Created by sun on May 3, 2006.
Edited by krupali mehta, jpl, LeeHunter, annajonna. Log in to edit this page.
i was add all the modules for drupal chat. but after that my site can not open.
Comments
PostgreSQL and upgrading from Drupal 4.6 to 4.7
Since MySQL is still pretty much the preferred database platform for Drupal (though PostgreSQL support is getting much better!), you may be faced with some additional steps in upgrading. I don't know if this is the case in Drupal 5, but the PostgreSQL database schema includes a number of functions, presumably to add a basic level of MySQL compatibility. Your site may be able to run okay without them, but some modules (like forum) won't be able to work without them. These functions don't seem to be upgraded with the update.php script, so when you upgrade, you may have to grab them from the database schema file (under the database directory of the installation). They're near the end of the file, starting with a section named "Functions". Copy these to a separate file and then you can load them with the command
psql [database_name] < [name of file you created]For reference, here is the contents of the file that I created, based on the 4.7 distribution. You'll want to use whatever's in your Drupal distribution, though.
---
--- Functions
---
--- Always installed in 'public' as prefix isn't appended to function names
SET search_path TO public;
CREATE OR REPLACE FUNCTION "greatest"(numeric, numeric) RETURNS numeric AS '
SELECT CASE WHEN (($1 > $2) OR ($2 IS NULL)) THEN $1 ELSE $2 END;
' LANGUAGE 'sql';
CREATE OR REPLACE FUNCTION "greatest"(numeric, numeric, numeric) RETURNS numeric AS '
SELECT greatest($1, greatest($2, $3));
' LANGUAGE 'sql';
CREATE OR REPLACE FUNCTION "rand"() RETURNS float AS '
SELECT random();
' LANGUAGE 'sql';
CREATE OR REPLACE FUNCTION "concat"(text, text) RETURNS text AS '
SELECT $1 || $2;
' LANGUAGE 'sql';
CREATE OR REPLACE FUNCTION "if"(boolean, text, text) RETURNS text AS '
SELECT CASE WHEN $1 THEN $2 ELSE $3 END;
' LANGUAGE 'sql';
CREATE OR REPLACE FUNCTION "if"(boolean, integer, integer) RETURNS integer AS '
SELECT CASE WHEN $1 THEN $2 ELSE $3 END;
' LANGUAGE 'sql';
Question re: Update Versions and Troubleshooting
Perhaps this is all explained somewhere other than a book.....
Lets say I inherit a database which has not been cared for, and there are many update versions for contrib modules to choose from, starting with 2, 3 and then jumping, say, to 4005, 4006, 4007.
Would the prudent course be to choose the first available (2), and then continue running update, moving up through those? That goes against the dictum "run update.php only once".
On the other hand, say I've leaped ahead (I chose 4005 instead of 3) and run an update that fails, because it is editing a table that looks different than it should, because previous updates had not been run. I assume my only recourse is to go and manually edit the table design based on what the update was trying to accomplish, given its error message. (I can't "un-do" the status of the update, can I?)
So...say I do that. Should I expect my next update.php to indicate that it is time to run update 4006?
--
Bram Moreinis
Principal, Game Face Web Design
http://gamefacewebdesign.com
Consultant, The Empowered Teacher
http://empowered-teacher.com
Supporter, Drupal Schools Network
http://drupalschools.net
Subscribing
Have the same problem and cannot find anything on the subject here for three days.
Always run all updates, serially
If you choose version X in the update select combo, then all updates numbered >= X are automatically executed for this module in their ascending order (not just your selected version X). It's a bad idea to skip individual updates unless you really know what you are doing; as you already noticed, later updates may depend on earlier ones having been executed. You cannot easily undo an update, other than reverting to the database snapshot that you should have created beforehand. If you want to mess around (not really recommended unless you encounter errors), you can see what each update does by inspecting the module.install script.
New installation Drupal 6 instead of upgrade
After I've copied all Drupal 6 files to the right directory, and I'm navigating to my website to login (/?q=user), it's starting a whole new installation of Drupal (/install.php?profile=default), instead of an upgrade. Also when I'm navigating to /upgrade.php, the new installation starts.
Can somebody help me how to fix this? To be sure I didn't loose everything, I've just put everything back to version 5.20, but of course eventually I want to upgrade to 6 :-p.
Thanks!
Mirjam
RE:New installation Drupal 6 instead of upgrade
You have to overwrite all files of drupal 6 to drupal 5 directory other than the sites folder of drupal 6 directory. Before running update.php you have to disable all the custom as well as contributed modules.
The same problem i have also faced but the solution is to keep intact the old settings.php file. Then you will be navigated to update page rather than install page.
I hope this will help you.
BLANK SCREEN WHEN I CLICK http://gastia.com/update.php
WHEN I CLICK http://gastia.com/update.php
became blank screen with address http://gastia.com/update.php?op=info
My Status Report
http://lh6.ggpht.com/_XE7k1yGWGhU/TF4cHjthR7I/AAAAAAAAAO0/e2FFUBsLJbo/st...
Everything is Oke ,.... this happen about 3 -6 days ago!
I do not know/forgot about what I'm doin last days.
BLANK SCREEN and STATUS STILL:
Database updates Out of date
Some modules have database schema updates to install. You should run the database update script immediately.
________________________________________________________
What I’m doing is NOT SPECIAL because EVERYONE can do It.
And Everything is Gonna Be Oke!
http://www.gastia.com
Updating v5x failure
Hi All
I'm updating from 5.16 to 5.21. Update throws many warnings and failures, and the process loses data, renames nodes, disappears the menus ... I know that this is 5x and boring, but I can't get to 6x until I solve this.
I'm sure I am following best practice by disabling all non-core modules before running update.php, but the errors are so numerous and the symptoms are so consistent (two separate site do the same thing on update) that I can't help but think I'm missing a step.
The main symptoms after the upgrade are content paths are moved around, and newer content pieces are missing. The titles of the newer pieces are somehow assigned to older nodes. And, the main menu does not display.
If this sounds familiar to anyone, let me know. I'd love to move to 6x soonest.
Many thanks in advance.
This helped me before
I know this is what the above tutorial reads... but
One way is to change the line in sites/default/settings.php that reads ...
$update_free_access = FALSE;
make it read:
$update_free_access = TRUE;
save the file, then go to:
http://example.com/update.php
(change the 'example.com' to your actual domain of-course.)
-I usually go to the update url in a browser other than the one I was having trouble with.
After the update runs it is very important to change the TRUE back to FALSE and !! Don't forget to reset the settings.php permissions back to secure if you didn't use a $ sudo command!...
Ali
Gator's Guides & www.allisonelizabeth.net
you shouldn't tinker with update_free_access
I hope Jeffrey's problems are solved by now, but I don't think you should tinker with the update_free_access settings. It doesn't affect this kind of problem, it only allows you to update or upgrade when you weren't logged in before you started the update/upgrade process. but, by setting the value to 'TRUE' allows anyone to call the update script without logging in.
so, if you have to alter the value, make sure to set it back to false after the update.