Go Back   vb.org Archive > Community Central > Community Lounge
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-25-2001, 05:31 AM
BaldNut BaldNut is offline
 
Join Date: Nov 2001
Location: Manchester, UK
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hi, i know this should be on the vbportals forums, it is, but no one has answered it, and ive just sent out through the night 150 new e-mails to my offline customers for them to go and see my site and at the moment its half missing so im starting to panick..

i just installed waJones latest release pr8

and the following happend:

i installed the updates now my right hand column has dissapeared along with all my news contents from the centre block

and at the bottom im getting an error:

Database error in vBulletin 2.2.0:

Invalid SQL: SELECT thread.*, CASE WHEN icon.iconpath IS NULL THEN '' ELSE icon.iconpath END as icon FROM thread LEFT OUTER JOIN icon ON icon.iconid=thread.iconid WHERE forumid=3 ORDER BY sticky DESC,dateline DESC LIMIT 5
mysql error: You have an error in your SQL syntax near 'icon.iconpath IS NULL THEN '' ELSE icon.iconpath END as icon FROM thread LEFT OU' at line 1

mysql error number: 1064

Date: Sunday 25th of November 2001 06:17:53 AM
Script: http://www.golden-springs.com/forums/index.php?s=
Referer: http://www.golden-springs.com/index.php?s=


please anyone with any ideas let me know

Rob
Reply With Quote
  #2  
Old 11-25-2001, 10:12 AM
Goldfinger's Avatar
Goldfinger Goldfinger is offline
 
Join Date: Oct 2001
Posts: 120
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

um. i went to your site and i am not receiving this error..
Reply With Quote
  #3  
Old 11-25-2001, 10:17 AM
BaldNut BaldNut is offline
 
Join Date: Nov 2001
Location: Manchester, UK
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

verry sorry m8, i should of updated this thread, i re-installed all the old activetopics.php files and got it up and running again, but im missing my icons on the active topics table as well as the centre table, and when i click on the propperties of missing images it only has my root folder, with no name as to what the .gif is, and now /images folder ?

Any idea what file i would need to edit to re-instate the path for these icons as i cant find anywhere in my admin cp to set up these icons ?

once again i appologise for wasting your time earlier

Rob
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:04 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03481 seconds
  • Memory Usage 2,173KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete