8.2c to 9.0 --Mysql tables not updating properly!!! :: Archived

Nuance · Gold Supporter Offline Joined: Dec 30, 2004 Posts: 223

I ran the install script to upgrade from 8.2c to 9.0 Final, and have been noticing that several functions do not work, apparently because the database tables were not updated correctly by the installer. Here is my list of things discovered thusfar:

1) No theme selection drop-down menu in My Account : My Preferences, even though it is enabled and there are multiple themes to choose from.

2) Unable to enable "PM Quick Reply" or "Enable bbCode Buttons" in Forum Admin : Configuration.

3) Unable to select Default Quota Limits in Forum Admin : Attachments : Attachment Settings.

For #1, the option isn't displayed. For #2 and #3, I can select options, but they revert to default upon hitting "submit"

An inspection of the MySQL tables seems to suggest that the rows for these options do not exist in the database. I would like to submit a formal bug report, but I don't know the names of the tables that are missing.

mortal.seraphim

I upgraded from 8.2b to Dragonfly and I'm having the same issue. I don't know about #2 and #3 but when going to My Account > My Prefrences, the Theme selection drop down menu is just NOT THERE.
The only way to change themes is with the Preview Theme block and that sucks.
Can anyone come up with a fix for this?

Head-e · Silver Supporter Offline Joined: Apr 20, 2004 Posts: 937

2) Unable to enable "PM Quick Reply" or "Enable bbCode Buttons" in Forum Admin : Configuration.

3) Unable to select Default Quota Limits in Forum Admin : Attachments : Attachment Settings.

Nuance, i think these are theme issues since they are controlled from themes/themname/template/forums.. on the site you have linked you are using the cpgnuke theme on a 9.0.0rc1 site.. i would try changing the theme to dragonfly, or uploading the theme from the 9.0.1final package.. it will also solve some of the formating problems..

Nuance · Gold Supporter Offline Joined: Dec 30, 2004 Posts: 223

Mortal Seraphim--

back up everything and then try this:

Code::

UPDATE cms_users_fields SET fid=fid+1 WHERE fid>12 ORDER BY fid DESC;
INSERT INTO cms_users_fields VALUES (13, 'theme', 5, 0, 7, 25, '_THEME');

Head-e; I have two other installations of Dragonfly, both are 9.0.1 Final. On both of these I experience the same problem and have tried using both the cpgnuke theme and the dragonfly theme. I'll do a fresh install of Dragonfly on the site I have linked, so I can compare tables between a clean install and an upgrade.

Phoenix

Nuance wrote:

I'll do a fresh install of Dragonfly on the site I have linked, so I can compare tables between a clean install and an upgrade.

Should do the trick - I don't have any of your issues with either a new install, a continuously upgraded cvs site, or a hybrid upgraded 8.2/9.0F (don't ask).

Nuance · Gold Supporter Offline Joined: Dec 30, 2004 Posts: 223

Well, I did a fresh install, and tried it again. Problem #2 persists, but problem #3 resolved. I compared the table structure for cms_bbattachments_config between the two databases, and found this discrepancy:

Nuance · Gold Supporter Offline Joined: Dec 30, 2004 Posts: 223

I can fix this problem manually, but if there is a problem with the upgrade installer, then it should probably be looked into.

One more thing-- can you please tell me where in the db the toggle-settings are stored for Forum Admin : Configuration : Enable Forum Quick Reply and Forum Admin : Configuration : Enable bbCode Buttons , so I can check my database for integrity? Thanks!

Phoenix

_bbconfig would be the logical place to start.

Nuance · Gold Supporter Offline Joined: Dec 30, 2004 Posts: 223

My _bbconfig has 39 rows, how many does yours have?

mortal.seraphim

Nuance wrote:

Mortal Seraphim--

back up everything and then try this:

Code::

UPDATE cms_users_fields SET fid=fid+1 WHERE fid>12 ORDER BY fid DESC;
INSERT INTO cms_users_fields VALUES (13, 'theme', 5, 0, 7, 25, '_THEME');

Head-e; I have two other installations of Dragonfly, both are 9.0.1 Final. On both of these I experience the same problem and have tried using both the cpgnuke theme and the dragonfly theme. I'll do a fresh install of Dragonfly on the site I have linked, so I can compare tables between a clean install and an upgrade.

Thanks man, this worked perfectly. The option now appears and works fine.

Nuance · Gold Supporter Offline Joined: Dec 30, 2004 Posts: 223

You can thank DJMaze for that one. Thanks again, DJMaze!

Now-- can someone who's pm quick reply works, please tell me how many rows are in their _bbconfig table? Mine has 39, but I don't see any rows for pm quick reply options.

mortal.seraphim

Doesn't look like I have PM quick reply man.
I sent myself a PM, opened it up to read it and the quick reply box isn't there. I have to click the reply button to get the job done.
I hope someone can fix that one, that would be a cool feature to have.

Nuance · Gold Supporter Offline Joined: Dec 30, 2004 Posts: 223

mortal.seraphim -- go to Forum Admin : Configuration : PM Quick Reply, and then try to enable the feature.

Let me know if you are able to successfully toggle these features. My problem is that the system won't let me toggle them"on".

mortal.seraphim

I tried setting the option to YES but after saving the changes it defaulted back to NO. Like the setting just doesn't take effect or something.
FUN
Lemme dig around and see if I can find out what the problem is. I've had some pretty decent luck fixing stuff today.

Nuance · Gold Supporter Offline Joined: Dec 30, 2004 Posts: 223

I have a feeling that when we ran the upgrade script, it didn't create the db rows to store this setting. I've been trying to find out what these rows are so that I can insert them manually, but I'm at a bit of a loss. Good luck!