Syntax error please help

[Sumeeth]

`ibwf_INSERT INTO
settings`
VALUES ( 1, #
39;sesexp&#
39; 

#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 '' at line 3

(please tell what should i do in line 3 near 39?)my full code is

INSERT INTO
`ibwf_settings`
VALUES (1, &#
39;sesexp&#
39;, '20&#
39;);
INSERT INTO
`ibwf_settings`
VALUES (2, &#
39;j', &#
39;');
INSERT INTO
`ibwf_settings`
VALUES (3, &#
39;4ummsg&#
39;, '&#
39;);
INSERT INTO
`ibwf_settings`
VALUES (4, &#
39;Counter&#
39;, '&#
39;);
INSERT INTO
`ibwf_settings`
VALUES (5, &#
39;pmaf',
'');
INSERT INTO
`ibwf_settings`
VALUES (6, &#
39;reg',
'1');
INSERT INTO
`ibwf_settings`
VALUES (7, &#
39;fview',
'');
INSERT INTO
`ibwf_settings`
VALUES (8, &#
39;lastbpm&#
39;, '&#
39;);
INSERT INTO
`ibwf_settings`
VALUES (9, &#
39;sitename&#
39;, '&#
39;);
INSERT INTO
`ibwf_settings`
VALUES (10, &#
39;vldtn',
'0'); 

please reply soon.thanks in advance

[amylee]

bit confused :/

is that the actual mysql you are using? or are you posting that from a mobile phone or something?
as if thats your actual mysql data then everything is wrong

[Sumeeth]

I am using lavalair script.and i want to turn on the registration.i am beginner.i am not able to upload the .sql file.so i used this in sql in my database

[amylee]

DROP TABLE IF EXISTS ibwf_settings;
CREATE TABLE IF NOT EXISTS ibwf_settings (
  id int(10) NOT NULL auto_increment,
  name varchar(30) NOT NULL default '',
  `value` varchar(200) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY name (name)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

--
-- Dumping data for table 'ibwf_settings'
--

INSERT INTO ibwf_settings VALUES(1, 'sesexp', '30');
INSERT INTO ibwf_settings VALUES(2, 'Thu 11 Oct 2011 - 21:02', '60');
INSERT INTO ibwf_settings VALUES(3, '4ummsg', '');
INSERT INTO ibwf_settings VALUES(4, 'Counter', '8903154');
INSERT INTO ibwf_settings VALUES(5, 'pmaf', '10');
INSERT INTO ibwf_settings VALUES(6, 'reg', '1');
INSERT INTO ibwf_settings VALUES(7, 'fview', '1');
INSERT INTO ibwf_settings VALUES(8, 'lastbpm', '2011-10-11');

copy and upload that into your database

edit.....

just realized the sql above is for a different lava script, i do not have that particular script, fact is i don't know what lava script that sql is from so the above sql i posted might not work
you will have to find the script you are using from here or where-ever you downloaded it from and reupload the sql

but to simply enable registration it's only a tiny edit to the line "INSERT INTO ibwf_settings VALUES(6, 'reg', '1');" make sure in your database it has that 1 right at the end

[Sumeeth]

Ok thanks you so much.i will try

ya understood.i really thank you so much for helping me out.thank you

Added after 4 minutes:

Please tell me how and where exactly i have to upload .sql file in my database?

Added after 34 minutes:

I am not able to upload .sql file.please can anyone do it for me?

[something else]

' is '
replace all of them and then use the sql window to paste it into like you have pasted it in here...

[Sumeeth]

Thanks a lot to all of you guys.you are so hearty here to help anyone.i learnt many things in few days which took me so many months in other places.i really thank you guys