Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-14-2004, 07:13 AM
RN BB guy RN BB guy is offline
 
Join Date: Jan 2004
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default what d0es this mean

Database error in vBulletin 2.3.4:

Invalid SQL: SELECT u.username, s.userid, s.shout_text, s.timestamp FROM user u, shoutbox s WHERE u.userid = s.userid ORDER BY s.timestamp DESC LIMIT 1
mysql error: Table 'nurses_forum.shoutbox' doesn't exist

mysql error number: 1146

Date: Wednesday 14th of January 2004 03:59:06 AM
Script: http://www.nurses-forum.com/forum/forum/
Referer:



And how do i fix this. Dam didnt realize the shoutbox function was so complicated
Reply With Quote
  #2  
Old 01-14-2004, 07:27 AM
RN BB guy RN BB guy is offline
 
Join Date: Jan 2004
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I figure it out, when I changed my index.php file it gave me this error so i replaced it back and it works fine. But, my next question is how do i "run a query on my database". Sux being a noob. Im determine to put up that shoutbox or chat box.
Reply With Quote
  #3  
Old 01-14-2004, 09:04 AM
rrottman rrottman is offline
 
Join Date: Jun 2002
Posts: 53
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by RN BB guy
I figure it out, when I changed my index.php file it gave me this error so i replaced it back and it works fine. But, my next question is how do i "run a query on my database". Sux being a noob. Im determine to put up that shoutbox or chat box.
An excellent web based MySQL administration tool is freely available at
http://www.phpmyadmin.net

Installation is a 2 minute issue and you can deep dive into your db, add content, delete content, dive into the structure.

Please note:
- You should protect the phpMyAdmin page accordingly as it has no strong built in security.
- Generally there should be no need to play with the vB database, at vB maintains it pretty well. While you CAN use direct MySQL access parallel to vB, chances are, that you manipulate or erase data which is required for the board. So handle with care, please.
Reply With Quote
  #4  
Old 01-16-2004, 01:22 AM
RN BB guy RN BB guy is offline
 
Join Date: Jan 2004
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by rrottman
An excellent web based MySQL administration tool is freely available at
http://www.phpmyadmin.net

Installation is a 2 minute issue and you can deep dive into your db, add content, delete content, dive into the structure.

Please note:
- You should protect the phpMyAdmin page accordingly as it has no strong built in security.
- Generally there should be no need to play with the vB database, at vB maintains it pretty well. While you CAN use direct MySQL access parallel to vB, chances are, that you manipulate or erase data which is required for the board. So handle with care, please.
I put in the shout box, queried my server and got it on. It is now on a page called www.myurl.com/forum/shoutbox.php Its on but when I type then press shout it gives a 404 error. Is there anything else I can do? I want to put the shout on my home forum page and want it to work too.
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 11:20 PM.


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.03295 seconds
  • Memory Usage 2,189KB
  • 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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)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