Help with a script. [Archive]

shadow322

08-15-2005, 02:27 AM

Im trying to setup Multi Forums Pro Host for phpBB for my website. It all goes well until you try to view your forum. You receieve the email telling you where your board is and your password but when you try to view the board it gives you this error.

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1054 Unknown column 'session_admin' in 'field list'

INSERT INTO shadow322_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES ('0fa996a6f0551ecf1ba60a89a6f79aa9', -1, 1124072775, 1124072775, 'd8c5b805', 0, 0, 0)

Line : 172
File : sessions.php

Does anyone know what this means and how to fix it?

Cojawfee

08-15-2005, 04:41 AM

Something went wrong with installation and the column "session_admin" was never created in the SQL table, and probably other columns as well and that just happened to be the first missing one so the page stopped. That or it was removed by something.

shadow322

08-15-2005, 05:24 PM

How would I fix that?

nick1presta

08-15-2005, 10:59 PM

This happened to me with IPB. I just deleted dropped all tables in the DB and ran the setup script again. Or, if you know the field settings, you can manually add each table.