FPP Resets to default after every Server Restart. Can't blacklist tools/props.

[GoogleCodeExporter]

What is the problem?

I own a Dark RP server. My issue is exactly that of Issue #766, but their 
resolution didn't resolve mine. After every restart, my server reverts all 
blacklisted tools and props to default. Also, players are able to use the 
material tool on each other as well as on doors, which I assume is only an 
effect of the overall issue with FPP.

What steps will reproduce the problem?
This coincidentally happened after I blacklisted a very large number of props. 
That's the only thing I can link to the issue, but I'm not sure if they are 
related. I blacklisted models for about a good hour straight.

Do you have any errors? serverside or clientside? If you do, which ones?
I see no errors in the console or client side.

Are you using the downloaded version or an SVN revision (if SVN, which
revision number)?
I am using the latest SVN repository of the DarkRP's FPP folder. I re 
downloaded it no more than 30 minutes ago.

Please provide any additional information below.
I use a MySQL database and all props are still listed in the table, but it's as 
if it fails to connect every time I restart. I can temporarily blacklist tools 
and props, but as soon as I restart the server, it defaults. I have also 
truncated the FPP_blockedmodels and FPP_toolrestrict tables but it has had no 
effect. I've tried everything I can think of. I do not have a seperate FPP 
addon on the server either that might interfere. I've been trying to resolve 
this for about a week now.

Original issue reported on code.google.com by TheHidde...@gmail.com on 10 Jun 2012 at 3:00

[GoogleCodeExporter]

Are you getting similar errors to this one:
[@gamemodes\darkrp\gamemode\data.lua:34] Data too long for column 'tools' at 
row 1
?

Original comment by fpeijnen...@gmail.com on 10 Jun 2012 at 3:41

[GoogleCodeExporter]

I checked through the logs and did not find errors similar to that one.

Original comment by TheHidde...@gmail.com on 10 Jun 2012 at 3:49

[GoogleCodeExporter]

Is there anything else we can do to troubleshoot the issue? It more than likely 
has to do with the database from what I've read.

Original comment by TheHidde...@gmail.com on 13 Jun 2012 at 2:36

[GoogleCodeExporter]

Remove some models from the list until I fix this. this issue has my second 
highest priority, the first being university

Original comment by fpeijnen...@gmail.com on 13 Jun 2012 at 3:39

[GoogleCodeExporter]

This might be related to the problem I'm having. I can move some entities with 
my phygun but I can't block some of them (up close and from all sides, ie. 
trees). I've tried to block for phygun & gravgun some props/entities and had 
same problem. No errors, and I don't think anything resets on restart though.

Original comment by chaosity...@gmail.com on 18 Jun 2012 at 6:07

[GoogleCodeExporter]

I don't believe the issues are related at all Chaosity. It's not that I can't 
blacklist a prop, but that whenever the server resets, every tool and prop I 
just blacklisted is spawnable and usable again.

Original comment by TheHidde...@gmail.com on 18 Jun 2012 at 2:11

[GoogleCodeExporter]

I actually did recently connect and found a few errors relating to FPP. I hope 
they indicate something that can be resolved.

Original comment by TheHidde...@gmail.com on 19 Jun 2012 at 10:01

Attachments:

• issue.png

[GoogleCodeExporter]

Issue 857 has been merged into this issue.

Original comment by fpeijnen...@gmail.com on 22 Jun 2012 at 6:26

[GoogleCodeExporter]

Read through this, still no solution.
However I think I know how to fix this. All you need to do is remove the FPP 
blockedmodels data from your database and it should work.

Now Im just looking for a clear answer on what is causing this, to avoid this 
kind of a problem later.

Original comment by MrSunshi...@gmail.com on 22 Jun 2012 at 8:53

[GoogleCodeExporter]

Still no solution because I'm busy.

Have a clean answer:
THE DATABASE IS SHIT AND NEEDS TO BE REDONE. I CURRENTLY HAVE NO TIME TO DO 
THIS. THE DATABASE BEING SHIT IS WHAT CAUSES YOUR PROBLEM.

Original comment by fpeijnen...@gmail.com on 22 Jun 2012 at 9:47

[GoogleCodeExporter]

Mr Sunshine. Just be patient.

Original comment by TheHidde...@gmail.com on 22 Jun 2012 at 10:05

[GoogleCodeExporter]

Sorry if I sounded like an ass. I didnt mean to sound like "Hurry up and fix 
this". 

Original comment by MrSunshi...@gmail.com on 22 Jun 2012 at 10:57

[GoogleCodeExporter]

Original comment by fpeijnen...@gmail.com on 28 Jun 2012 at 2:49

• Changed state: Accepted

[GoogleCodeExporter]

Wait, the blocked models doesn't have the issue that the tool restriction has.

The blocked models have one model per row, whereas the tool restriction is 
problematic because it puts tons of tools in one row.

I'm working on the tool restriction thing being fucked, but the models might be 
a harder issue.

Original comment by fpeijnen...@gmail.com on 28 Jun 2012 at 3:23

[GoogleCodeExporter]

FUCK

Another case of a corrupted database.

I tested it with the database file from issue 857, which was merged into this 
one.
Check this out:
> print(sql.QueryValue("SELECT COUNT(*) FROM FPP_BLOCKEDMODELS1;"))...
2488
] lua_run A = sql.Query("SELECT * FROM FPP_BLOCKEDMODELS1;")
> A = sql.Query("SELECT * FROM FPP_BLOCKEDMODELS1;")...
] lua_run print(table.Count(A))
> print(table.Count(A))...
442

Basically what this says:
- The database reports there are 2488 blocked models
- When I try to retrieve them from the database, only 442 are retrieved.
Where are the other 2046?

I will report later

Original comment by fpeijnen...@gmail.com on 29 Jun 2012 at 5:48

[GoogleCodeExporter]

I can fetch the first 1000 and the last 488, but somewhere between the 1000 and 
2000 it's corrupted:

] lua_run print(table.Count(A))
> print(table.Count(A))...
1000
] lua_run A = sql.Query("SELECT * FROM FPP_BLOCKEDMODELS1 LIMIT 1000, 2000;")
> A = sql.Query("SELECT * FROM FPP_BLOCKEDMODELS1 LIMIT 1000, 2000;")...
] lua_run print(table.Count(A))
> print(table.Count(A))...
466
] lua_run A = sql.Query("SELECT * FROM FPP_BLOCKEDMODELS1 LIMIT 2000, 2488;")
> A = sql.Query("SELECT * FROM FPP_BLOCKEDMODELS1 LIMIT 2000, 2488;")...
] lua_run print(table.Count(A))
> print(table.Count(A))...
488

Original comment by fpeijnen...@gmail.com on 29 Jun 2012 at 5:51

[GoogleCodeExporter]

I remade the table and re-inserted all the data.
the query still only retrieves 442 values.
Besides, SQLite says the database is NOT corrupt!

Original comment by fpeijnen...@gmail.com on 29 Jun 2012 at 6:04

[GoogleCodeExporter]

Found the issue:
GMod is broken:
http://www.facepunch.com/showthread.php?t=1194291&p=36552823

Original comment by fpeijnen...@gmail.com on 29 Jun 2012 at 6:59

[GoogleCodeExporter]

Full report of the issue.
I'm going to implement the workaround.

Original comment by fpeijnen...@gmail.com on 29 Jun 2012 at 7:19

[GoogleCodeExporter]

Original comment by fpeijnen...@gmail.com on 29 Jun 2012 at 7:39

• Changed state: Fixed