Converting SQLite to MySQL

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Post Reply
eXist73
Peon
Posts: 4
Joined: Sun Jan 08, 2006 6:56 pm

Converting SQLite to MySQL

Post by eXist73 » Fri Feb 22, 2008 6:45 pm

I was wondering is there was a way to convert SQLite XP to MySQL.

--- Please enter the following information for support ---
War3ft Version: RC8
Amxmodx Version: 1.8.0
Metamod Version: 1.19
amxx list:

Code: Select all

[  1] Admin Base              1.8.0.3660  AMXX Dev Team     admin.amxx       running  
          [  2] Admin Commands          1.8.0.3660  AMXX Dev Team     admincmd.amxx    running  
          [  3] Admin Help              1.8.0.3660  AMXX Dev Team     adminhelp.amxx   running  
          [  4] Slots Reservation       1.8.0.3660  AMXX Dev Team     adminslots.amxx  running  
          [  5] Multi-Lingual System    1.8.0.3660  AMXX Dev Team     multilingual.am  running  
          [  6] Menus Front-End         1.8.0.3660  AMXX Dev Team     menufront.amxx   running  
          [  7] Commands Menu           1.8.0.3660  AMXX Dev Team     cmdmenu.amxx     running  
          [  8] Players Menu            1.8.0.3660  AMXX Dev Team     plmenu.amxx      running  
          [  9] Teleport Menu           1.8.0.3660  AMXX Dev Team     telemenu.amxx    running  
          [ 10] Maps Menu               1.8.0.3660  AMXX Dev Team     mapsmenu.amxx    running  
          [ 11] Admin Chat              1.8.0.3660  AMXX Dev Team     adminchat.amxx   running  
          [ 12] Anti Flood              1.8.0.3660  AMXX Dev Team     antiflood.amxx   running  
          [ 13] Scrolling Message       1.8.0.3660  AMXX Dev Team     scrollmsg.amxx   running  
          [ 14] Info. Messages          1.8.0.3660  AMXX Dev Team     imessage.amxx    running  
