vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   problem - need help (https://vborg.vbsupport.ru/showthread.php?t=40230)

william1735 06-24-2002 01:45 PM
problem - need help
 
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

Admin 06-24-2002 02:03 PM
You installed some kind of last thread title on forum home hack. Do you know which one?

william1735 06-24-2002 02:31 PM
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.

Xenon 06-24-2002 03:06 PM
hmm, go to phpmyadmin and add the field lasttitle varchar(50) into your forumtable

william1735 06-24-2002 03:18 PM
thanks Xenon,
can u be more specify? maybe tell me exactly how to add.

Xenon 06-24-2002 03:45 PM
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]

william1735 06-24-2002 04:55 PM
thanks.. i will get my admin to do it..

william1735 06-25-2002 05:09 AM
i hv add this:

SQL-query : [Edit]
ALTER TABLE `soccer_forum`.`forum` CHANGE `lasttitle` `lasttitle` VARCHAR(50) DEFAULT NULL


All times are GMT. The time now is 05:48 AM.

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.00952 seconds
  • Memory Usage 1,720KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete