Issue: Step 17 vault wiki (paid) error

Issue Tools
- View Changes

February 16, 2017 9:56 PM

AnthonySmith AnthonySmith is offline

New Member

Step 17 vault wiki (paid) error

after a long and painful setup process i'm at a loss

So I fought with the lite version on install then I decided to take it on faith that the paid version would be a bit better on the install and lo and behold i did get up to step 17 which is as far as I've gotten so far! The error I'm currently facing is this.

Code:

Step 17

Importing phrases
An exception occurred: Mysqli statement execute error : Duplicate entry 'style_property_vw_fa_version_master-0' for key 'title' in [path]/library/Zend/Db/Statement/Mysqli.php on line 214
#0: Zend_Db_Statement_Mysqli->_execute() in [path]/library/Zend/Db/Statement.php at line 297
#1: Zend_Db_Statement->execute() in [path]/library/Zend/Db/Adapter/Abstract.php at line 479
#2: Zend_Db_Adapter_Abstract->query() in [path]/library/Zend/Db/Adapter/Abstract.php at line 574
#3: Zend_Db_Adapter_Abstract->insert() in [path]/library/XenForo/DataWriter.php at line 1624
#4: XenForo_DataWriter->_insert() in [path]/library/XenForo/DataWriter.php at line 1613
#5: XenForo_DataWriter->_save() in [path]/library/XenForo/DataWriter.php at line 1405
#6: XenForo_DataWriter->save() in [path]/vault/install/lib/common/xf.php at line 134
#7: vw_Install_Common_Controller_XF->do_language() in [path]/vault/install/lib/full/steps/xf.php at line 862
#8: vw_Install_Full_Steps_Controller_XF->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
#9: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
#10: vw_Progress_Steps_Controller->execute() in [path]/vault/install/lib/full/steps/vw.php at line 244
#11: vw_Install_Full_Steps_Controller->execute() in [path]/vault/core/controller/progress/vw.php at line 92
#12: vw_Progress_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
#13: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 35
#14: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/install/vw.php at line 258
#15: vw_CP_Install_Controller->install() in [path]/vault/core/controller/cp/install/vw.php at line 62
#16: vw_CP_Install_Controller->execute() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 119
#17: vw_XenForo_ControllerAdmin_Wiki->actionIndex() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 176
#18: vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in [path]/library/XenForo/FrontController.php at line 351
#19: XenForo_FrontController->dispatch() in [path]/library/XenForo/FrontController.php at line 134
#20: XenForo_FrontController->run() in [path]/admin.php at line 13

AFAIK my sql stuff is in order but if anyone can please guide me in the right direction I'd be a very happy web guy

Issue Details

Issue Number 4917

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 4 - Warnings / Script Errors

Affected Version 4.0.16

Fixed Version 4.0.17

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

February 17, 2017 9:10 AM

pegasus

VaultWiki Team

Duplicate entry errors usually happen if you double-click "Next Step" or "Next Batch" in manual mode, resulting in a race condition which is impossible for any software to handle or prevent.

The only way around this error is to reload the page in your browser and try again.

Reply

February 19, 2017 8:52 PM

AnthonySmith AnthonySmith is offline

New Member

Thanks. that was helpful!! I'm now at step 20 and get this

Code:

[B]Step 20[/B]

Importing templates
- template group: Style Property
An exception occurred: Mysqli statement execute error : Duplicate entry '0-vw_left' for key 'definition_style_id_property_name' in [path]/library/Zend/Db/Statement/Mysqli.php on line 214
#0: Zend_Db_Statement_Mysqli->_execute() in [path]/library/Zend/Db/Statement.php at line 297
#1: Zend_Db_Statement->execute() in [path]/library/Zend/Db/Adapter/Abstract.php at line 479
#2: Zend_Db_Adapter_Abstract->query() in [path]/library/Zend/Db/Adapter/Abstract.php at line 574
#3: Zend_Db_Adapter_Abstract->insert() in [path]/library/XenForo/DataWriter.php at line 1624
#4: XenForo_DataWriter->_insert() in [path]/library/XenForo/DataWriter.php at line 1613
#5: XenForo_DataWriter->_save() in [path]/library/XenForo/DataWriter.php at line 1405
#6: XenForo_DataWriter->save() in [path]/library/XenForo/Model/StyleProperty.php at line 2382
#7: XenForo_Model_StyleProperty->importStylePropertiesFromArray() in [path]/library/XenForo/Model/StyleProperty.php at line 2294
#8: XenForo_Model_StyleProperty->importStylePropertyXml() in [path]/vault/install/lib/common/xf.php at line 342
#9: vw_Install_Common_Controller_XF->do_stylevars() in [path]/vault/install/lib/common/xf.php at line 221
#10: vw_Install_Common_Controller_XF->do_templates() in [path]/vault/install/lib/full/steps/xf.php at line 907
#11: vw_Install_Full_Steps_Controller_XF->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
#12: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
#13: vw_Progress_Steps_Controller->execute() in [path]/vault/install/lib/full/steps/vw.php at line 244
#14: vw_Install_Full_Steps_Controller->execute() in [path]/vault/core/controller/progress/vw.php at line 92
#15: vw_Progress_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
#16: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 35
#17: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/install/vw.php at line 258
#18: vw_CP_Install_Controller->install() in [path]/vault/core/controller/cp/install/vw.php at line 62
#19: vw_CP_Install_Controller->execute() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 119
#20: vw_XenForo_ControllerAdmin_Wiki->actionIndex() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 176
#21: vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in [path]/library/XenForo/FrontController.php at line 351
#22: XenForo_FrontController->dispatch() in [path]/library/XenForo/FrontController.php at line 134
#23: XenForo_FrontController->run() in [path]/admin.php at line 13

it only loads every so often though most of the time I get a generic error from my browser that looks like this also my regular forums page is replaced by this

February 20, 2017 11:03 AM

pegasus

VaultWiki Team

Incomplete chunked encoding is a server problem. Your PHP installation might have opcache.fast_shutdown turned on in the master php.ini. This ini setting is known to cause connection problems between server processes. I would recommend that you disable it and restart your PHP process.

The second error suggests to me that the VaultWiki installation has been corrupted, probably by the connection issues in opcache.fast_shutdown, because it means that the wiki has no index records. If this error continues after you have finished the installation, you will need to uninstall and reinstall VaultWiki.

Reply
February 20, 2017 11:44 AM

pegasus

VaultWiki Team

As of 4.0.17, the VaultWiki installer will now check for the presence of opcache.fast_shutdown and require the admin to disable it before proceeding.

Reply

February 26, 2017 10:44 PM

AnthonySmith AnthonySmith is offline

New Member

First I'd like to thank you for all your help. I got this installed and oddly enough my previous issue turned out to be a cloudflare issue not a php issue.

so now I have this installed and when I select my wiki installation I get this:

Code:

An exception occurred: Invalid argument supplied for foreach() in /home/community_forum/public_html/community/vault/core/model/ui/tab/page/vw.php on line 86

XenForo_Application::handlePhpError() in /home/community_forum/public_html/community/vault/core/model/ui/tab/page/vw.php at line 86
vw_UI_Tab_Page_Model->can_edit_tab() in /home/community_forum/public_html/community/vault/core/model/ui/tab/vw.php at line 58
vw_UI_Tab_Model->check() in /home/community_forum/public_html/community/vault/core/model/ui/vw.php at line 62
vw_UI_Model->check() in /home/community_forum/public_html/community/vault/core/controller/ui/integrate/vw.php at line 198
vw_UI_Integrate_Controller->get_stack() in /home/community_forum/public_html/community/vault/core/controller/ui/integrate/vw.php at line 64
vw_UI_Integrate_Controller->setup() in /home/community_forum/public_html/community/vault/core/controller/ui/integrate/vw.php at line 40
vw_UI_Integrate_Controller->integrate() in vw/XenForo/CodeEventListener/Public.php at line 342
vw_XenForo_CodeEventListener_Public::front_controller_post_view()
call_user_func_array() in XenForo/CodeEvent.php at line 90
XenForo_CodeEvent::fire() in XenForo/FrontController.php at line 183
XenForo_FrontController->run() in /home/community_forum/public_html/community/index.php at line 13

Any help is appreciated.

February 27, 2017 12:38 PM
pegasus

VaultWiki Team
1. What was the CloudFlare problem? If it's an issue we can detect automatically and warn people about, we would like to do that.
2. After fixing the CloudFlare problem, did you do as I suggested and uninstall VaultWiki, then reinstall?

The error in your previous post tells me that the wiki index node, which is created by the installer and is needed for many wiki features to function properly, is probably missing. If you did not reinstall, you need to do that.

Otherwise, the error can be worked around as follows. In vault/core/controller/fetch/vw.php, find:

Code:

