Change Permissions = Error

Issue Tools
- View Changes

April 19, 2014 7:49 PM

Ptah

Junior Member

Area Manager -> "System" -> Change Permissions = Error

Clicking "Change Permissions" on the "System" area results in an error

... Only if clicking on the "Change Permissions" on "System" do I get this error (that is, it seems to work for other Areas?)

Code:

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT * FROM `vw_permission` WHERE nodetypeid = 3 AND  `nodeid` IN ()  AND applytypeid = 1;

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 ')  AND applytypeid = 1' at line 1
Error Number  : 1064
Request Date  : Sunday, April 20th 2014 @ 12:00:22 AM
Error Date    : Sunday, April 20th 2014 @ 12:00:22 AM
Script        : [url]http://forums.intpcomplex.com/admincp/wiki_cp.php?panel=area&areaid=2&do=permissions[/url]
Referrer      : [url]http://forums.intpcomplex.com/admincp/wiki_cp.php?panel=area[/url]
IP Address    : 71.201.229.147
Username      : Ptah
Classname     : vB_Database
MySQL Version : 5.5.36-cll

Issue Details

Issue Number 3696

Issue Type Bug

Project VaultWiki 4.x Series

Category Areas

Status Duplicate

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Gamma 5

Fixed Version (none)

Milestone VaultWiki 4 Gamma X

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

April 19, 2014 7:52 PM

pegasus

VaultWiki Team

The error message in the post above is the same as another report you made. I don't think it's relevant to this issue. You are probably receiving another error message for this.

Reply
April 19, 2014 8:01 PM

Ptah

Junior Member

Oops. Clipboard fail. I updated the error message with that is thrown; apologies.

Reply
April 19, 2014 8:11 PM

pegasus

VaultWiki Team

Yes, the parent-list for the System area was corrupted by one of the install errors. After you check on my response for the comments issue, I think the only way to resolve this would be a re-install.

Reply
April 19, 2014 10:51 PM

Ptah

Junior Member

The "area_parentlist" for "System" in "vw_area" table is NULL. I gather that to be problematic and/or indicative of the botched install I had at first?

Reply
April 20, 2014 12:12 AM

pegasus

VaultWiki Team

That's correct. The area_parentlist should always be a not null value, at least containing a copy of the pageid field.

Reply

+ Reply

All times are GMT -4. The time now is 7:09 AM.

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: Area Manager -> "System" -> Change Permissions = Error

Issue Tools