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)
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)