Error In Console!

[Imfreezing]

hello can someone give me the Sql Code For this one please?

[11/06/2013 14:26:10] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '139' LIMIT 1;)
[11/06/2013 14:26:10] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '25' LIMIT 1;)
[11/06/2013 14:26:10] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '9' LIMIT 1;)
[11/06/2013 14:26:10] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '57' LIMIT 1;)
[11/06/2013 14:26:25] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25' LIMIT 1;)
[11/06/2013 14:26:47] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '139' LIMIT 1;)
[11/06/2013 14:26:59] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '139' LIMIT 1;)
[11/06/2013 14:27:07] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25' LIMIT 1;)
[11/06/2013 14:27:20] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25' LIMIT 1;)
[11/06/2013 14:27:39] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25' LIMIT 1;)
[11/06/2013 14:27:50] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25' LIMIT 1;)
[11/06/2013 14:27:59] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25' LIMIT 1;)
[11/06/2013 14:28:07] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25' LIMIT 1;)
[11/06/2013 14:28:13] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "wins" = "wins" + 1 WHERE "id"= '139' LIMIT 1;)
[11/06/2013 14:28:13] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "players" SET "wins" = "wins" + 1 WHERE "id"= '25' LIMIT 1;)

if you help i give you rep

 

[psychomen]

As you already using the id field in the WHERE clause, you don´t need the LIMIT use. So try this:

UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '139'
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '25'
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '9'
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '57'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '139'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '139'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "wins" = "wins" + 1 WHERE "id"= '139'
UPDATE "players" SET "wins" = "wins" + 1 WHERE "id"= '25'

 

[Imfreezing]

As you already using the id field in the WHERE clause, you don´t need the LIMIT use. So try this:

UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '139'
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '25'
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '9'
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '57'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '139'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '139'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "wins" = "wins" + 1 WHERE "id"= '139'
UPDATE "players" SET "wins" = "wins" + 1 WHERE "id"= '25'

SQLiteManager: Likely SQL syntax error: UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '139'
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '25'
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '9'
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '57'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '139'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '139'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25'
UPDATE "players" SET "wins" = "wins" + 1 WHERE "id"= '139'
UPDATE "players" SET "wins" = "wins" + 1 WHERE "id"= '25'  [ near "UPDATE": syntax error ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

 

[psychomen]

Sorry, forgot the ';'

Now should work:

UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '139';
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '25';
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '9';
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '57';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '139';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '139';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "wins" = "wins" + 1 WHERE "id"= '139';
UPDATE "players" SET "wins" = "wins" + 1 WHERE "id"= '25';

 

[Imfreezing]

Sorry, forgot the ';'

Now should work:

UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '139';
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '25';
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '9';
UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '57';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '139';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '139';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "goals" = "goals" + 1 WHERE "id"= '25';
UPDATE "players" SET "wins" = "wins" + 1 WHERE "id"= '139';
UPDATE "players" SET "wins" = "wins" + 1 WHERE "id"= '25';

SQLiteManager: UPDATE "players" SET "total" = "total" + 1 WHERE "id"= '139'; [ no such column: total ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

 

[psychomen]

This error means that you dont have the total field in the players table...

You must has this fields in the table to work. I don´t know where you got this script, but you must alter some fields in your DATABASE before you use it.

Best Regards,

 

[Imfreezing]

awwwwww