Issue: Various issues and questions since install

Issue Tools
- View Changes

December 21, 2014 5:31 PM

SubaruClub

New Member

Various issues and questions since install

Issues we have come up against

Hi,

We have installed the product on our site and made it available to only a couple people who will be our Wiki Moderators.

We want to better understand the product and get it setup before launching it publicly.

So far our issues are:

1) No manuals for V4 - Admin and Usage

2) When people try to change the order of chapters in a test book they made they get the attached error and as admin I get this DB error e-mailed to me just as all other DB errors get sent to me:

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT categoryitemid FROM `vw_categoryitem` WHERE pageid = AND itemcategoryid = 8;

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 itemcategoryid = 8' at line 1
Error Number : 1064
Request Date : Saturday, December 20th 2014 @ 05:22:18 PM
Error Date : Saturday, December 20th 2014 @ 05:22:19 PM
Script : http://www.toronto-subaru-club.com/f...t&itemtypeid=1
Referrer : http://www.toronto-subaru-club.com/f...m&itemtypeid=1
IP Address : 99.238.239.234
Username : Nick411
Classname : vB_Database_MySQLi
MySQL Version :

3) IMG Tags not working when trying to link images from outside of the site

4) Uploading images doesn't work properly. See attached screen capture.

I am sure this could just be configuration issues.

We really want to move forward with an annual licence but need to make sure it is working first.

D.

Issue Details

Issue Number 4110

Issue Type Bug

Project VaultWiki 4.x Series

Category General

Status Duplicate

Priority 4 - Warnings / Script Errors

Affected Version 4.0.0 RC 5

Fixed Version (none)

Milestone VaultWiki 4.0 Gold

Software DependencyvBulletin 4.x w/ ckEditor

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

December 21, 2014 7:22 PM
pegasus

VaultWiki Team
1) We are aware that many of the VW4 manual pages are missing. Someone is currently working on them and we hope to have them up soon. Until then, we are welcome to address any questions you may have about how to perform various tasks. There is already an open issue for the missing manual pages here: https://www.vaultwiki.org/issues/4056/

2) This is a known issue and is slated to be fixed by the next update. It occurs when a user creates a new page and also selects categories for the new page, or when creating a new page via the "Add Listing" menu in a Category. The error does not occur when adding categories via the Edit tab to pages that were already created.

It can be fixed by modifying vault/core/controller/dm/item/category/vw.php. Find:

Code:

$duplicate_check = vw_DB::get()->query()->select(array( 'fields' => array('categoryitemid'), 'table' => 'vw_categoryitem', 'where' => array( vw_DB::get()->query()->eq('pageid', $this->instance->get('pageid')), vw_DB::get()->query()->eq('itemcategoryid', $this->instance->get('itemcategoryid')) ), 'first' => 1 )); if ($duplicate_check) { $this->instance->error('vw_page_already_category'); return false; }

Replace with:

Code:

if ($this->instance->get('pageid')) { $duplicate_check = vw_DB::get()->query()->select(array( 'fields' => array('categoryitemid'), 'table' => 'vw_categoryitem', 'where' => array( vw_DB::get()->query()->eq('pageid', $this->instance->get('pageid')), vw_DB::get()->query()->eq('itemcategoryid', $this->instance->get('itemcategoryid')) ), 'first' => 1 )); if ($duplicate_check) { $this->instance->error('vw_page_already_category'); return false; } }

3) For IMG tags in wiki pages, in the VaultWiki Admin Panel, go to Structures > Area Manager. In the settings for the area where the tag isn't working, make sure "Images" is checked for "Parse the following in Pages". If it's the index page, the setting can be found in Settings > Content Types > Wiki Index Options.

For IMG tags in wiki comments, also in the Area manager, there is a "Parse the following in Comments" section. In addition to that, at least one of the user's groups must be allowed to use IMG tags in wiki comments in the wiki permissions (Permissions > Usergroups > (edit) > Comment Permissions > Can use images in comments?)

4) The user must have permission to upload specific file extensions. In the VaultWiki Admin Panel, go to Content > Attachments, and click the "Modify Permissions" button. Check that at least one of the user's groups is allowed to upload jpg files. Please let me know if none of the groups were allowed by default, as this would be a bug in the install script that set the wrong default permissions. You should be able to change the permissions as needed.
Reply

+ Reply

All times are GMT -4. The time now is 8:52 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: Various issues and questions since install

Issue Tools