VaultWiki

VaultWiki [Paid] 4.1.7 Patch Level 1

No permission to buy ($15.00)
Overview Updates (55) Reviews (15) History Discussion
If you're familiar with and can read LocalSettings.php, then it's pretty easy. Basically just copy your configs from one file to another. If you're not comfortable doing that sort of thing, we offer a paid Import Service.
 
pegasus updated VaultWiki with a new update entry:

Changes in 4.0.4

(released May 21, 2015)
  • Filter Search by Page Type
  • Add Multiple Pages to Categories/Books/etc at a time
  • Fixed Photo of Loris vulnerability
  • Fixed feeds not appearing in sitemaps, news feeds
  • Fixed data loss of discussion views
  • Fixed template synonyms not parsing as target template
  • Fixed a few race conditions
  • Fixed "Add listing" tool removing pages from other categories
  • About 35 other bugs are fixed
Click to expand...

Read the rest of this update entry...
 
I have no rights to post this bug on your site (Walter, you do not have permission to access this page) so I post it here:

Fresh install of 4.0.4, during install step 8 I get this SQL error (note the missing value for lastupdate):

Code: 
An exception occurred: Database Error: INSERT IGNORE INTO `vw_counter` (`routeid`, `lastupdate`) VALUES (1,) Mysqli prepare 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 in /home/xxxxxx/public_html/test/vault/core/controller/db/xf.php on line 146

    vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 132
    vw_DB_Controller_XF->query_write() in vault/core/model/db/mysql/vw.php at line 950
    vw_DB_MySQL_Model->shutdown_or_run() in vault/core/model/db/mysql/vw.php at line 820
    vw_DB_MySQL_Model->insert() in vault/core/controller/dm/special/vw.php at line 89
    vw_DM_Special_Controller->post_save_each() in library/vw/XenForo/DataWriter.php at line 456
    vw_XenForo_DataWriter->_postSave() in library/XenForo/DataWriter.php at line 1409
    XenForo_DataWriter->save() in vault/core/controller/dm/xf.php at line 400
    vw_DM_Controller_XF->save() in vault/core/controller/install/db/insert/vw.php at line 228
    vw_Install_DB_Insert_Controller->execute_dm() in vault/core/controller/install/full/steps/vw.php at line 102
    vw_Install_Full_Steps_Controller->{closure}() in vault/core/controller/progress/vw.php at line 100
    vw_Progress_Controller->call() in vault/core/controller/cp/progress/vw.php at line 45
    vw_CP_Progress_Controller->process() in vault/core/controller/cp/install/vw.php at line 211
    vw_CP_Install_Controller->install() in vault/core/controller/cp/install/vw.php at line 64
    vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 113
    vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 170
    vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 180
    vw_XenForo_ControllerAdmin_Wiki->actionInstall() in library/XenForo/FrontController.php at line 347
    XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in admin.php at line 13
 
In vault/core/controller/dm/special/vw.php, find:
Code: 
'lastupdate' => $this->instance->get('dateline')
Replace with:
Code: 
'lastupdate' => intval($this->instance->get('dateline'))

You must confirm your email address using the link in the registration email before you can post on the support site.
 
pegasus said:
Replace with:
Click to expand...

Now I get this error (still at step 8):
Code: 
An exception occurred: Mysqli statement execute error : Column 'content_id' cannot be null in /home/xxxxxx/public_html/test/library/Zend/Db/Statement/Mysqli.php on line 214

    Zend_Db_Statement_Mysqli->_execute() in library/Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in library/Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in library/XenES/Model/Elasticsearch.php at line 301
    XenES_Model_Elasticsearch->logFailedIndex() in library/XenES/Search/SourceHandler/ElasticSearch.php at line 977
    XenES_Search_SourceHandler_ElasticSearch->_logFailedIndex() in library/XenES/Search/SourceHandler/ElasticSearch.php at line 64
    XenES_Search_SourceHandler_ElasticSearch->insertIntoIndex() in library/XenForo/Search/Indexer.php at line 44
    XenForo_Search_Indexer->insertIntoIndex() in library/vw/XenForo/Search/DataHandler/Base.php at line 66
    vw_XenForo_Search_DataHandler_Base->_insertIntoIndex() in library/vw/XenForo/Search/DataHandler/vwPage.php at line 49
    vw_XenForo_Search_DataHandler_vwPage->_insertIntoIndex() in library/XenForo/Search/DataHandler/Abstract.php at line 275
    XenForo_Search_DataHandler_Abstract->insertIntoIndex() in library/vw/XenForo/DataWriter.php at line 535
    vw_XenForo_DataWriter->_insertOrUpdateSearchIndex() in library/vw/XenForo/DataWriter.php at line 484
    vw_XenForo_DataWriter->update_search_index() in vault/core/controller/dm/special/vw.php at line 69
    vw_DM_Special_Controller->post_save_each() in library/vw/XenForo/DataWriter.php at line 456
    vw_XenForo_DataWriter->_postSave() in library/XenForo/DataWriter.php at line 1409
    XenForo_DataWriter->save() in vault/core/controller/dm/xf.php at line 400
    vw_DM_Controller_XF->save() in vault/core/controller/install/db/insert/vw.php at line 228
    vw_Install_DB_Insert_Controller->execute_dm() in vault/core/controller/install/full/steps/vw.php at line 102
    vw_Install_Full_Steps_Controller->{closure}() in vault/core/controller/progress/vw.php at line 100
    vw_Progress_Controller->call() in vault/core/controller/cp/progress/vw.php at line 45
    vw_CP_Progress_Controller->process() in vault/core/controller/cp/install/vw.php at line 211
    vw_CP_Install_Controller->install() in vault/core/controller/cp/install/vw.php at line 64
    vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 113
    vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 170
    vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 180
    vw_XenForo_ControllerAdmin_Wiki->actionInstall() in library/XenForo/FrontController.php at line 347
    XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in admin.php at line 13
