OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
SQL Error. DB function error number 1074 (0 viewing) 
VehicleManager component support
Go to bottom Favoured: 0
TOPIC: SQL Error. DB function error number 1074
#48
admin (Admin)
Admin
Posts: 5048
graph
User Offline Click here to see the profile of this user
SQL Error. DB function error number 1074 7 Years, 9 Months ago Karma: 61  
Some users, in istallation time, see so error:
JInstaller::install: SQL Error. DB function failed with error number 1074
Column length too big for column .. (max = 255); use BLOB or TEXT instead

Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions.
In your case, Mysql version is less than 5.0.3 so max value = 255. You can change like that: in Com_vehiclemanager package, you opens vehiclemanager.xml file and replace:

all varchar(450) to varchar(255)

after that again do zip all files to package and try reinstall package again.

Thank for use ours service.
 
Logged Logged  
  The administrator has disabled public write access.
Go to top
What are you looking for?
Anti-spam question: How many eyes has a typical person?