|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
|
veteran
Joined: Jun 2006
Posts: 1,344 |
I am probably missing something but I am getting a failure here. I am upgrading my test site from 7.4.2 Inserting GlobalModerators Group into the ubbt_GROUPS table. FAILED
SQL Query: insert into ubbt_GROUPS (GROUP_NAME,GROUP_ID,GROUP_IS_DISABLED,GROUP_CUSTOM_TITLE) values ('GlobalModerators','2','0','0')
Reason for failure: Unknown column 'GROUP_CUSTOM_TITLE' in 'field list'
Upgrade Step: /install/upgrade.php?step=altertable
|
|
|
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85 |
This looks like a bug.
I have 7.5.2 and there is not a field called "GROUP_CUSTOM_TITLE"
but there is a field called "Group_name". Looking at the alter files this is not for your version either. It was for 7.1 and 7.3a2
I would bet if you edit the altertable files for 7.1 and 7.3a2 in the install folder and replace Group_custom_title with GROUP_NAME. It would fly but "Remember the case" all caps
Last edited by Ruben; 03/25/2009 2:38 PM.
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Jun 2006
Posts: 16,378 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,378 Likes: 129 |
Went through the 7.5.x altertables and couldn't find the addition of a "GROUP_CUSTOM_TITLE" column...
|
|
|
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85 |
altertable-7.1.php line 132
altertable-7.3a2.php line 191
Thanks to windows grep
This is from the 7.5.2 zip
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Jun 2006
Posts: 16,378 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,378 Likes: 129 |
That's weird; I've been upgrading via the upgrade.php file and don't have the column... Lol... Makes me wonder what else I'm missing 
|
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
|
veteran
Joined: Jun 2006
Posts: 1,344 |
I have never had an issue like this on an upgrade so I was surprised, lol. I meant to post this in bugs 
|
|
|
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85 |
Well like I said in the prior post there is a custom_title field in the user table but not groups.
The Group_Name field is where globalmoderator is placed. So I think it is a bug.
I never had the issue so maybe I skipped 7.1 but I don't think so.
The query only appears in the two alter files I posted.
So I think gliderdad is not trying to upgrade 7.4.2 but a older version.
But in any case don't you think this should be in the Bug Forum?
Last edited by Ruben; 03/25/2009 4:26 PM. Reason: Added comment
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
|
veteran
Joined: Jun 2006
Posts: 1,344 |
|
|
|
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85 |
That sounds better then one of the files should apply which is still incorrect.
Last edited by Ruben; 03/25/2009 4:41 PM.
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
GROUP_CUSTOM_TITLE was added back in 7.1 and we used it for a few versions. We dropped it in 7.3.2 at the tail end of that altertable script. If you're still stuck on this you can manually add that field back in and then the altertable will run properly and drop it at the end. You can do that with this query:
alter table ubbt_GROUPS
add GROUP_CUSTOM_TITLE tinyint(1)
|
|
|
|
|
Joined: Jun 2006
Posts: 16,378 Likes: 129
|
|
Joined: Jun 2006
Posts: 16,378 Likes: 129 |
Ahh, so we're NOT supposed to have it; so those of us who don't are good :X... Other than Glider breaking things hehe
|
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
|
veteran
Joined: Jun 2006
Posts: 1,344 |
Thanks Rick that worked, but it faild again on step 7 of alter table. Adding default permissions to the ubbt_FORUM_PERMISSIONS table for existing groups. FAILED
SQL Query: update ubbt_FORUM_PERMISSIONS set SEE_FORUM = 1, READ_TOPICS = 1, READ_REPLIES = 1, CAN_DOWNLOAD = 1, EDIT_POSTS = 2160, DELETE_POSTS = 0 where FORUM_PERMISSION_CAN_READ = 1
Reason for failure: Unknown column 'FORUM_PERMISSION_CAN_READ' in 'where clause'
Upgrade Step: /install/upgrade.php?step=altertable
|
|
|
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85 |
Looks like the same issue but you are going to get at least two more in step 8 From altertable-7.3a2.php drop FORUM_PERMISSION_CAN_READ,
drop FORUM_PERMISSION_CAN_CREATE_REPLY,
drop FORUM_PERMISSION_CAN_CREATE_TOPIC Somewhere around step 18 there are several more that are dropped so not sure what your version does or does not have as far a fields are concerned.
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
It actually looks like maybe it's trying to run through that altertable a second time maybe, since it's obviously already dropped those fields.
Are you working on a test forum and database or is this your live board?
|
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
|
veteran
Joined: Jun 2006
Posts: 1,344 |
This is on a test forum and separate db. I is pretty much identical to my live site, wanted to test the install and make mods before going to live.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
I'd do another fresh test. It just seems that somewhere, something with the altertables got out of whack. I just did an upgrade from 7.3 today to 7.5.2 for a customer and everything went ok.
|
|
|
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85 |
Well Rick the weird thing to me is he is upgrading from 7.4.1.
Not 7.3x
Could the problem also be cheating a little on a prior upgrade. Meaning did not run the upgrade script from a prior upgrade.
The displayed version at the footer shows 7.4.1 but why is the altertable running a 7.3x version?
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
|
veteran
Joined: Jun 2006
Posts: 1,344 |
I have restarted the upgrade a few times with the same results. Going to go back to 7.4.1 make sure all permissions are right and try again I guess.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, so what you can do now is take a look at your ubbt_VERSION table and let me know what you have in there.
select * from ubbt_VERSION
|
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
|
veteran
Joined: Jun 2006
Posts: 1,344 |
SCRIPT_VERSION-- 7.3a2
DB_VERSION --7.3a2
LAST_ALTER_STEP -- 7
IS_RUNNING --1
Last edited by gliderdad; 03/27/2009 11:18 AM.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, so it looks like somehow your 7.3 upgrade got cut off and never updated the table. You can run this query and then you should be all set
update ubbt_VERSION
set SCRIPT_VERSION='7.4.1',
DB_VERSION='7.4.1',
LAST_ALTER_STEP='0',
IS_RUNNING='0'
|
|
|
|
|
Joined: Jun 2006
Posts: 1,344
veteran
|
|
veteran
Joined: Jun 2006
Posts: 1,344 |
Great, thanks Rick it worked. Sorry I didn't get back to this sooner, I was away.
|
|
|
|
1 members (Gizmo),
103
guests, and
103
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
