| Re: Need to display longer quote in Random Quote |
| by McDonald on 2006/7/1 12:00:16 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: le="color: #000000"><?php # # Table structure for table `citas` # CREATE TABLE citas ( id int(11) NOT NULL auto_increment, texto [color=FF0000]text[/color] NOT NULL default '', autor varchar(255) NOT NULL default '', PRIMARY KEY (id), KEY id (id) ) TYPE=MyISAM;
|
| Re: Need to display longer quote in Random Quote |
| by technigrafa on 2006/7/1 11:45:24 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! |
| Re: Need to display longer quote in Random Quote |
| by technigrafa on 2006/7/1 11:16:45 *BUMP* Anyone got randomquotes to work with longer quotes than 256 characters? |
| Need to display longer quote in Random Quote |
| by jfernau on 2004/7/22 16:37:18 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 |