Welcome, Guest
Please Login or Register.    Lost Password?

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


Go to bottom
Post Reply
Post New Topic
Page: 1
TOPIC: Database name field being truncated
#123
Database name field being truncated 2 Years 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?
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
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.
Reply Quote
 
#127
Re:Database name field being truncated 2 Years 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
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
viljem
Admin
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/01/08 01:48 By viljem.
Reply Quote
 
Go to top
Post Reply
Post New Topic
Page: 1
Moderators: tomaz
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting