Issue: Broken install

Issue Tools
- View Changes

August 3, 2018 1:55 PM

expanserpb

Junior Member

Broken install

Installing on new server. Auto install seemed to stick so switched to manual. Looks like it went wrong on the database:

Chronicles Roleplay
Server Error
Database Error: SELECT * FROM `vw_integrate` WHERE nodetypeid = 8 AND `nodeid` IN (1,2) AND adminset = 1 AND active = 1 Mysqli prepare error: Table 'chroniclesrp.vw_integrate' doesn't exist

vw_DB_Controller_XF->throw_error() in /var/www/html/vault/core/controller/db/xf.php at line 203
vw_DB_Controller_XF->query_read() in /var/www/html/vault/core/model/db/mysql/vw.php at line 27
vw_DB_MySQL_Model->select() in /var/www/html/vault/core/model/plugins/forum/vw.php at line 66
vw_Plugins_Forum_Model->cache_ordered_forums() in vw/XenForo/Model/Node.php at line 56
vw_XenForo_Model_Node->getAllNodes() in XenForo/Model/Node.php at line 737
XenForo_Model_Node->getNodeDataForListDisplay() in Audentio/UIX/Model/Node.php at line 16
Audentio_UIX_Model_Node->getNodeDataForListDisplay() in vw/XenForo/Model/Node.php at line 24
vw_XenForo_Model_Node->getNodeDataForListDisplay() in XenForo/ControllerPublic/Forum.php at line 129
XenForo_ControllerPublic_Forum->actionIndex() in XenForo/FrontController.php at line 369
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
XenForo_FrontController->run() in /var/www/html/index.php at line 13

https://chroniclesrp.net/

Sigh Sometimes I wish my users didn't want wikis

Issue Details

Issue Number 5435

Issue Type Bug

Project VaultWiki 4.x Series

Category General

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.23

Fixed Version 4.0.23

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)

August 3, 2018 2:10 PM

expanserpb expanserpb is offline

Junior Member

Code:

+--------------------------------------+
| Tables_in_chroniclesrp               |
+--------------------------------------+

| vw_301                               |
| vw_area                              |
| vw_attachment                        |
| vw_attachmentedit                    |
| vw_attachmentfail                    |
| vw_attachmentfile                    |
| vw_attachmentthumb                   |
| vw_attachmenttype                    |
| vw_attachmentview                    |
| vw_block                             |
| vw_blockcache                        |
| vw_blockcacherelation                |
| vw_blocktype                         |
| vw_book                              |
| vw_cache                             |
| vw_category                          |
| vw_categoryitem                      |
| vw_chainlock                         |
| vw_chainqualify                      |
| vw_chainqueue                        |
| vw_chapter                           |
| vw_chapterorder                      |
| vw_comment                           |
| vw_contenttype                       |
| vw_counter                           |
| vw_defer                             |
| vw_discussion                        |
| vw_feed                              |
| vw_feedcache                         |
| vw_feeditem                          |
| vw_file_usage                        |
| vw_flood                             |
| vw_help                              |
| vw_import                            |
| vw_importerror                       |
| vw_importsession                     |
| vw_island                            |
| vw_itemview                          |
| vw_langgroup                         |
| vw_langitem                          |
| vw_language                          |
| vw_lastupdate                        |
| vw_lastupdatecache                   |
| vw_likes                             |
| vw_link                              |
| vw_lock                              |
| vw_log                               |
| vw_markread                          |
| vw_moderator                         |
| vw_nodetype                          |
| vw_options                           |
| vw_page                              |
| vw_parsed                            |
| vw_parsed_widget                     |
| vw_patchinfo                         |
| vw_path                              |
| vw_permission                        |
| vw_ping                              |
| vw_poll                              |
| vw_pollitem                          |
| vw_pollvote                          |
| vw_prefix                            |
| vw_protect                           |
| vw_proxy                             |
| vw_rate                              |
| vw_redirect                          |
| vw_replacement                       |
| vw_replacementset                    |
| vw_report                            |
| vw_reputation                        |
| vw_revision                          |
| vw_route                             |
| vw_search                            |
| vw_searchmassive                     |
| vw_searchresult                      |
| vw_session                           |
| vw_share                             |
| vw_special                           |
| vw_subscribe                         |
| vw_subscribefolder                   |
| vw_subscribelog                      |
| vw_team                              |
| vw_team_member                       |
| vw_teamitem                          |
| vw_template                          |
| vw_templateusage                     |
| vw_topic                             |
| vw_unique                            |
| vw_upgradelog                        |
| vw_usercount                         |

August 3, 2018 2:35 PM

pegasus

VaultWiki Team

MySQL:

Code:

CREATE TABLE vw_integrate
(
integrateid INT UNSIGNED NOT NULL AUTO_INCREMENT,
title VARCHAR(255) NOT NULL DEFAULT '',
protect INT(1) UNSIGNED NOT NULL DEFAULT '0',
active INT(1) UNSIGNED NOT NULL DEFAULT '0',
nodeid INT UNSIGNED NOT NULL DEFAULT '0',
nodetypeid INT UNSIGNED NOT NULL DEFAULT '0',
injectid INT UNSIGNED NOT NULL DEFAULT '0',
injecttypeid INT UNSIGNED NOT NULL DEFAULT '0',
extra BLOB NULL,
adminset INT(1) UNSIGNED NOT NULL DEFAULT '0',
nodekey VARCHAR(21) NOT NULL DEFAULT '',
PRIMARY KEY (integrateid),
INDEX active (active),
INDEX nodeid (nodeid, nodetypeid),
INDEX itemid (injectid, injecttypeid),
INDEX adminset (adminset),
INDEX nodekey (nodekey)
)

Fixed the missing table in the current build, which affected new installations of 4.0.23 only. Users who already have this problem should execute the query above (note scroll bar).

August 3, 2018 3:32 PM

expanserpb

Junior Member

ERROR 1064 (42000): 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 ''0',
active INT(1) UNSIGNED NOT NULL '0',
nodeid INT UNSIGNED NOT NULL '0',
node' at line 5

Reply
August 3, 2018 6:41 PM

pegasus

VaultWiki Team

Sorry, edited.

Reply
August 4, 2018 5:08 AM

expanserpb

Junior Member

Thank you! All sorted

Reply

+ Reply

All times are GMT -4. The time now is 11:36 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: Broken install

Issue Tools