By ycim on

I was rather successfully running 4.6.0 for the last year. My ISP decided to upgrade his mysql to 4.1 and with that upgrade, I kept getting an "unsupported database format" error, and my entire website went down.

After some laborous decision making, we decided that I had to update Drupal. I installed to 4.7.3, but now, of course, I get all sorts of errors when trying to access my database. It would appear that there are some database file structure changes, which are causing errors.

Without starting all over, I need some direction from the group. As my web site has tons of pages already done, I have no idea how to access the existing content for this new version. I can no longer access my old database.

Any ideas how to get around this? How do I get my "old stuff" and get back up and running without having to start completely all over.

Thanks....

⋅ Categories: Drupal 4.7.x

Comments

toddgator’s picture

toddgator commented

Something similar happened to me a while back and it was not Drupal, but my old host had managed to botch things up when they updated the servers. Look to see if all of your files and settings were preserved. For me, one problem I had had in the past was when they moved my account to a new server, they neglected to move any hidden files like .htaccess. I hope you are able to resolve this. If your host is good, they will help you troubleshoot.

Sorry I couldn't be of more help...
Todd

My blog | Unlimited templates and graphics | Web Hosting | Instant PHP websites | Stock photos

ycim’s picture

ycim commented

Sorry this also happened to you. It is truly devastating to lose your data!

Do you know anything of the database structure. When I try to point 7.3 to my database, I get a bunch of structure errors. If drupal had some structure changes in the new version, how would one get access to the old info? I can do some SQL commands, but (in theory) that would be missing some information in the new database. Would it still work?

Also, I don't see that the .html pages are stored in the database? Is it still possible to access that content without the database? Where is that stored?

Any ideas?

Thanks

AmrMostafa’s picture

AmrMostafa commented

What errors exactly do you get?

Could you please execute these SQLs and post the output?

SHOW CREATE TABLE node;
SHOW INDEX FROM node;

It happened to me that 4.1 screwed up the database structure after upgrade from 4.0 due to some encoding related issues. And the only solution I found required a working backup of the database (e.g. before 4.1 upgrade).

ycim’s picture

ycim commented

After working with my ISP, we now have a different error! I dont' know if you would still need that, but now the situation has changed slightly. I now have 4.7.3 installed. I have 2 working databases.....Database A is my database that has worked for the last year. Database B is the brand new one that I created after installing 4.7.3. When I point settings.php to Database B, all works just fine, and my site is ready to be rebuilt!

When I point settings.php to Database A, I get the following error...

Fatal error: Call to undefined function banner_display() in /usr/home/mysite/html/info/includes/common.inc(1175) : eval()'d code on line 1

Why the difference? By the way, I ran the sql code you requested. Do you still need the results (It is lots of info!)? Here they are

  
Table  Non_unique  Key_name  Seq_in_index  Column_name  Collation  Cardinality  Sub_part  Packed  Null  Index_type  Comment  
node 0 PRIMARY 1 nid A NULL NULL NULL   BTREE   
node 0 PRIMARY 2 vid A 89 NULL NULL   BTREE   
node 0 vid 1 vid A 89 NULL NULL   BTREE   
node 1 node_type 1 type A NULL 4 NULL   BTREE   
node 1 node_title_type 1 title A NULL NULL NULL   BTREE   
node 1 node_title_type 2 type A NULL 4 NULL   BTREE   
node 1 status 1 status A NULL NULL NULL   BTREE   
node 1 uid 1 uid A NULL NULL NULL   BTREE   
node 1 node_moderate 1 moderate A NULL NULL NULL   BTREE   
node 1 node_promote_status 1 promote A NULL NULL NULL   BTREE   
node 1 node_promote_status 2 status A NULL NULL NULL   BTREE   
node 1 node_created 1 created A NULL NULL NULL   BTREE   
node 1 node_changed 1 changed A NULL NULL NULL   BTREE   
node 1 node_status_type 1 status A NULL NULL NULL   BTREE   
node 1 node_status_type 2 type A NULL NULL NULL   BTREE   
node 1 node_status_type 3 nid A NULL NULL NULL   BTREE   
node 1 nid 1 nid A NULL NULL NULL   BTREE

So with that info, any suggestions how I can get access to the first database? What about the .html pages? Without knowing how drupal works on the inside, I assume that it would generate these pages somewhere! I can view my Database A through the database window (myadmin), and can see all the data! But there isn't anywhere here that keeps the .html files. So by restoring the database, will that actually do anything to get my content back?

Thanks

vprajan’s picture

vprajan commented

Hi,

me too trying to upgrade from 4.6.0 to 4.7.3. Why not use update.php for updating your Database A to be compatible with 4.7.3?..

I followed the steps given in the UPGRADE.txt as follows:

1. Backup your database and Drupal directory - especially your
configuration file in 'sites/default/settings.php'.

2. Log on as the admin user

3. Remove all the old Drupal files then unpack the new Drupal
files into the directory that you run Drupal from.

4. Put the old settings.php (Database A configured) into sites/default

5. Run update.php by visiting http:///update.php.

This update.php changes the database structure to be compatible with 4.7.3 without affecting any of your data. Now check whether your site is back to normal.

I tried these steps and made my site up. But the problem i get now is the due to some depricated modules like fckeditor, menu_otf and some other modules.

Figuring out how to solve it.

ycim’s picture

ycim commented

Just an update......I found some documentation on the error that I was getting. Once I found a way to disable the banner module and also disable clean url's, I was up and running!

The clean url's are still a problem, but hopefully my ISP is working through it and will have it soon.

Thanks for the contributions! I think I am on my way!

strooltz’s picture

strooltz commented

Im having the same problem

Call to undefined function banner_display()

im upgrading from 4.6.4 to 4.7.4

i followed the instructions but can't get past this error...

asainko’s picture

asainko commented

I am getting this error on when trying to configure my PHP Gallery

Undefined index: REQUEST_URI in E:\hshome\asainko\morecollectionthailand.com\exports\gadmin\menu.php(1) : eval()'d code on line 3