A couple of upgrade issues from the 2.3 version

Updating status to: Awaiting Feedback

Did you have the mod installed prior to upgrading?  A fresh installation should have just used the table definitions in the tutorials_mysql_tables.php file, shouldn't it?

Another thing I have noticed is that the categories cache is not automatically updated and I couldn't see any category in the public side even if the permissions in the admin side were fine, rebuilding the cache of course fixed the issue. You might want to place a call to the rebuild cache function after the tables from the old IPB 2.3 version are detected.

That's an IP.Board bug, the Shoutbox had the same problems, didn't it?

1) I've upgraded a 2.3.5 board to 3.0.5, as I said on the old board I had the old version [(FSY23) Tutorials v2.1].
After the IPB 3 upgrade process was done I have installed (IM) TUtorials 1.0.2 from the ACP and I have chosen to skip the tables already there to not loose the data and at the end of the process I noticed the missing columns because I got a driver error trying to update the category permissions (because of #2)

2) That issue you mention actually happens only when you make a fresh install of IPB 3 + IP.Shoutbox; the upgrader is fine instead afaik.


Right now I made this test upgrade on my localhost but I'll be doing a live test upgrade too soon, if you want I can give you access to it once it is setup.

Hi,

Hope I'm ok to add to this, as my error seems to be along the same lines...

· ALTER TABLE ibf_tutorials_cats ADD c_name_seo varchar(255) NOT NULL AFTER c_name;

Unknown column 'c_name' in 'ibf_tutorials_cats'
· ALTER TABLE ibf_tutorials_cats ADD c_forum smallint(5) DEFAULT '0' AFTER c_tarts;

Unknown column 'c_tarts' in 'ibf_tutorials_cats'
· ALTER TABLE ibf_tutorials_cats ADD c_can_rss tinyint(1) NOT NULL DEFAULT '0' AFTER c_forum;

Unknown column 'c_forum' in 'ibf_tutorials_cats'
· ALTER TABLE ibf_tutorials_cats ADD c_last_id int(11) DEFAULT NULL AFTER c_can_rss;

Unknown column 'c_can_rss' in 'ibf_tutorials_cats'
· ALTER TABLE ibf_tutorials_cats ADD c_last_name varchar(255) DEFAULT NULL AFTER c_last_id;

Unknown column 'c_last_id' in 'ibf_tutorials_cats'
· ALTER TABLE ibf_tutorials_cats ADD c_last_name_seo varchar(255) DEFAULT NULL AFTER c_last_name;

Unknown column 'c_last_name' in 'ibf_tutorials_cats'
· ALTER TABLE ibf_tutorials_cats ADD c_last_time int(11) DEFAULT NULL AFTER c_last_name_seo;

Unknown column 'c_last_name_seo' in 'ibf_tutorials_cats'
· ALTER TABLE ibf_tutorials_cats ADD c_last_mid int(11) DEFAULT NULL AFTER c_last_time;

Unknown column 'c_last_time' in 'ibf_tutorials_cats'
· ALTER TABLE ibf_tutorials_cats ADD c_last_mgroup int(3) DEFAULT NULL AFTER c_last_mid;

Unknown column 'c_last_mid' in 'ibf_tutorials_cats'
· ALTER TABLE ibf_tutorials_cats ADD c_last_mname varchar(255) DEFAULT NULL AFTER c_last_mgroup;

Unknown column 'c_last_mgroup' in 'ibf_tutorials_cats'
· ALTER TABLE ibf_tutorials_cats ADD c_last_mname_seo varchar(255) DEFAULT NULL AFTER c_last_mname;

Unknown column 'c_last_mname' in 'ibf_tutorials_cats'
· ALTER TABLE ibf_tutorials_cats ADD c_artorder varchar(6) NOT NULL DEFAULT 'title' AFTER c_last_mname_seo;

Unknown column 'c_last_mname_seo' in 'ibf_tutorials_cats'
· ALTER TABLE ibf_tutorials_cats ADD c_artsort varchar(4) NOT NULL DEFAULT 'asc' AFTER c_artorder;

Unknown column 'c_artorder' in 'ibf_tutorials_cats'
· UPDATE ibf_tutorials_cats SET c_parent=0 WHERE c_parent='root'

Unknown column 'c_parent' in 'where clause'

I've moved from 2.3.x to 3.0.5 with your tutorials system previously installed.

No other systems have been installed in the past.

I've checked the install/sql file and there is no _9 or _10 file, but emptied and re-uploaded anyway to be sure.

I've tried manually adding the SQL in phpmyadmin without joy.

any ideas?

Regards

Jim

OK, I'll have another look at this, but this was all tested in the 1.0.0 release.

Updating status to: Confirmed Bug
Updating severity to: 4 - High

Updating status to: Fixed
Issue fixed in: 1.1.0 Beta 1

Should all be fixed now.

Fantastic, thank you, missed not having your system running all this time.

Cheers

Jim