vbCover - Returng to Experts...

[Mondi]

I - perhaps foolishly - purchased and installed - attempted to - vbCover's Magazine Bundle. I am now experiencing severe problems posting and thread problems at my board, not much helped by Lionel's virtual absence caused by an apparent problem with his server.

Situation: Hosted server, attempting to override vbCover's Magazine 1.5 version installation with product's upgrade to 2.0, giving me the following error message:

Database error in vBulletin 3.8.2:

Invalid SQL:
INSERT INTO thread
(prefixid, postusername, postuserid, title, iconid, visible, forumid, coverattach, sidestory, sidetitle, similar, dateline, open, attach, lastpost, lastposter, replycount, hiddencount, deletedcount)
VALUES
('', 'Administrator', 1, 'Test Magazine Article I', 0, 0, 589, 0, '', 'Some Side Story Text I', '', 1243503062, 1, 0, 1243503062, 'Administrator', 0, 0, 0);

MySQL Error : Unknown column 'sidestory' in 'field list'
Error Number : 1054
Request Date : Thursday, May 28th 2009 @ 11:31:02 AM
Error Date : Thursday, May 28th 2009 @ 11:31:02 AM
Script : http://gblcg.com/newthread.php?do=postthread&f=589
Referrer : http://gblcg.com/newthread.php?do=newthread&f=589
IP Address : XX XXXXn XXXX
Username : XXXX
Classname : vb_database
MySQL Version : 4.1.15-Debian_0.dotdeb.4-log

Not being a complete SQL expert, and after attempting to de-install and re-install the product after running 'Repair & Optimise Tables' thrue AdminCP, it still doesn't allow me to proceed with posting threads or posts as expected and being 'normal.'

Being aware this may not be the right place to post this query, as it relates to an installation of a third-party mod, I still anticipate a true SQL-vBulletin expert may be of help to me. In other words; while being sympathethic to vbCover's recent inabiliyt to provide on-call and online support services, what I perhaps need most is someone who can assist me with this query.

Help? Advice? Quick?

Millions of thanks to respondents.

[diendo]

Hi Friend,

Lionel is busy with his server for recovering data. Maybe he knows better than us. I wonder he has many good mods but dont storage it well somewhere. I am also crazy like you when vBcover pape has broken until now.

Can you aks him to remote by teamvier to install it for you one more time?

[Mondi]

thanks for rapid reply;

Knowing and understanding his situation I am eager - believe me! - to get resolution on my issue.

I was just wondering whether anyone could poperly interpret the SQL code I provided in my previous message, and if anoyone other than Lionel could provide assistance, assuming this would require just undestanding of SQL requirements and coding.

I am still stuck - but thanks for your response!

[Lynne]

It looks like either the modification was not installed properly, or it wasn't uninstalled properly. If you have it installed, uninstall it and the error should go away. If you thought you already uninstalled it, make sure you removed all the files you had uploaded for it.

[Mondi]

Thanks all for your feedback - appreciated...

However, still looking at that same error code after complete de- and re-install of the mod.

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT sidetitle, sidestory, visible FROM thread WHERE threadid = '103';

MySQL Error : Unknown column 'sidestory' in 'field list'
Error Number : 1054
Request Date : Friday, May 29th 2009 @ 01:57:06 AM
Error Date : Friday, May 29th 2009 @ 01:57:07 AM
Script : http://gblcg.com/showthread.php?t=103
Referrer : http://gblcg.com/magazine.php?preview&issueid=1
IP Address : XX.XXX.XXX.XXX
Username : XXXXXXXXXXXX
Classname : vb_database
MySQL Version : 4.1.15-Debian_0.dotdeb.4-log

Can this nasty little nuisance be fixed manually somehow - 'cos now I am sitting here ripping my hair out - of which I have very little left anyway - and hesitant to make any further changes before this one is 'gone.'

By the way - noticed that I cannot post anywhere on my board. Can reply to posts, but not open new threads. That could become a bit of a irritation I guess..... LOL

Anyone know how to attack this one - quickly?

Thanks


----

For what it's worth, this may also be helpful [well, not to me that is...]

Database error in vBulletin 3.8.2:

Invalid SQL:
INSERT INTO thread
(prefixid, postusername, postuserid, title, iconid, visible, forumid, coverattach, sidestory, sidetitle, similar, dateline, open, attach, lastpost, lastposter, replycount, hiddencount, deletedcount)
VALUES
('', 'Raymond', 2, 'What\'s This', 0, 1, 1, 0, '', '', '', 1243561119, 1, 0, 1243561119, 'Raymond', 0, 0, 0);

MySQL Error : Unknown column 'sidestory' in 'field list'
Error Number : 1054
Request Date : Friday, May 29th 2009 @ 03:38:39 AM
Error Date : Friday, May 29th 2009 @ 03:38:40 AM
Script : http://gblcg.com/newthread.php?do=postthread&f=1
Referrer : http://gblcg.com/newthread.php?do=newthread&f=1
IP Address : XXXXXXXXXXX
Username : XXXXXXXXXXXX
Classname : vb_database
MySQL Version : 4.1.15-Debian_0.dotdeb.4-log

[Lynne]

If you think it is supposed to be installed, then uninstall it. Then see if you still have the error.

If you think it is supposedly uninstalled, then install it. Then see if you still have the error.

[Mondi]

Lynne - thanks for quick reply...

Just checking in with you - 'uninstall' as both the product and all files?

[Lynne]

Yes. Totally uninstall it and see if the problem is fixed.

[Mondi]

Nope - no luck.

Followed your instructions completely, including deletion of all uploaded files and the product itself.

Frustrating.

Anything else I should/could/would try if I were you Lynne...?

Thanks again.

[Dismounted]

Look inside the Plugin Manager (this is below the Products Manager in the Admin CP menu bar), and check for any vbCover plugins.