Error
Error inserting:
Table ‘proba.SC_LOG’ doesn’t exist
INSERT INTO SC_LOG (inserted_date, username, application, creator, ip_user, action, description) VALUES (‘2013-03-18 03:25:14’, ‘admin’, ‘grid_customers’, ‘Scriptcase’, ‘188.6.11.167’, ‘access’, ‘’)
What could be the problem ?
The table does not exists. Did you create it using tools -> log? Or accidentally removed?
No. The table is there. Therefore, I do not understand why you can not access? Needed to set something somewhere? Or I do not understand …
Some databases use case sensitive table names (in oracle you are better off using only upper case).
So try using the correct casing or surrounding your table names with quotes.
Super. It works. Must be written with a capital letter in the name of the table. I thank you very much. I searched for half a day, but I have not found the solution!
DROP TABLE IF EXISTS SC_LOG;
CREATE TABLE SC_LOG (
id int(11) NOT NULL AUTO_INCREMENT,
inserted_date datetime DEFAULT NULL,
username varchar(90) NOT NULL,
application varchar(200) NOT NULL,
creator varchar(30) NOT NULL,
ip_user varchar(32) NOT NULL,
action varchar(30) NOT NULL,
description text,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO SC_LOG…