Issue: Get error after physically deleting a category

Issue Tools
- View Changes

April 4, 2013 1:20 AM

Replicators Replicators is offline

Junior Member

Get error after physically deleting a category

I am pretty much messing around to try to get a feel of how the wiki works, and i made a category just to see what it was or did, now i want to delete it, i tried physically deleting it and also checked the box under that option and got a db error.

Code:

Warning: array_keys() expects parameter 1 to be array, integer given in /home/*****/public_html/vault/core/controller/dm/category/vw.php on line 85

Warning: Invalid argument supplied for foreach() in /home/*****/public_html/vault/core/controller/dm/category/vw.php on line 90

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT * FROM `vb_vw_categoryitem` WHERE  `itemcategoryid` 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 1
Error Number  : 1064
Request Date  : Thursday, April 4th 2013 @ 12:14:33 AM
Error Date    : Thursday, April 4th 2013 @ 12:14:36 AM
Script        : http://www.*****.com/wiki_inlinemod.php?do=kill
Referrer      : http://www.*****.com/wiki-index/planets?do=delete
IP Address    : **.***.***.***
Username      : ******
Classname     : vB_Database
MySQL Version : 5.0.96-community-cll-lve

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 459
#2 vB_Database->query_read() called in [path]/vault/core/controller/db/vb3.php on line 187
#3 vw_DB_Controller_vB3->query_read() called in [path]/vault/core/model/db/mysql/vw.php on line 29
#4 vw_DB_MySQL_Model->select() called in [path]/vault/core/controller/dm/category/vw.php on line 107
#5 vw_DM_Category_Controller->delete_multiple() called in [path]/vault/core/controller/dm/vw.php on line 113
#6 vw_DM_Controller->delete_multiple() called in [path]/vault/core/controller/dm/page/vw.php on line 1543
#7 vw_DM_Page_Controller->delete_multiple() called in [path]/vault/core/controller/dm/vw.php on line 113
#8 vw_DM_Controller->delete_multiple() called in [path]/vault/core/controller/ui/imod/vw.php on line 323
#9 vw_UI_iMod_Controller->kill() called in [path]/vault/core/controller/ui/imod/vw.php on line 77
#10 vw_UI_iMod_Controller->execute() called in [path]/wiki_inlinemod.php on line 47

Issue Details

Issue Number 3000

Issue Type Bug

Project VaultWiki 4.x Series

Category Areas

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Alpha 3

Fixed Version 4.0.0 Alpha 4

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 4, 2013 1:23 AM

Replicators Replicators is offline

Junior Member

Now when i go to that area i get

Code:

#1 : vbstop() called in [path]/vault/core/view/ui/proxy/vb4.php on line 89
#2 : vw_UI_Proxy_View_vB4->debug_error() called in [path]/vault/core/controller/fetch/stack/vw.php on line 255
#3 : vw_Fetch_Stack_Controller->verify_retval() called in [path]/vault/core/controller/fetch/vw.php on line 281
#4 : vw_Fetch_Controller->verify_retval() called in [path]/vault/core/controller/fetch/vw.php on line 147
#5 : vw_Fetch_Controller->get() called in [path]/vault/core/view/content/list/base/vw.php on line 201
#6 : vw_Content_List_View->do_query() called in [path]/vault/core/view/content/list/base/vw.php on line 177
#7 : vw_Content_List_View->query() called in [path]/vault/core/view/content/list/base/vw.php on line 22
#8 : vw_Content_List_View->get() called in [path]/vault/core/view/ui/area/vw.php on line 82
#9 : vw_UI_Area_View->view() called in [path]/vault/core/controller/ui/area/vw.php on line 98
#10 : vw_UI_Area_Controller->view() called in [path]/vault/core/controller/ui/stack/vw.php on line 171
#11 : vw_UI_Stack_Controller->view() called in [path]/vault/core/controller/ui/stack/vw.php on line 138
#12 : vw_UI_Stack_Controller->execute() called in [path]/wiki_index.php on line 92

April 4, 2013 5:20 AM

alpha

Junior Member

i had this issue too . i thought this is fixed in alpha 3 .... or do you have alpha 2 still running?

Reply
April 4, 2013 10:39 AM
pegasus

VaultWiki Team
We missed one place with the new delete code (there were two loops near each other that look similar). The ZIP is updated now: vault/core/controller/dm/page.php.
As for the corrupted category causing the vbstop, you'll need to run this query:

Code:

DELETE vw_category, vw_page FROM vw_page AS vw_page LEFT JOIN vw_category AS vw_category ON (vw_category.pageid = vw_page.pageid) LEFT JOIN vw_route AS vw_route ON (vw_route.itemtypeid = 1 AND vw_route.itemid = vw_page.pageid) WHERE vw_route.itemid IS NULL
Reply
April 5, 2013 12:20 AM

Replicators

Junior Member

Well i use a prefix, out of that code you gave me i don't know what all to add my prefix to.

Reply
April 5, 2013 10:23 AM

pegasus

VaultWiki Team

If you use a prefix, it goes before every vw

Reply

+ Reply

All times are GMT -4. The time now is 6:14 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: Get error after physically deleting a category

Issue Tools