Issue: Wiki Crash vaultwiki 4

Issue Tools
- View Changes

April 11, 2013 3:30 PM

nobodieshero nobodieshero is offline

New Member

Wiki Crash vaultwiki 4

Deleted some areas

I was going through and messing around with areas trying to figure out how I will organize my wiki and after deleting my initial set of sub areas I get this error now when I click the wiki.

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT * FROM `vbvw_lastupdate` WHERE  `nodeid` IN ()  AND nodetypeid =  ORDER BY lastdateline DESC;

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 nodetypeid =  ORDER BY lastdateline DESC' at line 1
Error Number  : 1064
Request Date  : Thursday, April 11th 2013 @ 03:26:22 PM
Error Date    : Thursday, April 11th 2013 @ 03:26:22 PM
Script        : http://osxgaming.com/wiki_index.php
Referrer      : http://osxgaming.com/content.php
IP Address    : 108.173.181.73
Username      : nobodieshero
Classname     : vB_Database
MySQL Version : 5.5.30-cll

Issue Details

Issue Number 3016

Issue Type Bug

Project VaultWiki 4.x Series

Category Areas

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Alpha 5

Fixed Version 4.0.0 Alpha 6

Milestone VaultWiki 4 Alpha 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 12, 2013 6:43 PM
pegasus

VaultWiki Team
This will be fixed in Alpha 6. The cache entry for the deleted sub-area still exists, so the update collector tries to find updates for it. Since it no longer exists, the ID is missing, and the query fails when there's no IDs. I think this only occurs if there are no sub-areas left under the same parent as the deleted area.

You can restore access by executing the following database query:

Code:

DELETE FROM datastore WHERE title = 'vw_areacache'
Reply
April 13, 2013 12:44 PM

nobodieshero

New Member

Well I ran that in phpmyadmin and just got an error saying it didn't exist. Upon further investigating I realized that all my database names began with vb so the correct location would be vbvw_areacache however that table doesn't exist. I checked vbvw_area and noticed the area_childlist was still showing numbers as well (ex. 2, 6, 8, 10, ect.) for each areaid. So obviously the child area's were not deleted from here. Should I go ahead and clear those tables?

Reply
April 13, 2013 2:54 PM

pegasus

VaultWiki Team

No the table name is 'datastore' or in your case 'vbdatastore'. If your area_childlist fields are incorrect, only update the area_childlist field. (It should contain at least the ID of itself. Don't clear all the data in the whole 'vbvw_area' table.

Reply
April 13, 2013 4:28 PM

nobodieshero

New Member

Thats better vbdatastore seems to have worked.. thanks.

Reply

April 13, 2013 9:33 PM

nobodieshero nobodieshero is offline

New Member

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT * FROM `vbvw_lastupdate` WHERE  `nodeid` IN ()  AND nodetypeid =  ORDER BY lastdateline DESC;

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 nodetypeid =  ORDER BY lastdateline DESC' at line 1
Error Number  : 1064
Request Date  : Saturday, April 13th 2013 @ 09:31:36 PM
Error Date    : Saturday, April 13th 2013 @ 09:31:36 PM
Script        : http://osxgaming.com/wiki_index.php?title=Games
Referrer      : http://osxgaming.com/wiki_index.php
IP Address    : 142.179.252.151
Username      : nobodieshero
Classname     : vB_Database
MySQL Version : 5.5.30-cll

Same error when I click an area.

April 14, 2013 10:12 AM

pegasus

VaultWiki Team

Did you delete another area? This is the same error as the first post. I would imagine the same steps should resolve it again.

Reply
April 14, 2013 9:40 PM

nobodieshero

New Member

nope this is still the same as before.. i just tried it out and clicked wiki to make sure it fixed it.. then later in the day i clicked on the original areas that were showing up again to add a page and it went to the same error.. so the fix only fixed the main page.

And just to be sure I ran it again. Still same thing I can see the main wiki page but can't advance any further then that.

Reply
April 14, 2013 10:04 PM

pegasus

VaultWiki Team

Did you update the area_childlist fields that were wrong before you got this error again? If you modified them, did you clear the datastore entry again after fixing the area_childlist fields?

Reply
April 14, 2013 10:10 PM
pegasus

VaultWiki Team
This is not a real solution, but it should restore order to the affected areas. In vault/core/view/factory/area/vw.php, find:

Code:

if (!vw_Hard_Core::model('UI')->check('can_main_tab', $area))

Replace with:

Code:

if (!$area['displayorder'] OR !vw_Hard_Core::model('UI')->check('can_main_tab', $area))

A proper fix would be for an upgrade script to rebuild the corrupted childlists.
Reply
April 15, 2013 10:55 AM

pegasus

VaultWiki Team

A step has been added to the upgrade script for Alpha 6 which will rebuild parent- and child-list fields on areas. Marking this issue as Fixed.

Reply

+ Reply

All times are GMT -4. The time now is 10:53 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: Wiki Crash vaultwiki 4

Issue Tools