Hi, good morning.
I've updated our development system to 2.4_Beta this morning. When updating any of the values in the existing Entities I get the following error produced (I've replaced sensitive information with XXXX):
"Database Error: 1054 - Unknown column 'date_updated' in 'field list'
Query: update app_entity_30 set field_286 = '0', field_410 = '161', field_259 = '153', field_418 = '', field_287 = '', field_262 = '', field_394 = '', field_288 = '', field_263 = '', field_264 = '', field_393 = '247', field_265 = '1537225200', field_256 = XXXX', field_266 = '0', field_376 = 'XXXX', field_267 = '0', field_380 = '[map]53.49358,-2.5556(XXX)[/map]', field_377 = 'XXX', field_269 = '0', field_378 = '0192679435', field_270 = '', field_271 = '', field_255 = '1539704400', field_258 = '61180', field_272 = '', field_273 = '', field_435 = '91', field_416 = '', field_411 = '', field_276 = '126', field_252 = 'XXX', field_254 = 'XXX ', field_268 = 'XX', field_257 = 'XXX', field_415 = '', field_408 = '1539868500', field_253 = '', field_412 = '', field_275 = '', field_373 = '', field_379 = '', field_413 = '', field_414 = '', field_422 = '', date_updated = '1547033041' where id='328'
Page: /Rukovoditel_2.4_Beta/index.php?module=items/&action=save&id=328"
If I try to add a record I get the following error:
"Database Error: 1146 - Table 'DEV_CCTVPM.app_ext_subscribe_rules' doesn't exist
Query: select r.*, m.module from app_ext_subscribe_rules r, app_ext_modules m where r.entities_id='30' and r.contact_email_field_id>0 and length(contact_list_id)>0 and m.id=r.modules_id and m.is_active=1
Page: /Rukovoditel_2.4_Beta/index.php?module=items/&action=save"
Is this anything that anyone has come across? I'd like to upgrade our primary system from 2.3 to 2.4, but as I'm not a PHP expert I'm hesitant to do so.
Many thanks in advance
Error when updating a field or adding a new value
-
- Posts: 227
- Joined: 24 Sep 2018, 23:22
- Name: Stuart B
- Location: Manchester UK
- support
- Site Admin
- Posts: 6222
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Error when updating a field or adding a new value
You did not update database. See instruction https://blog.rukovoditel.net/rukovoditel-2-4-beta/
Run /install/autoupdate/from_2.3_to_2.4.php (It means you have to open in browser like this [your site]/install/autoupdate/from_2.3_to_2.4.php)
If you are using Extension then run /install/ext_autoupdate/from_2.3_to_2.4.php
Run /install/autoupdate/from_2.3_to_2.4.php (It means you have to open in browser like this [your site]/install/autoupdate/from_2.3_to_2.4.php)
If you are using Extension then run /install/ext_autoupdate/from_2.3_to_2.4.php
-
- Posts: 227
- Joined: 24 Sep 2018, 23:22
- Name: Stuart B
- Location: Manchester UK
Re: Error when updating a field or adding a new value
Hi and thanks for the reply so quickly. I'm pretty sure I did update, but I'll have another go and let you know if the same thing is happening.
Thanks again
Thanks again
-
- Posts: 227
- Joined: 24 Sep 2018, 23:22
- Name: Stuart B
- Location: Manchester UK
Re: Error when updating a field or adding a new value
So, I ran the updates as described. Running the first one produced an error saying:
"Rukovoditel | Database Auto Update from 2.3 to2.4
Processing...
DROP FUNCTION IF EXISTS rukovoditel_hours_diff 1370 alter routine command denied to user 'DEV_CCTVPM'@'localhost' for routine 'DEV_CCTVPM.rukovoditel_hours_diff'"
Refreshing the page shows me the normal login page. Running the Extension update went smoothly and I'm able to then login and access the system and all the data.
However, when I then try to update any of the records, I still get the Database Error: 1054 - Unknown column 'date_updated' in 'field list'.
If I roll-back to V2.3.1 then the error doesn't happen, but that obviously means I can't take advantage of the updates and bug-fixes.
Thanks again for the assistance with this. Sorry if it's a bit vague. If you need anything else then I'll try and help as best I can
Thanks
"Rukovoditel | Database Auto Update from 2.3 to2.4
Processing...
DROP FUNCTION IF EXISTS rukovoditel_hours_diff 1370 alter routine command denied to user 'DEV_CCTVPM'@'localhost' for routine 'DEV_CCTVPM.rukovoditel_hours_diff'"
Refreshing the page shows me the normal login page. Running the Extension update went smoothly and I'm able to then login and access the system and all the data.
However, when I then try to update any of the records, I still get the Database Error: 1054 - Unknown column 'date_updated' in 'field list'.
If I roll-back to V2.3.1 then the error doesn't happen, but that obviously means I can't take advantage of the updates and bug-fixes.
Thanks again for the assistance with this. Sorry if it's a bit vague. If you need anything else then I'll try and help as best I can
Thanks
- support
- Site Admin
- Posts: 6222
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: Error when updating a field or adding a new value
Load attached file to /install/autoupdate/ and run it.
It should fix issue with date updated field.
It should fix issue with date updated field.
- Attachments
-
- from_2.3_to_2.4_custom.php
- (1.72 KiB) Downloaded 163 times
-
- Posts: 227
- Joined: 24 Sep 2018, 23:22
- Name: Stuart B
- Location: Manchester UK
Re: Error when updating a field or adding a new value
That seems to have done the trick - thank you so much!
I'd be interested to know what it was that was wrong (if it isn't too technical!)
Also, I've noticed during a 'fresh' install, if I try to install the system to a folder with any other name than "Rukovoditel_X.X" then this causes problems.
It's possible to install the system with this folder name and then re-name it once everything is in place and this seems to be OK.
Anyway, thanks again for your swift assistance.
All the best
I'd be interested to know what it was that was wrong (if it isn't too technical!)
Also, I've noticed during a 'fresh' install, if I try to install the system to a folder with any other name than "Rukovoditel_X.X" then this causes problems.
It's possible to install the system with this folder name and then re-name it once everything is in place and this seems to be OK.
Anyway, thanks again for your swift assistance.
All the best