This guide has been removed. It's highly recommended you use the Docker method (Windows, Linux) of installing instead. If you see need to view this guide check the version history.
If you need help then join the LEGO Universe Community Hub Discord server and ask for help in the #questions channel.
Guide made by Deleted User d183a1c4#7217.
I get that as well... Error: no such table: ActivityRewards.
But, looking at the sql file, I don't see anywhere a Create table ActivityRewards?
You can try copying fdb_to_sqlite.py to your client's /res folder, then run cmd in that directory and then the command fdb_to_sqlite.py cdclient.fdb in order to generate cdclient.sqlite
I suggest adding sudo mysql_secure_installation as a stage for correct root/DB setup.
Comment Obsolete, Issue Fixed.
Please, someone help.
UPD. External ip changed, that was the reason
Im currently experiencing the same issue as @NekoTiga . Opened all the necessary ports and edited the config files with my external ip. When i change the external ip to localhost there is no problem but i want to host it for bunch of my friends and me so keeping it at localhost is not an option. Any ideas?
@NekoTiga @yavkata999 did you run this in WSL to find IP? hostname -I | awk '{print $1}'
I think I've pretty much done exactly this whole thing except that I'm on WSL 2. At login the game just says I need to update the game and won't let me in. Wishing I waited for this guide. Don't want to start all over.
Edit the DarkflameServer/CMakeVariables.txt file with Notepad or nano and replace NET_VERSION=171023 with NET_VERSION=171022
With 22 being the new repo default you might want to update that it should be checked, but not mandatory now.
@cooltrain7 yeah I did that and it was still causing that game needs update issue. Ended up rebooting my PC, and relinked IPs because they change after each reboot. Now it just won’t sign in at all. All green lights but the sign in. Really don’t know. Best guess is WSL2.
@jonnyporter yep, I did. I edited the post later. The problem was in the IP, it changed after the restart.
@jonnyporter I tried with WSL but no luck so i got frustrated and deleted it. Then i downloaded virtualbox + ubuntu 20.04 lts and ran the whole process there. Made the network adapter settings for the VM as bridged adapter. Got IP with ip addr and confirmed in my router that it is the same one that is shown there and then forwarded the appropriated ports.
It seems that winds in Forbidden Valley do not work. The only workaround for now is using admin jetpack (/gmadditem 1727 1)
I don't understand where CDServer.sqlite is since it's not a folder how do you move cdclient.sqlite into it or beside in it's folder.
Also, after running the fdb to sqlite command I can't find the cdclient.sqlite anywhere, any help with that?
Thx.
@yavkata999 is your game running? Thinking of trying something like that or on my Mac instead of trying WSL1.
@NekoTiga you are actually up and running!? Did you use WSL 1 or 2?
Recommend adding a note about the chat issue for unix/wsl users under troubleshooting. Solution to the problem is provided here: DarkflameUniverse/DarkflameServer#61
When trying to create an admin account I keep getting this error:
[mycomputername]:~/DarkflameServer/build$ ./MasterServer -a
Error: no such table: ActivityRewards
Fatal error -1
Stacktrace:
./MasterServer(+0x1ddcf)[0x7f67bf5e1dcf]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xaa38c)[0x7f67be9ba38c]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xaa3f7)[0x7f67be9ba3f7]
/lib/x86_64-linux-gnu/libstdc++.so.6(+0xaa6a9)[0x7f67be9ba6a9]
./MasterServer(+0x15446)[0x7f67bf5d9446]
./MasterServer(+0x476cb)[0x7f67bf60b6cb]
./MasterServer(+0x1fb0c)[0x7f67bf5e3b0c]
./MasterServer(+0x25a9e)[0x7f67bf5e9a9e]
./MasterServer(+0x1fbf5)[0x7f67bf5e3bf5]
./MasterServer(+0x169fe)[0x7f67bf5da9fe]
Any ideas on how to resolve this?
@jonnyporter already sorted and playing with friends
Any idea how to approve names cuz my friend typed a name but in game it is shown as the random name from the 3 words
@jonnyporter I used WSL1
@yavkata999 give them gm account, gm names are auto-approved.
@boyoawesome1 @patbonecrusher looks like we're in the same boat. Someone on reddit has the same issue too. Cant find someone to help for the life of me.
@yavkata999 Im running into the issue of getting friends to be able to join. Ive done WSL1, Ive done port forwarding, and made sure the permissions are fine. Ive also edited the Boot cfg file to match the ip address of the server. I make sure the server is running but when I attempt to login to the game from a different computer, not the one thats hosting the server, nothing happens.
@GalacticMagmaFalcon So what i did to make my friends able to join was delete any internet adapter that im not using then restarted the pc. Then i looked up my ip(in WSL) with hostname -I
Once i found out the ip i copied it and pasted it in auth,chat and master configs.
Then i searched whats my ip on google and copied and paste it in boot.cfg following the official guide.
Hope that this can help you.
Im having a little issue. Im not sure what i am supposed to do with the checksums. I dont have any version on LU installed. I do have the original digital installer but i cant install it to get a path to the client. Is that what you are supposed to do? or am i just stupid xD
I am at the sqlite server setup. all the utilities are installed and placed correctly, i just need some help with the next command:
python3 CHANGE_THIS_PATH_TO_lcdr-utils/fdb_to_sqlite.py "/mnt/c/CHANGE_THIS_PATH_TO_CLIENT/LEGO Universe (unpacked)/res/cdclient.fdb"
much appreciation to whoever helps me haha
Thanks!
@patbonecrusher @boyoawesome1 @mattg247 Did any of you guys fix the no such table error?
I recommend anyone still struggling to start over and follow this guy (https://youtu.be/jZJR4VrUG9U) and to locate the unpacked client. The unpacked client will save you a world of headache because you can avoid using the pkextractor tool. And also finding out if your system plays well with WSL1 before trying WSL2. My personal system seems biased towards WSL2 (MariaDB/MySQL refused to work on WSL1) but we had great success with WSL1 on my nephew’s system. We got him setup in only a couple hours. This is not easy for sure. Every system seems to be different. It took me over 20 hours to figure out everything that is going on here but in the end it’s totally worth it. You got this!
the CDServer setup is causing problems for me, I keep getting "no such table" errors for all 3 commands. What did I likely do wrong?