FUDforum: FUDforum 3.0+ » Error in reply to Sticky

Home » FUDforum Development » FUDforum 3.0+ » Error in reply to Sticky

Show: Today's Messages :: Polls :: Message Navigator

Error in reply to Sticky [message #2557]

Sat, 11 May 2002 12:24

esm2002

Messages: 339
Registered: May 2002
Location: Atlanta Georgia

Karma: 0

Senior Member

I get the following error when I try to use the reply, quote, new thread when viewing a Sticky msg

Query Failed: SELECT * FROM fud2_smiley ORDER BY vieworder
Reason: Unknown column 'vieworder' in 'order clause'
From: /home/acct351/public_html/fudforum/br/post.php
Server Version: 3.23.22-beta

Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."

[Updated on: Sat, 11 May 2002 13:20]

Report message to a moderator

Re: Error in reply to Sticky [message #2563 is a reply to message #2557]

Sat, 11 May 2002 15:12

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Once a problem resulting in the source being newer than sql.

You need to run the following query:


ALTER TABLE fud2_smiley ADD vieworder INT UNSIGNED NOT NULL;

FUDforum Core Developer

Report message to a moderator

Re: Error in reply to Sticky [message #2571 is a reply to message #2563]

Sat, 11 May 2002 22:48

esm2002

Messages: 339
Registered: May 2002
Location: Atlanta Georgia

Karma: 0

Senior Member

no we have already proven that I'm not a real smart guy on all this sql, php, cvs etc stuff!

how in the world would one go about running a query like

ALTER TABLE fud2_smiley ADD vieworder INT UNSIGNED NOT NULL;

Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."

Report message to a moderator