Icy Phoenix

Old Support Topics - SOLVED - Could Not Add Download Traffic To User Account

roco [ Wed 30 Apr, 2008 04:20 ]
Post subject: SOLVED - Could Not Add Download Traffic To User Account

Quote:
Could not add download traffic to user account

DEBUG MODE

SQL Error : 1054 Unknown column 'user_traffic' in 'field list'

UPDATE ip_users SET user_traffic = user_traffic + 524288 WHERE user_id = 35

Line : 420
File : functions_post.php

Can anybody gives me the line to add this field ??

I have recently updated and ran the update file but, there are SOME (not all ) missing changes on DB i have to enter manually.

roco [ Wed 30 Apr, 2008 06:28 ]
Post subject: Re: SOLVED - Could Not Add Download Traffic To User Account

FOUND SOLUTION ON ANOTHER FORUM !!!!

Just this

ALTER TABLE phpbb_users ADD COLUMN user_traffic BIGINT(20) DEFAULT '0' NOT NULL;

Now the forums seems working OK !!!!

Seems that lots of ppls who upgraded from xs or phpbb are having trouble with the icy updater, and some tables need to be entered manually.

TheSteffen [ Sat 10 May, 2008 09:50 ]
Post subject: Re: SOLVED - Could Not Add Download Traffic To User Account

Great you solved roco,

and thanks for sharing your solution.