Warning: The author of this contribution does not provide support for it anymore.

phpBB3 SEO Sitemap

Error on adding to many forums to exclude list - phpBB3 SEO Sitemap

Error on adding to many forums to exclude list

by Kiweed » Wed Aug 27, 2014 2:16 am

I have a lare forum of 900K + posts most being in the members area
Thee way google handles it at the mo sucks!!

When i go to add all the 100+ members/admin/mod area forums i get this error

Code: Select all

Data too long for column 'config_value' at row 1 [1406]

SQL

UPDATE phpbb3_config SET config_value = '459,594,595,593,466,465,464,596,490,473,477,474,492,495,475,494,498,499,496,497,626,472,489,512,513,514,515,516,517,518,519,520,523,521,524,525,539,538,528,529,530,531,532,533,534,535,536,537,552,553,554,522,503,504,506,505,507,508,509,547,548,549,550,551,597,542,543,544,545,555,605,286,295,631,557,619,5,150,13' .... many more WHERE config_name = 'sitemap_seo_excluded'


I dont eant members only/vip/mods/admin posts showing up in the sitemap

Is it just a matter of upping that field of 255 a bit higher or is there a better way of excluding whole directories??

Any thoughts very much appreciated

If i can get this sorted and working i think as donation is in order

Many thanks
Kiweeed
User avatar
Kiweed
Registered User
Posts: 29
Joined: Sun Jan 01, 2006 9:30 pm

Re: Error on adding to many forums to exclude list

by Kiweed » Fri Aug 29, 2014 2:05 pm

not ideal but i changed var255 to var300 and it fits in all my forums i want excluded
im no sql expert but it does var300 for the whole of the phpbb_config table

any nice way of doing this with a heap of excludeds .... in my case a large members area. it cut the links from 748,000 down to 21,000 and worked perfect not a member or admin post in there

thanks for the mod ..... seeems the only one to do a decent exclude

cheers
w33d
User avatar
Kiweed
Registered User
Posts: 29
Joined: Sun Jan 01, 2006 9:30 pm