PDA

View Full Version : 3.6.2 -> 3.8.0 b4


JasonWilliams
Fri 5th Dec '08, 5:47pm
Run into a few problems upgrading to 3.8.0 --


Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET
forumpermissions = forumpermissions |
IF(forumpermissions & 16, 1048576, 0) |
IF(forumpermissions & 64, 2097152, 0) |
IF(forumpermissions & 512, 4194304, 0),
genericpermissions = genericpermissions |
IF(forumpermissions & 64
OR forumpermissions & 16, 1073741824, 0),

genericpermissions2 = genericpermissions2 |
IF(genericpermissions & 4096
OR genericpermissions & 268435456, 1, 0),

albumpermissions = albumpermissions |
IF(genericpermissions & 2
AND genericpermissions & 128, 1, 0) |
IF(genericpermissions & 1, 2, 0),
albumpicmaxwidth = 600,
albumpicmaxheight = 600,
albumpicmaxsize = 100000,
albummaxpics = 100,
albummaxsize = 0,

usercsspermissions = usercsspermissions |
IF(genericpermissions & 2
AND signaturepermissions & 8, 1, 0) |
IF(genericpermissions & 2
AND signaturepermissions & 8, 2, 0) |
IF(genericpermissions & 2
AND signaturepermissions & 2, 4, 0) |
IF(genericpermissions & 2
AND genericpermissions & 128
AND signaturepermissions & 2, 8, 0) |
IF(genericpermissions & 2
AND signaturepermissions & 2, 16, 0),

visitormessagepermissions = visitormessagepermissions |
IF(forumpermissions & 64
OR forumpermissions & 32, 1, 0) |
IF(forumpermissions & 64, 2, 0) |
IF(forumpermissions & 128, 4, 0) |
IF(forumpermissions & 256, 8, 0) |
IF(forumpermissions & 131072, 16, 0) |
IF(forumpermissions & 128
OR forumpermissions & 256, 32, 0),

socialgrouppermissions = socialgrouppermissions |
IF(genericpermissions & 1, 1, 0) |
IF(forumpermissions & 16, 2, 0) |
IF(forumpermissions & 128, 4, 0) |
IF(forumpermissions & 512, 8, 0) |
IF(genericpermissions & 1, 16, 0) |
IF(forumpermissions & 128
OR forumpermissions & 256, 32, 0) |
IF(adminpermissions & 1, , 0) |
64;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0) |
64' at line 55
Error Number : 1064
Request Date : Friday, December 5th 2008 @ 04:45:09 PM
Error Date : Friday, December 5th 2008 @ 04:45:09 PM
Script : http://www.steadi-forum.com/install/upgrade_370b2.php?step=4
Referrer : http://www.steadi-forum.com/install/upgrade_370b2.php?step=3
IP Address : 90.218.126.xxx
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community-log

I did try it and jumped past this error but at the end, the forum didn't work, I totally uninstalled all mods/hacks before I upgraded (I think there is a template addition I need to alter though, will report back with results, but this error doesn't appear to be associated to the issue I'm thinking of).

HELP!!

Thnx
slappy
Fri 5th Dec '08, 6:08pm
Is there a specific reason you are upgrading using 3.8.0 B4 rather than 3.8.0 RC1???

You also do understand that this is not "release' software, and is not generally recommended for your production Forum???

Regards,
JasonWilliams
Fri 5th Dec '08, 6:13pm
Because it was the version I downloaded, I've found the issue why it wasn't working but need to know if the above MySQL error will cause me problems....

I will be upgrading to RC1 in the next few moments

Thnx
JamesAB
Tue 9th Dec '08, 4:03am
Because it was the version I downloaded, I've found the issue why it wasn't working but need to know if the above MySQL error will cause me problems....

I will be upgrading to RC1 in the next few moments

Thnx
Someone else had the same problem in this thread:
http://www.vbulletin.com/forum/showthread.php?t=293119

Now I just tried to update a test forum to 3.8.0 RC1 and I'm getting the same database error.

You said you found the issue...What was it?

Thanks,
James
JasonWilliams
Tue 9th Dec '08, 4:47am
The problem I had was that the forum didn't work at the end of the upgrade, the database error above (and also the one the other member experienced) doesn't seem to have impacted anywhere important, as far as I can tell there are no issues with usergroups, I've checked out the AdminCP, and I get no DB errors there.

The only thing I can think of with that code is that the "64;" on the end might have to be in quotes? I'm not too hot with MySQL but understand the very basics. I will give the usergroups a good test today to see what happens, just to make sure I've missed nothing, will report back with any findings.

Jason
JamesAB
Wed 10th Dec '08, 2:24am
I'm only guessing here, but it looks like
$vbulletin->bf_ugp_socialgrouppermissions['canpostnonmembergroup'] isn't an integer here. :confused:
Wayne Luke
Sun 14th Dec '08, 12:10pm
In your includes/xml/vbulletin_bitfields.xml file, what does line 200 look like?

It should look like:


<bitfield group="social_group_permissions" name="followforummoderation" phrase="follow_group_message_moderation_rules" install="1,2,3,4,5,6,7">64</bitfield>
azher
Mon 15th Dec '08, 8:06pm
Hey Wayne,


In your includes/xml/vbulletin_bitfields.xml file, what does line 200 look like?

