Editing Template Question

Post Reply
tubeman
Posts: 297
Joined: Sat Mar 02, 2013 11:33 am

Editing Template Question

Post by tubeman » Wed Sep 13, 2017 11:30 am

Hi,I see that while editing templates it does not all more than 992 lines of code per template , how do I increase this number to for example 3000?

admin
Site Admin
Posts: 24044
Joined: Wed Sep 10, 2008 11:43 am

Re: Editing Template Question

Post by admin » Wed Sep 13, 2017 11:36 am

The only limit is 64kb - txt field in mysql.

Is you template larger then that ?
Have you done script update ?

tubeman
Posts: 297
Joined: Sat Mar 02, 2013 11:33 am

Re: Editing Template Question

Post by tubeman » Wed Sep 13, 2017 11:50 am

Yes its larger than that, how do I increase it?

admin
Site Admin
Posts: 24044
Joined: Wed Sep 10, 2008 11:43 am

Re: Editing Template Question

Post by admin » Wed Sep 13, 2017 11:52 am

Well you can do it in mysql but i thibk it's a good ides to check your template
Honestly I haven't seen templates that large
Note that large template => higher loading times for user => lower prod ..
Have you done script update ?

tubeman
Posts: 297
Joined: Sat Mar 02, 2013 11:33 am

Re: Editing Template Question

Post by tubeman » Wed Sep 13, 2017 11:58 am

Yes but template output should be less as its only if else statements of 1000 lines which will only display 1 line in output.Correct?

admin
Site Admin
Posts: 24044
Joined: Wed Sep 10, 2008 11:43 am

Re: Editing Template Question

Post by admin » Wed Sep 13, 2017 12:03 pm

Yes
What do you have 1000 ifs for ?
Have you done script update ?

tubeman
Posts: 297
Joined: Sat Mar 02, 2013 11:33 am

Re: Editing Template Question

Post by tubeman » Wed Sep 13, 2017 12:06 pm

How do I exactly increase the value of text field in mysql?

admin
Site Admin
Posts: 24044
Joined: Wed Sep 10, 2008 11:43 am

Re: Editing Template Question

Post by admin » Wed Sep 13, 2017 12:09 pm

I see, you don't want to optimize your template

ALTER TABLE `rot_pages` CHANGE `template` `template` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
Have you done script update ?

tubeman
Posts: 297
Joined: Sat Mar 02, 2013 11:33 am

Re: Editing Template Question

Post by tubeman » Wed Sep 13, 2017 1:08 pm

Thank you, that worked.

admin
Site Admin
Posts: 24044
Joined: Wed Sep 10, 2008 11:43 am

Re: Editing Template Question

Post by admin » Wed Sep 13, 2017 1:14 pm

NP
Have you done script update ?

Post Reply