Welcome, Guest
Please Login or Register.    Lost Password?

Database name field being truncated
(1 viewing) (1) Guest
Welcome to the ToolsJX forum!


Go to bottomPage: 1
TOPIC: Database name field being truncated
#123
Database name field being truncated 6 Months, 3 Weeks ago Karma: 0
When saving my "grid" the host name of my database is being truncated so that the grid no longer works.

I need to keep the host name as it was assigned by my host. Is there a way that I can increase the max characters for my database name?
nlarkin
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/01/07 19:05 By nlarkin.
The administrator has disabled public write access.
 
#127
Re:Database name field being truncated 6 Months, 3 Weeks ago Karma: 1
Hi nlarkin,

Yes, in DB I see relatively small field for hostname (yourdomain.com or IP). In next release we will enlarge that field.

But here is the solution, go to phpMyAdmin and in joomla DB find table jos_grid_conn.

Then modify field (column) dbHost, leave Varchar, change only length to your desired length, lets say 150 or even more if your hostname is really big.

The same for db name, e.g. Northwind, the field is dbName.

Or,
no change needed, if you use IP for hostname.

Regards,
Viljem
viljem
Admin
Posts: 145
graph
User Offline Click here to see the profile of this user
Last Edit: 2010/01/08 01:48 By viljem.
The administrator has disabled public write access.
 
Go to topPage: 1
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting