Can't tell what this problem is

bail out

Been having this for several weeks now, don't have the money to pay for support so I have been trying to figure it out on my spare time, which is precious little, being a farmer and not an IT professional. This first began when I upgraded from OCPortal to Composr and since then I have tried with each new release to use upgrader.php, which steps through just fine, but when I try to launch the site, this is what I've been getting.

"Unfortunately a query has failed [SELECT cached_for,identifier,the_value,date_and_time,dependencies FROM ocp5_cache WHERE the_theme='admin' AND staff_status IS NULL AND the_member IS NULL AND groups='1' AND is_bot=0 AND timezone='America/Phoenix' AND lang='EN' AND (1=0 OR cached_for='menu' AND identifier='4786f5ddc15af7fa60f73bd8eeb8fd04')] [Unknown column 'dependencies' in 'field list'] (version: 10.0.10, PHP version: 5.5.37, URL: /adminzone/index.php)"

Hi,

I'll look at it for free, but to save me time could you email FTP access to chris@ocproducts.com?
It looks like a failed upgrade. What did you upgrade from exactly, maybe ocPortal 8?

Have you definitely done the step 5 'database upgrade' step of the upgrader?
This is what hasn't completed properly, but it's impossible for me to say if you attempted it or not, and where it might have failed, without looking directly on the site. I could give a patch for the specific database change that is needed, but there may be dozens more that didn't go through too.

Originally had the problem going from last 8 to 9, got it cleared up somehow and then had the problem again going from 9 to Composr. I'll email the FTP as soon as I get to my home system. Thank you!a

As for the database issue:

It says

"The on-disk version of Composr is 10 and the in-database version is 10. This means the database is currently up-to-date."

