PDA

View Full Version : [PHPBB] Does not show posts


neocyb
Fri 11th May '07, 9:11pm
Newly purchased version : (heard alot of good things about it!!!)
VBulletin Version : 3.6.6
Imported PHPBB 2.0.21
Clean install of VBulletin

I ran Impex and worked without errors.
Then I wanted to merge the old admin with the new one and I got this :
Database error in vBulletin 3.6.6:

Invalid SQL:

INSERT IGNORE INTO userlist (userid, relationid, type) VALUES(1, CONCAT(buddylist,, 'buddy'),
(1, ''), 'buddy');

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 ' 'buddy'),
(1, ''), 'buddy')' at line 1
Error Number : 1064
Date : Saturday, May 12th 2007 @ 01:38:44 AM
Script : http://vcdforum.ezr.be/cp2admin/usertools.php?do=reallydomerge (http://vcdforum.ezr.be/cp2admin/usertools.php?do=reallydomerge)
Referrer : http://vcdforum.ezr.be/cp2admin/usertools.php?do=domerge (http://vcdforum.ezr.be/cp2admin/usertools.php?do=domerge)
IP Address : xxx.xxx.xxx.xxx
Username : neocyb
Classname : vB_Database

Now this is not the main issue...
I can view everything that is not post related so the forum shows perfect with the threads but when I open the threads I see this :
Subscribed Threads in Folder : Subscriptions
Jump to Folder :
Subscriptions (0 Threads) GO
View all subscribed threads | Edit Folders
Subscribed Threads in Folder : Subscriptions
This Folder is currently empty.

The weird thing is that if I do a search on posts I can see the text and view a part of it. But when I click on it I get the upper info.
So the posts are in the database but when I click a thread I get redirected somehow to Subscriptions. Am I doing something wrong?
The board is currently offline. Strange that the posts are in the database and in the correct thread but not viewable (or redirected to subscribed threads)

thanks in advance,

Mario Verleene (Neocyb)

Floris
Mon 14th May '07, 12:33am
This is the second time I've seen this, perhaps it is a bug in the vbulletin software.

http://www.vbulletin.com/forum/project.php

borofan
Tue 15th May '07, 12:59am
Hi,

this 3.6.6 bug has been repaired. If you download vbulletin again and just take one file from the zipped archive:

\includes\class_dm_user.php

replace the old file with the new file.

Everything will work after that.