Drupal gives error help! :(
Hi everybody,
well firstly i will give you the error messages that drupal gave me and then i will tell you the story.
user warning: Unknown column 'description' in 'field list' query: UPDATE system SET description = 'Aggregates syndicated content (RSS, RDF, and Atom feeds).', name = 'aggregator', filename = 'modules/aggregator/aggregator.module', bootstrap = 0 WHERE filename = 'modules/aggregator/aggregator.module' in C:\Inetpub\vhosts\***********\subdomains\bakirkoy\httpdocs\includes\database.mysql.inc on line 172.
user warning: Unknown column 'description' in 'field list' query: UPDATE system SET description = 'Controls the boxes that are displayed around the main content.', name = 'block', filename = 'modules/block/block.module', bootstrap = 0 WHERE filename = 'modules/block/block.module' in C:\Inetpub\vhosts\*************\subdomains\bakirkoy\httpdocs\includes\database.mysql.inc on line 172.
This error messages shown when i click on the moduls button.
Also when i click on the themes button it gives this error messages:
user warning: Unknown column 'description' in 'field list' query: INSERT INTO system (name, description, type, filename, status, throttle, bootstrap) VALUES ('chameleon', 'themes/chameleon/chameleon.theme', 'theme', 'themes/chameleon/chameleon.theme', 0, 0, 0) in C:\Inetpub\vhosts\************\subdomains\bakirkoy\httpdocs\includes\database.mysql.inc on line 172.
user warning: Unknown column 'description' in 'field list' query: INSERT INTO system (name, description, type, filename, status, throttle, bootstrap) VALUES ('bluemarine', 'themes/engines/phptemplate/phptemplate.engine', 'theme', 'themes/bluemarine/page.tpl.php', 0, 0, 0) in C:\Inetpub\vhosts\************\subdomains\bakirkoy\httpdocs\includes\database.mysql.inc on line 172.
Now there is no button and menus. But i can see the pages without themes.
The process that i get these messages:
Firstly i have the drupal 5.x version (i dont remember but it is 5.7 i think) which is working. Then i upgraded it to 6.1 version and it worked well. But i recognize that i have to make the installation with the Turkish language. So i found the 6.x turkish version and i try to upgrade it. But it didnt work and gave lots of error like these. Then i erased all of the files and copied my backup files back to the server. Now it still gives these errors.
What is the meaning of these errors? Does anyone can help me?
Did you run update.php after
Did you run update.php after the upgrade? Upgrading takes more than just copying files, you also have to execute the database updates by running update.php. Once you did that, you can't just switch back to Drupal 5 by copying the files, because the database will remain in the Drupal 6 state. Make sure you have read the documentation before you do anything else: http://drupal.org/upgrade/.
If you did everything 'by the book', you must have backed up your database as well. I recommend reverting to the backed up version of both your database and your files and start over completely.
By the way, when upgrading from drupal 5.7, I would recommend upgrading everything (core and modules) to the latest Drupal 5 version first. After that, you can upgrade to the latest Drupal 6 version straight away (no need to go to 6.1 first, just take 6.12). Make sure you have read the upgrade instructions of every single module you use before you do anything.
Thank you very much for your
Thank you very much for your answer. Well i realize now that i missed the database backup. :(
i watch the video and i read the instructions but i missed it. Thats a big mistake.
So i think my database is now 6 versions db. So do you have any advice??
My advice: back up your
My advice: back up your database now. Even though it may contain some problems at this point, you may want to revert to where you are now. So do it now. I'll wait.
[waiting...]
OK, now that you have backed up your db, let's continue.
You say 'I think', but it's better to be sure. Did you run update.php after uploading the D6 files? Did you receive any error messages? You might find some info about this in de drupal logs. If you did not run update.php yet, your database is probably still in the D5 state.
The error you're seeing means that the database structure is not what the code expects. You can try to put back the D6 files, run update.php again and see if there are pending updates. Remember that every module can have it's own upgrade script, so you have to run update.php every time you enable a module on your D6 site. This is a method of trial and error, but that's OK - after all, you have your backups :-)
I'm trying to backup my db, i
I'm trying to backup my db, i want help from a friend for that because i didn't understand it really.
Amd i m sure that i upgrade drupal 6. And it worked with little errors. But when i change it with turkish version it collapsed. Then i put the drupal 5 and i try to upgrade it again. But it didn't work. it gives errors.
Now i copied back the working 6 versions files to the server. But it didnt work. Nothing happens...
Well i'm waitin for my db. But i didnt know what to do...
While you're waiting, check
While you're waiting, check out the documentation on this site. There is a lot of information available which will help to prevent this kind of situations: backing up, version control, test servers, you name it.