Need help for some errors

[Pleasuree]

I get this error

UPDATE `core_groups` core_groups  SET `g_promote_exclude`=false,`g_displayname_unit`=0,`g_dname_date`=1,`g_signature_limits`='1:::::',`g_view_board`=true,`g_dohtml`=false,`g_search_flood`=3.0,`g_access_offline`=false,`g_hide_online_list`=false,`g_post_polls`=true,`g_vote_polls`=true,`g_close_polls`=false,`g_append_edit`=false,`g_avoid_flood`=false,`g_avoid_q`=false,`g_mod_preview`=false,`g_bypass_badwords`=false,`g_edit_posts`=1,`g_hide_own_posts`=0,`g_delete_own_posts`=0,`g_lock_unlock_own`=0,`g_can_report`=1,`g_view_displaynamehistory`=true,`g_edit_profile`=true,`g_upload_animated_photos`=true,`g_can_msg_attach`=true,`g_rep_max_positive`=1,`idm_view_approvers`=false,`idm_bypass_revision`=false,`idm_view_downloads`=false,`idm_linked_files`=false,`idm_import_files`=false,`idm_bulk_submit`=false,`idm_restrictions`='{"limit_sim":0,"daily_bw":0,"weekly_bw":0,"monthly_bw":0,"daily_dl":0,"weekly_dl":0,"monthly_dl":0,"min_posts":0}',`ms_can_bank`=false,`ms_deposit_cost`=0,`ms_daily_points`=0,`g_bitoptions`=28966944 WHERE g_id=3 
IPS\Db\Exception: Unknown column 'ms_daily_points' in 'field list' (1054)
#0 /home/1/mydomain.com/system/Db/Db.php(1150): IPS\_Db->preparedQuery('/*IPS\\core\\modu...', Array)
#1 /home/1/mydomain.com/system/Patterns/ActiveRecord.php(520): IPS\_Db->update('`core_groups` c...', '`g_promote_excl...', 'WHERE g_id=?')
#2 /home/1/mydomain.com/applications/core/modules/admin/members/groups.php(223): IPS\Patterns\_ActiveRecord->save()
#3 /home/1/mydomain.com/system/Dispatcher/Controller.php(85): IPS\core\modules\admin\members\_groups->form()
#4 /home/1/mydomain.com/applications/core/modules/admin/members/groups.php(34): IPS\Dispatcher\_Controller->execute()
#5 /home/1/mydomain.com/system/Dispatcher/Dispatcher.php(152): IPS\core\modules\admin\members\_groups->execute()
#6 /home/1/mydomain.com/admin/index.php(14): IPS\_Dispatcher->run()
#7 {main}

 

I'm using Members shop and when I try to change the group permissions (to disable the signatures for the normal members I get this)
My theme is blood gaming.

[rolandsaven]

Hello @Pleasuree,

I had a quick look at this application and the `my_daily_points` column was only introduced in version 1.0.5. So you mind be using an outdated version or Member Shop was not installed/upgraded properly.

This was also described in the following topic.

 

Edited October 27, 2020 by rolandsaven

[Pleasuree]

1 hour ago, rolandsaven said:

Hello @Pleasuree,

I had a quick look at this application and the `my_daily_points` column was only introduced in version 1.0.5. So you mind be using an outdated version or Member Shop was not installed/upgraded properly.

This was also described in the following topic.

 

Ty for the info mate, my version is 1.1.2 I think its the last ..

[Logan_Rocks]

Hello,

as @rolandsaven stated that application is causing it to throw errors. I suggest you disable it and see if that fixes it temporarily and contact the uploader to get the latest version. 

[rolandsaven]

After further checking, there is a bug in the app, so if you have gone through all the upgrades i.e. v1.0.0 -> v1.0.1 -> v1.0.2 and in particular hit v1.0.4 -> v1.0.5 then you would have the correct database. However, I assume you have gone the straight install of v1.1.2 route (which is the most obvious) which causes this issue. The developers have made a mistake of not including this column in the install script of the application and tbh it seems like they have missed a few other bits too. So I would not be surprised if there are other errors.

agree with @洛根 (๖̶̶̶ۣۣۜۜ͜ζ͜͡Logan)  get the latest version (if there is one at all) from the uploader that might fixes the issue.... but otherwise you have these options:

1. get a developer who looks at each upgrade script and fixes your database manually (each version contain all previous versions's upgrade script)
2. get a developer who can execute these upgrade scripts one by one (each version contain all previous versions's upgrade script)
3. try to get the earliest version (v1.0.4 or even v1.0.0 as there are few bugs I can see already) uninstall the app and install earliest, upgrade it with the latest you have (v1.1.2) - NOTE: This might cause data loss, so I recommend a backup of the db.

 

More detail on Invision's website for devs

https://invisioncommunity.com/developers/docs/development/applications/versions-and-upgrading-your-application-r51/

Quote

You will notice there is a special "install" version which can be used to specify queries which should be ran on install. Since on a fresh install, those are the only queries that are ran, it may be necessary to add a query both to the "install" special version, and to the version you're working with. For example, if you're working on version 1.0.1 and decide you want to add a column to the core_groups table that you didn't add in version 1.0.1, you would need to specify the query in both the 1.0.1 version (for people upgrading from 1.0.0) and the special "install" version (for new installs).

 

 

 

 

 

[Logan_Rocks]

The question(s) in this support topic have been answered and the topic author has resolved their issue. This topic is now closed. If you have other questions, please open a new topic.