[HELP]Unknown system variable

[SarahSxe]

Ok so when I go to do the batch file in my db I get this message when I try to query it "SQL Error: Unknown system variable 'SQL_MODE'" Ive tried looking and searching for people with the same problem but I could only find this;

Hey master, dude im getting somekind of error its saying: Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.10.3
-- phpMyAdmin
--
-- Host: localhost
-- Czas wygenerowania: 25 Lis 2008, 19:06
-- Wersja serwera: 5.0.51
-- Wersja PHP: 5.2.6
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

MySQL said: Documentation
#1193 - Unknown system variable 'SQL_MODE'

thats in my phpmyadmin and in mysql it says Script line: 10 Unknown system variable 'SQL_MODE'


if ya can fix this id much appreciate it, thanks.

The thread was closed.

If anyone could please help me / guide me through this issue im having you will get a huge thanks! lol

EDIT: Ive been trying to do it for hours now and I found this "SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";" im pretty sure it has something to do with this but I just don't know.

[SarahSxe]

6 hours and no reply, doesn't anyone know a possible solution?

[IcedEarth]

Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";