When I click on the upgrade database upgrade button:

Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='award_types' AND m_name='a_description' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='text' AND m_name='the_message' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='match_key_messages' AND m_name='k_message' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='menu_items' AND m_name='i_caption' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='menu_items' AND m_name='i_caption_long' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='cached_comcode_pages' AND m_name='string_index' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='authors' AND m_name='description' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='authors' AND m_name='skills' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='banners' AND m_name='caption' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='calendar_types' AND m_name='t_title' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='calendar_events' AND m_name='e_title' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='calendar_events' AND m_name='e_content' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='catalogue_efv_long_trans' AND m_name='cv_value' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='catalogue_efv_short_trans' AND m_name='cv_value' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='catalogues' AND m_name='c_description' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='catalogue_categories' AND m_name='cc_description' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='chat_messages' AND m_name='the_message' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='download_downloads' AND m_name='description' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='download_categories' AND m_name='description' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='galleries' AND m_name='description' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='galleries' AND m_name='fullname' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='iotd' AND m_name='i_title' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='iotd' AND m_name='caption' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='news' AND m_name='title' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='news' AND m_name='news' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='news' AND m_name='news_article' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='chargelog' AND m_name='reason' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='gifts' AND m_name='reason' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='pstore_customs' AND m_name='c_description' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='pstore_permissions' AND m_name='p_description' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='poll' AND m_name='question' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='poll' AND m_name='option1' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='poll' AND m_name='option2' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='poll' AND m_name='option3' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='poll' AND m_name='option4' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='poll' AND m_name='option5' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='poll' AND m_name='option6' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='poll' AND m_name='option7' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='poll' AND m_name='option8' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='poll' AND m_name='option9' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='poll' AND m_name='option10' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='quiz_question_answers' AND m_name='q_answer_text' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='quizzes' AND m_name='q_start_text' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='quizzes' AND m_name='q_end_text' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='quizzes' AND m_name='q_end_text_fail' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='f_posts' AND m_name='p_post' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='f_topics' AND m_name='t_cache_first_post' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='f_members' AND m_name='m_signature' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='f_members' AND m_name='m_pt_rules_text' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='f_forums' AND m_name='f_description' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='f_forums' AND m_name='f_intro_question' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='f_usergroup_subs' AND m_name='s_description' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='f_member_custom_fields' AND m_name='field_1' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='f_member_custom_fields' AND m_name='field_4' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='f_member_custom_fields' AND m_name='field_7' [Data too long for column 'm_type' at row 1]
Database query failed: UPDATE ocp5_db_meta SET m_type=CONCAT(m_type,'__COMCODE') WHERE m_table='f_member_custom_fields' AND m_name='field_37' [Data too long for column 'm_type' at row 1]
Database query failed: ALTER TABLE ocp5_security_images RENAME ocp5_captchas [Table 'rt66days_ocpt1.ocp5_security_images' doesn't exist]
Database query failed: ALTER TABLE ocp5_validated_once RENAME ocp5_webstandards_checked_once [Table 'rt66days_ocpt1.ocp5_validated_once' doesn't exist]
Database query failed: ALTER TABLE ocp5_long_values RENAME ocp5_values_elective [Table 'rt66days_ocpt1.ocp5_long_values' doesn't exist]
Database query failed: SELECT d_message,id FROM ocp5_digestives_tin WHERE 1=1 [Table 'rt66days_ocpt1.ocp5_digestives_tin' doesn't exist]
Database query failed: ALTER TABLE ocp5_digestives_tin DROP COLUMN d_message [Table 'rt66days_ocpt1.ocp5_digestives_tin' doesn't exist]
Database query failed: ALTER TABLE ocp5_digestives_tin ADD d_message integer DEFAULT 0 NOT NULL [Table 'rt66days_ocpt1.ocp5_digestives_tin' doesn't exist]
Database query failed: SELECT * FROM ocp5_digestives_tin LIMIT 0,1000 [Table 'rt66days_ocpt1.ocp5_digestives_tin' doesn't exist]

PHP WARNING [2] Invalid argument supplied for foreach() in sources/global.php(250) : eval()'d code on line 600 (version: 10.0.10, PHP version: 5.5.37, URL: /upgrader.php?type=db_upgrade)

Ah ok. I should be able to fix that for you.

Out of interest, do you know the origin version of this install? (the version you started with right at the beginning)

My first inclination was to say Version 3, but I did notice that I have an SQL database named OCPT1 and another named OCF that I remember was to import an SMF forum with. So I'm not sure if I was on this ride earlier than Version 3 or not, but I do remember using it for sure by that time. SMF was at about 1.4 at the time and the TikiWiki install that I left on the site at /tikiwiki as an archived shows last changes in the summer of 2009. OCPortal replaced that installation as the face of the main website.

Since then we have undergone massive life changes, wasn't able to give this project the attention it deserved, and I am only now really getting around to the site again except for the minor amount of maintenance it took to keep OCP up until recently.

Are you able to provide the access within the next hour? I need to catch a flight early tomorrow, then I'm away until Monday bare minimum.

Chris, I emailed the FTP credentials before I made the last reply. I'll make sure to send them again, in case something happened.

Ah, went into my spam. I've flagged it for attention on Monday.

Hi,

I've now corrected your site.

I think the issue is that you upgraded from version 5 or 6 or 7, straight to 10 – but we only support upgrading to 10 from 8 and 9.

The upgrader didn't handle this very gracefully, I have made it more robust so it is able to get through, and with better error messages.

Then I ran the database repair cleanup tool, which was able to correct your database structure. This essentially puts things back to a consistent state, so you should be good now.

You'll still need to go through and update the site. For example, at least one banner is missing, forum rank images seem to be missing, and the main_top_downloads block was replaced with use of the main_multi_content block.

Oh, and I isolated some old stuff that won't run under '_old' folders, particularly your old theme, and some old template and CSS overrides in the default theme.

Thank you so much, Chris. Now I can get to work polishing up the poor old thing. Absolute appreciation and respect for this favor. I know you didn't have to.