1
martyboy
Changing SQL values in Random Qoute Module
  • 2004/12/26 21:10

  • martyboy

  • Quite a regular

  • Posts: 256

  • Since: 2004/5/25


Hi, I need a little expert advice on this, I was using the random quote module(shows random qoute in a block) but longer qoutes seemed to get cut-off and it didnt look too good, so I looked through the modules files as I thought there would be some sort of max characters to show type of thing and I found this in the MySQL file:
Quote:
CREATE TABLE citas (
id int(11) NOT NULL auto_increment,
texto varchar(255) NOT NULL default '',
autor varchar(255) NOT NULL default '',
PRIMARY KEY (id),
KEY id (id)
) TYPE=MyISAM;


Would I be correct in thinking that if I go into phpmyadmin and change texto varchar from 255 to a higher value this will allow for more characters to be displayed thus stopping the qoutes from being cut-off? Or am I completely wrong?( I dont know much about SQL)

Any assistance would be much appreciated, thanks.

2
irmtfan
Re: Changing SQL values in Random Qoute Module
  • 2004/12/26 21:39

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


login via phpmyadmin and change 'texto' field Type from varchar to Text its should work

Login

Who's Online

155 user(s) are online (56 user(s) are browsing Support Forums)


Members: 0


Guests: 155


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