https://www.icyphoenix.com/viewtopic.php?f=35&t=4141
-----------------------------------
roco
Wed 30 Apr, 2008 04:20

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
[/quote]


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

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 !!!! :D



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

Re: SOLVED - Could Not Add Download Traffic To User Account
-----------------------------------
Great you solved [b]roco[/b],

and thanks for sharing your solution.