$index_pages = $this->get('Page', array(

Before it, add:

Code:

$index['typelist'] = array($index['itemtypeid'], vw_Hard_Core::model('Node')->id('Index'));

To test the change, you will need to modify vault/config.php and change VW_CACHE_ON to 0.

While this will handle this one error, there will probably be lots more due to the missing index.
If you have already reinstalled and you still have no wiki index, you will need to submit a ticket so we can try to find out why it's missing and create one manually.
Reply
February 27, 2017 9:21 PM

AnthonySmith

New Member

I have a feeling that I'm missing something due to my noobishness but because I was unable to find an uninstall button or a detailed guide on uninstalling I just reuploaded the files after deleting them from the server so I assume this was not the proper method here... after you asked this i re-searched the wiki here and the closest i could find to a helpful result mentioned this file

/vault/core/controller/uninstall/xf.php

Sadly i get a "forbidden" error which corresponds to another issue that I found but I'm clueless as to how to fix/do this

as for cloudflare we didn't notice an error specifically but after noticing that our php files were in order I tried this as a troubleshooting method because we've had issues previously with cloudflare resetting connections which I assumed could mimic the php issue you described.

Reply
February 28, 2017 9:19 AM

pegasus

VaultWiki Team

In XenForo, you uninstall add-ons as follows: https://www.vaultwiki.org/pages/Help...ltWiki#XenForo

Reply
March 3, 2017 8:08 PM

Koala_Steamed

New Member

Hi Pegasus, I'm working with AnthonySmith on this and we seem to have come up with a redirect issue. When clinking on the Wiki tab (which is linked to "https://freedom.community.tm/wiki/" it will be redirected to this page "https://es.community.tm/wiki/" which is one of our language forums that is created from the Xencentral Multisite System add-on. Do you know how we would correctly set this to "https://freedom.community.tm/wiki/" and not redirect?

Another issue that has been popping up is that we are sometimes getting an "error 500" but only with logged in users when trying to view the forums. This can be fixed by rebuilding templates in the ACP, could this possible be some conflict with our multisite or cloudflare add-ons?

Reply
March 4, 2017 9:18 AM

pegasus

VaultWiki Team

That sounds like a question more for the XenCentral people. You want to know how to ignore the language forum rules on the freedom subdomain or on the /wiki route.

"Error 500" can literally be anything. You will have to dig deeper to see what that actual error is.

Reply
March 7, 2017 8:38 AM

Koala_Steamed

New Member

So is there no way to choose where the Wiki index page is located?

Getting these errors

Reply
March 7, 2017 8:55 AM

pegasus

VaultWiki Team

The wiki index page is located at the wiki route, default /wiki
You can change the name of the route in AdminCP > Home > Options > VaultWiki: Site Config > Name of the Wiki Route.
That database error occurs when creating a new synonym, but specifying a targetid in the create-URL which does not refer to a valid page.

In your stack trace, the create-URL appears to be coming from an existing page; however, you should not be able to access any existing page if its targetid is invalid. The only exception I can think of is the wiki index page, which is the fallback when another target does not exist.

Since your wiki index is missing its targetid, you can try to edit the content of the wiki index, which should generate a new targetid when you save the edit. Then you will be able to set synonyms for the index without hitting this error.

Reply
March 7, 2017 10:31 PM

Koala_Steamed

New Member

Changing the Wiki Route to where the Index was (https://es.community.tm) fixed the error, I can now edit the page and manage synonyms. Only problem is I still can't change the location of where the index is. When going to https://freedom.community.tm/wiki/ it now redirects to https://freedom.community.tm while the index seems to still be located at https://es.community.tm/wiki/

This is what the wiki base url is set up as at the moment

Reply
March 8, 2017 9:38 AM

pegasus

VaultWiki Team

To make sure you are not fighting against a stale cache in VaultWiki, edit vault/config.php and set VW_CACHE_ON to 0 until you can get everything working as expected.

It is possible that you are experiencing a conflict between the wiki router and the XenCentral router. If this is the case, a developer will need to investigate the collision. If this issue persists, please request Ticket Support: https://www.vaultwiki.org/members/?do=tickets

Reply
March 22, 2017 9:01 AM

Koala_Steamed

New Member

Hey again! We got all that working with a re-install

Unfortunately we have come up with a new issue where permissions are failing to save "invalid permission specified" and ideas on a fix?
https://community.gyazo.com/2f9c9588...5bb9327f8853b0

Thanks again for the help, looks like we almost have it operational.

Reply

+ Reply

All times are GMT -4. The time now is 7:26 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: Step 17 vault wiki (paid) error

Issue Tools