Warning: The author of this contribution does not provide support for it anymore.

Ultimate Points

Bug breaking 3.0.8 update - Ultimate Points

Bug breaking 3.0.8 update

by naderman » Sat Nov 20, 2010 11:27 pm

There is a bug in this MOD causing trouble for people updating to 3.0.8. The updater for 3.0.8 uses user_add to add a new search bot. In that context $points_values is not initalised, so the code in user_add will incorrectly try to insert NULL rather than 0 into the user_points column. Since the user_points column is set to NOT NULL this causes a SQL error on updating.

To solve this you need to replace in functions_user.php

Code: Select all

if ( $config['points_enable'] )
with

Code: Select all

if ($config['points_enable'] && isset($points_values['reg_points_bonus']))
.
I appreciate gifts from my Amazon wishlist.
naderman.de twitter: @naderman
User avatar
naderman
Consultant
Consultant
Posts: 3735
Joined: Fri Aug 01, 2003 10:06 pm
Location: Berlin, Germany
Name: Nils Adermann
Contact:

Re: Bug breaking 3.0.8 update

by Schwpz » Sun Nov 21, 2010 10:45 am

This fixed my problems with updating to 3.0.8.
Thanks for sharing the fix :)
..:: PlanetZot.com - Your ultimate source for animation! ^^
Schwpz
Registered User
Posts: 335
Joined: Wed May 07, 2003 1:33 pm
Location: Planet Zot
Contact:

Re: Bug breaking 3.0.8 update

by keith10456 » Sun Nov 21, 2010 7:15 pm

Worked for me as well... Thank you!
User avatar
keith10456
Registered User
Posts: 2315
Joined: Thu Feb 24, 2005 6:55 pm
Contact:

Re: Bug breaking 3.0.8 update

by femu » Wed Nov 24, 2010 2:51 am

Hi Nils,

thanks very much for the fix! We are already working on the update for the UPS, but we didn't thought, that the new release of phpBB would come that fast ;-)

Kind regards,
Felix
Regards, femu
_____________________________________________
[My development page] - [My normal homepage (German only)]
femu
Registered User
Posts: 1070
Joined: Tue Sep 27, 2005 10:03 am

Re: Bug breaking 3.0.8 update

by stagezero » Sat Dec 18, 2010 7:54 am

thanks for the fix
stagezero
I've Been Banned!
Posts: 4
Joined: Sat Dec 18, 2010 7:31 am
Contact:

Re: Bug breaking 3.0.8 update

by redron007 » Fri Jan 28, 2011 5:21 pm

Hey guy, I found a bug in Ultimate Points that you get unlimited points for the same post.

1.)Submit a post,
2.)Wait to get point for the submitted post.
3.)Click back with the browser butyon and a "page cannot be displayed will appear"
4.)Press F5 to refresh the page, "popup window with a retry button appears" click the retry button
5.)When you return to the original post, click submit without entering any character and you will get double, triple ..... points for the same post.

can some one help me to fix this please

thanks in advanced for your expertise
redron007
Registered User
Posts: 1
Joined: Fri Jan 28, 2011 4:54 pm
Contact:

Re: Bug breaking 3.0.8 update

by Altered » Sun Feb 27, 2011 8:00 pm

I am trying to install the "Board3_Portal_AddOns" that came with Ultimate Points to 3.0.8 with Board3 Portal version 1.0.6 . This is what I get that I (the noob :oops: ) do not have the answer to.

File edits
portal/additional_blocks.php
Cannot locate file

styles/prosilver/portal/additional_blocks_right.html
Cannot locate file

styles/subsilver2/portal/additional_blocks_right.html
Cannot locate file


I see additional_blocks.php located at portal/block/additional_blocks.php . I do realize that the the Ultimate Points Lottery Block is for the Board3 Portal 1.0.4.

So can anyone help me, offer suggestions, or point me in the right direction.

Thank you to all the guys who make this stuff and offer it to people like me. :mrgreen: the Ultimate Points system installed great and seems to have no issues.
User avatar
Altered
Registered User
Posts: 23
Joined: Mon Dec 27, 2010 12:38 am
Location: Texas
Name: Steve
Contact:

