Profile Error

[Justin]

I get this error on my forum when I try to edit my profile:
General Error
SQL ERROR [ mysqli ]

Unknown column 'user_ipr' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Please help.

 

[Nathan]

For some reason "user_ipr" is in your phpBB's DB, ive never seen that column in a phpBB DB before, what mods have you got installed?

Also search your DB for "user_ipr" and tell us which table it's in.

 

[Justin]

I have a lot of mods mate, that might take a while.

One might be the Social Networking buttons that is affiliated with the profile..

checking DB now..

 

[Justin]

Found:
1 match(es) inside table forum_posts

Only one

 

[Nathan]

Alright lemme correct that, mods that require you to do SQL changes/addition or used UMIL.

Edit: Browse it, is there anything inside?

 

[Justin]

Ah it has to do with Ultimate Points. I see now, thanks!

I saw it brining up points in the browsing.

Thanks 😀

 

[Justin]

Not solved: I get this after submitting in board prefrences:
General Error
SQL ERROR [ mysqli ]

Unknown column 'user_ipr' in 'field list' [1054]

SQL

UPDATE forum_users SET user_allow_pm = 1, user_allow_viewemail = 1, user_allow_massemail = 1, user_allow_viewonline = 1, user_notify_type = '0', user_notify_pm = 1, user_ipr = 0, user_options = '895', user_dst = 0, user_dateformat = 'D M d, Y g:i a', user_lang = 'en', user_timezone = 0, user_style = '4' WHERE user_id = 2

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/ucp/ucp_prefs.php
LINE: 110
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: ucp_prefs->main()

FILE: ucp.php
LINE: 320
CALL: p_master->load_active()

 

[Nathan]

"user_ipr" seems to be causing all the problems, ive got UPS installed myself and have not got that field, are you sure it's meant to be there, as im not sure that it is...

 

[Justin]

Hmm, I will delete the sql and see what that does.

 

[Nathan]

Back up your DB first.

 

[Justin]

Ok.

 

[Justin]

Interesting, it cant find it anymore :\

 

[Nathan]

Did you delete it? Or it just can't find it when you do a search?

 

[Justin]

I have not deleted it. It is just gone.

 

[Nathan]

Alright well see if you get the errors or not :great:

 

[Justin]

I do 😛

 

[Nathan]

Try searching it again, if you get the same error then it'll be there :lol:

 

[Justin]

Nada, not in any.

 

[Nathan]

And you still do get the same error? :shrug:

 

[Matteo]

The problem you are getting is caused by the Instant Post Redirect MOD

You should try running the following SQL Query and then see if the problem still persists.

ALTER TABLE phpbb_users ADD user_ipr INT(1) UNSIGNED NOT NULL DEFAULT '0';

If you don't know how to run an SQL Query I'll explain for you. Go into cPanel, scroll down to databases area, click on phpMyAdmin, new window will open up, on left side you will see a list of all your databases, click the name of whatever database your phpBB3 installation is using, then some stuff will open up on the right side, at the top of the right side you'll see some tabs, click the SQL tab and in the big white text area past the code I provided above and then click on the "Go" button. It should say SQL query executed successfully. That's it.

Let us know how it goes.