Night.Ride Posted March 2, 2011 Share Posted March 2, 2011 (edited) 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 Link to comment
UAEpro Posted March 2, 2011 Share Posted March 2, 2011 اعتقد القسم خطأ لكن ممكن صورة ^^ can you post a picture ^^ Link to comment
Castillo Posted March 2, 2011 Share Posted March 2, 2011 Do you have the required tables and columns? Link to comment
Moderators Citizen Posted March 2, 2011 Moderators Share Posted March 2, 2011 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 Link to comment
Castillo Posted March 2, 2011 Share Posted March 2, 2011 I think he's using SQLITE not mySQL. Link to comment
Night.Ride Posted March 2, 2011 Author Share Posted March 2, 2011 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 ? Link to comment
Night.Ride Posted March 2, 2011 Author Share Posted March 2, 2011 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 Link to comment
Moderators Citizen Posted March 2, 2011 Moderators Share Posted March 2, 2011 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 ? Link to comment
Moderators Citizen Posted March 2, 2011 Moderators Share Posted March 2, 2011 do i have to install anything to get that working ? No it should works Link to comment
Night.Ride Posted March 2, 2011 Author Share Posted March 2, 2011 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 Link to comment
UAEpro Posted March 3, 2011 Share Posted March 3, 2011 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 ?? Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now