SOLVED - Could Not Add Download Traffic To User Account


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.

Profile PM  
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 !!!! :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.

Profile PM  
Subject: Re: SOLVED - Could Not Add Download Traffic To User Account
Great you solved roco,

and thanks for sharing your solution.

Profile PM  

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.3214s (PHP: 5% SQL: 95%)
SQL queries: 10 - Debug Off - GZIP Enabled