MODS.DB9.DK

[Cyberian75]

I just took a look at the file db_update.php for this MOD and my database. It seems SQL statements ALTER TABLE are missing, and there are only INSERT statements, which fails because there are no fields to insert.

Please correct this. Thanks!


Michael

[Niels]

the included db_update.php file, should be alrigth
there is no need to alter any tables in order to have this mod work...

only the extra into in the config table need to be INSERTed
if you do this by hand, you MUST remember to add any DB prefix yoiu may use (default is phpbb_)

if indoubt about how to do this, simply use the included db_update.php file, it will add any needed prefix, by it self

[Cyberian75]

Niels,

The problem is that there are no such fields as "max_sessions", so the INSERT statements fail.

I uninstalled this MOD, and ever since then, I often get a "session table is full" error message. I then deleted all the entries in that table, which solved the problem; but then, users aren't able to login. For this, I did an UPDATE statement in the users table to change "user_session_page" to value 1, which enables them to login.

Do you have any ideas why this is happening?


Michael

[Niels]

I DO REPEAT the SQL are fine, nothing wrong with them, the VALUES are storred into the table named CONFIG, and does not need any ALTER or like
the "max_sessions" are a VALUE not a field, this is how the config table works....for greater flexibility - you will just have to accept that.

sorry for talking in capital letters, but the SQL are just like the should be

[Niels]

I often get a "session table is full" error message. I then deleted all the entries in that table, which solved the problem; but then, users aren't able to login. For this, I did an UPDATE statement in the users table to change "user_session_page" to value 1, which enables them to login.

Do you have any ideas why this is happening?


Michael

I did forgot to answer this, this offen happen on larger boards if you have installed last visit mod - did you ?
you could try change the table type for the session table from heap into myISAM see the last visit mod for further info, where I have described this isue