Simple Machines Community Forum

That's it.

I want to put in my calendar an event with a long name and unfortunately it had a maximum of letters.

Is there any possibility to make unlimited letters in calendar?

Best regards

Searching does wonders eh? :P

Does this solution work for you posted in another topic

http://www.simplemachines.org/community/index.php?topic=116873.0 by akabukeyes

LainaaFor increasing the length allowed for event names you can run this query in phpmyadmin,

ALTER TABLE `smf_calendar` CHANGE `title` `title` VARCHAR( 60 )

Changing smf_ to your database prefix if that isn't your database prefix. Do backup your database before you run this query though.

What is phpMyAdmin? (http://index.php?topic=21919.0)

I dont see how unlimited characters would ever work out though. You should at least have a cap somewhere. Imagine a 1,000 character title, it would stretch the entire page.

Sorry, I searched in portuguese but I forgot to search in english.

Actually, just administrators can change the calendar so we know the limit. xD

But about Myphpadmin, I'm not the real administrator of my website and I use ftp to acess there.
I don't know about programation so I would like to ask, do you know if there other posibilities to change the limit of the letters?

Best regards

iirc thats the only way at the time. As the table is what determines how long the calender title can be. You should contact someone that can access the database or phpymadmin. :)

I have access to the database but I don't have that phpmyadmin.

I will see if the other administrator have that program.

But in phpmyadmin, when I find that table smf_calendar ?


Best regards

Well you do not have to use phpmyadmin. Anything that will allow you to view your database and modify tables. smf_calender is a table that was added when you installed and should be found within your database.

Hope that helps.

Lainaus käyttäjältä: ShaDow82x - tammikuu 24, 2009, 02:20:12 IP
Well you do not have to use phpmyadmin. Anything that will allow you to view your database and modify tables. smf_calender is a table that was added when you installed and should be found within your database.

Hope that helps.

Well, if you say that, where I can find that? In any particularly folder?
Maybe it is because I'm not english, but I'm not understanding what it's that "table".
So, where normally I can found that?


best regards

Take a look at this:

Database (http://docs.simplemachines.org/index.php?topic=357.msg445#msg445)
and
What is phpMyAdmin? (http://simplemachines.org/index.php/?topic=21919.0)

Do you have any sort of hosting panel you can access? Because thats where you can usually access your database.

I think I understood what you say.

It wasn't me that installed the forum so I asked the person that installed and he say that the forum is MySQL.

I acess the server by ftp.


Best regards

Just to say, I use WS_FTP Pro by Ipswitch.

Is it this that we wanted?

best regards

No, you need to be able to alter the db tables.  phpMyAdmin is the most common tool.  Whoever setup your database will be able to help you, you'll need to run a SQL command at least to alter the fields characteristics.

I think all the possible information has been supplied, there is little more we can inform or give you.

Sorry for the time took to answer.

I did what you said in phpMyAdmin but when I create an event or an holiday it has again the limit of letters (I think it is 30).

What should I do?


best regards

For SMF 2.0 RC1, should be the same for 2.0 BETA 4 though.

Calender.template.php
Find:
<input type="text" name="evtitle" maxlength="30" size="30" value="', $context['event']['title'], '" style="width: 90%;" />
Replace:
<input type="text" name="evtitle" maxlength="60" size="30" value="', $context['event']['title'], '" style="width: 90%;" />

Well, I tried that but I still have the problem. =/

Just to know, where I want to have more limit is here: ?action=admin;area=managecalendar;sa=editholiday


Best Regards

You'll need to find the maxlength="30" found in other template files relating to the calender.  Most likely ManageCalendar.template.php

Thank you very much!! =D

I found that file, I edited it and it worked! Thanks a lot! Really, I don't know why Simple Machines don't put a MOD of Karma. xD

Well, now I will put the solved icon.


Best Regards

Sorry, but now I have another problem.

I write the holiday but when I save it the letters that are exceeded go out.
So, I continue to have the limit of 30.=/


best regards

'go out' what?  There is a reason for the initial limit, due to template and space issues.  You might find allowing larger text will mean things wont look right.

Thought size="30" might need to be altered as well.

I went to Calendar.template.php and to ManageCalendar.template.php in the default theme. Even the size="30" and maxlength="30" are now with 60. Even so the problem continue: I write: Data da Criação da Comunidadade Jogos RPG and when I save in the calendar appears this: Data da Criação da Comunidad

Is there more any comand that I should edit? In my theme folder there isn't any file related with calendar.

best regards

You've increased the field details to allow for 60 via the sql command in the second post?

I went to PhpMyAdmin and what appear after the changes is in anex.

I repair that exist a tabel called smf_calendar_holidays but in the title seems to be the same as what I send in anex.

best regards

In $source/Calender.php

Try altering this portion of code
// Check the title isn't too long - iCal requires some formatting if so.
$title = str_split($event['title'], 30);

$source/ManageCalender.php
// Not too long good sir?
$_REQUEST['title'] = substr($_REQUEST['title'], 0, 30);

thanks for the tip, I will try that.
I have jus repaired that I ahd in the titlethat my forum is 2.0 beta 4 but the truth is that meanwhile I upgraded to 2.0 RC1. Is it makes any change of what have been said?

best regards

Lainaus käyttäjältä: Rumbaar - helmikuu 24, 2009, 10:53:42 IP
For SMF 2.0 RC1, should be the same for 2.0 BETA 4 though.

All my posts relate to 2.0 RC1.

I went to forum/sources/calendar.php
and changed for this:

   // Check the title isn't too long - iCal requires some formatting if so.
   $title = str_split($event['title'], 60);

I went to forum/Sources/ManageCalendar.php
and I put this:
// Not too long good sir?
$_REQUEST['title'] = substr($_REQUEST['title'], 0, 60);

The Problem continues.
Are you certain that in PhpMyAdmin is everything alright?
I say that because in the image I passed to you the title, varchar etc is the only parameter of smf_calendar that is with a "Sim" (in portuguese is yes) and the others are all in Não (No).


best Regards

The (60) is the important part.  The fact it's cutting off still at the 30 character mark and allowing utf8 characters would indicated it's being truncated elsewhere as well.  I'm not sure where else it could be doing do.

How is it stored in the db?  The full length or shortened?

Sorry, but I don't know what is that full and shortened lenght. Could you explai, please?


abraços!

I mean in the database is the title stored as Data da Criação da Comunidadade Jogos RPG or as Data da Criação da Comunidad?

I will be sincerely, I write that but I don't know where it appears in the database.  ???

The smf_calendar table and the record for the entry in question.

I went there and as I have deleted that holiday I created one again. For some reason I cannot explain the holiday appeared normally, and so the problem is solved. O_o"
I don't know... Maybe there should be some time until the modification of the table?


best regards

There shouldn't be a time delay.  But if it's working now that that main thing.