import users by CSV

Reply·Subscribe

daihloPremium

2315 posts

Anyone using this module?

http://www.boonex.com/m/import-users-via-csv-from-admin-panel

I have it, but am trying to make it work on 7.1 with no joy...

just results in errors when trying to import the sample file included.

Database query error

Query:
LOAD DATA INFILE '/tmp/phpAJwsMf' IGNORE INTO TABLE Profiles FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (`NickName`,`Email`,`Status`,`Role`,`Couple`,`Sex`,`LookingFor`,`Headline`,`DescriptionMe`,`Country`,`City`,`DateOfBirth`,`Featured`,`DateReg`,`DateLastEdit`,`DateLastLogin`,`DateLastNav`,`aff_num`,`Tags`,`zip`,`EmailNotify`,`LangID`,`UpdateMatch`,`Views`,`Rate`,`RateCount`,`CommentsCount`,`PrivacyDefaultGroup`,`allow_view_to`,`UserStatus`,`UserStatusMessage`,`UserStatusMessageWhen`,`Avatar`,`Height`,`Weight`,`Income`,`Occupation`,`Religion`,`Education`,`RelationshipStatus`,`Hobbies`,`Interests`,`Ethnicity`,`FavoriteSites`,`FavoriteMusic`,`FavoriteFilms`,`FavoriteBooks`,`FirstName`,`LastName`,`FacebookProfile`,`imported_user`) SET imported_user ='1'

Mysql error:
Access denied for user 'cmj'@'%' (using password: YES)

Found error in the file '/var/www/vhosts/root/website/modules/thakkertech/import_user/classes/ThtImportUsrDb.php' at line 63.
Called 'query' function with erroneous argument #0.

Quote · 29 Dec 2014

geek_girlPremium

11493 posts

Without knowing more about how the module works, my guess is that it failed when connecting to the database. Does the module grab the database credentials or do you have to enter them?

Geeks, making the world a better place

Quote · 29 Dec 2014

AlexTNavigator

6101 posts

Many hosting providers disable some privileges by default for security reasons.

Most probably that this module requires FILE MySQL privileges to work.

I suggest to ask your hosting provider to ask if they can grant FILE privileges for your MySQL user.

Rules → http://www.boonex.com/terms

Quote · 29 Dec 2014

daihloPremium

2315 posts

The module does grab database access itself, so most likely something privilege based.