Erros (database)

[FSXTim]

Hello,

I'm using vio_lite and the dates are saved after the registration in the database. But only in the table "userdata", but not in the table "players", so you can't login, you have to register everytime new.

Errors:

[2012-04-11 12:50:37] INFO: Error executing the query: (1146) Table 'ni73062_1_DB.blocks' doesn't exist

And there are also errors about this file: register_login_server.lua

Maybe someone can fix it for me, I can pay, if you want!

http://www.fileuploadx.de/400012 (download for register_login_server.lua)

Thanks a lot!

Edited April 11, 2012 by Guest

[FSXTim]

I need help! Please!

I pay for your work, if you want!

[MIKI785]

Maybe the accounts are not created at all, registration is via that panel? If yes, does it have acces to the addAccount function?

[FSXTim]

I don't know! I will show you some screens:

Registration windows:

1. http://s1.directupload.net/file/d/2857/j5qs996r_jpg.htm

Databse (uderdata, dates saved)

2. http://s14.directupload.net/file/d/2857 ... 23_jpg.htm

Database(players, dates are not saved)

http://s7.directupload.net/file/d/2857/ejk4px4o_jpg.htm

Maybe I can give you the complete script and the database and you can fix it for me. I can pay, if you want, I just need some help! It would be so nice!

Regards

[BriGhtx3]

Lol!

Just ask Zipper! He gives you the support, if you bought it.

[FSXTim]

I bought and I already asked him! Last login in the german mta forum: septembre 2011 He can't answer me, if he is not online!

Can someone else help me?

Regards

[BriGhtx3]

Just give us the lines of the script where the errors are.

[FSXTim]

[2012-04-11 16:29:43] INFO: Error executing the query: (1146) Table 'ni73062_1_DB.blocks' doesn't exist

[2012-04-11 16:33:35] INFO: Error executing the query: (1054) Unknown column 'LastLogin' in 'field list'

[2012-04-11 16:34:39] INFO: Error executing the query: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Sprunk Fabrik'' at line 1

[2012-04-11 16:34:39] INFO: Error executing the query: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Bar'' at line 1

[2012-04-11 16:37:23] INFO: Error executing the query: (1054) Unknown column 'Handy' in 'field list'

[2012-04-11 16:32:33] ERROR: vio/register_login/register_login_server.lua:1020: attempt to concatenate a boolean value

This are the six errors.

Renember: The userdates are saved in the table userdata, but not in the table players!

For the last error:

mysql_vio_query ( "UPDATE inventar "..fields.." WHERE Name LIKE '"..pname.."'" ) 

I also uploaded the file. Download link: http://www.fileuploadx.de/400012

Reagards

[BriGhtx3]

You got a pm

[FSXTim]

Thanks a lot, but it still doesn't work! You got a pm, too!

[FSXTim]

You got a pm again!

[FSXTim]

Hey,

everything is working now, but all the fraction maps are not loading, does anybody know the reason? There are no errors in the console and the meta.xml says that:

    "schimpanse.map"/> 
    "maps\army\alka_prison.map"/> 
    "maps\army\army_base.map"/> 
    "maps\army\ufo.map"/> 
    "maps\drugjob\drugjob.map"/> 
    "maps\drugjob\farm.map"/> 
    "maps\else\adminhouses.map" /> 
    "maps\else\deko.map" /> 
    "maps\else\internetcafe.map" /> 
    "maps\else\safetytank.map" /> 
    <---  ---> 
    "maps\fbi\fbi.map" /> 
    "maps\fishing\fishhabour.map" /> 
    "maps\fun\racetrack_first.map" /> 
    "maps\fun\racetrack_second.map" /> 
    "maps\fun\boxarena.map" /> 
    "maps\los_aztecas\aztecas.map" /> 
    "maps\newsreporter\helipad.map" /> 
    "maps\mafia\mafia.map" /> 
    "maps\mafia\vincenzo.map" /> 
    <---  ---> 
    "maps\sfpd\sfpd.map" /> 
    "maps\terroristen\terrormap.map" /> 
    "maps\triaden\triaden.map" /> 
    "maps\triaden\triaden_casino.map" /> 
    

Regards

[BriGhtx3]

Sorry I didn't read your second pm.

What is the size of the maps?

[drk]

Where is meta node?

[BriGhtx3]

I think it is just a snippet or he couldn't start the resource or would get errors.

[FSXTim]

Everything is fixed now! Thank you!

Special thanks goes to BriGhtx3!

[FSXTim]

BriGhtx3, you got a pm!

[BriGhtx3]

Send me the file name