vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - [DBTech] vBQuiz v2 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=262358)

Robru 08-13-2011 10:01 AM

After upgrade v1.1.1 to v1.2.0, I get the following error, when start a new Quiz:

Code:

MySQL Error  : Table 'forum.dbtech_vbactivity_medal' doesn't exist
Error Number  : 1146


DragonByte Tech 08-13-2011 10:10 AM

1 Attachment(s)
Quote:

Originally Posted by Robru (Post 2232943)
After upgrade v1.1.1 to v1.2.0, I get the following error, when start a new Quiz:

Code:

MySQL Error  : Table 'forum.dbtech_vbactivity_medal' doesn't exist
Error Number  : 1146


Sorry about that. Try putting these two files into your dbtech/vbquiz/actions directory and try again.

Dylan

Robru 08-13-2011 10:25 AM

Oke, I have put in your new files, and when I start now: vbquiz.php?do=quizcreate, I get a blank screen ;)

BadgerDog 08-13-2011 10:33 AM

I just updated to v1.20 and when I attempted to add a quiz, I got an SQL error ... :eek:

Quote:

Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT
medalid,
title
FROM dbtech_vbactivity_medal
WHERE
availability > 0;

MySQL Error : Table 'milsurp.dbtech_vbactivity_medal' doesn't exist
Error Number : 1146
Request Date : Saturday, August 13th 2011 @ 07:31:24 AM
Error Date : Saturday, August 13th 2011 @ 07:31:24 AM
Script : http://www.xxxx.com/vbquiz.php?do=quizcreate
Referrer : http://www.xxxx.com/vbquiz.php?do=main&category_id=2
IP Address : xx.xx.xxx.xxx
Username : Badger
Classname : vB_Database
MySQL Version : 5.0.77
Substituted xxxx's for privacy ...

Running vBulletin 4.1.3 ....

Regards,
Doug

BadgerDog 08-13-2011 10:38 AM

Quote:

Originally Posted by DragonByte Tech (Post 2232945)
Sorry about that. Try putting these two files into your dbtech/vbquiz/actions directory and try again.

Dylan

I tried this solution to solve the same problem I have and I got this:

Quote:

Warning: require_once([path]/dbtech/vbquiz_pro/hooks/dbtech_vbquiz_create_complete.php) [function.require-once]: failed to open stream: No such file or directory in [path]/dbtech/vbquiz/actions/quizcreate.php(140) : eval()'d code on line 4

Fatal error: require_once() [function.require]: Failed opening required '/xxx/vbquiz_pro/hooks/dbtech_vbquiz_create_complete.php' (include_path='.:/usr/share/pear:/usr/share/php') in xxx/vbquiz/actions/quizcreate.php(140) : eval()'d code on line 4
xxxx's for privacy ...

How do we roll this version back to something stable and clean up residue tables mess it might have created? Thanks .. :)

Regards,
Doug

Robru 08-13-2011 10:58 AM

Please, give Dylan the time for making a solution :)

DragonByte Tech 08-13-2011 11:01 AM

Quote:

Originally Posted by BadgerDog (Post 2232953)
I tried this solution to solve the same problem I have and I got this:



xxxx's for privacy ...

How do we roll this version back to something stable and clean up residue tables mess it might have created? Thanks .. :)

Regards,
Doug

Really sorry about that. If you edit the plugin, Build Quiz Type List
and change
PHP Code:

if (file_exists(DIR '/dbtech/vbquiz/hooks/dbtech_vbquiz_create_complete.php')) 

to
PHP Code:

if (file_exists(DIR '/dbtech/vbquiz_pro/hooks/dbtech_vbquiz_create_complete.php')) 

It will fix that.

I'm not positive about rolling it back. You can try to upload the old files, edit the product to be version 1.1.0 and then import the 1.1.1 xml product and it should work.

Dylan

Robru 08-13-2011 11:08 AM

Quote:

Originally Posted by DragonByte Tech (Post 2232956)
If you edit the plugin, Build Quiz Type List
and change
PHP Code:

if (file_exists(DIR '/dbtech/vbquiz/hooks/dbtech_vbquiz_create_complete.php')) 

to
PHP Code:

if (file_exists(DIR '/dbtech/vbquiz_pro/hooks/dbtech_vbquiz_create_complete.php')) 

It will fix that.

Thanks for this edit, now its working again!!

DragonByte Tech 08-13-2011 11:12 AM

Quote:

Originally Posted by Robru (Post 2232957)
Thanks for this edit, now its working again!!

Good to hear, let me know if you run into any other problems.

Dylan

Robru 08-13-2011 11:14 AM

Another bug is:

View ... quiz results (profile.php?do=userresults&u=XXX) Get a blank screen.


All times are GMT. The time now is 01:38 AM.

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.01411 seconds
  • Memory Usage 1,754KB
  • 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
  • (2)bbcode_code_printable
  • (4)bbcode_php_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (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