 Unknown column 'fud23_users.affero' ?? [message #10587] |
Thu, 05 June 2003 12:13  |
_pz_
Messages: 14
Registered: February 2003
Karma: 0
|
Junior Member |
|
|
Well, I've managed that my Provider installed FUDForum for us
(for "only" 18EUR), since his settings are horrible (at least to me).
I then imported the stuff my partner has already done, just to
see that postings cant be read. I'm getting the same error when
posting, but afterwards they show up anyway (but cant be read).
What could have happen'? Should I create a column with that
name, and if so, what should it be (String etc.)?
The address is http://forum.yookie.eel.at.
I'll provide you an admin-account, if that could help.
Thanks for any help,
pz
P.S.: Here's the complete msg I'm getting:
(t=msg&th=14&start=0&rid=1&S=a5ca908559d37faa293c402677fe47 21) 1054: Unknown column 'fud23_users.affero' in 'field list'
Query: SELECT fud23_msg.*, fud23_thread.locked, fud23_thread.root_msg_id, fud23_thread.last_post_id, fud23_thread.forum_id, fud23_forum.message_threshold, fud23_avatar.img AS avatar, fud23_users.id AS user_id, fud23_users.alias AS login, fud23_users.display_email, fud23_users.avatar_approved, fud23_users.avatar_loc, fud23_users.email, fud23_users.posted_msg_count, fud23_users.join_date, fud23_users.location, fud23_users.sig, fud23_users.custom_status, fud23_users.icq, fud23_users.jabber, fud23_users.affero, fud23_users.aim, fud23_users.msnm, fud23_users.yahoo, fud23_users.invisible_mode, fud23_users.email_messages, fud23_users.is_mod, fud23_users.last_visit AS time_sec, fud23_level.name AS level_name, fud23_level.pri AS level_pri, fud23_level.img AS level_img FROM fud23_msg INNER JOIN fud23_thread ON fud23_msg.thread_id=fud23_thread.id INNER JOIN fud23_forum ON fud23_thread.forum_id=fud23_forum.id LEFT JOIN fud23_users ON fud23_msg.poster_id=fud23_users.id LEFT JOIN fud23_avatar ON fud23_users.avatar=fud23_avatar.id LEFT JOIN fud23_level ON fud23_users.level_id=fud23_level.id WHERE fud23_msg.id IN(18) ORDER BY id ASC
Server Version: 3.23.52-log
[Referring Page] http://forum.yookie.eel.at/index.php?t=thread&frm_id=1&rid=1&S= a5ca908559d37faa293c402677fe4721
[Updated on: Thu, 05 June 2003 12:13] Report message to a moderator |
|
|
|
| Re: Unknown column 'fud23_users.affero' ?? [message #10590 is a reply to message #10587] |
Thu, 05 June 2003 12:40  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The problem is simple, the data you are using is older then the forum sources. For example, the forum expects to find affero field inside the users table, but you have not such field in your database.
The solution is to run an upgrade script.
FUDforum Core Developer
|
|
|
|
|
|
| Re: Unknown column 'fud23_users.affero' ?? [message #10597 is a reply to message #10593] |
Thu, 05 June 2003 13:39 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
I am not sure why do you need the assinstance of your provider. Simply download the upgrade script from the download page, upload it to your forum's directory and run it.
FUDforum Core Developer
|
|
|
|
 Re: Unknown column 'fud23_users.affero' ?? [message #10604 is a reply to message #10597] |
Thu, 05 June 2003 14:36 |
_pz_
Messages: 14
Registered: February 2003
Karma: 0
|
Junior Member |
|
|
| Quote: |
I am not sure why do you need the assinstance of your provider. Simply download the upgrade script from the download page, upload it to your forum's directory and run it.
|
I'm not sure also, but I've asked you (and them) for a number
of times. Last time, you didn't answer in time so I payed... :-/
They say, it's your fault, you say, it's theires, ....  ((
Pretty sure that it's theires, btw, but cant confirm it without
setting up a Linux machine with exactly their setup
(http://eel.at/info.php). Paying 13 EUR/Month I'm already getting
angry... - but bound for 2 years, so I can only stringle with
them...
Anyway, it works now after the local update and data export (and
remote import, of course), so I'm only able to thank you for this
wonderfull product. By chance I'd be able to help you out
somewhere sometimes... - just let me know! 
cu, pz
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]