PDA

View Full Version : problem - need help


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


ALTER TABLE forum ADD lasttitle VARCHAR(50)

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