• Registered: 2008-10-18
  • Posts: 9

Topic: Im getting this error when I try to import my data

hello, I uploaded the forum files to my server & am now trying to import the table data from an sql file, but I am getting this error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.11.8.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1:3306
-- Generation Time: Oct 18, 2008 at 07:15 AM
-- Server version: 4.1.20
-- PHP Version: 4.3.11
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"' at line 1

Any ideas what this is?

  • User33
  • PunBB senior member
  • Offline
  • Registered: 2008-02-03
  • Posts: 875

Re: Im getting this error when I try to import my data

This link might help: http://www.securiour.com/2007/set-sql_m … e_on_zero/

  • From: Russia
  • Registered: 2007-12-13
  • Posts: 642

Re: Im getting this error when I try to import my data

PunBB 1.2?

Check the character sets: this must be the same for the SQL-file and for the MySQL, trying to parse it.

Carpe diem

Anatoly's Website