phpBB Topic Prefixes

Add prefixes with a SQL Query - phpBB Topic Prefixes

Add prefixes with a SQL Query

by aedgington » Tue Feb 12, 2019 8:07 pm

I have a lot (100+) of prefixes I'd like to add and was trying to do it via a batch query. Of course I started with just one:

Code: Select all

INSERT INTO 
	phpbb_topic_prefixes 
		(prefix_tag,prefix_enabled,prefix_parent_id,prefix_left_id,prefix_right_id,prefix_parents,forum_id)
	VALUES 
		('Prefix Title',1,0,1,2,null,2);
I get an error that 'prefix_parents' cannot be null, but if I omit it, it says it's required. Yet both test prefixes I made with the ACP have null values for that field. What would be the proper way to add numerous prefixes via SQL statement?
aedgington
Registered User
Posts: 5
Joined: Sat Dec 11, 2010 3:28 pm
Contact:

Re: Add prefixes with a SQL Query

by VSE » Tue Feb 12, 2019 10:48 pm

It's not null, it should be an empty string ''
Dictated but not read.
Official phpBB Extensions My Extensions & MODs
Please do not PM me for support.
User avatar
VSE
Extensions Development Coordinator
Extensions Development Coordinator
Posts: 4883
Joined: Sat Jan 17, 2009 9:37 am
Location: Los Angeles, CA
Name: Matt Friedman
Contact: