Hello,

I successfully upgraded from 4.7.6 to 4.7.11 to 5.0 then to 5.7. Then I decide to upgrade from 5.7 to 6.0.

When I did the update.php proper, I got a page saying register globals had to be disabled. So I searched this website and found out I had to add this to .htaccess: AddType x-mapp-php5 .ph.

I did this (I knew it worked cause I used it on a previous upgrade).

Then instead of clicking on the "continue button" I reloaded the page so the modified .htacesss file would be taken into account. Was that a mistake?

Then I got a lot of mysql warnings, and I thought perhaps reloading was the cause, so I ran update.php again (I've read you shouldn't do that but I didn't know what to do).

I got no error warnings, just the update button, so I cliked on it.

Then I got a lots of warnings. Here they are:

    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT vid FROM node n WHERE t.nid = n.nid)' at line 1 query: UPDATE term_node t SET vid = (SELECT vid FROM node n WHERE t.nid = n.nid) in /homepages/xxx/htdocs/modules/system/system.install on line 1154.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT n.uid FROM node n WHERE files.uid = n.nid)' at line 1 query: UPDATE files SET uid = (SELECT n.uid FROM node n WHERE files.uid = n.nid) in /homepages/xxx/htdocs/modules/system/system.install on line 1954.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT r.nid FROM node_revisions r WHERE upload.vid = r.vid)' a query: UPDATE upload SET nid = (SELECT r.nid FROM node_revisions r WHERE upload.vid = r.vid) in /homepages/xxx/htdocs/modules/system/system.install on line 1955.
    * user warning: Duplicate entry '384-0' for key 1 query: ALTER TABLE locales_target ADD PRIMARY KEY (language, lid, plural) in /homepages/xxx/htdocs/includes/database.mysql-common.inc on line 374.
    * user warning: Duplicate entry '67-0' for key 1 query: ALTER TABLE term_node ADD PRIMARY KEY (tid, vid) in /homepages/xxx/htdocs/includes/database.mysql-common.inc on line 374.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT lid FROM locales_target)' at line 1 query: DELETE FROM locales_source WHERE lid NOT IN (SELECT lid FROM locales_target) in /homepages/xxx/htdocs/modules/locale/locale.install on line 144.

At the bottom of the page, one failure:

The following queries were executed
....
Update #6003

    * Failed: DELETE FROM {locales_source} WHERE lid NOT IN (SELECT lid FROM {locales_target})

Our LUG website is hosted by 1&1.

I hope you can help me! I'm not familiar with MySQL apart from creating databases on the command line. I don't even know how to upgrade manually as Drupal recommends when there are errors. Yet, I can find out, I suppose.

Many thanks in advance :-)

Comments

libre fan’s picture

Hell again,

I had a look at the website in off-line mode: it looks fine. Then I had a look at the /?q=admin/reports/status
I says: "MySQL database 4.0.27 Your MySQL Server is too old. Drupal requires at least MySQL 4.1.1" (I wish the message had been displayed on the update.php result page).

I got a message from 1&1 the other day saying they were upgrading their servers to Debian Etch (4.0), about time too as Debian 4.0 has been around for almost a year now. I can't remember when if the upgrade has already taken place. I see that Debian Etch has mysql-client 5.0, so 1&1 should be able to deliver.

I have just looked at 1&1 web site and they say the offer Mysql 5 but I've checked my db at 1&1: one is mysql 5 (a subdomain I made for testing Wordpress) and the two others are still Mysql 4.0.
Perhaps I should write to them to ask them to upgrade the main DB.

---
Libres-Ailé(e)s (Association for Linux and libre software) (France, Cévennes)

libre fan’s picture

Now I can no longer login as admin (user1)? .../?=user/ sends me back to the off-line page.
I was able to once but a day later I can't.

I know I can use the sql file I have on my DD but it's easier to copy an article or two from the actual web site.

perhaps I can't login because Mysql 4.0 is incompatible with Drupal 6?
---
Libres-Ailé(e)s (Association for Linux and libre software) (France, Cévennes)