From: [EMAIL PROTECTED] on behalf of gareth
Sent: Fri 05/05/2006 00:16
To: [email protected]
Subject: Re: [Oscar-users] How to recover from a lost DB ?
On Thu 2006-05-04 (11:04), DongInn Kim wrote:
> OK, now I
think I found why you could not really do anything (not select
> query but
update/delete thing) on the oscar database.
> INSERT INTO db
VALUES
>
('localhost','oscar','oscar','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
>
INSERT INTO db VALUES
>
('%','oscar','oscar','Y','Y','Y','Y','N','N','N','N','N','N');
> INSERT
INTO db VALUES
>
('%','oscar','anonymous','Y','N','N','N','N','N','N','N','N','N');
>
Please run the above queries and see if it works for you.
ah ok.
i
assume i run 'use msyql' first. i then get:
mysql> INSERT INTO db
VALUES
('localhost','oscar','oscar','Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
ERROR
1136 (21S01): Column count doesn't match value count at row 1
the db
table exists, how do you check it's
structure?
-------------------------------------------------------
Using
Tomcat but need to do more? Need to support web services, security?
Get stuff
done quickly with pre-integrated technology to make your job easier
Download
IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Oscar-users
mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/oscar-users
