XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Beginner's Corner 
  4.  / A question about smartsections
Register
1
xooperman
A question about smartsections

  • 2005/12/21 17:47

  • xooperman

  • Not too shy to talk

  • Posts: 117

  • Since: 2005/5/11


Hello,

I´m using smartsections for a website of mine called http://www.abogadoslaboralistas.com

I´m using it to store the text of the spanish law.

But after sometime, i did realize that the number of characters is limited.

So i can´t add the complete text of the law.

I can´t see any option on the preferences of the module to change the length of the articles, so i don´t know what to do.

Is there any other module that I could use?


Thank you in advanced
2
davidl2
Re: A question about smartsections

  • 2005/12/21 18:59

  • davidl2

  • XOOPS is my life!

  • Posts: 4843

  • Since: 2003/5/26


Please can you post this on the SmartFactory site (http://www.smartfactory.ca) and we can see if theres any way to assist.

Please note that due to the holidays, we may not be able to assist immediately - but we will look at it
3
Lourdes
Re: A question about smartsections

  • 2005/12/21 19:07

  • Lourdes

  • Not too shy to talk

  • Posts: 119

  • Since: 2005/2/26


In the meantime, until you find a permanent solution to your limited characters, have you tried using the
[pagebreak]
tag to break up your article into pages?
4
Shine
Re: A question about smartsections

  • 2005/12/21 20:33

  • Shine

  • Just can't stay away

  • Posts: 822

  • Since: 2002/7/22


You won't solve this by using the [pagebreak] feature.

A user of the wiwimod 0.83 stumbled into the same. From my own experiences I knew there was a solution to adjust the specific sql table.

Explanation sql rows:

tinytext: 255 (nice for sigs)
text: 65535
mediumtext: 16777215
longtext: 4294967295

within caractars use mediumtext... which is approx. 2mb text.

TinyBLOB and TinyTEXT
A BLOB (binairy large object) or TEXT with maximum length of: 2^8 - 1 (=255) signs.

BLOB and TEXT
A BLOB or TEXT with maximum length of 2^16 -1 (=65,535) signs.

MEDIUMBLOB and MEDIUMTEXT
A BLOB or TEXT with maximum length of 2^24 - 1 (=16,777,215) signs.

LONGBLOB and LONGTEXT
A BLOB or TEXT with maximum length of 2^32 - 1(=4,294,967,295) signs.
This means this field can contain a max of 4GB data/text.

Therefore I'd advice to change the sql table into longtext (or mediumtext), to solve problem of the textlimit.

If the specific sqltable already has longtext, could it be that your text is more than the 4 GB????

Grtz., Shine
5
xooperman
Thanks a lot, but could you tell me how to change the sql

  • 2005/12/24 13:18

  • xooperman

  • Not too shy to talk

  • Posts: 117

  • Since: 2005/5/11


Thanks a lot for your explanation. But the problem is that i don´t know where to find the sql table and which programm or how to change it.

Could someone explain me how to do this, please?



Thanks a lot a xooper happy holidays for everyone!!
6
bb2120
Re: Thanks a lot, but could you tell me how to change the sql

  • 2005/12/24 13:35

  • bb2120

  • Not too shy to talk

  • Posts: 179

  • Since: 2005/7/6 1


I don't use smartsections, but I've done this sort of thing before.

You'll need a tool such as phpMyAdmin. Then you'll need to log in to your DB and find the table (and the column) that stores the articles. You can do this by searching for something in your articles.

If you're in phpMyAdmin, find the desired table, then click the structure tab, then click the pencil next to the name of the column that contains the articles.

I would then change the 'type' option to longtext because that allows LOADS of writing (not sure how much) to be stored.


REMEMBER TO BACK UP YOUR DB BEFORE YOU DO THIS

Sorry if this is too complex, but I've explained it as simply as I can.

You might want to let someone else do it for you for a bit of money (or free)
7
xooperman
Thanks a lot, but one little more question...

  • 2005/12/24 17:30

  • xooperman

  • Not too shy to talk

  • Posts: 117

  • Since: 2005/5/11


I did download the phpMyAdmin-2.6.4-pl4


Where do I have to install it, on my computer ?
on my server?

where exactly on the server,

i have many directories

anon_ftp
bin
cgi-bin
conf
error_docs
httpdocs (Here i did install xoops)
httpsdocs
pd
private
statistics
subdomains
web_users



Welcome Help!!!

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

194 user(s) are online (109 user(s) are browsing Support Forums)

Members: 0

Guests: 194

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits