vb.org Archive
Page 21 of 23 « First 111920 21 2223
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Vbjokes (https://vborg.vbsupport.ru/showthread.php?t=98248)

micheal332001 03-19-2006 03:08 PM
Quote:
Originally Posted by bashy
Hi Micheal

Just installed and got this error when i went to vbjokes.php
Any ideas please

Code:
Database error in vBulletin 3.5.3:
 
Invalid SQL:
SELECT * FROM vbjokes_jokes WHERE aprove=1 ORDER BY rating/numberOfVotes DESC LIMIT 0 , 3;
 
MySQL Error  : Unknown column 'rating' in 'order clause'
Error Number : 1054
Date        : Sunday, March 19th 2006 @ 02:16:58 PM
Script      : http://www.bashys-place.com/forums/vbjokes.php
Referrer    :
Yes i have followed the instructions
When the product imported i saw it modify the DB on 3 occasions, is this correct?
I know what the problem is and here is what you can do.

Goto your sql in cpanel and look for your TABLE_PREFIX I.E.( vb3_ )vbjokes_jokes

And see if you have these 2 sql feilds there

rating and numberOfVotes

If these are not there you can run this in your sql to add them

PHP Code:
ALTER TABLE `vbjokes_jokes` ADD `rating` FLOAT( 10, 2 ) DEFAULT '0.00' NOT NULL ;
ALTER TABLE `vbjokes_jokes` ADD `numberOfVotes` INT( 20 ) DEFAULT '0' NOT NULL ; 
And this will fix your problem

But dont forget to put your sql's table prefix before vbjokes_jokes

bashy 03-19-2006 04:21 PM
Cheers m8...this appeared to sort it :)

Can you remember me asking you if you can sort it so that my mods/smods
can have the control panel for your vBCheats?
Well i dont think ya got round to doing it yet ;)

When you do can you do the same for this one as well please?

Drago912 03-25-2006 07:37 PM
any way to turn the approval off so peeps can upload jokes without waiting?

micheal332001 03-26-2006 06:39 AM
Quote:
Originally Posted by Drago912
any way to turn the approval off so peeps can upload jokes without waiting?
Hi there

This has been answered in these posts

xspazx 04-07-2006 01:27 PM
looks like an all around great hack! i love hacks where members can give content.

xspazx 04-07-2006 07:41 PM
any idea why when i click a joke i get a popup of my index? :(

bashy 04-07-2006 08:00 PM
Hi...

How can i set this so that we dont have to approve the jokes and they go straight through the system please?

fosman 04-17-2006 02:39 PM
Does this work with vbulletin 3.5.4 ?

xspazx 04-20-2006 04:49 PM
http://chewonthat.net/vbjokes.php?do=category

is there a way I can fix this so it doesn't stretch the entire page like shown ^

great hack by the way keep up the good work man! :D

micheal332001 04-20-2006 05:42 PM
Quote:
Originally Posted by bashy
Hi...

How can i set this so that we dont have to approve the jokes and they go straight through the system please?
This has been answered in a few threads back


All times are GMT. The time now is 05:53 PM.
Page 21 of 23 « First 111920 21 2223
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.01168 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
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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