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.

[Mondi]

There are a few Side Story related entries in there.

What, precisely, will I be looking for Dismounted?


Product : vBmagazine
Automatically Subscribe New Member - register_addmember_complete [Edit] [Delete]
Edit Side Story - editpost_edit_complete [Edit] [Delete]
Modcp vBmagazine Moderation - mod_index_navigation [Edit] [Delete]
Postbit Info - postbit_display_complete [Edit] [Delete]
Side Story Editpost Update - editpost_update_start [Edit] [Delete]
Side Story Form - newthread_form_complete [Edit] [Delete]
Side Story New Thread - newthread_post_start [Edit] [Delete]
Side Story Process - newpost_process [Edit] [Delete]
Side Story Update - editpost_update_complete [Edit] [Delete]
Side Story Valid Fields - threadfpdata_start [Edit] [Delete]
vBadvanced Modules - vba_cmps_fetch_vba_module [Edit] [Delete]
vBadvanced Query - vba_cmps_include_getpage [Edit] [Delete]
vBmagazine Author's Picture - showthread_query [Edit] [Delete]
vBmagazine Clean Archives - archive_thread_post [Edit] [Delete]
vBmagazine Courtesy PM - newthread_post_complete [Edit] [Delete]
vBmagazine Define Side Story - threadfpdata_start [Edit] [Delete]
vBmagazine Navbar Link - parse_templates [Edit] [Delete]
vBmagazine Navbar Link Options - global_start [Edit] [Delete]
vBmagazine Online Process - online_location_process [Edit] [Delete]
vBmagazine Online Unknown - online_location_unknown [Edit] [Delete]
vBmagazine Process New Articles - newpost_process [Edit] [Delete]
vBmagazine Similar Articles - showthread_similarthread_query [Edit] [Delete]
vBmagazine Style Fetch - style_fetch [Edit] [Delete]
vBmagazine Template Cache - cache_templates [Edit] [Delete]
vBmagazine Templates Group - template_groups [Edit] [Delete]


Thanks mate!

[Dismounted]

Remove any related to vbCover. You can also take the plugin's name and do a search in the product XML - if it is there, remove it.

[Lynne]

Are you sure you deleted all the files related to it? Very often, there are files in includes/xml that users forget to delete.

[Mondi]

Honestly - Thanks for all your support and assistance.

Really appreciate it - but to no avail. I've spent ample time trying to solve this issue but my efforts simply don't produce anything of value.

I've located the responsible plugin but before disabling it permanently, without knowing what may happen to existing posts when a solution becomes available, I am just somewhat hesitant to continue using vbCover's Magazine.

Shame - was VERY much looking forward to using it.

I'll wait until Lionel comes back online - probably hiddeously busy at present with recovering his site(s). Understandably.

[I guess what I really need are some expert eyes who can look at the way things are set-up within my AdminCP...]

Thanks especially Lynne. Outstanding moderation.

:(

[Mondi]

Just for the record: Lionel [vbCover] has returned and provided me with excellent support, following which all afore mentioned issues became resolved.

Great support.

Mentioning this here serves as an advertisement for his business, but also as a 'come clear' in as far it concerns my satisfaction as his client.

Nonetheless: again, thanks to all who helped me with this so far.