Problem with upgrade from 5.0 to 5.1

I just upgraded phorum, and got that error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') or (parent_id=0 and sort=1 ' at line 22: select phorum_messages.author, phorum_messages.datestamp, phorum_messages.email, phorum_messages.message_id, phorum_messages.meta, phorum_messages.moderator_post, phorum_messages.modifystamp, phorum_messages.parent_id, phorum_messages.msgid, phorum_messages.sort, phorum_messages.status, phorum_messages.subject, phorum_messages.thread, phorum_messages.thread_count, phorum_messages.user_id, phorum_messages.viewcount, phorum_messages.closed from phorum_messages where status=2 and ((parent_id=0 and sort=0 and forum_id=) or (parent_id=0 and sort=1 and forum_id=1)) order by sort, modifystamp desc

all goes ok throught the admin.php steps, and now i can only see admin panel but not phorum contents.

my forum is there:

[www.pureculture.lt]



Edited 1 time(s). Last edit at 12/18/2006 05:21AM by dainjaru.

go to the admin, save the settings for the forum itself and try again.

---

Thomas Seifert

is you mean General setting -> Update, it nothing changes...

no, I mean go to the admin and edit *the forum*.
or is the forum not shown in the admin either?

---

Thomas Seifert

hmm made but got answer:

Database error while adding/updating forum.

check the html-source of the generated page - it should show the error-message itself.

---

Thomas Seifert

This:

<!-- Unknown column 'vroot' in 'field list': update phorum_forums set name='PureCulture', description='', parent_id=0, active=1, inherit_id=NULL, moderation=0, email_moderators=0, pub_perms=11, reg_perms=15, display_fixed=0, template='default', language='lt', threaded_list=0, threaded_read=0, reverse_threading=0, float_to_top=1, list_length_flat=30, list_length_threaded=15, read_length=100, display_ip_address=0, count_views=0, check_duplicate=0, allow_email_notify=1, max_attachments=0, allow_attachment_types='', max_attachment_size=0, max_totalattachment_size=0, vroot=0 where forum_id=1 --><div class="PhorumAdminError">Database error while adding/updating forum.</div>

this sounds like you haven't run through all the upgrade scripts (if any at all).

---

Thomas Seifert

but if adding vroot field with value 0 i got empty phorum with no data:

***Sorry, no forums to show here.

run all upgrade scripts and got no errors...

all goes to work finally, few times got no forum and now it running!