[HELP]Unknown system variable

04/19/2009 09:57 SarahSxe#1
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;

Quote:
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.
04/19/2009 16:20 SarahSxe#2
6 hours and no reply, doesn't anyone know a possible solution? :(
04/19/2009 18:02 IcedEarth#3
Delete
Code:
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";