SMF Support > Install and Upgrade Help

Unknown column 'c.can_collapse' in 'field list'

(1/2) > >>

retone:
Happy New Year to all.

(well, based on the following, mines not too happy yet)

I'm upgrading v1.1.11 to 2.0 RC2 and everything seems fine until I finish and run index.php, get the following error:

Unknown column 'c.can_collapse' in 'field list'
File: C:\xampp\htdocs\smf\Sources\Subs-BoardIndex.php
Line: 82

Background:  I installed a fresh v1.1.11 and converted a VB 3.6 forum.  All was well.
I then tried to do the large 2.0 upgrade and got the above error.

I have tried this five or six times in the last 24 hours in several variations based on other threads here.

I'm running on a testsite under Windows XP, using XAMPP full
Apache 2.2.14
MySQL 5.1.41
PHP 5.3.1

I double checked all mySQL and PHP settings from the SMF requirements page.

From reading other threads, it appears that the upgrade did not convert all column names from 1.1.11 format, specifically the one smf_categories ID_CAT which is apparently old format still.

I followed advice from another thread and reset smf_settings smfVersion back to 1.1.11 and reran upgrade.

Then get error midway through upgrade during the Calendar Holiday process: Unknown column 'eventDate' in 'where clause'

This is apparently because eventDate had been changed in the initial upgrade to the 2.0RC2 format event_date  apparently referring to the column in the smf_calendar_holidays table.

I can get into admin, but not forum home.

There were 4-6 other threads with this error, but they all died before a resolution was posted.

Any advice/assistance would be appreciated.

babjusi:
Have a look here. It might help you.

http://www.simplemachines.org/community/index.php?topic=243268.msg1796791#msg1796791

P.s. Did you make a backup of the db prior to the upgrade?

retone:

--- Quote from: babjusi on December 31, 2009, 10:59:34 AM ---Have a look here. It might help you.

http://www.simplemachines.org/community/index.php?topic=243268.msg1796791#msg1796791

P.s. Did you make a backup of the db prior to the upgrade?

--- End quote ---

I couldn't find anything in your referenced post that looked like a fix.  It seems to be referencing a collapse issue, whereas my problem although collapse in in the error message, appears to be the overall funtion not being able to handle the v1.1.11 column name smf_categories ID_CAT.

As far as backup, I copied the full v1.1.11 install to another drive before attempting this upgrade, including Apache/mySQL/PHP/SMF folders/files.

More info...  I'm not a SQL/PHP expert, but no where in the upgrade associated files did I find anthing that would change smf_categories - ID_CAT v1.1.11 format  to id_cat v2.0RC2 format.

I expected to find something in the upgrade_2-0_mysql.sql file in the array under the section "Renaming table columns" but didn't see it.

Hope this info helps

 

retone:
I don't understand why the upgrade associted files would not have changed the smf_categories column ID_CAT.

Question:  If I add the following to the upgrade_2-0_mysql.sql file in the array under the section "Renaming table columns"

'categories' => array(
      'ID_CAT' => 'ID_CAT id_cat smallint(5) unsigned NOT NULL auto_increment',
   ),

Then deleted the complete 2.0 folder, copied over the 1.1.11 folder and reran the upgrade, you think it might work or would it create other problems with the upgrade process?

retone:
Update:

The above fix didn't work, same issue.

I don't understand why it didn't change the smf_categories column from v1.1.11 ID_CAT to 2.0RC2 id_cat?

Well, easy explanation I guess is thats why SMF says 2.0RC2 is not ready for production, and with all the support replies I've received, looks like I better stick with v1.1.11 for now.

Thanks anyway!

Navigation

[0] Message Index

[#] Next page