Announcement

Collapse
No announcement yet.

[SOLVED] Sc_log

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [SOLVED] Sc_log

    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 ?

  • #2
    The table does not exists. Did you create it using tools -> log? Or accidentally removed?
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      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 ...

      sc_log.jpg

      Comment


      • #4
        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.

        Comment


        • #5
          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`...

          Comment

          Working...
          X