By mrmachine on

i upgraded a few weeks ago to drupal 4.6.3 and i am no longer able to add users. well, i get sent an email telling me someone has applied for a user account, but when i go to activate it i get this error:

Cannot modify header information - headers already sent by (output started at /home/machine/public_html/blog/includes/common.inc:384) in /home/machine/public_html/blog/includes/common.inc on line 192.

although it says that the action succeeded when i then browse to my homepage, when i got the user administration section, it lists no users (well, apart from me and a few others who have tried to sign up in this manner, there is no one else). it also prints this error at the top of the page:

user error: Unknown column 'u.changed' in 'field list'
query: SELECT u.uid, u.name, u.status, u.changed FROM users u WHERE uid != 0 ORDER BY  u.changed DESC LIMIT 0, 50 in /home/machine/public_html/blog/includes/database.mysql.inc on line 66.

i'm pretty sure these problems are from a previous upgrade that was a bit wonky, rather than the upgrade from 4.6.2 to 4.6.3, and that it's something to do with the database (duh!) - but can someone give me some pointers (hopefully not involving a total re-install).

shayne

Comments

mrmachine’s picture

mrmachine commented

*bump*

anyone have any idea? it would be good to be able to add users. tis one of the main points of drupal, is it not?

http://www.machinehasnoagenda.com

Dublin Drupaller’s picture

Dublin Drupaller commented

Hi Mrmachine..

I had the same error before after importing a load of users into drupal.

the reason I was getting the error was because you have to update the sequences table when importing "manually" so to speak.

i.e. go to the SEQUENCES table in your database and make sure the last UID matches the last UID of the users you imported.

More info at this thread discussing a step-by-step bulk users import

Hope that makes sense..and is of use.

Dub

Currently in Switzerland working as an Application Developer with UBS Investment Bank...using Drupal 7 and lots of swiss chocolate

mrmachine’s picture

mrmachine commented

hey dub,

sorry for the delay in responding, but my server and site were down for some time.

i checked the sequences table, and the UIDs match up ... should i maybe run that php script in the link you posted in any case?

http://www.machinehasnoagenda.com

mrmachine’s picture

mrmachine commented

anyone else with ideas on this?

http://www.machinehasnoagenda.com

pamphile’s picture

pamphile commented

I had the same problem... with a beta website... I deleted users and started over. totally unacceptable on a live site though - hehe

The issue was solved when I made sure the sequences were in synch.

See how a new drupal installation sequences and user ids match up.

Marcel
http://businessletter.com