SQL questions <solved>

This add-on will allow you to give "moderators" access to manage users, and theire permissions, admin accounts are protected

Moderator: Moderators

Forum rules
The content in this forum is dated Dec. 21 2005 and can be used as Archive only. This Forum is LOCKED and READ ONLY !

SQL questions <solved>

Postby Nrc02 on Sun 02. Jan, 2005 07:16

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 :lol:
Last edited by Nrc02 on Mon 10. Jan, 2005 06:28, edited 1 time in total.
Nrc02
Poster
Poster
 
Posts: 3
Joined: Sun 02. Jan, 2005 07:06

Postby kooky on Tue 04. Jan, 2005 01:12

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 :)
kooky
brilliant supporter
 
Posts: 1329
Joined: Tue 31. Dec, 2002 17:52
Location: Au pays des rêves

Postby Nrc02 on Tue 04. Jan, 2005 23:38

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');
Nrc02
Poster
Poster
 
Posts: 3
Joined: Sun 02. Jan, 2005 07:06

Postby kooky on Thu 06. Jan, 2005 02:36

What is your MySQL version? please :wink:

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_
kooky
brilliant supporter
 
Posts: 1329
Joined: Tue 31. Dec, 2002 17:52
Location: Au pays des rêves

Postby Nrc02 on Fri 25. Mar, 2005 22:06

Well, I lost some of my MySQL tables, anyway of repairing them without loosing my settings?
Image
Nrc02
Poster
Poster
 
Posts: 3
Joined: Sun 02. Jan, 2005 07:06

Postby kooky on Fri 01. Apr, 2005 02:19

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
kooky
brilliant supporter
 
Posts: 1329
Joined: Tue 31. Dec, 2002 17:52
Location: Au pays des rêves


Return to Moderator CP [2.0.17/EM]

Who is online

Users browsing this forum: No registered users and 1 guest

cron