The view_3 property does not exist in the Item_Model class - Possibly solved

So I have seen a few people report this issue, a while ago, but no real resolutions, or ideas on why it happened (that I could see).

My configuration is going to be 'difficult'
I am upgrading to a new server, AND upgrading to gallery3 at the same time.

So server1, had the http and database on the same machine.
Server2, has the database and http on different machines.

I have installed G3 rpm on Centos, and done the update within the admin GUI.
I then immediately went to modules, added the G2 import module.
I have mounted using NFS the two directories used for G2 on server1, onto the correct areas on server2 (I will be using different directories eventually).
I have modified the SQL service for server1 so that server3 can now authenticate using the correct credentials.

Going to the G2 import module, I get the option to select the place of embed.php
Then:
---
Gallery version 2.3 detected
Your most common thumbnail size in Gallery 2 is 150 pixels, but your Gallery 3 thumbnail size is set to 200 pixels. Using the same value will speed up your import.
Your Gallery 2 has the following importable data in it: 16 users, 4 groups, 234 albums, 19500 photos/movies, 1 comment, 17 tagged photos/movies/albums
---

When I go to import.....
---
The view_3 property does not exist in the Item_Model class
---
If I attempt to import again, it recognises the users and groups. It also attempts to re-import the first album, and then it does again.

So where do I start to look? At the gallery2 database? I can't see a view_3. In the G3 database, I see a view_2, but that is a table schema.
The G2 server is 2.3-14, unfortunately rpm updates are no longer available for that system. Don't particularly want to do a source code update if I can avoid it.

Looks like for some reason the mysql_setpermissions I was using, whilst pretending to grant full permissions, didn't

Log into the mysql server as the admin user, and run:

update db set alter_priv="y" where user="<gallery user>";
flush privileges;

This appears to add the alter privilege which was missing.

The import is now progressing further (and taking somewhat longer)

Possibly it would be wise for the gallery installer to check that the correct permissions exist for the database user. I don't think this should be too difficult?

I think something like the following would probably do (bit of a hack, the regular expression could do with some extra work, but it is better than the nothing there currently is!), but where to put it.....

 <?php

$server="";
$user="";
$pass="";
$db="";

#pass
$privs=array("ALTER","SELECT","UPDATE","DELETE","CREATE","DROP");
#fail
$privs=array("ALTER","SELECT","UPDATE","DELETE","CREATE","DROP","Notthere");

$link=mysql_connect($server, $user, $pass);
mysql_select_db($db);
$query="Show grants";
$fails=array();
$found=0;
if($result=mysql_query($query)){
        $found=1;
        while($row=mysql_fetch_array($result)){
                if(preg_match("/SELECT/",$row[0])){
                        foreach($privs as &$privilege){
                                if(!preg_match("/$privilege/",$row[0])){
                                        $found=0;
                                        array_push($fails,$privilege);
                                }else{
                                        #We don't really need to test here
                                }
                        }
                }
        }
        if(1==$found){
                echo "All privileges have been checked and are OK\n<br>";
        }else{
                echo "Some privileges are missing for this user\n<br>The following extra privileges are required:\n<br>";
                foreach($fails as $failure){
                        echo "$failure\n<br>";
                }
        }
}else{
        echo "Could not connect to the database to check privileges\n<br>";
}
?>