 | I am getting an error message whe trying to update my user profile |  |
 Posted: 04/04/2007 6:13 AM |
 |
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 6:19 AM
Location: Birmingham, UK.
|
|
|
|
|
 |
only just noticed this problem when trying to update my usercp
| Quote:
|
Could not update users table
DEBUG MODE
SQL Error : 1054 Unknown column 'games_block_pm' in 'field list'
UPDATE phpbb_users SET user_email = 'admin@djpassions.com', user_icq = '', user_website = 'http://www.djpassions.com', user_occ = '', user_from = 'Birmingham, UK.', user_interests = '', user_sig = 'www.djpassions.com www.djpassion.co.uk www.thetrancearena.com www.christopher-powell.co.uk www.myspace.com/chris_s_powell', user_sig_bbcode_uid = '69e481217a', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = 'christopher-powell@hotmail.com', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, games_block_pm = 0, user_popup_pm = 1, user_timezone = 0, user_dateformat = 'd M Y h:i a', user_lang = 'english', user_style = 1, user_active = 1, user_actkey = '' WHERE user_id = 2
Line : 531
File : usercp_register.php
|
Now I could try and remove this but something in the games mod depends on it so I suppose it's wise not to remove it but to just fix the problem instead or ill run into problems later on (I think) |
|
|
|
|
| Back to Top |
|
|
| Re: I am getting an error message whe trying to update my user profile | |
| Posted: 04/04/2007 7:31 AM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 6:19 AM
Location: Birmingham, UK.
|
|
|
|
|
|
|
|
|
|
| Back to Top |
|
|
| Re: I am getting an error message whe trying to update my user profile | |
| Posted: 04/04/2007 8:19 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:19 AM
Location: St Pete, FL
|
|
|
|
|
|
Ok, it appears that the Arcade author failed to include the addition of a field in the phpbb_users table. So I updated the table and the SQL query now works correctly in your Profile. You can use this to update your Live board database:
| Code:
|
|
ALTER TABLE phpbb_users ADD games_block_pm TINYINT(1) DEFAULT '0' NOT NULL;
|
 |
|
|
|
|
| Back to Top |
|
|
| Re: I am getting an error message whe trying to update my user profile | |
| Posted: 04/04/2007 8:27 AM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 6:19 AM
Location: Birmingham, UK.
|
|
|
|
|
|
Cool, cheers!
where/how do I add the above query ?
| Code:
|
|
ALTER TABLE phpbb_users ADD games_block_pm TINYINT(1) DEFAULT '0' NOT NULL;
|
|
|
|
|
|
| Back to Top |
|
|
| Re: I am getting an error message whe trying to update my user profile | |
| Posted: 04/04/2007 8:48 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:19 AM
Location: St Pete, FL
|
|
|
|
|
|
MySQL to PHP Converter
You can create a DB Update file that you can run in your browser by using the following utility. All you need to do is paste the SQL Code in the window, then press the Generate PHP Code button. It will ask where to save the file. You can then upload the file to your phpBB root folder and run it in your browser:
MySQL to PHP Converter
|
|
|
|
|
| Back to Top |
|
|
| Re: I am getting an error message whe trying to update my user profile | |
| Posted: 04/04/2007 9:13 AM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 6:19 AM
Location: Birmingham, UK.
|
|
|
|
|
|
Your good man... was easy 
Cheers |
|
|
|
|
| Back to Top |
|
|
| Re: I am getting an error message whe trying to update my user profile | |
| Posted: 04/04/2007 9:19 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:19 AM
Location: St Pete, FL
|
|
|
|
|
|
Yep, that's a good site to have bookmarked for future use. I use it a lot...
 |
|
|
|
|
| Back to Top |
|
|
| Re: I am getting an error message whe trying to update my user profile | |
| Posted: 04/04/2007 10:03 AM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 6:19 AM
Location: Birmingham, UK.
|
|
|
|
|
|
Bookmarked! I couldn't have figured out that this was the query I needed to run though. I'm not sure how you got this info
| Code:
|
|
ALTER TABLE phpbb_users ADD games_block_pm TINYINT(1) DEFAULT '0' NOT NULL;
|
|
|
|
|
|
| Back to Top |
|
|
| Re: I am getting an error message whe trying to update my user profile | |
| Posted: 04/04/2007 11:23 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 1:19 AM
Location: St Pete, FL
|
|
|
|
|
|
The error message told us that the missing field was games_block_pm and it belonged to the phpbb_users table. I guessed that it might be a boolean field, meaning that it would be assigned either 0 or 1, then I created the SQL query to add the field...
I have often used this utility to create db update files to run complex queries that EM couldn't handle. So in those cases, there is no need to create the query like I did above. You just have to copy and paste what was provided in the MOD into the utility then create the update file and run it from your browser. This utility has come in handy for me a lot of times...
I also use it to create DB Update files for people who are just learning and don't know their way around phpMyAdmin. It's easier to give them a file to run from their browser than to explain how to apply the queries in phpMyAdmin...
|
|
|
|
|
| Back to Top |
|
|
| Re: I am getting an error message whe trying to update my user profile | |
| Posted: 04/04/2007 11:30 AM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 6:19 AM
Location: Birmingham, UK.
|
|
|
|
|
|
Ok, wicked! Well I have all my posts here to come back to if I ever need to backtrack on the things I've gone through etc.
I just hope this site doesn't go down like phpbb 
Thanks again Nightrider |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