*sigh*
 
I don't know why you would ever get a NULL value assigned for the routeid (the field used for content_id). Even if you restart the same step with a NULL id (as you did here), it should still create one for you before it gets anywhere near the index.

In vault/core/controller/dm/base/routable/vw.php, find:
Code: 
$this->instance->set_info('routeid', $routeid);
Before it, add:
Code: 
        if (!$routeid)
        {
            // if it fails, at least give us a numeric value
            $routeid = 0;
        }
If that works, I really don't know why it can't get the ID out of the DM. It will always return a valid integer unless it fails a sanity check, which is impossible to debug on my end without access to a system that's lost its sanity. The entry that's doing this will never be searchable.

I have noticed that servers running PHP 7 can lose sanity very easily (in PHP 7 builds from November - March variables in memory could suddenly become NULL from one line to the next, usually causing an infinite loop or a segfault). Are you running PHP 7?

If it still doesn't work, please PM me on the support site and I will give you a free installation service so we can get you up and running.
 
Last edited:
I'm running PHP 5.5 on this server and now that this is fixed, I get another error in step 9:
TBH, this is a fresh install of VaultWiki and I simply don't expected such problems in a rather simple installation routine.

Code: 
Adding data to table: vw_page

Creating the main index

An exception occurred: Database Error: UPDATE `vw_counter` SET `editcount` = CASE `pageid` WHEN 1 THEN editcount + 1 END WHERE `pageid` IN (1) LIMIT 1 Mysqli prepare error: Unknown column 'pageid' in 'where clause' in /home/xxxxx/public_html/test/vault/core/controller/db/xf.php on line 146

    vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 132
    vw_DB_Controller_XF->query_write() in vault/core/model/db/mysql/vw.php at line 950
    vw_DB_MySQL_Model->shutdown_or_run() in vault/core/model/db/mysql/vw.php at line 719
    vw_DB_MySQL_Model->update() in vault/core/controller/dm/node/vw.php at line 327
    vw_DM_Node_Controller->update_counters() in vault/core/controller/dm/vw.php at line 106
    vw_DM_Controller->update_counters() in vault/core/controller/dm/base/vw.php at line 1354
    vw_DM_Base_Controller->rebuild_multiple() in vault/core/controller/dm/revision/vw.php at line 281
    vw_DM_Revision_Controller->post_save_each() in library/vw/XenForo/DataWriter.php at line 456
    vw_XenForo_DataWriter->_postSave() in library/XenForo/DataWriter.php at line 1409
    XenForo_DataWriter->save() in vault/core/controller/dm/xf.php at line 400
    vw_DM_Controller_XF->save() in vault/core/controller/dm/page/vw.php at line 1617
    vw_DM_Page_Controller->save_revision() in vault/core/controller/dm/page/vw.php at line 1341
    vw_DM_Page_Controller->post_save_each() in library/vw/XenForo/DataWriter.php at line 456
    vw_XenForo_DataWriter->_postSave() in library/XenForo/DataWriter.php at line 1409
    XenForo_DataWriter->save() in vault/core/controller/dm/xf.php at line 400
    vw_DM_Controller_XF->save() in vault/core/controller/install/full/steps/vw.php at line 158
    vw_Install_Full_Steps_Controller->{closure}() in vault/core/controller/progress/vw.php at line 100
    vw_Progress_Controller->call() in vault/core/controller/cp/progress/vw.php at line 45
    vw_CP_Progress_Controller->process() in vault/core/controller/cp/install/vw.php at line 211
    vw_CP_Install_Controller->install() in vault/core/controller/cp/install/vw.php at line 64
    vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 113
    vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 170
    vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 180
    vw_XenForo_ControllerAdmin_Wiki->actionInstall() in library/XenForo/FrontController.php at line 347
    XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in admin.php at line 13
 
