Help Please! Error database on Upgrade from 3.7.3 to 3.8.0 beta 4

L

Leony

New Member
Who can help me, by the updating from 3.7.3 to 3.8.0 beta 4
Nuulified By GYSN
I get on step 4 this error message

PHP: 
Database error in vBulletin 3.7.3:

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 8th 2008 @ 12:19:29 PM
Error Date    : Monday, December 8th 2008 @ 12:19:29 PM
Script        : http://xxxxx-xxxxx.com/install/upgrade_370b2.php?step=4
Referrer      : 
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 4.1.22
 
D

dacoolguy

New Member
Hmm, try this:

1. Reupload backup from the original working 3.7.3

2. Restore the DB backup from the original working 3.7.3

3. Repair this DB and then try the upgrade again, and if this happens again, try to repair the DB from phpmyadmin

Just a suggestion, it might not work.
 
L

Leony

New Member
Thank´s dacoolguy, but I tryed this befor, I had reupload backup, alos I tryed in phpmyadmin, but nothings changed.
Anyway thnx fot your answer.
 
B

Brendius

New Member
If you had a back up of your database and a back up of your master vBull files, I can't imagine why you would still have a problem if you didn't before the attempt to upgrade.

1. You re-uploaded the old vBull directory?
2. You re-uinstalled the old database?

Did you create a new tableless database in phpmyadmin before uploading the database backup, and then adjusted your config.php accordingly with the new database name/user/password?

Regards,
 
L

Leony

New Member
Thanks Bro but my problem ist that I can´t make a backup for my forum, course I can´t find the way to do it, I tryed before with some scripts, but with no result, it doesn´t create e full backup, everytime with errors.
How do I make this, I meen what kind of tools is the best to make backup (full backup)

Thanks 4 trying 2 help me
Regards
 
B

Brendius

New Member
If the database that is already installed on your server is corrupt, there is no point downloading it. You'd only be downloading a copy of your corrupt database. If you have no undamaged backup, you are stuck with the damaged one.

I suspect the problem is related to the fact your server us running an older version of mysql which may not support recent versions of vBulletin. Once you ran the upgrade script, you altered your database tables, and this cannot be reversed by reverting back to your previous version of vBulletin.
I could only assess the situation by having access to your Web Account and your vBulletin Administrator panel. It is always strongly advised that full back ups are made of your database 'before' any software upgrades or modification installations. If you only have one copy of your database, and it is damaged, you are somewhat screwed, because database repair requires professional assistance, and that is not cheap.

Regards,
 
You must log in or register to reply here.
Top