vb.org Archive
Page 4 of 7 « First 23 4 56 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Miscellaneous Hacks - [DBTech] Random Questions v2 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=243967)

CRDeveloper 08-07-2010 04:46 AM
Im getting this database error at members profiles.
not working

Code:
Database error in vBulletin 4.0.5:

Invalid SQL:

                SELECT a.*, q.*, u.username, u.userid FROM vbulletin_dbt_random_questions_answers AS a
                LEFT JOIN vbulletin_dbt_random_questions AS q USING (qid)
                INNER JOIN vbulletin_user AS u USING(userid)
                WHERE a.touserid = 7261 AND
                (private = 0 OR userid = 1 OR touserid = 1)
                ORDER BY a.dateline DESC
                LIMIT 0, 30;

MySQL Error  : Column 'userid' in where clause is ambiguous
Error Number  : 1052
Request Date  : Saturday, August 7th 2010 @ 01:43:33 AM
Error Date    : Saturday, August 7th 2010 @ 01:43:33 AM
Script        : http://www.toxxxicas.com/foro/member.php/7261-GUCCI
Referrer      : http://www.toxxxicas.com/foro/member.php/7261-GUCCI
IP Address    : ##.##.##.##
Username      : ToxXxicas.com
Classname    : vB_Database
MySQL Version : 4.1.22-standard

DragonByte Tech 08-07-2010 09:56 AM
Quote:
Originally Posted by ToxXxicas (Post 2080397)
Im getting this database error at members profiles.
not working

Code:
Database error in vBulletin 4.0.5:

Invalid SQL:

                SELECT a.*, q.*, u.username, u.userid FROM vbulletin_dbt_random_questions_answers AS a
                LEFT JOIN vbulletin_dbt_random_questions AS q USING (qid)
                INNER JOIN vbulletin_user AS u USING(userid)
                WHERE a.touserid = 7261 AND
                (private = 0 OR userid = 1 OR touserid = 1)
                ORDER BY a.dateline DESC
                LIMIT 0, 30;

MySQL Error  : Column 'userid' in where clause is ambiguous
Error Number  : 1052
Request Date  : Saturday, August 7th 2010 @ 01:43:33 AM
Error Date    : Saturday, August 7th 2010 @ 01:43:33 AM
Script        : http://www.toxxxicas.com/foro/member.php/7261-GUCCI
Referrer      : http://www.toxxxicas.com/foro/member.php/7261-GUCCI
IP Address    : ##.##.##.##
Username      : ToxXxicas.com
Classname    : vB_Database
MySQL Version : 4.1.22-standard
Sorry about that, re-download the files and give it a try now.

- David

thecelticway 08-07-2010 04:24 PM
Forum NOT working~~~~~~ HELP!!!!!!!

Warning: require_once([path]/dbtech/random_questions/hooks/cache_templates.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/class_bootstrap.php(1269) : eval()'d code on line 188

Fatal error: require_once() [function.require]: Failed opening required '/home/celticway/thecelticway.net/forum/dbtech/random_questions/hooks/cache_templates.php' (include_path='.:/usr/local/lib/php:/usr/local/php5/lib/pear') in /home/celticway/thecelticway.net/forum/includes/class_bootstrap.php(1269) : eval()'d code on line 188

Gemma 08-07-2010 04:46 PM
Not working for me either. Pressing submit does nothing. The skip button works though.

thecelticway 08-07-2010 08:46 PM
thanks for the help in getting this uploaded and fixed..... appears to be working ok but how do you configure it.... is it dependent on usergroups

bada_bing 08-08-2010 03:36 AM
I have installed the lite version and so far it looks pretty cool I do however have a few questions as I am interested in the pro version.

I would like to make this feature more visible for my members maybe you have add a feature in the admincp where we can set the random questions in various location such as postbit
near there member name so a member can just click and answer a question about this member.

I would also like to see a vbadvanced module to for this mod.

bada_bing 08-08-2010 03:39 AM
I also just noticed that when I choose random member and answer a question and click Submit it does nothing, but the skip question seems to work.

Also noticed that if I view my own profile and click "Request This User To Answer Questions About You. " and click Submit I get this error message "Invalid Action Specified."

Personally I think this is a glitch, you should not be able to go to your own profile and have this feature "Request This User To Answer Questions About You." doesnt make much sence

DragonByte Tech 08-08-2010 02:06 PM
Quote:
Originally Posted by thecelticway (Post 2080558)
Forum NOT working~~~~~~ HELP!!!!!!!


Warning: require_once([path]/dbtech/random_questions/hooks/cache_templates.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/class_bootstrap.php(1269) : eval()'d code on line 188

Fatal error: require_once() [function.require]: Failed opening required '/home/celticway/thecelticway.net/forum/dbtech/random_questions/hooks/cache_templates.php' (include_path='.:/usr/local/lib/php:/usr/local/php5/lib/pear') in /home/celticway/thecelticway.net/forum/includes/class_bootstrap.php(1269) : eval()'d code on line 188
This means that you do not have all the files uploaded either at all or you have them in the wrong place. Please check you have all of them uploaded.

Quote:
Originally Posted by Gemma (Post 2080563)
Not working for me either. Pressing submit does nothing. The skip button works though.
Could you PM a test account for your site?

Quote:
Originally Posted by thecelticway (Post 2080626)
thanks for the help in getting this uploaded and fixed..... appears to be working ok but how do you configure it.... is it dependent on usergroups
Yes, go to edit a usergroup and you will see a few options.

Quote:
Originally Posted by bada_bing (Post 2080721)
I have installed the lite version and so far it looks pretty cool I do however have a few questions as I am interested in the pro version.

I would like to make this feature more visible for my members maybe you have add a feature in the admincp where we can set the random questions in various location such as postbit
near there member name so a member can just click and answer a question about this member.

I would also like to see a vbadvanced module to for this mod.
That is interesting. I could look at something like this in a future version.

Quote:
Originally Posted by bada_bing (Post 2080723)
I also just noticed that when I choose random member and answer a question and click Submit it does nothing, but the skip question seems to work.

Also noticed that if I view my own profile and click "Request This User To Answer Questions About You. " and click Submit I get this error message "Invalid Action Specified."

Personally I think this is a glitch, you should not be able to go to your own profile and have this feature "Request This User To Answer Questions About You." doesnt make much sence
The request feature was just something I forgot to take out. I'll release a fixed version soon.

Also for the bug you have, I will look into this right away.

- David

thecelticway 08-08-2010 06:17 PM
Originally Posted by thecelticway View Post

thanks for the help in getting this uploaded and fixed..... appears to be working ok but how do you configure it.... is it dependent on usergroups

Yes, go to edit a usergroup and you will see a few options.


checked the boxes~~~~~~when in a members profile I make the request I get......


vBulletin Message
Invalid Action Specified.
:confused:

betts02 08-08-2010 09:13 PM
I have purchased the pro version and posted 2 questions on your site,Could you please look them up mate and try to give an answer, cheers


All times are GMT. The time now is 02:27 PM.
Page 4 of 7 « First 23 4 56 Last »
Show 40 post(s) from this thread on one page

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.04357 seconds
  • Memory Usage 1,755KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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