Issue: Blank article pages when using forum with existing threads

Issue Tools
- View Changes

November 23, 2010 10:16 AM

Mikele

New Member

Blank article pages when using forum with existing threads

Blank article pages when using forum with existing threads

Earlier, I used the Lite-version and everything was fine until I switched to Premium (3.0.6).
Now, when I try to access the default namespace associated with existing forum (http://wiki.rotarycars.ru/showwiki.php - link on the left) I see a list of threads-articles that are empty on opening (contrary to the contents of the database, which has all the info).

At first I thought it was a problem because of the language, but English-language articles that I create does not work either

Issue Details

Issue Number 2101

Issue Type Bug

Project VaultWiki 3.x Series

Category Install / Upgrade

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 3.0.6

Fixed Version (none)

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

November 23, 2010 11:29 AM

pegasus

VaultWiki Team

If you uninstalled Lite first, rather than upgrading, this may be the reason. Go to AdminCP > VaultWiki > Wiki URL Manager > Rebuild Page URLs.

Reply
November 23, 2010 12:00 PM

Mikele

New Member

Firstly I tried to run the upgrade script, but the "Proceed" button takes me back to the upgrade_lite.php (just like the simple page refresh), and I decided to try reinstalling the product.

After fixing this bug, the newly created articles work well (even with cyrillic names), but the old still does not work, even after Page URL rebuild...

Also, I tried to change thread title from Cyrillic to English manually via database (to make sure that this is not a problem with the charset), but it did not help

Reply
November 23, 2010 12:37 PM

Mikele

New Member

It's very strange. I compared the two threads and posts belonging to them in the database.
They are identical (only the first post from the new thread has an empty value in the "htmlstate" field; in the old topic - htmlstate is "on_nl2br" everywhere; but the database does not allow me to select a blank value to test it).

One thread works fine, the other - no

Reply
November 23, 2010 12:39 PM
pegasus

VaultWiki Team
Lite did not have support for Cyrillic names. Because titles are mapped to URLs in a separate database table, simply editing the thread table in the database will not help. You will have to manually rename the pages in the following manner:

Go to the forum containing the old articles.
Double click the title of the problematic articles.
In the pop-up editor, change the title so that it uses the correct Cyrillic characters. Check the box not to redirect the old URL (it was broken anyway).
Save, and the article should now be available.
Reply
November 23, 2010 12:58 PM

Mikele

New Member

I tried to change the titles through the forum (as you wrote) and through the database (manually via phpmyadmin). Even change the Cyrillic titles to English. Then clean Article Post Cache and rebuilding URLs. But it does not help

If I try to create a new article with the name of the existing-old (blank), I just moved into edit screen. But the text field is still empty...

...
Seem to understand the problem.
The tables vault_article and vault_revision has no information about old topics, they are empty. How I can fill them?

Reply

November 23, 2010 1:24 PM

Mikele

New Member

OK, I've found. It just does not fill the articles and revisions tables when I assign Forum to the Namespace.
This action drops the error:

Code:

Database error in vBulletin 4.0.8:

Invalid SQL:
v
			SELECT rev.*, post.pagetext AS newtext, post.attach AS newattach, thread.forumid
				
				, post.htmlstate AS newstate
			FROM vb3_vault_revision AS rev
			LEFT JOIN vb3_post AS post ON (post.threadid = rev.threadid AND post.parentid = 0)
			
			WHERE rev.threadid = 13198
			ORDER BY rev.dateline DESC;

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 'v
			SELECT rev.*, post.pagetext AS newtext, post.attach AS newattach, thread.fo' at line 1
Error Number  : 1064
Request Date  : Tuesday, November 23rd 2010 @ 09:20:47 PM
Error Date    : Tuesday, November 23rd 2010 @ 09:20:47 PM
Script        : http://forum.rotarycars.ru/admincp/vaultwiki_namespace.php?do=rebuild&namespaceid=2&meta=79,55&types[0]=0&types[1]=1&parents[0]=79&parents[1]=55&postcache=,2
Referrer      : http://forum.rotarycars.ru/admincp/vaultwiki_namespace.php?do=save
IP Address    : 93.80.208.231
Username      : Mikele
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.53

November 23, 2010 1:30 PM

Mikele

New Member

It's just a mistype in inlinemod.php on the line 226

Reply

November 23, 2010 1:32 PM

Mikele

New Member

Well, the new error has come... the same action:

Code:

Database error in vBulletin 4.0.8:

Invalid SQL:

			SELECT rev.*, post.pagetext AS newtext, post.attach AS newattach, thread.forumid
				
				, post.htmlstate AS newstate
			FROM vb3_vault_revision AS rev
			LEFT JOIN vb3_post AS post ON (post.threadid = rev.threadid AND post.parentid = 0)
			
			WHERE rev.threadid = 13198
			ORDER BY rev.dateline DESC;

MySQL Error   : Unknown column 'thread.forumid' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, November 23rd 2010 @ 09:31:37 PM
Error Date    : Tuesday, November 23rd 2010 @ 09:31:37 PM
Script        : http://forum.rotarycars.ru/admincp/vaultwiki_namespace.php?do=rebuild&namespaceid=2&meta=55,79&types[0]=0&types[1]=1&parents[0]=55&parents[1]=79&postcache=,2
Referrer      : http://forum.rotarycars.ru/admincp/vaultwiki_namespace.php?do=save
IP Address    : 93.80.208.231
Username      : Mikele
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.53

November 23, 2010 1:48 PM

Mikele

New Member

Temporary fixed it by removing the "!VAULT_40X_COMPAT" condition for the "LEFT JOIN " . TABLE_PREFIX . "thread" , changed the namespace forum to temporary forum and back to working one, rebuilded the URLs and it started to working!!

Reply
November 23, 2010 7:27 PM

pegasus

VaultWiki Team

Okay I've fixed the errors you reported which were preventing the forum updates, so closing this. As for the articles being empty, this is expected when changing encoding methods (no Cyrllic support to Cyrillic support). It is also expected that the change is difficult to propagate across the database, but it looks like you have figured it out. We hope to simplify changes like this by separating the wiki from threads in version 4.

Reply

+ Reply

All times are GMT -4. The time now is 1:09 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: Blank article pages when using forum with existing threads

Issue Tools