Errors when dealing with any SQL functions

[Night.Ride]

Hello all,

I been having problems with SQL databases and all the things related to SQL

since about a month ago (after i formated 'reinstalled' my Windows)

Even the scripts that was working fine, now it keeps showing me errors on every SQL line

i can't 'insert, upgrade, select, remove, or any other SQL related function

(( I'm talking about my LAN server, but everything is working just fine on my hosted server)

can anyone help me with this ?

Edited March 2, 2011 by Guest

[UAEpro]

اعتقد القسم خطأ

لكن ممكن صورة ^^

can you post a picture ^^

[Night.Ride]

[Castillo]

Do you have the required tables and columns?

[Citizen]

And most of all, do you have a sql server on your pc like Easy PHP or wamp ?

EDIT: Except if you don't use the mySQL system

[Castillo]

I think he's using SQLITE not mySQL.

[Night.Ride]

Yes i do have the tables, and I'm sure it works fine

And no i don't use mySQL, im using SQLITE .

do i have to install anything to get that working ?

[Night.Ride]

5 minutes ago, i uploaded another SQL based script, and it worked perfectly on my hosted server.

but it doesn't work on my LAN server, it shows the same errors like on that pic i uploaded

[Citizen]

Yeah I think too but I didn't realised immediately

maybe try to put ' ' like this:

executeSQLQuery("SELECT 'Attempts'  FROM ... ") 

And can you put a screen of your table with the column Attempts plz ?

[Citizen]

do i have to install anything to get that working ?

No it should works

[Night.Ride]

here is one of the tables

    executeSQLCreateTable ( "GgInfo", "serial STRING, topic INT, real_name INT, country INT, age INT, profile_picture INT" )  

and this is the insert function

function on_Register ( player ) 
local serial = getPlayerSerial(player) 
 executeSQLInsert ( "GgInfo", "'".. serial .."','][topic ~','name','country','age','SpongeBob'" ) 
  outputChatBox("works !!!") 
end  

the function used to have about 10 strings passed from the client side to the server, and it used to work

now it doesn't (after the pc format) , i even deleted all the other unneeded strings, and supplied it with some random things

[Night.Ride]

Nothing works

[UAEpro]

if it work in the server

and not in your PC

did you try to replace *.db With new one

or with the one in your server ??