iGoogle wont display

- open uddeim.php.
- goto line 2287 "SELECT id, name, username, password, usertype, block..."
- remove "usertype, ", so the SQL statement contains "SELECT id, name, username, password, block..." only.

Ooh you little darling slabbi, perfect, wonderful, now working.

Many many thanks.

Only the iGoogle to sort now

Slabbi

I have the same issue in the rss feeds direct access to the mailbox, also getting this error:

Error: 1054

Unknown column 'usertype' in 'field list' SQL=SELECT id, name, username, password, usertype, block FROM lcs9y_users WHERE username='Cliff'

I am trying to find the php file where this needs to be removed as well, but inst this something that can be fixed please? I am worried that there are more places that this is used that we haven't found yet.

** UPDATE: Can't find the file where I need to remove this for the RSS feed to work - please can you help?

Cheers

Cliff

The file uddeim.php mentioned above is stored in /components/com_uddeim

I managed to get the RSS feed to work by removing the "usertype" field from "includes.db.php" on line 1249 as follows

from
"$sql = "SELECT id, name, username, password, usertype, block FROM #__users WHERE username=". $database->Quote( $username );"

to "$sql = "SELECT id, name, username, password, block FROM #__users WHERE username=". $database->Quote( $username );"

Hope this is ok?

Cheers

Cliff

I have to check this but basically it should be ok.
When there is a problem with this solution I will come back to this.