Greetings,

I am trying to use the Random Quote module to display scriptures on my church's website. Some scriptures are too long and are truncated. In the mysql.sql file there were 2 fields defined. I attempted to increase the size of the 'texto' field. I uninstalled and reinstalled, and got this error:

Installing Random Quotes

Too big column length for column 'texto' (max = 255). Use BLOB instead

Unable to install randomquote. Error(s):
Back to Module Administration page

So, I'm guessing I can't do that. Is there another way to increase the quote length, or another module that would serve my purpose better?

Thanks.

John

*BUMP*

Anyone got randomquotes to work with longer quotes than 256 characters?

Ok, answered by own question. Duh! Use phpmyadmin and look for xoops_citas and change the character length of the "texto" field to 600 or whatever.

Hope this helps someone!

You can change this in the database after installation.
Go to the table _citas and change the citas field from VARCHAR to TEXT, length/value: leave empty.

Or for a fresh install change the sql file as follows: