vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   vbCover - Returng to Experts... (https://vborg.vbsupport.ru/showthread.php?t=214727)

Mondi 05-28-2009 06:47 AM

vbCover - Returng to Experts...
 
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:

Quote:

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 05-28-2009 07:37 AM

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 05-28-2009 07:48 AM

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 05-28-2009 12:14 PM

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 05-28-2009 10:05 PM

Thanks all for your feedback - appreciated...

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

Quote:

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...]

Quote:

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 05-29-2009 12:24 AM

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 05-29-2009 12:44 AM

Lynne - thanks for quick reply...

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

Lynne 05-29-2009 01:14 AM

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

Mondi 05-29-2009 09:08 AM

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 05-29-2009 09:13 AM

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


All times are GMT. The time now is 12:17 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02594 seconds
  • Memory Usage 1,740KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete