Connect with other users about what to run on your webhosting (and how to run it) here.
Badutski
New to forums
Posts: 3 https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA Joined: Thu Mar 27, 2014 2:21 pm
Post
by Badutski Thu Mar 27, 2014 2:28 pm
Evening, I some trouble with my MySQL, I'm trying to convert my SQLite (sv.db) to MySQL database, And everything worked EXECPT for my DarkRP money.. I get this error when I try to do it..
Code: Select all
Getting 'playerpdata' table structure ...
Creating table 'playerpdata' ...
Create table 'playerpdata' failed!
ERROR 1170: BLOB/TEXT column 'infoid' used in key specification without a key length
CREATE TABLE `playerpdata` (`infoid` LONGTEXT NOT NULL,
`value` LONGTEXT,
PRIMARY KEY(`infoid`))
I'm using this
http://forums.xenonservers.com/showthre ... e-to-MYSQL
Anyone can help? (Garry's Mod DarkRP server btw) I dunno where to post this
soja
This is my homepage
Posts: 2389 Joined: Fri May 18, 2012 3:20 pm
Post
by soja Thu Mar 27, 2014 2:50 pm
Is this in the conversion, or import into the mysql database?
Not a NFO employee
Badutski
New to forums
Posts: 3 Joined: Thu Mar 27, 2014 2:21 pm
Post
by Badutski Fri Mar 28, 2014 4:26 am
The error? in the conversion
soja
This is my homepage
Posts: 2389 Joined: Fri May 18, 2012 3:20 pm
Post
by soja Fri Mar 28, 2014 6:29 am
Give this one a shot, I found it the other day. I do not know how to fix that error, maybe try asking the author that made the converter.
http://tjservers.org/dev/SQLiteToMySQL/ Not a NFO employee
Badutski
New to forums
Posts: 3 Joined: Thu Mar 27, 2014 2:21 pm
Post
by Badutski Fri Mar 28, 2014 8:10 am
Already tried using this one, doesnt work.
