|
|
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. |
|
|
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<>''] [<strong>Unknown column 'field_2__text_parsed' in 'where clause'</strong>] 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<>''] [<strong>Unknown column 'field_2__text_parsed' in 'where clause'</strong>] 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' |
|
|
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. |
|
|
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 |
|
|
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. |
|
|
Fatal error: Call to undefined function has_solemnly_declared() in /home1/joe2209/mca0.com/sources/database.php on line 244 |
|
|
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. |
|
|
Not sure if it matters, but this error is only shown on the MSN's. The main site doesn't seem to be affected. |
|
|
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! |
|
|
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 0000300: String "non-assigned_bug_title" not found." I'll attach a screenshot for you as well. |
|
|
bugtrackererror.png (124,568 bytes) |
|
|
bugnewnew.png (28,411 bytes) |
|
|
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<>''] [<strong>Unknown column 'field_2__text_parsed' in 'where clause'</strong>] 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<>''] [<strong>Unknown column 'field_2__text_parsed' in 'where clause'</strong>] 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' |
|
|
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 :(. |
|
|
Any luck with this, Chris? |
|
|
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. |
|
|
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. |
- Anonymous