19:44:36  [ 15] Admin Votes             1.8.0.3660  AMXX Dev Team     adminvote.amxx   running  
          [ 16] NextMap                 1.8.0.3660  AMXX Dev Team     nextmap.amxx     running  
          [ 17] TimeLeft                1.8.0.3660  AMXX Dev Team     timeleft.amxx    running  
          [ 18] Pause Plugins           1.8.0.3660  AMXX Dev Team     pausecfg.amxx    running  
          [ 19] Stats Configuration     1.8.0.3660  AMXX Dev Team     statscfg.amxx    running  
          [ 20] Restrict Weapons        1.8.0.3660  AMXX Dev Team     restmenu.amxx    running  
          [ 21] StatsX                  1.8.0.3660  AMXX Dev Team     statsx.amxx      running  
          [ 22] CS Misc. Stats          1.8.0.3660  AMXX Dev Team     miscstats.amxx   running  
          [ 23] CS Stats Logging        1.8.0.3660  AMXX Dev Team     stats_logging.a  running  
          [ 24] Warcraft 3 Frozen Thro  3.0 RC9     Geesu & Avanderi  war3ft.amxx      debug    
          [ 25] VIP and Admin Access    3.0         eXist`            vip.amxx         debug    
          [ 26] Team Balancer           1.8b3       Ptahhotep         ptb.amxx         debug    
          [ 27] DeagsMapManage          2.30b       Deags             deagsmapmanage2  debug    
          [ 28] Admin Spectator ESP     1.3         KoST              admin_spec_esp.  debug    
          [ 29] Admin Gag               1.8.3       EKS               exec_gag.amxx    debug    
19:44:36  [ 30] MAP CVARs               2.1         EJL               map_cvars.amxx   debug    
          [ 31] Autoresponder/Advertis  0.5         MaximusBrood      ad_manager.amxx  debug    
          [ 32] Knife Only on Bridge i  1.0         xx_sirhc_xx       amx_deagle5_kni  debug    
          [ 33] CSNadeDrops             0.14        Avalanche         csnadedrops.amx  debug    
          [ 34] Rules                   1.0         Chad 'eXist' Fis  rules.amxx       debug    
          [ 35] Point System            1.3         Chad 'eXist' Fis  timer.amxx       debug
amxx modules:

Code: Select all

 [ 1] SQLite                  1.8.0.3660  AMX Mod X Dev Team   running    
          [ 2] Fun                     1.8.0.3660  AMX Mod X Dev Team   running    
          [ 3] Engine                  1.8.0.3660  AMX Mod X Dev Team   running    
          [ 4] FakeMeta                1.8.0.3660  AMX Mod X Dev Team   running    
          [ 5] GeoIP                   1.8.0.3660  AMX Mod X Dev Team   running    
          [ 6] CStrike                 1.8.0.3660  AMX Mod X Dev Team   running    
          [ 7] CSX                     1.8.0.3660  AMX Mod X Dev Team   running    
          [ 8] MySQL                   1.8.0.3660  AMX Mod X Dev Team   running

meta list:

Code: Select all

          [ 1] AMX Mod X        RUN   -    amxmodx_mm_i386.  v1.8.0.3  ini  Start ANY  
          [ 2] SQLite           RUN   -    sqlite_amxx_i386  v1.8.0.3  pl1  ANY   ANY  
          [ 3] Fun              RUN   -    fun_amxx_i386.so  v1.8.0.3  pl1  ANY   ANY  
          [ 4] Engine           RUN   -    engine_amxx_i386  v1.8.0.3  pl1  ANY   ANY  
          [ 5] FakeMeta         RUN   -    fakemeta_amxx_i3  v1.8.0.3  pl1  ANY   ANY  
          [ 6] CStrike          RUN   -    cstrike_amxx_i38  v1.8.0.3  pl1  ANY   ANY  
          [ 7] CSX              RUN   -    csx_amxx_i386.so  v1.8.0.3  pl1  ANY   ANY  
          [ 8] MySQL            RUN   -    mysql_amxx_i386.  v1.8.0.3  pl1  ANY   ANY
[/code]
Top
User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:
Contact YamiKaitou

Post by YamiKaitou » Fri Feb 22, 2008 7:08 pm

Not by hand. If you give me 2-3 weeks, I might have time to create a plugin that can do it
Image

No support via PM or Email
Top
eXist73
Peon
Posts: 4
Joined: Sun Jan 08, 2006 6:56 pm

Post by eXist73 » Fri Feb 22, 2008 10:53 pm

I guess I'm going to have to get down on my knees and beg you. Cause I think my SQlite file is too large, since the server is have SQlite problems. Its 4,443 KB.

So yeah. Please make it :D.
Top
User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:
Contact YamiKaitou

Post by YamiKaitou » Fri Feb 22, 2008 11:15 pm

What SQLite issues is the server having?
Image

No support via PM or Email
Top
eXist73
Peon
Posts: 4
Joined: Sun Jan 08, 2006 6:56 pm

Post by eXist73 » Sat Feb 23, 2008 12:38 pm

Well, here's the full error log:
http://www.cs-imbalanced.com/images/wc3_error.log

All the SQLite trouble happens at the very end.
Top
User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:
Contact YamiKaitou

Post by YamiKaitou » Sat Feb 23, 2008 1:25 pm

Upgrade your AMXx to 1.8 and upgrade Wc3ft to RC9. "Database is locked" error has been fixed by the new version of AMXx

EDIT: Ah, I see. Your new error.
database disk image is malformed
I believe your SQLite database file has become corrupt. I would recommend deleting it and restarting the xp from 0 for everyone.
Image

No support via PM or Email
Top
eXist73
Peon
Posts: 4
Joined: Sun Jan 08, 2006 6:56 pm

Post by eXist73 » Sat Feb 23, 2008 7:07 pm

Yawn, thats not really the answer I wanted :(
Top
kp_downarrow
Rifleman
Posts: 162
Joined: Thu Dec 21, 2006 2:12 am

Post by kp_downarrow » Mon Feb 25, 2008 7:12 pm

lmao thats what u get for sql
Top
User avatar
Geesu
<b>King of the world!</b>
Posts: 3159
Joined: Tue Jul 05, 2005 9:24 pm
Contact:
Contact Geesu

Post by Geesu » Wed Feb 27, 2008 11:21 am

kp_downarrow wrote:lmao thats what u get for sql
enough with ur GD negativity! :P
No Support via PM
Top
Post Reply

Return to “Help/Support”