Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

按照示例的步骤尝试运行游戏,但是启动客户端以后,客户端不停重启 #15

Open
Highmiao opened this issue Sep 2, 2023 · 4 comments

Comments

@Highmiao
Copy link

Highmiao commented Sep 2, 2023

看网页的表现大概是,每次都是在网页左边的控件上显示出两个npc的图标以后就会立刻重启。服务器上的log如下:

----------Server Started----------
connection check_origin
connection open
somebody linked.
connection on_message
{"uri":"command.auth.Register","method":"POST","data":{"nickname":"Mayor","email":"[email protected]","cryptoPWD":"123456"}}
send: {"uri":"command.auth.Register","method":"POST","data":{"nickname":"Mayor","email":"[email protected]","cryptoPWD":"123456"}}
1146 (42S02): Table 'llm_account.account001' doesn't exist
Player-10001 first login
1146 (42S02): Table 'llm_account.npc001' doesn't exist
GLM2Caller init
GLM2Caller init
map setting: (71,41).uid = Player-10001
map setting: (50,71).uid = NPC-10001
map setting: (52,73).uid = NPC-10002
{'email': '[email protected]', 'nickname': 'Mayor', 'cryptoPWD': '123456', 'uid': 'Player-10001', 'buildings': [{'building_id': 1, 'building_type': 3, 'name': 'dessert shop', 'x': 3, 'y':
1}, {'building_id': 2, 'building_type': 4, 'name': 'gym', 'x': 3, 'y': 2}, {'building_id': 3, 'building_type': 5, 'name': 'houseZ', 'x': 2, 'y': 4}, {'building_id': 4, 'building_type':
6, 'name': 'park', 'x': 4, 'y': 2}], 'npcs': [{'uid': 'NPC-10001', 'homeBuilding': 3, 'asset': 0, 'assetName': 'premade_01', 'model': 'glm2', 'memorySystem': 'LongShortTermMemories', 'planSystem': 'QAFramework', 'workBuilding': 0, 'nickname': 'Alan', 'bio': 'Alan is a genius with outstanding talents and is the inventor of computer. Alan has an introverted personality
and is only interested in the research he foucues on.', 'goal': 'Promoting the Process of Computer Research', 'cash': 10000, 'x': 50, 'y': 71}, {'uid': 'NPC-10002', 'homeBuilding': 3, 'asset': 3, 'assetName': 'premade_04', 'model': 'glm2', 'memorySystem': 'LongShortTermMemories', 'planSystem': 'QAFramework', 'workBuilding': 0, 'nickname': 'pH', 'bio': 'pH is a positive, cheerful, optimistic but somewhat crazy girl who dares to try and explore. She loves food, loves life, and hopes to bring happiness to everyone.', 'goal': 'Taste all the delicious food and become a gourmet or chef.', 'cash': 10000, 'x': 52, 'y': 73}]}
bound websocket to Player-10001
Player-10001 logging in at 2023-09-02 21:37:53
{"code":200,"data":{"email":"[email protected]","nickname":"Mayor","cryptoPWD":"123456","uid":"Player-10001","buildings":[{"building_id":1,"building_type":3,"name":"dessert shop","x":3,"y":1},{"building_id":2,"building_type":4,"name":"gym","x":3,"y":2},{"building_id":3,"building_type":5,"name":"houseZ","x":2,"y":4},{"building_id":4,"building_type":6,"name":"park","x":4,"y":2}],"npcs":[{"uid":"NPC-10001","homeBuilding":3,"asset":0,"assetName":"premade_01","model":"glm2","memorySystem":"LongShortTermMemories","planSystem":"QAFramework","workBuilding":0,"nickname":"Alan","bio":"Alan is a genius with outstanding talents and is the inventor of computer. Alan has an introverted personality and is only interested in the research he foucues
on.","goal":"Promoting the Process of Computer Research","cash":10000,"x":50,"y":71},{"uid":"NPC-10002","homeBuilding":3,"asset":3,"assetName":"premade_04","model":"glm2","memorySystem":"LongShortTermMemories","planSystem":"QAFramework","workBuilding":0,"nickname":"pH","bio":"pH is a positive, cheerful, optimistic but somewhat crazy girl who dares to try and explore.
She loves food, loves life, and hopes to bring happiness to everyone.","goal":"Taste all the delicious food and become a gourmet or chef.","cash":10000,"x":52,"y":73}],"register":true},"uid":null,"msg":"","uri":"command.auth.Register"}
connection closing
Player-10001 is logging out
connection check_origin
connection open
somebody linked.
connection on_message
{"uri":"command.auth.Register","method":"POST","data":{"nickname":"Mayor","email":"[email protected]","cryptoPWD":"123456"}}
send: {"uri":"command.auth.Register","method":"POST","data":{"nickname":"Mayor","email":"[email protected]","cryptoPWD":"123456"}}
Player-10001 login
{'email': '[email protected]', 'nickname': 'Mayor', 'cryptoPWD': '123456', 'uid': 'Player-10001', 'buildings': [{'building_id': 1, 'building_type': 3, 'name': 'dessert shop', 'x': 3, 'y': 1}, {'building_id': 2, 'building_type': 4, 'name': 'gym', '
1}, {'building_id': 2, 'building_type': 4, 'name': 'gym', 'x': 3, 'y': 2}, {'building_id': 3, 'building_type': 5, 'name': 'houseZ', 'x': 2, 'y': 4}, {'building_id': 4, 'building_type': 10001', 'homeBuilding': 3, 'asset': 0, 'assetName': 'premad
6, 'name': 'park', 'x': 4, 'y': 2}], 'npcs': [{'uid': 'NPC-10001', 'homeBuilding': 3, 'asset': 0, 'assetName': 'premade_01', 'model': 'glm2', 'memorySystem': 'LongShortTermMemories', 'pd is the inventor of computer. Alan has an introverted perslanSystem': 'QAFramework', 'workBuilding': 0, 'nickname': 'Alan', 'bio': 'Alan is a genius with outstanding talents and is the inventor of computer. Alan has an introverted personality g': 3, 'asset': 3, 'assetName': 'premade_04', 'model': 'glm
and is only interested in the research he foucues on.', 'goal': 'Promoting the Process of Computer Research', 'cash': 10000, 'x': 50, 'y': 71}, {'uid': 'NPC-10002', 'homeBuilding': 3, ' dares to try and explore. She loves food, loves life, and asset': 3, 'assetName': 'premade_04', 'model': 'glm2', 'memorySystem': 'LongShortTermMemories', 'planSystem': 'QAFramework', 'workBuilding': 0, 'nickname': 'pH', 'bio': 'pH is a positive, cheerful, optimistic but somewhat crazy girl who dares to try and explore. She loves food, loves life, and hopes to bring happiness to everyone.', 'goal': 'Taste all the delicious food and become a gourmet or chef.', 'cash': 10000, 'x': 52, 'y': 73}]}
bound websocket to Player-10001 :1},{"building_id":2,"building_type":4,"name":"gym","x":3,"
Player-10001 logging in at 2023-09-02 21:38:37 0,"assetName":"premade_01","model":"glm2","memorySystem":"L
{"code":200,"data":{"email":"[email protected]","nickname":"Mayor","cryptoPWD":"123456","uid":"Player-10001","buildings":[{"building_id":1,"building_type":3,"name":"dessert shop","x":3,"y"rted personality and is only interested in the research he :1},{"building_id":2,"building_type":4,"name":"gym","x":3,"y":2},{"building_id":3,"building_type":5,"name":"houseZ","x":2,"y":4},{"building_id":4,"building_type":6,"name":"park","x":4,"ySystem":"LongShortTermMemories","planSystem":"QAFramework"y":2}],"npcs":[{"uid":"NPC-10001","homeBuilding":3,"asset":0,"assetName":"premade_01","model":"glm2","memorySystem":"LongShortTermMemories","planSystem":"QAFramework","workBuilding":0,"iness to everyone.","goal":"Taste all the delicious food annickname":"Alan","bio":"Alan is a genius with outstanding talents and is the inventor of computer. Alan has an introverted personality and is only interested in the research he foucues
on.","goal":"Promoting the Process of Computer Research","cash":10000,"x":50,"y":71},{"uid":"NPC-10002","homeBuilding":3,"asset":3,"assetName":"premade_04","model":"glm2","memorySystem":"LongShortTermMemories","planSystem":"QAFramework","workBuilding":0,"nickname":"pH","bio":"pH is a positive, cheerful, optimistic but somewhat crazy girl who dares to try and explore.
She loves food, loves life, and hopes to bring happiness to everyone.","goal":"Taste all the delicious food and become a gourmet or chef.","cash":10000,"x":52,"y":73}],"register":true},"uid":null,"msg":"","uri":"command.auth.Register"}
connection closing
Player-10001 is logging out

@py499372727
Copy link
Owner

I have noticed the bug traceback "1146 (42S02): Table 'llm_account.account001' doesn't exist", it there anything wrong with the mysql database?

@Highmiao
Copy link
Author

Highmiao commented Sep 4, 2023

I have noticed the bug traceback "1146 (42S02): Table 'llm_account.account001' doesn't exist", it there anything wrong with the mysql database?

似乎不是数据库出了问题,我检查了抛出这个报错位置的代码,那里的逻辑貌似是这样的:在注册用户的时候,先直接使用这个table进行操作,然后看操作是否成功,如果这个table不存在,那么就会创建这个table。

并且,如果我在运行了一次客户端之后,不关闭服务器,直接再次重新启动客户端,那么在日志中就不会再出现这个数据库的报错。

@Highmiao
Copy link
Author

Highmiao commented Sep 4, 2023

我不知道到底发生了什么,但我猜测比较可能是使用unity发布的这个webgl应用程序不能在我的浏览器环境下正常工作。我尝试了Edge浏览器,GoogleChrome浏览器,都遇到相同的问题。

@Lllydialee
Copy link

If you are MAC OS user, maybe you need to use nginx to load the index.html

我不知道到底发生了什么,但我猜测比较可能是使用unity发布的这个webgl应用程序不能在我的浏览器环境下正常工作。我尝试了Edge浏览器,GoogleChrome浏览器,都遇到相同的问题。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants