Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
problem - need help Details »»
problem - need help
Version: , by william1735 william1735 is offline
Developer Last Online: Dec 2002 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 06-24-2002 Last Update: Never Installs: 0
 
No support by the author.

when i post a new thread, i hv error in the data base.

by right click on error:

html><head><title>Soccer Willy Forums Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

<!-- Database error in vBulletin 2.2.4:

Invalid SQL: UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1, lastpost='1024924511',lastposter='willy',lasttitle
='testing' WHERE forumid IN (17,16,-1)
mysql error: Unknown column 'lasttitle' in 'field list'

mysql error number: 1054

Date: Monday 24th of June 2002 09:14:49 AM
Script: http://www.soccerwilly.com/forum/forum/newthread.php
Referer: http://soccerwilly.com/forum/newthr...read&forumid=17
-->

</table></td></tr></table></form>
<blockquote><p> </p><p><b>There seems to have been a slight problem with the Soccer Willy Forums database.</b><br>
Please try again by pressing the <a href="java script:window.location=window.location;">refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:webmazter@soccerwily.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>

my url:http://soccerwilly.com/forum/index.php

thanks

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 06-24-2002, 02:03 PM
Admin's Avatar
Admin Admin is offline
Coder
 
Join Date: Oct 2023
Location: Server
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You installed some kind of last thread title on forum home hack. Do you know which one?
Reply With Quote
  #3  
Old 06-24-2002, 02:31 PM
william1735 william1735 is offline
 
Join Date: May 2002
Location: singapore
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i hv no idea. someone hv done it for me but he cannot be found now. wat shd i do? i need someone to rectify this. pls.
Reply With Quote
  #4  
Old 06-24-2002, 03:06 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hmm, go to phpmyadmin and add the field lasttitle varchar(50) into your forumtable
Reply With Quote
  #5  
Old 06-24-2002, 03:18 PM
william1735 william1735 is offline
 
Join Date: May 2002
Location: singapore
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks Xenon,
can u be more specify? maybe tell me exactly how to add.
Reply With Quote
  #6  
Old 06-24-2002, 03:45 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hmm, with php my admin it shouldn't be a problem for you the query i think is

[sql]
ALTER TABLE forum ADD lasttitle VARCHAR(50)[/sql]
Reply With Quote
  #7  
Old 06-24-2002, 04:55 PM
william1735 william1735 is offline
 
Join Date: May 2002
Location: singapore
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks.. i will get my admin to do it..
Reply With Quote
  #8  
Old 06-25-2002, 05:09 AM
william1735 william1735 is offline
 
Join Date: May 2002
Location: singapore
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i hv add this:

SQL-query : [Edit]
ALTER TABLE `soccer_forum`.`forum` CHANGE `lasttitle` `lasttitle` VARCHAR(50) DEFAULT NULL
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 05:13 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.04264 seconds
  • Memory Usage 2,263KB
  • Queries Executed 23 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (7)postbit
  • (8)postbit_onlinestatus
  • (8)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