FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » FUDforum 3.0+ » Error in reply to Sticky
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
icon12.gif  Error in reply to Sticky [message #2557] Sat, 11 May 2002 08:24 Go to next message
esm2002 is currently offline  esm2002   United States
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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 09:20]

Report message to a moderator

Re: Error in reply to Sticky [message #2563 is a reply to message #2557] Sat, 11 May 2002 11:12 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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
Re: Error in reply to Sticky [message #2571 is a reply to message #2563] Sat, 11 May 2002 18:48 Go to previous messageGo to next message
esm2002 is currently offline  esm2002   United States
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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."
Re: Error in reply to Sticky [message #2576 is a reply to message #2571] Sat, 11 May 2002 20:20 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
in your shell, type:

mysql -uUSER_NAME -pPASSWORD DATABASE_NAME

if/when this command works you'll be at the MySQL promt, type that command there.


FUDforum Core Developer
Re: Error in reply to Sticky [message #2583 is a reply to message #2576] Sat, 11 May 2002 21:12 Go to previous message
esm2002 is currently offline  esm2002   United States
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
worked like a charmed!!!

you are da' man!

Thanks


Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: lib.js in adm 404 error
Next Topic: Last Call for Features
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 11 04:36:06 EST 2017

Total time taken to generate the page: 0.00716 seconds