Black Screen After Install

[ToastyZA]

Hi,

I have downloaded the development branch and setup the server as explained and to my understanding, however im getting a black screen after selecting my player slot and loading the mission file.

I have only run the SQL and not the migration one.

Not sure if i have missed a step.

Server & EXTDB3 RPTs.zip

[Scarso327]

Hi @ToastyZA

You're getting this error in your sql logs

[22:47:00:427021 +02:00] [Thread 5624] extDB3: SQL: Error MariaDBQueryException: Duplicate entry '1' for key 'PRIMARY' [22:47:00:427042 +02:00] [Thread 5624] extDB3: SQL: Error MariaDBQueryException: Input: INSERT INTO community_goals (id, goal_cfg, end_date) VALUES ('1', 'SellCigarette', DATE_FORMAT(ADDDATE(CURDATE(), INTERVAL 14 DAY), '%Y-%c-%e'));

I'd recommend clearing the "community_goals" table and restarting the server.

[ToastyZA]

Thanks for the quick reply @Scarso327

I saw this in on of the other comments and tried this and the same issue is still happening.

I can hear myself walking around in water and that but the black screen stays.

Edit: When i look at the table after trying this i have one added again for ArrestPeople with a deadline.

[Scarso327]

DELETE FROM community_goals; ALTER TABLE community_goals AUTO_INCREMENT=1;

Try running this and going again

[ToastyZA]

Didn't work either, attached latest logs.

Server & EXTDB3 RPTs - 2.zip

Edit: Not sure if the below error from server RPT has anything to do with it

2024/11/19, 23:31:59 Scripting function 'bis_fnc_arsenal' is not allowed to be remotely executed
2024/11/19, 23:31:59 User Tower 2 [TAG] (76561198152351109) tried to remoteExec a disabled function: 'bis_fnc_arsenal'

[Scarso327]

Could you use https://pastebin.com/ please? For security I have to do virus scans on files so it's just easier to use the site.

That error is fine.

[ToastyZA]

Total understand.

Server RPT https://pastebin.com/bzPFjiKp

Extdb3 https://pastebin.com/9esDd98W

[Scarso327]

Without wiping the current goals table state can you run SHOW TABLE STATUS LIKE 'community_goals'

I think it's the fn_getNextId script getting the same id each time which I wouldn't expect but assuming you've wiped the table the auto increment should work

[ToastyZA]

This is what the table is showing.

https://pastebin.com/GmB6EvQk

TABLES

Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment	Max_index_length	Temporary
community_goals	InnoDB	10	Dynamic	1	16384	16384	0	0	0	2	2024-11-19 23:30:48	2024-11-19 23:31:35	\N	utf8mb4_general_ci	\N			0	N

[Scarso327]

Okay - Could you try restarting the server and seeing if the SQL error changes? The Auto_increment value is used from that query to get the "next id" for a table so 2 should be fine

[ToastyZA]

Looks to be the same.

https://pastebin.com/TDL81i6h

[Scarso327]

To try and see if we can get in "fn_initCommunityGoals"

lines 44 - 66, try commenting this out and repacking the life server file. I'll try and have a closer look tomorrow.

[ToastyZA]

Thanks. I’ll try this first thing tomorrow when I’m back from work and give you an update. Appreciate the assistance.

[ToastyZA]

Morning, managed to make the changes from work and booted the server, below is the new log file.

https://pastebin.com/p5SJet8Y

I haven't tested connecting as a player as of yet due to being at work. But will have someone in about 3hrs who will be able to connect for me and give me feedback

[ToastyZA]

To try and see if we can get in "fn_initCommunityGoals"

lines 44 - 66, try commenting this out and repacking the life server file. I'll try and have a closer look tomorrow.

Did this now and connected to the server.

Database doesn't enter anything into the _communitygoals table now, but still on a black screen and can still hear myself walking on wood and water.

Server RPT https://pastebin.com/LzdvinvH

extdb3 Log https://pastebin.com/w1B98TZM

[ToastyZA]

Sooooo i changed to 32bit Server exe and it worked xD

[Scarso327]

Apologies for the delay, I am glad you got it sorted but the bit version shouldn't have an effect on the mission.

Are you sure you didn't perform another troubleshooting step at the same time that could have resolved it?

[ToastyZA]

No worries man.

Not that I can recall. I am using AMP Manager to control the server. I will do a test a bit later of switching back to 32bit and see what happens and let you know

[ToastyZA]

Ok so server was running now on x32.exe

Shut it down and switched to x64.exe and started back up, connected to server and black screen.

Put the server back up on x32.exe and connected just fine.

No other adjustments were made between the switching