That Good Restaurant / Pub guide wiki

[Dick Dastardly]

Has some joker deleted all reference to Wales?

We are the culinary capital of Europe I'll have you know.

[illmonkey]

http://pistonheads.com/gassing/topic.asp?h=0&t...

st, you are wondering where wales went, not after a link. Sorry.

Edited by illmonkey on Friday 29th August 08:58

[Mr Will]

Don't worry, the information is still there.

Unfortunately though, there is a maximum length for a wiki or post, beyond which no text is displayed and this is what is causing the end of the good grub guide to not appear.

Its a physical size limit, rather than a number or characters, so condesing the wiki down might manage to squeeze everything on, but the best solution is going to be to split it up into sub-wikis, which will also make it a bit easier to read.

Any volunteers???

i'll do it later if nobody beats me to it!

[illmonkey]

Mr Will said:

Don't worry, the information is still there.

Unfortunately though, there is a maximum length for a wiki or post, beyond which no text is displayed and this is what is causing the end of the good grub guide to not appear.

Its a physical size limit, rather than a number or characters, so condesing the wiki down might manage to squeeze everything on, but the best solution is going to be to split it up into sub-wikis, which will also make it a bit easier to read.

Any volunteers???

i'll do it later if nobody beats me to it!

I dont mind doing it. The problem is the majority are places from England, so even if you seperate it into countrys, Englands one is going to spill over soon.

Then you'll end up with 3+ wiki's just for the pubs!

Why cant the size limit be changed, whats stopping you from changing it? You can add to the post, so it must just be a max size on the display settings.

[Mr Will]

If I remember correctly from when this came up regarding the PHers Cars wiki, it is browser related rather than something that is easy to change, but I will look into it.

[miniman]

My techies reckon there's no limit on the amount of data that can be stored and displayed in a div, aside of the memory available to the browser.

[illmonkey]

miniman said:

My techies reckon there's no limit on the amount of data that can be stored and displayed in a div, aside of the memory available to the browser.

My thoughts too.

I run a few sites and never had a problem with things like this.

[RacingPete]

I think what Mr Will is referring too is the max length of a textbox as 32k. In this instance the problem is the field size in the database which isn't long enough to hold more data in that field. It is currently a TEXT type and needs to be upped to a MEDIUMTEXT or larger, but this will require some benchmarking to see the effect of changing the size on the speed of the forums (and annoyingly an outage to make the change, of which one I did last night and took 4 hours ).

For the time being there is a max length to a wiki and thus it should probably be split into seperate sections using the WIKI linking for further sections.

[miniman]

RacingPete said:

I think what Mr Will is referring too is the max length of a textbox as 32k. In this instance the problem is the field size in the database which isn't long enough to hold more data in that field. It is currently a TEXT type and needs to be upped to a MEDIUMTEXT or larger, but this will require some benchmarking to see the effect of changing the size on the speed of the forums (and annoyingly an outage to make the change, of which one I did last night and took 4 hours ).

For the time being there is a max length to a wiki and thus it should probably be split into seperate sections using the WIKI linking for further sections.

But if it's a db field size issue, why isn't any data being lost? All the content is there, just only in edit mode.

i.e. the text is missing from here:
http://www.pistonheads.com/gassing/topic.asp?h=0&a...

but it is present here:
http://www.pistonheads.com/gassing/post.asp?h=0&am...

Also I'm not sure that a textbox is 32k max - 32k what? 32kb? 32k characters?

Edited by miniman on Friday 29th August 18:39

[Mr Will]

miniman said:

RacingPete said:

I think what Mr Will is referring too is the max length of a textbox as 32k. In this instance the problem is the field size in the database which isn't long enough to hold more data in that field. It is currently a TEXT type and needs to be upped to a MEDIUMTEXT or larger, but this will require some benchmarking to see the effect of changing the size on the speed of the forums (and annoyingly an outage to make the change, of which one I did last night and took 4 hours ).

For the time being there is a max length to a wiki and thus it should probably be split into seperate sections using the WIKI linking for further sections.

But if it's a db field size issue, why isn't any data being lost? All the content is there, just only in edit mode.

i.e. the text is missing from here:
http://www.pistonheads.com/gassing/topic.asp?h=0&a...

but it is present here:
http://www.pistonheads.com/gassing/post.asp?h=0&am...

Also I'm not sure that a textbox is 32k max - 32k what? 32kb? 32k characters?

Edited by miniman on Friday 29th August 18:39

There are two different fields in the database, the html version displayed on the page and a text/phcode version stored to avoid unparsing the data when it is edited/quoted/etc.

The html version is longer (in terms of characters) so runs out of space first.

[miniman]

Interesting, makes sense though as I suppose you only have to do the parse on the occasional save of a post (I guess with forum posts, mostly once only) rather than on every read.