Issue: Lamp forum upgrade issue oh sos

Issue Tools
- View Changes

August 1, 2009 10:04 AM

Jella

Regular Member

Lamp forum upgrade issue oh sos

seemed to go ok but

you have logins.

I upgraded everything and it seemed to go okay, also rebuilt and checked all permission ok.

Only now:

1. I cannot edit any wiki

2. This error when clicking Title Protector, if there is no tiltle to protect, I get the following database error:

Code:

Database error in vBulletin 3.8.3:

Invalid SQL:

		SELECT protectid, namespaceid, title
		FROM vault_protect
		WHERE protectid IN ();

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 ')' at line 3
Error Number  : 1064
Request Date  : Saturday, August 1st 2009 @ 09:51:42 AM
Error Date    : Saturday, August 1st 2009 @ 09:51:42 AM
Script        : http://tvlampforum.com/admincp/vaultwiki_protect.php?do=add
Referrer      : http://tvlampforum.com/admincp/vaultwiki_protect.php?do=modify
IP Address    : 98.229.123.186
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.81-community

and when going to Usergroups --> Administrator Permissions --> Edit Permissions and checking off the ones that are not checked such as (Can Administer HelpCenter, UMG etc...) I get the following error when saving:

Code:

Database error in vBulletin 3.8.3:

Invalid SQL:
UPDATE administrator SET
	### Bitfield: administrator.adminpermissions ###
		adminpermissions = IF(adminpermissions & 4, adminpermissions, adminpermissions + 4),
		adminpermissions = IF(adminpermissions & 8, adminpermissions, adminpermissions + 8),
		adminpermissions = IF(adminpermissions & 16, adminpermissions, adminpermissions + 16),
		adminpermissions = IF(adminpermissions & 32, adminpermissions, adminpermissions + 32),
		adminpermissions = IF(adminpermissions & 64, adminpermissions, adminpermissions + 64),
		adminpermissions = IF(adminpermissions & 128, adminpermissions, adminpermissions + 128),
		adminpermissions = IF(adminpermissions & 256, adminpermissions, adminpermissions + 256),
		adminpermissions = IF(adminpermissions & 512, adminpermissions, adminpermissions + 512),
		adminpermissions = IF(adminpermissions & 1024, adminpermissions, adminpermissions + 1024),
		adminpermissions = IF(adminpermissions & 2048, adminpermissions, adminpermissions + 2048),
		adminpermissions = IF(adminpermissions & 4096, adminpermissions, adminpermissions + 4096),
		adminpermissions = IF(adminpermissions & 8192, adminpermissions, adminpermissions + 8192),
		adminpermissions = IF(adminpermissions & 16384, adminpermissions, adminpermissions + 16384),
		adminpermissions = IF(adminpermissions & 65536, adminpermissions, adminpermissions + 65536),
		adminpermissions = IF(adminpermissions & 131072, adminpermissions, adminpermissions + 131072),
		adminpermissions = IF(adminpermissions & 262144, adminpermissions, adminpermissions + 262144),
	### Bitfield: administrator.garsadminperms ###
		garsadminperms = IF(garsadminperms & 1, garsadminperms, garsadminperms + 1),
	ptpermissions = 3,
	### Bitfield: administrator.customumgpermissions ###
		customumgpermissions = IF(customumgpermissions & 1, customumgpermissions, customumgpermissions + 1),
	blogpermissions = 3,
	admin_view_pm_log = 1,
	### Bitfield: administrator.customadminperms ###
		customadminperms = IF(customadminperms & 1, customadminperms, customadminperms + 1),
	cssprefs = 'vBulletin_2_Default',
	dismissednews = '61,63,74'
WHERE userid = 1;

MySQL Error   : Unknown column 'customadminperms' in 'field list'
Error Number  : 1054
Request Date  : Saturday, August 1st 2009 @ 10:03:16 AM
Error Date    : Saturday, August 1st 2009 @ 10:03:16 AM
Script        : http://tvlampforum.com/admincp/adminpermissions.php?do=update
Referrer      : http://tvlampforum.com/admincp/adminpermissions.php?do=edit&u=1
IP Address    : 98.229.123.186
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.81-community

Issue Details

Issue Number 747

Issue Type Bug

Project VaultWiki 3.x Series

Category Protection

Status Fixed

Priority 5 - Minor Bugs / Small Tweaks

Affected Version 2.5.0

Fixed Version 2.5.1

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 1, 2009 2:17 PM

pegasus

VaultWiki Team

What happens when you try to edit a wiki page?

'customadminperms' is not a field added by or used by VaultWiki. I will have a look for you.

EDIT: Yup, it's used by your Help Center mod.

Reply
August 1, 2009 5:06 PM

pegasus

VaultWiki Team

It looks like you need to set forum permissions for your wiki forums again. Not sure what would have caused this, unless you recently reset them to inherit from the Lampipedia category?

Reply
August 1, 2009 6:36 PM

Jella

Regular Member

There is no edit tab showing

oh I see okay now I know where to look, I will report back

Reply
August 1, 2009 7:55 PM
Jella

Regular Member
Well I disabled helpcenter, so that's done and it fixed those permission

... and I went through the Wiki settings but of course I can't seem to get it to work again.

There is no edit tab showing, I disabled all the wiki's but that didn't help either

and when I click on Title Protector then click UNPROTECT titles (even tho there are none to unprotect) I get this error

Code:

Warning: array_keys() [function.array-keys]: The first argument should be an array in [path]/admincp/vaultwiki_protect.php on line 106 Warning: implode() [function.implode]: Invalid arguments passed in [path]/admincp/vaultwiki_protect.php on line 106
Reply
August 1, 2009 8:37 PM

pegasus

VaultWiki Team

Well, you are getting the errors in the title protector because as you say, there are no titles to unprotect.

Your edit tab is not showing because your wiki permissions have all been disabled - they are now correctly inheriting custom permissions. See your AdminCP -> Forums & Moderators -> Forum Permissions for the wiki forums.

Reply
August 1, 2009 10:20 PM

Jella

Regular Member

OK it seems to work now, thank you.

But shouldn't when I click on unprotect even with nothing to unprotect, I get a page that says ' hey stupid, there is nothing to unprotect? instead of a database error???? Yes?

One more thing, it seems 2.50 has different templates? When you create an article or image etc... I need to add a line break... one line break between the footer table and topic table, seen here in the image below... I have tried numerous templates but can't find it, can you help please.... this is the only place that needs a line break.

I had the <br /> before the upgrade.

Reply
August 2, 2009 1:40 AM

pegasus

VaultWiki Team

Yes there should be an error message. I'll make sure that's added.

The name of the template is vault_edit_newform

Reply

+ Reply

All times are GMT -4. The time now is 1:29 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Lamp forum upgrade issue oh sos

Issue Tools