View Single Post
  #1  
Old 01-17-2005, 04:52 PM
miz miz is offline
 
Join Date: Mar 2003
Posts: 416
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default forums problems please help

im tring to get other conditions to forums and i got little problem

i copied part of code from forum.php (admincp dir)

any way i have tried to do something like :

PHP Code:
$forumid "3"// just exsample
$forum fetch_foruminfo($forumid);
$DB_site->query(fetch_query_sql($forum'forum'"WHERE forumid=$forumid")); 
and i got this error :

PHP Code:
Invalid SQLUPDATE forum SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    
forumid '3',
    
styleid '0',
    
title 'warcraft privte forum',
    
description '',
    
options '3783',
    
displayorder '1',
    
daysprune '30',
    
newpostemail '',
    
newthreademail '',
    
parentid '-1',
    
parentlist '3,-1',
    
password '',
    
link '',
    
childlist '3,-1',
    
depth '0',
    
permissions 'Array',
    
active '1',
    
allowposting '1',
    
cancontainthreads '1',
    
moderatenewpost '0',
    
moderatenewthread '0',
    
moderateattach '0',
    
allowbbcode '1',
    
allowimages '1',
    
allowhtml '0',
    
allowsmilies '1',
    
allowicons '1',
    
allowratings '1',
    
countposts '0',
    
canhavepassword '0',
    
indexposts '0',
    
styleoverride '0',
    
showonforumjump '0',
    
warnall '0'
WHERE forumid=3
mysql error
Unknown column 'depth' in 'field list' 
now i cant find depth on forum table on db
on forum.php this query works fine so what might be the problem ?
please help...
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01720 seconds
  • Memory Usage 1,790KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete