Bug Recalculate Points Bug

[Zoul]

Hello there



I modified some statistical criteria last night and so I wanted to recalculate the points.



The problem is that research is long and finished on an error
The program was originally with just the translation
I just reinstall the program without translation morning and the problem persists

**********
in cpadmin
**********
Internal Server Error
The server Encountered internal error or misconfiguration year and Was Unable to complete your request.

Please Contact the server administrator to inform of the time the error occurred and of anything you might-have-have done that May Caused the error.

More information about this error May Be available in the server error log.

*******
in member profiles
*******
Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT
totalpoints,activitylevel,albumpictures,attachments,post,post_own,thread,threadrating,threadratingreceived,vmgiven,vmreceived,pollposted,pollvote,friend,givenrep,gottenrep,infractiongiven,infractionreceived,referral,sgmessage,sgdiscussion,calendarevent,dayregistered,blogpost,blogcomment,shout,mentionsgiven,mentionsreceived,tagsgiven,tagsreceived,profilecomplete,contestswon,dbgalleryupload
FROM dbtech_vbactivity_points
WHERE userid = '2'
LIMIT 1;

MySQL Error : Unknown column 'totalpoints' in 'field list'
Error Number : 1054

*******

most disturbing is that all member profiles are error now ...

edit: I deactivated the hack to retrieve the profiles.

 

[Fillip H.]

This issue has been resolved in v3.1.8. If you continue to experience this issue, please re-download & re-upload the mod, then edit the product on your server and set it to 3.1.7, then re-import the XML file (which should not be modified in any way).

 

[Zoul]

Hello Fillip H.

I download the program again
everything installed
imported the xml 3.1.8 (the bug is still)
imported the xml 3.1.7 (still the bug too)

*****
in admincp
*****
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.

More information about this error may be available in the server error log.



*****
in profil
*****

Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT
totalpoints,activitylevel,albumpictures,attachments,post,post_own,thread,threadrating,threadratingreceived,vmgiven,vmreceived,pollposted,pollvote,friend,givenrep,gottenrep,infractiongiven,infractionreceived,referral,sgmessage,sgdiscussion,calendarevent,dayregistered,blogpost,blogcomment,shout,mentionsgiven,mentionsreceived,tagsgiven,tagsreceived,profilecomplete,contestswon,dbgalleryupload
FROM dbtech_vbactivity_points
WHERE userid = '1'
LIMIT 1;

MySQL Error : Unknown column 'totalpoints' in 'field list'
Error Number : 1054






Do you have another idea?

 

[Zoul]

Hello Fillip H.

So I managed to install the program without this bug.

TYVM

 

[Zoul]

Hello Balazor

So I vbactivity that works
I do not have member profiles in error

nevertheless I still can not update the points
I still have an error

*****
in admincp
*****
Calcul des points...
Traitement : 1
totalpoints
activitylevel
albumpictures
attachments
attachmentviews
post
post_own
thread
threadrating
threadratingreceived
vmgiven
vmreceived
pollposted
pollvote
friend
givenrep
gottenrep
infractiongiven
infractionreceived
referral
sgmessage
sgdiscussion
Database Error Database error
The GFX-Art database has encountered a problem.
Please try the following:

Load the page again by clicking the Refresh button in your web browser.
Open the gfx-art.eu home page, then try to open another page.
Click the Back button to try another link.

The gfx-art.eu forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

____________________________________________

Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT *
FROM discussion AS discussion
LEFT JOIN groupmessage AS gm ON(gm.gmid = discussion.firstpostid)
WHERE 1=1
AND discussion.dateline >= 1404165600 AND postuserid = 1;

MySQL Error : Unknown column 'discussion.dateline' in 'where clause'
Error Number : 1054
Request Date : Wednesday, August 20th 2014 @ 08:24:05 PM
Error Date : Wednesday, August 20th 2014 @ 08:26:57 PM
Script : Se connecter - GFX-Art - vBulletin Panneau d'administration
Referrer : Se connecter - GFX-Art - vBulletin Panneau d'administration
IP Address : XXXXXXXXXXXXXXXXXXX
Username : Zoul
Classname : vB_Database
MySQL Version : XXXXXXXXXXXXXXX

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 473
#2 vB_Database->query_read_slave() called in [path]/dbtech/vbactivity/includes/class_core.php on line 2877
#3 vBActivity_Database->query() called in [path]/dbtech/vbactivity/includes/class_core.php on line 2652
#4 vBActivity_Database->fetchAllObject() called in [path]/dbtech/vbactivity/type/sgdiscussion.php on line 45
#5 vBActivity_Type_sgdiscussion->recalculate_points() called in [path]/dbtech/vbactivity/actions/admin/maintenance.php on line 133
#6 include_once([path]/dbtech/vbactivity/actions/admin/maintenance.php) called in [path]/admincp/vbactivity.php on line 83


Have you any idea?

 

[Fillip H.]

I've uploaded a potential hotfix to /dbtech/vbactivity/type/sgdiscussion.php