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 Modules Support forums / 
  3. Module troubleshooting 
  4.  / Random Quotes 1.0.1
Register
1
kreateam
Random Quotes 1.0.1

  • 2005/8/22 19:47

  • kreateam

  • Just popping in

  • Posts: 5

  • Since: 2005/8/21


Anybody know what file to change to TEXT as recommended by artigas (below) in order to have longer quotes?

Thanks.

----------------

Random Quotes 1.0.1
I have the same question. It seems there is a 255 character limit. How can this be changed to allow much longer quotes to be displayed?

artigas Posted: 2005/8/5 0:06 Updated: 2005/8/5 0:06

Joined: 2004/12/21
From: Memphis, Tennessee, USA
Posts: 206 Re: Random Quotes 1.0.1
You need to change the SQL type on the field that holds the quote to TEXT.
2
hyperpod
Re: Random Quotes 1.0.1

  • 2005/8/22 19:53

  • hyperpod

  • Quite a regular

  • Posts: 359

  • Since: 2004/10/4


You have two options.

If you dont want to uninstall the module, you would need to edit the database table that holds the quote and change it from a varchar(255) to a text type.

You can also edit the /sql/mysql.sql file and locate the field that holds the quotes, and change its type to 'text'.

Making the change to the sql file will allow it to work anytime you need to install the module again.


Hope that helps,
Daniel Hall / XOOPS Module Development & Theme Design
Free XOOPS Support > My Wish List
3
otr222
Re: Random Quotes 1.0.1

  • 2005/8/22 23:00

  • otr222

  • Not too shy to talk

  • Posts: 124

  • Since: 2005/5/13


Hyperpod,

Could you please post an example.
Here's the sql
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;


Thanks
4
hyperpod
Re: Random Quotes 1.0.1

  • 2005/8/23 0:24

  • hyperpod

  • Quite a regular

  • Posts: 359

  • Since: 2004/10/4


CREATE TABLE citas (
  id int(11) NOT NULL auto_increment,
  texto TEXT NOT NULL default '',
  autor varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY id (id)
) TYPE=MyISAM;


Hope that helps,
Daniel Hall / XOOPS Module Development & Theme Design
Free XOOPS Support > My Wish List
5
kreateam
Re: Random Quotes 1.0.1

  • 2005/8/23 10:01

  • kreateam

  • Just popping in

  • Posts: 5

  • Since: 2005/8/21


thanks for the tips hyperpod,
done edit mysql.sql, and even updated the module to make sure the updated file is in use, but still not possible to add longer quotes than 255. When I try to add, they still cut off

I am hosted onhttp://www.planetxoops.com
and can not find any way to edit the databasetable to TEXT in their Control Panel...

any other tips?

thanks
6
otr222
Re: Random Quotes 1.0.1

  • 2005/8/23 21:39

  • otr222

  • Not too shy to talk

  • Posts: 124

  • Since: 2005/5/13


Thanks hyperpod.

kreateam -Give this a try. It should be what you need.
LINK HERE
7
hyperpod
Re: Random Quotes 1.0.1

  • 2005/8/24 0:42

  • hyperpod

  • Quite a regular

  • Posts: 359

  • Since: 2004/10/4


@otr222: NP :)


@Kreateam

When changing a database field, simply updating the module does not affect the database...

You either need to use phpmyadmin or MySQL to actually edit the field...

Or you have to deactivate & uninstall the module and then reinstall the module again, and it will use your new SQL file edits when creating the module db tables.

make sure you backup your module data if you have a bunch of quotes in their already, before you uninstall it.


Does that make sense?


Best Regards
Daniel Hall / XOOPS Module Development & Theme Design
Free XOOPS Support > My Wish List
8
kreateam
Re: Random Quotes 1.0.1

  • 2005/8/24 11:04

  • kreateam

  • Just popping in

  • Posts: 5

  • Since: 2005/8/21


thanks hypernod,

thats it. was using phpmyadmin and edit database to TEXT and than it was OK. I didnt see the phpmyadmin at planetxoops.org controlpanel to start with, but found it.

Thanks.
9
kreateam
Re: Random Quotes 1.0.1

  • 2005/8/24 11:06

  • kreateam

  • Just popping in

  • Posts: 5

  • Since: 2005/8/21


thanks hypernod,

Working good now.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

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

Members: 0

Guests: 141

more...

Donat-O-Meter

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

Latest GitHub Commits