Issue: Mysqli prepare error: Table 'database.vw_log' doesn't exist

Issue Tools
- View Changes

September 15, 2013 12:14 PM

Alfa1

Distinguished Member

Mysqli prepare error: Table 'database.vw_log' doesn't exist

When doing an import from VW3 it apparently looks for vw_log instead of vault_log.
Is this the case for all tables? (vw instead of vault)

Issue Details

Issue Number 3338

Issue Type Bug

Project VaultWiki 4.x Series

Category Importing

Status Duplicate

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Beta 5

Fixed Version (none)

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)

September 15, 2013 2:28 PM

pegasus

VaultWiki Team

I have noticed this on another user's install. Some server configurations seem to drop the target DB connection when the source database is connected. When this happens, updates to the target DB are applied instead to the source DB (which fails with a DB error - usually 'vw_log' does not exist). I'm not sure exactly what causes this, but some refactoring of the DB controller seems to be effective. If my user has Admin Panel access on your test site, I will gladly try the changes there as well and perform a test import against the data there in case there are new issues after the change.

Marking this issue as a duplicate of: https://www.vaultwiki.org/issues/3336/

Reply
September 16, 2013 4:09 AM

Alfa1

Distinguished Member

Well that sucks. My live site is down. Vaultwiki seems to have affected the .htaccess. After adding the exact same content to a new .htaccess file the site worked again. I'm not sure what was altered in the database. No database errors occurred.
Do you know what exactly has been changed by vw4? I need to decide whether i need to revert to the latest backup. Please respond quickly.

Reply
September 16, 2013 4:39 PM

pegasus

VaultWiki Team

I don't think you would need to revert a backup on the live site. None of the tables VW4 uses exist in VW3, so it wouldn't be able to successfully modify anything.

Reply
September 16, 2013 5:24 PM

Alfa1

Distinguished Member

It affected the .htaccess in some way that it made the site unavailable. Something to do with rewrite rule flags.

Reply
September 22, 2013 8:21 PM

Alfa1

Distinguished Member

I will not be doing an import of the live database again. At least not until VW4 is Gold. Until then I will use a copy. As I should have.

Reply

+ Reply

All times are GMT -4. The time now is 6:46 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: Mysqli prepare error: Table 'database.vw_log' doesn't exist

Issue Tools