SQL Error

[Stone]

Hi,When I try to register in my server or login it Doesn't let me one,I connected the DB,that's what It says:

[2013-08-08 22:12:47] INFO: SQL Error: #1146: Table 'test.accounts' doesn't exist

Please Answer as soon as possible

[golanu21]

show the code..

[manve1]

The table isn't created. Or if it is then show the code and it would get answered a lot quicker.

[golanu21]

use dbExec

dbExec( THEDATABASE, "CREATE TABLE IF NOT EXISTS table .... 
  
  
 

[Stone]

Well,I'm not so good in lua stuff,where I have to type that? I'm using MySQL

[Stone]

Here is what it says when I start the server and try to login:

[2013-08-08 22:12:29] Resources: 46 loaded, 0 failed

[2013-08-08 22:12:29] Querying game-monitor.com master server... failed! (302: Moved temporarily)

[2013-08-08 22:12:30] Querying backup master server... success!

[2013-08-08 22:12:31] MODULE: Loaded "MySQL 5.0 database module" (0.50) by "Alberto Alonso "

[2013-08-08 22:12:31] Starting resources...

[2013-08-08 22:12:31] ERROR: sql\sql.lua:9: Database query failed: near "NUMBER": syntax error

[2013-08-08 22:12:32] INFO: Coroutine failure.

[2013-08-08 22:12:32] ERROR: Bad/missing 'posX' attribute in (line 11)

[2013-08-08 22:12:33] INFO: Coroutine failure.

[2013-08-08 22:12:34] INFO: Loading Elevators...

[2013-08-08 22:12:34] Server started and is ready to accept connections!

[2013-08-08 22:12:34] Type 'help' for a list of commands.

[2013-08-08 22:12:37] CONNECT: [CIA]Stone connected (IP: 192.168.1.11 Serial: AFF85B7B02BF52FF89004FD640A777A3 Version: 1.3.3-9.05666.0)

[2013-08-08 22:12:38] JOIN: [CIA]Stone joined the game (IP: 192.168.1.11)

[2013-08-08 22:12:47] INFO: SQL Error: #1146: Table 'test.accounts' doesn't exist

[2013-08-08 22:12:55] SHUTDOWN: Got shutdown command from Console (No reason specified)

[2013-08-08 22:12:55] Server stopped!

[2013-08-08 22:12:55] Stopping resources..........................................

[2013-08-08 22:12:55] Closing SQLite3 database

[xXMADEXx]

You need to create the table "test.accounts" in PhpMyAdmin or LUA with dbExec

[golanu21]

man show the script.....

[golanu21]

You need to create the table "test.accounts" in PhpMyAdmin or LUA with dbExec

i have say that man

use dbExec

dbExec( THEDATABASE, "CREATE TABLE IF NOT EXISTS table .... 
  
  
  
  
 

[Stone]

Well,I couldn't create the table,and I'm not so good in lua,can you tell me where and how I do dbExec step by step? Thank you.