It should look like:


<bitfield group="social_group_permissions" name="followforummoderation" phrase="follow_group_message_moderation_rules" install="1,2,3,4,5,6,7">64</bitfield>


I'm having the same issue only I'm upgrading from 3.6.8 to the latest 3.8 RC1 however I'm getting stuck on the intermediary upgrade to 3.70b2 (upgrade_370b2.php). My file (and I believe the correct filename is "bitfield_vbulletin.xml") looks like yours.

Could it be the filename that's off?

Here's my SQL error (very similar to the one listed above):


Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE usergroup SET
forumpermissions = forumpermissions |
IF(forumpermissions & 16, 1048576, 0) |
IF(forumpermissions & 64, 2097152, 0) |
IF(forumpermissions & 512, 4194304, 0),
genericpermissions = genericpermissions |
IF(forumpermissions & 64
OR forumpermissions & 16, 1073741824, 0),

genericpermissions2 = genericpermissions2 |
IF(genericpermissions & 4096
OR genericpermissions & 268435456, 1, 0),

albumpermissions = albumpermissions |
IF(genericpermissions & 2
AND genericpermissions & 128, 1, 0) |
IF(genericpermissions & 1, 2, 0),
albumpicmaxwidth = 600,
albumpicmaxheight = 600,
albumpicmaxsize = 100000,
albummaxpics = 100,
albummaxsize = 0,

usercsspermissions = usercsspermissions |
IF(genericpermissions & 2
AND signaturepermissions & 8, 1, 0) |
IF(genericpermissions & 2
AND signaturepermissions & 8, 2, 0) |
IF(genericpermissions & 2
AND signaturepermissions & 2, 4, 0) |
IF(genericpermissions & 2
AND genericpermissions & 128
AND signaturepermissions & 2, 8, 0) |
IF(genericpermissions & 2
AND signaturepermissions & 2, 16, 0),

visitormessagepermissions = visitormessagepermissions |
IF(forumpermissions & 64
OR forumpermissions & 32, 1, 0) |
IF(forumpermissions & 64, 2, 0) |
IF(forumpermissions & 128, 4, 0) |
IF(forumpermissions & 256, 8, 0) |
IF(forumpermissions & 131072, 16, 0) |
IF(forumpermissions & 128
OR forumpermissions & 256, 32, 0),

socialgrouppermissions = socialgrouppermissions |
IF(genericpermissions & 1, 1, 0) |
IF(forumpermissions & 16, 2, 0) |
IF(forumpermissions & 128, 4, 0) |
IF(forumpermissions & 512, 8, 0) |
IF(genericpermissions & 1, 16, 0) |
IF(forumpermissions & 128
OR forumpermissions & 256, 32, 0) |
IF(adminpermissions & 1, , 0) |
64;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0) |
64' at line 55
Error Number : 1064
Request Date : Monday, December 15th 2008 @ 06:53:43 PM
Error Date : Monday, December 15th 2008 @ 06:53:43 PM
Script : http://www.[mysite].com/forums/install/upgrade_370b2.php?step=4
Referrer : http://www.[mysite].com/forums/install/upgrade_370b2.php?step=3
IP Address : [xxx]
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community
azher
Mon 15th Dec '08, 8:20pm
Found it....hopefully this will help someone else (I saw some other people having troubles with upgrades directly from 3.6x.

In the upgrade_370b2.php script, there's a value that isn't being assigned anything and it's resulting in the "double comma" mentioned in another thread. The variable is:

$vbulletin->bf_ugp_socialgrouppermissions['canpostnonmembergroup']

I simply searched for that and placed a zero there. It's a hack job, but it works so I can continue the upgrade. ;-)
stejoh
Sun 28th Dec '08, 5:49am
Found it....hopefully this will help someone else (I saw some other people having troubles with upgrades directly from 3.6x.

In the upgrade_370b2.php script, there's a value that isn't being assigned anything and it's resulting in the "double comma" mentioned in another thread. The variable is:

$vbulletin->bf_ugp_socialgrouppermissions['canpostnonmembergroup']

I simply searched for that and placed a zero there. It's a hack job, but it works so I can continue the upgrade. ;-)

Azher, my upgrade gets stuck at this step too. How do I change this variable?
I have tried to enter my admincp but I cannot, due to a database error...
Thanks, Stefan
stejoh
Sun 28th Dec '08, 8:05am
Azher, my upgrade gets stuck at this step too. How do I change this variable?
I have tried to enter my admincp but I cannot, due to a database error...
Thanks, Stefan

Well, I solved it the "beginner's" way.
I re-uploaded the latest version vB 3.7.4 PL1, and upgraded to this version.
Then I upgraded to 3.8.0 RC2.
JamesAB
Sun 28th Dec '08, 4:57pm
Well, I solved it the "beginner's" way.
I re-uploaded the latest version vB 3.7.4 PL1, and upgraded to this version.
Then I upgraded to 3.8.0 RC2.
Has anyone filed a bug report on this yet?
stejoh
Mon 29th Dec '08, 1:06pm
Has anyone filed a bug report on this yet?
Not me. How do one do that?
Zachery
Mon 29th Dec '08, 2:20pm
http://www.vbulletin.com/forum/projectpost.php?do=addissue&projectid=6&issuetypeid=bug