I did not expect any issues in the install routine either. The 4.0.3 install routine was flawless. I heard a similar account of the issues you're encountering now from another user last week, but it turned out they were using the 4.0.4 install script against 4.0.3 files that they already uploaded but didn't install yet. Now that it has happened to another user, I'm inclined to believe that something is actually awry.

This new error absolutely fails sanity. The install step sets the install flag ON, and the DM is supposed to skip this query if the install flag is set to ON.

You can try to set a different flag to bypass it, which should be safe only on a fresh install. In vault/core/controller/install/steps/full/vw.php, find:
Code: 
$index = vw_DB::get()->query()->select(array(
Before it, add:
Code: 
vw_Hard_Core::model('Settings')->set('vw_version_string', '4.0.4');
 
Last edited:
pegasus said:
core/controller/install/steps/full/vw.php
Click to expand...

There is no such file. You probably meant the other way round core/controller/install/full/steps/vw.php ?

After this correction, installation seemed to work - but now it fails doing step 24 rebuilding cache entries. Every time I click on "next batch" it works for a short while then it comes back to exact the same step.

Is it safe to remove this addon and do a complete reinstall?
 
Last edited:
If you made it all the way to "Next Batch" it will finish eventually. I would recommend going back to Auto Mode, so you don't have to click through every single batch. Depending on how many add-ons you have or don't have, how fast your server is, etc there can be 1 batch or 100,000 batches -- rebuilding all the phrases, templates, etc. XenForo usually uses its own version of Auto Mode for this.

If you made it all the way there, you don't really need to uninstall, but it should be safe to do at this point using the normal uninstall routine for a XenForo addon.

I spun up a new test instance today and can confirm that there were a number of compatibility breaks with the installer in 4.0.4 that did not exist in 4.0.3. I've worked through what I found and generated 4.0.4 build 004 which should restore compatibility between the install routines and the target version 4.0.4. If you reinstall I recommend doing so with the new build.
 
I'm trying to install images into my actual wiki pages - but it seems like a hassle to do this. What might the issue be?
 
1. In the editor, click the gold picture frame icon.
2. Click "+ New Attachment".
3. Browse your PC for the image you want.
4. Write a name for the image.
5. Apply these changes to insert the image.
 
@pegasus Parse HTML doesn't seem to be working. I enter HTML into the wiki page, and it just shows up as text. What am I doing wrong?

http://snag.gy/zgKJn.jpg

This would be amazing if you integrated a text to HTML converter like WordPress and the following website: https://justpaste.it/. I need to move a lot of content from another source into VaultWiki, and the easiest way would be if I could highlight, copy, and paste. This doesn't work because there are tables, images, and other formats. So, my solution is to paste the content into the website cited above to convert the content to HTML, then paste into VaultWiki. VaultWiki isn't recognizing the HTML code at present.

Also, are you working on a widget for the Widget Framework?
 
Last edited:
Is VW4.1 coming soon? That release is set to have a lot of features that will make VW4 very attractive.
 
Hey,

Just bought and installed this addon on my forum, however it seems to be not displaying correctly, can you guide me on fixing this issue?

Here is an image of how it looks:

a410718daf.png
 
It looks like the CSS for the wiki is not loading on your site or it contains errors.

Try disabling the addon and then reenabling it.


If that fails, Please PM me a link to your wiki so I can take a closer look.
 
You must log in or register to reply here.

Similar threads

pegasus
VaultWiki [Paid]
2 3
Replies
49
Views
3K
pegasus
pegasus
XenConcept
[XenConcept] Quiz Manager [Paid]
2
Replies
38
Views
2K
XenConcept
XenConcept
G
  • Suggestion Suggestion
Integration of a WYSIWYG Editor for Notice Creation
Replies
5
Views
1K
Suzanne O
Suzanne O
XDinc
[XTR] Paid Membership [Paid]
Replies
16
Views
2K
NYJimbo
NYJimbo
XDinc
[XTR] Advanced Page Slider [Paid]
Replies
4
Views
758
XDinc
XDinc
Top Bottom