#3610 - Error after install – Composr CMS: Your Data, Your Privacy, Your Control

Identifier	#3610
Issue type	Feature request or suggestion
Title	Error after install
Status	Completed
Handling member	Chris Graham
Addon	core_cns
Description	New install on an MSN and I got this error: Unfortunately a query has failed [UPDATE boss_f_member_custom_fields SET field_2__text_parsed='' WHERE field_2__text_parsed<>''] [Unknown column 'field_2__text_parsed' in 'where clause'] (version: 10.0.15, PHP version: 5.6.30, URL: /forum/index.php?page=forumview) Stack: http://mcajunction.com/error3.htm
Steps to reproduce
Funded?	No

By Guest posted 12th May 2018, 2:38 PM

All sites have to have the same setting for Support content translations, it's up to you to check that as the installer won't.

By Guest posted 20th May 2018, 7:32 PM

Updated stack below. Somehow the stack link above no longer works.

File '/home3/joe2209/mca0.com/sources/failure.php'
Line 968
Function 'get_html_trace'
Args
File '/home3/joe2209/mca0.com/sources/global2.php'
Line 1,019
Function '_fatal_exit'
Args

Tempcode -> Unfortunately a query has failed [UPDATE boss_f_member_custom_fields SET field_2__text_parsed='' WHERE field_2__text_parsed<>''] [Unknown column 'field_2__text_parsed' in 'where clause']
File '/home3/joe2209/mca0.com/sources/database/mysqli.php'
Line 258
Function 'fatal_exit'
Args

Tempcode -> Unfortunately a query has failed [UPDATE boss_f_member_custom_fields SET field_2__text_parsed='' WHERE field_2__text_parsed<>''] [Unknown column 'field_2__text_parsed' in 'where clause']
File '/home3/joe2209/mca0.com/sources/database.php'
Line 1,717
Function 'db_query'
Class 'Database_Static_mysqli'
Object O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:2:{s:50:"a:2:{i:0;s:12:"joe2209_mca0";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}s:48:"a:2:{i:0;s:10:"joe2209_bl";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}}s:14:"last_select_db";a:2:{i:0;r:23;i:1;s:10:"joe2209_bl";}s:16:"reconnected_once";b:0;}
Type '->'
Args

'UPDATE boss_f_member_custom_fields SET field_2__text_parsed='' WHERE field_2__text_parsed<>'''

array

NULL

NULL

false

false

false

false
File '/home3/joe2209/mca0.com/sources/database.php'
Line 1,490
Function '_query'
Class 'DatabaseConnector'
Object O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:5:"boss_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:10:"joe2209_bl";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:10:"joe2209_bl";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:0:{}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:2:{s:50:"a:2:{i:0;s:12:"joe2209_mca0";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}s:48:"a:2:{i:0;s:10:"joe2209_bl";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:10:"joe2209_bl";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type '->'
Args

'UPDATE boss_f_member_custom_fields SET field_2__text_parsed='' WHERE field_2__text_parsed<>'''

NULL

NULL

false

false

NULL

''
File '/home3/joe2209/mca0.com/sources/caches3.php'
Line 185
Function 'query'
Class 'DatabaseConnector'
Object O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:5:"boss_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:10:"joe2209_bl";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:10:"joe2209_bl";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:0:{}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:2:{s:50:"a:2:{i:0;s:12:"joe2209_mca0";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}s:48:"a:2:{i:0;s:10:"joe2209_bl";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:10:"joe2209_bl";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type '->'
Args

'UPDATE boss_f_member_custom_fields SET field_2__text_parsed='' WHERE field_2__text_parsed<>'''
File '/home3/joe2209/mca0.com/sources/caches3.php'
Line 54
Function 'erase_comcode_cache'
Args
File '/home3/joe2209/mca0.com/sources/global2.php'
Line 420
Function 'auto_decache'
Args

true
Function 'init__global2'
Args
File '/home3/joe2209/mca0.com/sources/global.php'
Line 302
Function 'call_user_func'
Args

'init__global2'
File '/home3/joe2209/mca0.com/sources/global.php'
Line 782
Function 'require_code'
Args

'global2'
File '/home3/joe2209/mca0.com/index.php'
Line 73
Args

'/home3/joe2209/mca0.com/sources/global.php'
Function 'require'

By Guest posted 1st Jun 2018, 3:43 PM

Sorry for the long delay. Please try the latest sources/database.php out of git.

https://raw.githubusercontent.com/ocproducts/composr/master/sources/database.php