Re: Bug breaking 3.0.8 update

by Schwpz » Sun Feb 27, 2011 8:10 pm

Seems like you uploaded the files in the wrong location.

You said the additional_blocks.php file is currently located at portal/block/additional_blocks.php
However, the first error message says that the script is expecting to find that file at portal/additional_blocks.php
(without the extra folder "block" between)

I suggest you go through the files you uploaded and make sure they are located in the right folders :)
..:: PlanetZot.com - Your ultimate source for animation! ^^
Schwpz
Registered User
Posts: 335
Joined: Wed May 07, 2003 1:33 pm
Location: Planet Zot
Contact:

Re: Bug breaking 3.0.8 update

by Altered » Mon Feb 28, 2011 6:09 am

I did not install the ones in question because they were one folder deeper than what was shown. That was my dilemma I didnt know if I should go into the extra folder "block" or what?

Or are you saying my install of board3 was messed up?
User avatar
Altered
Registered User
Posts: 23
Joined: Mon Dec 27, 2010 12:38 am
Location: Texas
Name: Steve
Contact:

Re: Bug breaking 3.0.8 update

by benmaya » Sun Apr 10, 2011 5:14 pm

I do have a problem when I try to update but when I try to edit function_user.php I can't find this piece of code. I don't even remember installing this mod. Is there a way to remove it?

this is the error I get:
SQL ERROR [ mysql4 ]

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

SQL

INSERT INTO phpbb_users (username, username_clean, user_password, user_pass_convert, user_email, user_email_hash, group_id, user_type, user_permissions, user_timezone, user_dateformat, user_lang, user_style, user_actkey, user_ip, user_regdate, user_passchg, user_options, user_new, user_inactive_reason, user_inactive_time, user_lastmark, user_lastvisit, user_lastpost_time, user_lastpage, user_posts, user_dst, user_colour, user_occ, user_interests, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_message_rules, user_full_folder, user_emailtime, user_notify, user_notify_pm, user_notify_type, user_allow_pm, user_allow_viewonline, user_allow_viewemail, user_allow_massemail, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_form_salt, user_points) VALUES ('Bing [Bot]', 'bing [bot]', '', 0, '', '00', '30', 2, '', 0, 'D M d, Y g:i a', 'he', '3', '', '', 1302439263, 1302439263, 230271, 0, 0, 0, 1302439263, 0, 0, '', 0, 1, '9E8DA7', '', '', '', 0, 0, 0, 0, 0, 0, 0, -3, 0, 0, 1, 0, 1, 1, 1, 0, '', '', '', '2924d8f9e95194dd', '0.0')

BACKTRACE



FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 251
CALL: dbal_mysql->sql_query()

FILE: install2/database_update.php
LINE: 1781
CALL: user_add()

FILE: install2/database_update.php
LINE: 398
CALL: change_database_data()
benmaya
Registered User
Posts: 8
Joined: Mon Mar 28, 2011 9:04 am
Contact:

Re: Bug breaking 3.0.8 update

by JustWdoWit » Tue May 17, 2011 6:25 am

Do you have to install this fix even if you don't have updated?

I mean, when I install a fresh Phpbb3 3.0.8, then I am not updating?!

Might be the case my site crashed of this mod.
JustWdoWit
Registered User
Posts: 20
Joined: Sat May 07, 2011 5:26 am
Contact:

Re: Bug breaking 3.0.8 update

by Akshay2598 » Sun Jul 17, 2011 10:42 pm

how do you even update to 3.0.8. You guys should updateas the pages and posts this is so confusing which is why im hesitating to install this MOD
Akshay2598
Registered User
Posts: 241
Joined: Tue Jun 21, 2011 5:35 pm
Contact:

Re: Bug breaking 3.0.8 update

by Groundy » Wed Apr 04, 2012 8:58 pm

Does this work with 3.0.10 yet ?
Man Utd Forum

The one stop site for United fans
Groundy
Registered User
Posts: 307
Joined: Tue Dec 08, 2009 5:05 pm
Contact: