SQL help

[Callum93]

How would you remove this from the database in phpMyAdmin?

NSERT INTO `phpbb_acl_options` (`auth_option`, `is_global`, `is_local`, `founder_only`) VALUES
('u_rp_give', 1, 0, 0),
('u_rp_view', 1, 0, 0),
('u_rp_disable', 1, 0, 0),
('u_rp_ignore', 1, 0, 0);
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES
('rp_block_per_points', '50'),
('rp_comment_max_chars', '255'),
('rp_display', '2'),
('rp_enable', '0'),
('rp_max_blocks', '10'),
('rp_max_power', '5'),
('rp_membership_days', '365'),
('rp_min_posts', '100'),
('rp_recent_points', '5'),
('rp_reg_bonus', '5'),
('rp_time_limitation', '12'),
('rp_total_posts', '500'),
('rp_user_spread', '10');

 

[spyka]

try doing this first to make sure it lists the correct values you want deleted:

select * from phpbb_acl_options where auth_option like '%u_cp_%'
select * from phpbb_config where config_name like '%rp_%'

then do this if the above queries work fine

delete from phpbb_acl_options where auth_option like '%u_cp_%'
delete from phpbb_config where config_name like '%rp_%'

 

[Callum93]

Copy and pasted that and it doesn't work

 

[spyka]

what does it say?

 

[Callum93]

Error

SQL query: Documentation

SELECT *
FROM phpbb_acl_options
WHERE auth_option LIKE '%u_cp_%'
SELECT *
FROM phpbb_config
WHERE config_name LIKE '%rp_%'
LIMIT 0 , 30

MySQL said: Documentation
#1064 - 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 'select * from phpbb_config where config_name like '%rp_%'

LIMIT 0, 30' at line 2

 

[Subz]

you could just delete them manually in phpmyadmin -😉-

 

[Callum93]

Can't find them in phpMyAdmin...

 

[md16185]

ya hould becareful to deletle mySQL files, I had to start all over, when I deleted some files that were
being used for the forum.

 

[spyka]

don't run them at the same type. on the SQL tab on phpMyAdmin put:

select * from phpbb_acl_options where auth_option like '%u_rp_%'

delete the 4 rows

and then go back to the SQL tab and put

SELECT *
FROM phpbb_config
WHERE config_name LIKE '%rp_%'

in and delete those rows

 

[Callum93]

Thanks a lot, this has now been solved. 🙂