MODS.DB9.DK

[Nrc02]

I was being an idiot and trying to add them as fields instead of running them as queries. Learned a bit about mysql and now everything looks obvious

[kooky]

there is no type to define
the ModCP doesn't add a new column in phpbb_config
so new entries use default setting = varchar(255) NOT NULL

What is the version of your MySQL?

Type is defined where you ALTER table_X ADD column_X type Y default NULL (or NOT NULL)
With an INSERT or UPDATE no type

[Nrc02]

ummm... How do you add it then? I went to to the table php_config, added the feild, and made it a varchar with a value of 255, and it STILL dosnt work. you can't add it unless you fill in the field "lenght/value"




Where are you supposed to add these fields????:

Code: Select all

INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('enable_module_disallow', '1');
INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('enable_module_mass_email', '1');
INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('enable_module_ranks', '1');
INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('enable_module_smilies', '1');
INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('enable_module_user_ban', '1');
INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('enable_module_users', '1');
INSERT INTO `phpbb_config` (config_name, config_value) VALUES ('enable_module_words', '1');

[kooky]

What is your MySQL version? please

if you are using phpMyAdmin as DB manager, enter to your database stucture, at the top click on SQL
In the white dialog box, add these queries and click on execute
You should have a successfull message

Be sure your DB extension name is phpbb_

[Nrc02]

Well, I lost some of my MySQL tables, anyway of repairing them without loosing my settings?

[kooky]

there some solution with a few functions for MySQL, read its manual for the entire list

Try "Optimizing" or "Repair"
Then, it depends how and which tables have been altered/lost