I need some help please.

[Hitman™]

When i try to install this mafia game i downloaded i get the following error wen installing the db tables

 

Write Config...

Config written.

Attempting DB connection

Connection Successful.

Writing Main MySQL data.

 

Warning: fopen(dbdata.sql) [function.fopen]: failed to open stream: No such file or directory in /home/adam/public_html/ng5/installer.php on line 468

 

Warning: fread(): supplied argument is not a valid stream resource in /home/adam/public_html/ng5/installer.php on line 470

 

Warning: fclose(): supplied argument is not a valid stream resource in /home/adam/public_html/ng5/installer.php on line 471

Main MySQL data was written.

Now write Extra MySQL data.

QUERY ERROR: Table 'adam_mobster.users' doesn't exist

Query was INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( 'Hitman™', 'Hitman™', md5('mhtydz'), 1, 100, 0, 0, 2, 12, 12, 100, 100, 5, 5, 100, 100, 1, '', unix_timestamp(), 'P155_3D@hotmail.com', -1, '82.18.43.104', '82.18.43.104')

 

I hope someone can help

[trq]

Can we see line 468 of installer.php? It is trying to open a file that it can not find, you need to check to see if the file exists.

[Hitman™]

The file is there do you have msn it would be easier to do that way + i might have some payed work for you to do later this week assuming i get this site working correctly

[trq]

Your kidding me aren't you? This is a forum, understand how these things work?

 

What are the permissions on the file in question?

[Hitman™]

0777 is the permission

and these are the lines: 465 to 469

 

$c=$db->connection_id;

print "Connection Successful.<br>

Writing Main MySQL data.<br>";

$fo=fopen("dbdata.sql","r");

$query="";

 

Thanks

 

[revraz]

And where is the dbdata.sql file located.

[Hitman™]

dio nt know i assumed everything came with the software

[revraz]

You need to look and find it.

[Hitman™]

will it be called that or could it be call something elts?

 

[revraz]

Thats what your script calls it.

[Hitman™]

then it isnt there

[trq]

I thought you said the file was there, hence you know what its called.

 

Do yourself a favour and post line 468 of installer.php like I originaly asked.

[revraz]

$fo=fopen("dbdata.sql","r");  is the line, it's trying to create his table.

[Hitman™]

I have and you asked me to get the installer.php lines not dbdata.php.

i hove posted the lines for you up there did it ages ago

 

 

@ revraz:  Dose that mean i have to make a file called that?

[revraz]

Take the INSERT Query and build your own table based on what it's doing.

 

If it builds other things, then you will have to build those too, so it's best if you find that file.

[Hitman™]

iv never dun anything like that so i wouldn't even know how to start it

 

is there anything elts i can do to allow it to carry on with its job?

[revraz]

Contact whoever you got it from and ask for the missing file.

[Hitman™]

Ok thanks for you help and fast replies

 

[Hitman™]

i got past the 1st error but its saying this now

 

Now write Extra MySQL data.

QUERY ERROR: Table 'adam_mobsterusers.users' doesn't exist

Query was INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney, lastip, lastip_signup) VALUES( 'Hitman�', 'Hitman�', md5('******'), 1, 100, 0, 0, 2, 12, 12, 100, 100, 5, 5, 100, 100, 1, '', unix_timestamp(), 'P155_3D@hotmail.com', -1, '82.18.43.104', '82.18.43.104')

 

I think I'm meant to add that somewhere but i don't know were

Sorry for bugging you

[revraz]

Means it didnt create your users table.