The problem is that the CPF fields are set up differently on the sites, and the satellite sites need to be considering the CPF database structure from the central site (local structure is irrelevant as it's not even used). This changes pulls in the database structure from the central site in addition to the satellite structure, and gives it precedence.

By Guest posted 3rd Jun 2018, 11:29 AM

Notice: Undefined index: FORUM_DB in /home1/joe2209/mcajunction.com/sources/database.php on line 162

Fatal error: Call to a member function query() on null in /home1/joe2209/mcajunction.com/sources/database.php on line 162

By Guest posted 4th Jun 2018, 5:26 PM

Yeah, sorry it was more complex than I realised.

I have fixed in https://github.com/ocproducts/composr/commit/ac78ad87af98428a184f9cda7ba64d50d0472535and
then in https://github.com/ocproducts/composr/commit/dd881da32b83304b500953f3c853a437aba963f9

And this was tested on a real MSN set up.

There will be a new patch release soon.

By Guest posted 5th Jun 2018, 6:07 AM

Fatal error: Call to undefined function has_solemnly_declared() in /home1/joe2209/mca0.com/sources/database.php on line 244

By Guest posted 5th Jun 2018, 6:15 AM

For some reason (even after the changes), my global2.php and database.php had less lines than the files on Github. I downloaded a fresh copy from Github and it's still giving me the same error, only now that function is on line 249.

By Guest posted 5th Jun 2018, 6:22 AM

Not sure if it matters, but this error is only shown on the MSN's. The main site doesn't seem to be affected.

By Guest posted 6th Jun 2018, 3:09 PM

My test site was on dev-mode which was blocking this issue showing. I've fixed in:

https://github.com/ocproducts/composr/commit/5466ffdf1b0b74152d7ec4be8151992af0285b70

(it's a one line change)

Hope this finally works for you!

By Guest posted 20th Jul 2018, 11:57 PM

Chris,

Despite this error supposedly being fixed, it does seem to show in one last place.

Before the error was global and I couldn't get rid of it. Now it's only showing after clearing the catches. It doesn't seem to be negatively impacting me or keeping from my clearing the catches, it just shows up afterwards.

I took some time off so I haven't been working on my site lately. No changes were made since I left. I also confirmed the edits in global2.php and database.php, everything seems up-to-date.

Please let me know if I should concern myself with this.

On a second note, your bug tracker has some textual errors when clicking the "reopen" button and adding a note. I've noticed it many times before but just thought it wasn't appropriate to add irrelevant info inside my issue reports. However, I see it still persists so maybe it hasn't been brought to your attention yet.

"APPLICATION WARNING #300: String "non-assigned_bug_title" not found."

I'll attach a screenshot for you as well.

By Guest posted 20th Jul 2018, 11:57 PM

By Guest posted 21st Jul 2018, 12:00 AM

By Guest posted 5th Aug 2018, 8:52 AM

Chris, here's an update:

I reinstalled everything, yet again. I started off fresh - new database, new files. This time I went directly to v10.0.18 (my last post was when I was using v10.0.17).

(On a side note, check into the automatic extractor for version 10.0.18, it gave me some errors that I cannot really recall during step2 of the install so I had to download Composr's full archive and extract the files manually. If you can't reproduce this let me know I'll try it again on a test site.)

Now we're back to square one with the original error message showing globally. I don't understand why because your fixes to database.php and global2.php are still intact. Somewhere along the line from v10.0.17 to 18 is where the problem lies, or so I would think.

Here's your stack:

File '/home1/joe2209/mca0.com/sources/failure.php'
Line 974
Function 'get_html_trace'
Args
File '/home1/joe2209/mca0.com/sources/global2.php'
Line 1,037
Function '_fatal_exit'
Args

Tempcode -> Unfortunately a query has failed [UPDATE mcaj_f_member_custom_fields SET field_2__text_parsed='' WHERE field_2__text_parsed<>''] [Unknown column 'field_2__text_parsed' in 'where clause']
File '/home1/joe2209/mca0.com/sources/database/mysqli.php'
Line 258
Function 'fatal_exit'
Args

Tempcode -> Unfortunately a query has failed [UPDATE mcaj_f_member_custom_fields SET field_2__text_parsed='' WHERE field_2__text_parsed<>''] [Unknown column 'field_2__text_parsed' in 'where clause']
File '/home1/joe2209/mca0.com/sources/database.php'
Line 1,742
Function 'db_query'
Class 'Database_Static_mysqli'
Object O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:2:{s:50:"a:2:{i:0;s:12:"joe2209_mca0";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}s:50:"a:2:{i:0;s:12:"joe2209_mcaj";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}}s:14:"last_select_db";a:2:{i:0;r:23;i:1;s:12:"joe2209_mcaj";}s:16:"reconnected_once";b:0;}
Type '->'
Args

'UPDATE mcaj_f_member_custom_fields SET field_2__text_parsed='' WHERE field_2__text_parsed<>'''

array

NULL

NULL

false

false

false

false
File '/home1/joe2209/mca0.com/sources/database.php'
Line 1,515
Function '_query'
Class 'DatabaseConnector'
Object O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:5:"mcaj_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:12:"joe2209_mcaj";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:12:"joe2209_mcaj";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:0:{}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:2:{s:50:"a:2:{i:0;s:12:"joe2209_mca0";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}s:50:"a:2:{i:0;s:12:"joe2209_mcaj";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:12:"joe2209_mcaj";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type '->'
Args

'UPDATE mcaj_f_member_custom_fields SET field_2__text_parsed='' WHERE field_2__text_parsed<>'''

NULL

NULL

false

false

NULL

''
File '/home1/joe2209/mca0.com/sources/caches3.php'
Line 185
Function 'query'
Class 'DatabaseConnector'
Object O:17:"DatabaseConnector":8:{s:12:"table_prefix";s:5:"mcaj_";s:15:"connection_read";a:2:{i:0;O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}i:1;s:12:"joe2209_mcaj";}s:16:"connection_write";a:2:{i:0;r:4;i:1;s:12:"joe2209_mcaj";}s:26:"text_lookup_original_cache";a:0:{}s:17:"text_lookup_cache";a:0:{}s:18:"table_exists_cache";a:0:{}s:9:"static_ob";O:22:"Database_Static_mysqli":3:{s:8:"cache_db";a:2:{s:50:"a:2:{i:0;s:12:"joe2209_mca0";i:1;s:9:"localhost";}";O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"client_info";N;s:14:"client_version";N;s:13:"connect_errno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:"error";N;s:10:"error_list";N;s:11:"field_count";N;s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s:11:"server_info";N;s:14:"server_version";N;s:4:"stat";N;s:8:"sqlstate";N;s:16:"protocol_version";N;s:9:"thread_id";N;s:13:"warning_count";N;}s:50:"a:2:{i:0;s:12:"joe2209_mcaj";i:1;s:9:"localhost";}";r:4;}s:14:"last_select_db";a:2:{i:0;r:4;i:1;s:12:"joe2209_mcaj";}s:16:"reconnected_once";b:0;}s:11:"dedupe_mode";b:0;}
Type '->'
Args

'UPDATE mcaj_f_member_custom_fields SET field_2__text_parsed='' WHERE field_2__text_parsed<>'''
File '/home1/joe2209/mca0.com/sources/caches3.php'
Line 54
Function 'erase_comcode_cache'
Args
File '/home1/joe2209/mca0.com/sources/global2.php'
Line 432
Function 'auto_decache'
Args

true
Function 'init__global2'
Args
File '/home1/joe2209/mca0.com/sources/global.php'
Line 309
Function 'call_user_func'
Args

'init__global2'
File '/home1/joe2209/mca0.com/sources/global.php'
Line 789
Function 'require_code'
Args

'global2'
File '/home1/joe2209/mca0.com/index.php'
Line 73
Args

'/home1/joe2209/mca0.com/sources/global.php'
Function 'require'

By Guest posted 5th Aug 2018, 4:47 PM

Hi, sorry about this - I'll try and get back to you this week. I'm on the cusp of moving countries so I haven't been able to get back to you on it yet :(.

By Guest posted 22nd Aug 2018, 6:28 PM

Any luck with this, Chris?

By Guest posted 24th Aug 2018, 10:28 AM

Sorry I'm still having a very major time crunch, I underestimated how much work there'd be in setting up our new home (assembling furniture etc). Then I have a lot of client responsibilities I need to put first. I'm also away this weekend, so it'll have to be next week.

I'm aiming to dedicated a couple of long days next week to bug fixing.

Things should settle back to normal before too long.

By Guest posted 29th Aug 2018, 6:53 PM

This should double fix it:
https://github.com/ocproducts/composr/commit/bf4423ef4e5637cdc7edf4bd9a0977f2dc51a90b

I think I've located the bug, but I've also suppressed errors here as it's too optimistic to assume the meta DB is completely valid. Some people manually change database structure.

You can ignore the comment ("//") lines, I'm just tidying up the code here.

Sorry again for the delay.

#3610 - Error after install

Rating

Comments

Statistics